case when block_number < 38189056 then 'Before Hard Fork'

else 'After Hard Fork' end as timespan,

count (distinct tx_hash) as TX_Count,

count (distinct from_address) as Users_Count,

sum (tx_fee) as Fees,

avg (tx_fee) as Average_Fee,

median (tx_fee) as Median_Fee,

min (tx_fee) as Minimum_Fee,

max (Tx_fee) as Maximum_Fee,

count (case when STATUS != 'SUCCESS' then 1 end) as Failed_TX,

count (case when STATUS = 'SUCCESS' then 1 end) as Success_TX,

(Success_TX / (Success_TX + Failed_TX)) * 100 as Success_Rate

from polygon.core.fact_transactions

where block_timestamp >= '2022-12-17' and block_timestamp < '2023-02-18'

group by 1,2

order by 1