dylan_apraPriori Faucet Claim Addresses
    Updated 2025-02-25

    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,
    Last run: about 1 month ago
    STAT_DATE
    DAILY_CLAIM_ADDRESS_COUNT
    CUMSUM_CLAIM_ADDRESS_COUNT
    1
    2025-02-19 141717545
    2
    2025-02-19 1517175672
    3
    2025-02-19 16171751644
    4
    2025-02-19 17171752512
    5
    2025-02-19 18171756162
    6
    2025-02-19 191717512790
    7
    2025-02-19 201717517152
    8
    2025-02-20 042034117332
    9
    2025-02-20 052034122997
    10
    2025-02-20 062034125337
    11
    2025-02-20 082034125774
    12
    2025-02-20 092034126539
    13
    2025-02-20 122034126540
    14
    2025-02-20 132034128098
    15
    2025-02-20 142034136199
    16
    2025-02-22 0392036201
    17
    2025-02-22 0492036303
    18
    2025-02-22 1292036677
    19
    2025-02-23 15190836731
    20
    2025-02-23 16190836844
    ...
    410
    12KB
    39s