SELECT

tx_hash,

block_timestamp,

tx_fee AS gas_fee_in_mon

FROM monad.testnet.fact_transactions

WHERE

block_timestamp BETWEEN '2025-03-12 17:35:46' AND '2025-03-13 22:24:53'

AND to_address = lower('0xdCf3c00e9F8A2FdaaF19Fe59050e80c433b509DC') -- Replace with actual airdrop sender contract

AND tx_succeeded = 'true'

SELECT

COUNT(tx_hash) AS total_airdrop_txs,

SUM(gas_fee_in_mon) AS total_gas_spent_in_mon,

MIN(block_timestamp) AS first_airdrop_time,

MAX(block_timestamp) AS last_airdrop_time,

TIMESTAMPDIFF('hour', MIN(block_timestamp), MAX(block_timestamp)) AS duration_hours

FROM fmon_airdrop_txs;