with cum_address_dim as

select

create_date

,claim_address_count

,SUM(claim_address_count) OVER (ORDER BY create_date) AS cumsum_claim_address_count

from

(

select

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

,count(distinct other_address) as claim_address_count

from

(

select

other_address

,min(stat_date) as create_date

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,