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