date_trunc('day', hour) as date,

symbol,

avg(price) as ethbtc_price

from flipside_prod_db.ethereum_core.fact_hourly_token_prices

where symbol in ('WBTC','WETH')

and hour >= current_date - 30

group by 1,2