SELECT

to_address

, MIN(block_timestamp) as min_time

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

, drip_events as (

SELECT

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

, (CASE WHEN time_bin<=min_time THEN 'first drip' ELSE 'nth drip' END) as label

, COUNT(DISTINCT to_address) as receivers

, COUNT(DISTINCT tx_hash) as txns

, SUM(value) as mon_dripped

, MAX(tx_hash) as sample1

, MIN(tx_hash) as sample2

from monad.testnet.fact_traces

LEFT JOIN min_drips using(to_address)

where 1=1

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

--AND tx_hash = '0xf778e0929e99f1df14e94fb1a8089a8968c420e3c275b97033e6fd7224acd987'

AND origin_function_signature = '0x7bfc2741'

AND origin_to_address = '0x09fb6a39471eb9dcee30fb91d8830195b1380e0f'

AND from_address = '0x09fb6a39471eb9dcee30fb91d8830195b1380e0f'

-- faucet wallet: 0x09fb6a39471eb9dcee30fb91d8830195b1380e0f

GROUP BY 1, 2