SELECT
'Before Airdrop' AS period,
AVG(tx_fee) AS average_tx_fee
FROM
blast.core.fact_transactions
WHERE
block_timestamp < '2024-06-26 14:00:00'
UNION ALL
SELECT
'After Airdrop' AS period,
AVG(tx_fee) AS average_tx_fee
FROM
blast.core.fact_transactions
WHERE
block_timestamp between '2024-06-26 14:00:00' and '2024-06-27 14:00:00';