avax_price AS

SELECT

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

, avg( a.price ) AS price

, a.symbol

FROM

avalanche.core.fact_hourly_token_prices a

WHERE

a.symbol = 'WAVAX'

GROUP BY 1 , 3

ORDER BY 1 DESC

,

hubble AS

SELECT

a.address AS address

, a.address_name AS name

FROM

avalanche.core.dim_labels a

WHERE

a.project_name = 'hubble'

GROUP BY 1 , 2

SELECT

date_trunc( 'week' , a.block_timestamp ) AS "date"