JeffersMon transfers
    Updated 2025-03-05
    select
    DATE(t.block_timestamp) AS transfer_date,
    COUNT(*) AS total_transfers,
    round(SUM(t.value), 2) AS total_value
    from monad.testnet.fact_transactions t
    LEFT JOIN monad.testnet.dim_contracts c
    on t.to_address = c.address -- Check if receiver is a smart contract
    where t.value > 0 and t.block_timestamp >= '2025-02-19 15:00' and t.tx_succeeded = 'TRUE'
    AND c.address IS NULL -- Only include transfers to EOAs
    AND t.from_address != t.to_address -- Exclude self-transfers
    group by transfer_date
    ORDER BY transfer_date ASC;
    Last run: 14 days ago
    TRANSFER_DATE
    TOTAL_TRANSFERS
    TOTAL_VALUE
    1
    2025-02-19 00:00:00.0001590212143616.93
    2
    2025-02-20 00:00:00.00011213264214603.67
    3
    2025-02-21 00:00:00.00010241363523760.83
    4
    2025-02-22 00:00:00.00048757542783419.25
    5
    2025-02-23 00:00:00.0005429664623335.54
    6
    2025-02-24 00:00:00.0006148824866384.32
    7
    2025-02-25 00:00:00.0009443178597674.02
    8
    2025-02-26 00:00:00.00015430447142873.65
    9
    2025-02-27 00:00:00.0007822493997776.69
    10
    2025-02-28 00:00:00.00012761133033618.36
    11
    2025-03-01 00:00:00.0007420323455750.17
    12
    2025-03-02 00:00:00.0006953202406623.55
    13
    2025-03-03 00:00:00.00086086413931053.35
    14
    2025-03-04 00:00:00.00010086813113053.66
    15
    2025-03-05 00:00:00.0009182712337439.42
    15
    698B
    8s