token_price AS

SELECT

date_trunc( 'day' , a.recorded_hour ) AS day

, avg( a.price ) AS price_usd

, a.currency AS currency

, a.symbol AS symbol

FROM

osmosis.core.ez_prices a

GROUP BY

1 , 3 , 4

ORDER BY

1 DESC

,

osm_price AS

SELECT

date_trunc( 'day' , a.recorded_hour ) AS day

, avg( a.price ) AS price_usd

FROM

osmosis.core.ez_prices a

WHERE

a.symbol = 'OSMO'

GROUP BY

1

ORDER BY

1 DESC