select 'Before Merge' as timespan,

block_timestamp::date as date,

count (distinct tx_hash) as TX_Count,

tx_count/86400 as TPS,

count (distinct from_address) as Users_Count,

sum (tx_fee) as Total_Fee,

avg (tx_fee) as Average_Fee,

sum (gas_used) as Gas_Used

from ethereum.core.fact_transactions

where block_timestamp >= '2022-09-01' and block_timestamp < '2022-09-15'

and block_timestamp::date != CURRENT_DATE

and status = 'SUCCESS'

group by 1,2

union all

select 'Post Merge' as timespan,

block_timestamp::date as date,

count (distinct tx_hash) as TX_Count,

tx_count/86400 as TPS,

count (distinct from_address) as Users_Count,

sum (tx_fee) as Total_Fee,

avg (tx_fee) as Average_Fee,

sum (gas_used) as Gas_Used

from ethereum.core.fact_transactions

where block_timestamp >= '2022-09-15'

and block_timestamp::date != CURRENT_DATE

and status = 'SUCCESS'

group by 1,2