dylan_apraPriori Faucet Claim Transactions
    Updated 2025-02-25

    select
    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'
    QueryRunArchived: QueryRun has been archived