flipside

    SIG Particle
    rezarwzSIG Particle
    Updated 2024-03-24
    SELECT
    tx_hash,
    ORIGIN_FUNCTION_SIGNATURE as sig,
    n_tx
    from
    blast.core.fact_transactions f
    inner join (
    SELECT
    count(tx_hash) as n_tx,
    ORIGIN_FUNCTION_SIGNATURE as sig
    from
    blast.core.fact_transactions f
    where
    to_address = '0x121b5ac4de4a3e6f4171956bc26ceda40cb61a56'
    and STATUS = 'SUCCESS'
    group by
    2
    ) as t on t.SIG = f.ORIGIN_FUNCTION_SIGNATURE
    where
    to_address = '0x121b5ac4de4a3e6f4171956bc26ceda40cb61a56'
    and STATUS = 'SUCCESS'
    and (
    ORIGIN_FUNCTION_SIGNATURE,
    block_timestamp
    ) in (
    SELECT
    ORIGIN_FUNCTION_SIGNATURE,
    max(block_timestamp) as block_timestamp
    from
    blast.core.fact_transactions
    where
    to_address = '0x121b5ac4de4a3e6f4171956bc26ceda40cb61a56'
    and STATUS = 'SUCCESS'
    group by
    1
    )
    QueryRunArchived: QueryRun has been archived