frankmaseovoluminous-indigo
    Updated 2025-04-10
    SELECT
    BLOCK_NUMBER,
    BLOCK_TIMESTAMP,
    TX_HASH,
    FROM_ADDRESS,
    TO_ADDRESS,
    GAS,
    GAS_USED
    FROM polygon.core.fact_traces t
    WHERE
    t.block_number > 58000000
    /*AND t.origin_from_address IN (
    {{insert_addresses_here}}
    )*/
    AND t.tx_succeeded
    and TYPE in ('CREATE', 'CREATE2')
    AND t.TRACE_SUCCEEDED
    Last run: 17 days ago
    TYPE
    1
    CREATE
    2
    CALL
    3
    SELFDESTRUCT
    4
    STATICCALL
    5
    CREATE2
    6
    CALLCODE
    7
    DELEGATECALL
    7
    95B
    153s