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 corr(price, tvl_usd) as cc

from price left join tvl on price.date=tvl.date