upgrade_period as "Upgrade Period",

date_trunc('day', block_timestamp) as date,

sum(tx_fee) as fee,

sum(fee) over(PARTITION BY upgrade_period ORDER BY date) as cumulative_fee,

avg(tx_fee) as daily_avg_fee,

sum (MATIC_VALUE) as valuess ,

count(*) as n_txns,

COUNT(DISTINCT FROM_ADDRESS) as users

FROM (

SELECT

date_trunc('day', block_timestamp) as block_day,

block_timestamp,

tx_fee,

FROM_ADDRESS,

MATIC_VALUE,

status,

'After Upgrade' as upgrade_period

FROM polygon.core.fact_transactions

WHERE block_timestamp >= '2023-01-17'

AND block_timestamp > '2023-01-01'

UNION ALL

SELECT

date_trunc('day', block_timestamp) as block_day,

block_timestamp,

tx_fee,

FROM_ADDRESS,

MATIC_VALUE,

status,

'Before Upgrade' as upgrade_period

FROM polygon.core.fact_transactions

WHERE block_timestamp < '2023-01-17'

AND block_timestamp > '2023-01-01'

) t