distinct token,

avg(price_usd) as price,

date_trunc('day',timestamp) as date

from flow.core.fact_prices

group by 1,3

order by 2 desc