Hi,
I'm currently doing this:
SELECT symbol, date_trunc('minute', posted), min(price), max(price), avg(price) FROM trade GROUP BY symbol,
date_trunc('minute',posted);
to get a list of minute-averages of trade prices. I get the feeling
that this is bad form, that I should be doing this some other way. Is
that the case?
-itai