stat_date,

daily_claim_tx_count,

SUM(daily_claim_tx_count) OVER (ORDER BY stat_date) AS cumsum_claim_tx_count

from

select

TO_CHAR(stat_date, 'YYYY-MM-DD HH24') as stat_date

,count(distinct case when transfer_type='out' then hash else null end ) as daily_claim_tx_count

from

(

SELECT

FROM_ADDRESS AS core_address,

TO_ADDRESS AS other_address,

'out' AS transfer_type,

value,

BLOCK_TIMESTAMP AS stat_date,

TX_HASH as hash

FROM monad.testnet.fact_transactions

WHERE from_address=lower('0xD7a24d1F1435CD314E86736E139f8431D4498D4e')

and BLOCK_TIMESTAMP>='2025-02-19 14:00:00'

UNION ALL

SELECT

TO_ADDRESS AS core_address,

FROM_ADDRESS AS other_address,

'in' AS transfer_type,

value,

BLOCK_TIMESTAMP AS stat_date,

TX_HASH as hash

FROM monad.testnet.fact_transactions

WHERE to_address=lower('0xD7a24d1F1435CD314E86736E139f8431D4498D4e')

and BLOCK_TIMESTAMP>='2025-02-19 14:00:00'