date_trunc('day', hour) as date,

avg(price) as avgprice

from ethereum.core.fact_hourly_token_prices

where symbol in ('MATIC')

and hour >= '2023'

group by 1

order by 1)

select

date_trunc('day', block_timestamp) as date,

case

when date < '2023-01-18' then 'Before hard fork'

else 'After hard fork' end as date_cat,

y.avgprice as matic_price,

count(*) as n_txs,

count(distinct from_address) as n_active_users,

sum(matic_value) as volume,

avg(matic_value) as avg_volume_per_transation,

sum(tx_fee) as total_fee,

avg(tx_fee) as avg_fee_per_tx

from polygon.core.fact_transactions x join pricet y on x.block_timestamp::date = y.date

where block_timestamp >= '2023-01-01'

group by 1,2,3

order by 1