stat_date

-- ,mainnet_address_count

-- ,total_claim_address_count

,mainnet_address_count /total_claim_address_count as main_percent

from

select

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

,count(case when transfer_type='out' and value>=2 then other_address else null end ) as mainnet_address_count

,count(case when transfer_type='out' then other_address else null end ) as total_claim_address_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'

) a

group by 1

order by 1

) a

order by 1