aPrioriPer Claim MON Distribution
    Updated 2025-03-04
    select
    claim_amount as Per_Claim_Amount
    ,count(*) as Claim_tx_Count
    from
    (
    select
    other_address as wallet
    ,value as claim_amount
    ,stat_date as claim_time
    ,hash as tx_hash
    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'
    Last run: 14 days ago
    PER_CLAIM_AMOUNT
    CLAIM_TX_COUNT
    1
    0.0210990
    2
    0.054168
    3
    114842
    4
    256861
    4
    46B
    8s