date_trunc('day', block_timestamp) as Date,

case when block_timestamp > '2024-06-27' then 'After Airdrop' else

'Before Airdrop' end as Time_Period,

count(distinct tx_hash) as Transactions,

count(distinct from_address) as Users,

sum(tx_fee) as Fee_Volume_ETH

from blast.core.fact_transactions

where Status = 'SUCCESS'

group by 1,2