rezarwzSIG FINDER
    Updated 2024-03-21
    SELECT
    DISTINCT ORIGIN_FUNCTION_SIGNATURE,
    tx_hash
    FROM
    blast.core.fact_transactions
    Where
    to_address = '0x4300000000000000000000000000000000000003'
    and (
    block_timestamp,
    ORIGIN_FUNCTION_SIGNATURE
    ) in(
    SELECT
    max(block_timestamp),
    ORIGIN_FUNCTION_SIGNATURE
    FROM
    blast.core.fact_transactions
    Where
    to_address = '0x4300000000000000000000000000000000000003'
    group by
    2
    )
    QueryRunArchived: QueryRun has been archived