with MATIC_Price as (
select date_trunc('day', hour::date) as date,
avg(price) as AVG_PRICE
from ethereum.core.fact_hourly_token_prices
where symbol = 'MATIC'
group by 1
),
matic_amount as(
select date_trunc('day', block_timestamp::date) as date,
sum(amount) as AMOUNT_MATIC
from flipside_prod_db.polygon.udm_events
where symbol = 'MATIC'
group by 1
)
SELECT MATIC_Price.date, MATIC_Price.AVG_PRICE, matic_amount.AMOUNT_MATIC
from MATIC_Price
full join matic_amount on MATIC_Price.date=matic_amount.date
order by 1