price AS

SELECT

date_trunc( 'day' , a.hour ) AS date

, avg( a.price ) AS price

, a.token_address AS address

, a.symbol AS symbol

FROM

avalanche.price.ez_hourly_token_prices a

GROUP BY 1 , 3 , 4

ORDER BY 1 DESC

,

avax AS

SELECT

date_trunc( 'day' , a.hour ) AS date

, avg( a.price ) AS price

, a.token_address AS address

, a.symbol AS symbol

FROM

avalanche.price.ez_hourly_token_prices a

WHERE

a.symbol = 'WAVAX'

GROUP BY 1 , 3 , 4

ORDER BY 1 DESC

,

final AS

SELECT

date_trunc( '{{period}}' , a.block_timestamp ) AS "date"