ravelmon giveaways
    Updated 2025-02-23
    with total_transfers AS (
    SELECT from_address as sender,
    value
    FROM monad.testnet.fact_traces
    WHERE type = 'CALL'
    AND from_address NOT IN (SELECT address FROM monad.testnet.dim_contracts WHERE address IS NOT NULL)
    AND block_timestamp::DATE >= DATE '2025-02-19'
    AND input = '0x' -- Ensure '0x' is treated as a string
    AND TX_SUCCEEDED = 'TRUE'
    AND TRACE_SUCCEEDED = 'TRUE'
    )

    select sender,
    sum(value) AS total_sent
    from total_transfers
    group by 1
    order by 2 desc
    limit 200





    QueryRunArchived: QueryRun has been archived