SELECT

TIME_SLICE(block_timestamp, 15, 'minute', 'START') as time_bin

, COUNT(DISTINCT tx_hash) as txns

, COUNT(DISTINCT to_address) as receivers

, SUM(value) as mon_dripped

from monad.testnet.fact_traces

where 1=1

AND block_timestamp >= '2025-02-19 15:00' --- monad public announcement: https://x.com/monad_xyz/status/1892227817149997212

--AND tx_hash = '0xc3af99d908e68c5378bb98863b3e9984c7d5c9cd5c12c628ef3f9c052d538ed4'

AND origin_function_signature = '0x7bfc2741'

AND origin_to_address = '0x09fb6a39471eb9dcee30fb91d8830195b1380e0f'

AND from_address = '0x09fb6a39471eb9dcee30fb91d8830195b1380e0f'

-- faucet wallet: 0x09fb6a39471eb9dcee30fb91d8830195b1380e0f

GROUP BY 1

, time_bins as (

SELECT

TIME_SLICE(block_timestamp, 15, 'minute', 'START') as time_bin

, COUNT(*) as test

from ethereum.core.fact_blocks

WHERE 1=1

AND block_timestamp >= '2025-02-19 15:00'

AND block_timestamp < CURRENT_TIMESTAMP - INTERVAL '1 hour, 30 minutes'

GROUP BY 1

, merge as (

SELECT

time_bin

, coalesce(txns, 0) as txns

, coalesce(receivers, 0) as receivers

, coalesce(mon_dripped, 0) as mon_dripped

from time_bins

LEFT JOIN faucet_stats using(time_bin)