rezarwzsig finder copy
    Updated 2024-04-05
    0x05123bb4-- forked from sig finder @ https://flipsidecrypto.xyz/edit/queries/cef05185-07d0-46aa-8252-989b6f1489dc

    SELECT
    DISTINCT ORIGIN_FUNCTION_SIGNATURE,
    tx_hash
    FROM
    blast.core.fact_transactions
    Where
    to_address = '0x121b5ac4de4a3e6f4171956bc26ceda40cb61a56'
    and (
    block_timestamp,
    ORIGIN_FUNCTION_SIGNATURE
    ) in(
    SELECT
    max(block_timestamp),
    ORIGIN_FUNCTION_SIGNATURE
    FROM
    blast.core.fact_transactions
    Where
    to_address = '0x121b5ac4de4a3e6f4171956bc26ceda40cb61a56'
    group by
    2
    )


    QueryRunArchived: QueryRun has been archived