with price as (select HOUR::date as date, avg(price) as price
from crosschain.price.ez_prices_hourly
where token_address is null and symbol='GLMR' AND hour::date between '{{Start_Date}}' and '{{End_Date}}'
group by 1
order by 1),
tvl as (select date, tvl_usd
from external.defillama.fact_chain_tvl
where chain='Moonbeam' AND date between '{{Start_Date}}' and '{{End_Date}}'
order by 1)
select price.date as date, price, tvl_usd
from price left join tvl on price.date=tvl.date
order by 1