freemartian2024-04-01 01:26 AM
    Updated 2024-04-01
    WITH from_op AS (
    -- SELECT
    -- block_timestamp,
    -- tx_hash,
    -- from_address AS bridger,
    -- amount,
    -- amount_usd,
    -- 'ETH' AS symbol,
    -- 'inbound' AS direction,
    -- '1' AS rank
    -- FROM optimism.core.ez_native_transfers
    -- WHERE to_address = '0x1572d48a52906b834fb236aa77831d669f6d87a1'
    -- AND from_address <> '0x4200000000000000000000000000000000000006'

    -- UNION

    SELECT
    block_timestamp,
    tx_hash,
    origin_from_address AS bridger,
    amount,
    amount_usd,
    symbol,
    'outbound' AS direction,
    rank() over (partition BY tx_hash ORDER BY event_index ASC) AS rank
    FROM optimism.core.ez_token_transfers
    WHERE to_address = '0x1572d48a52906b834fb236aa77831d669f6d87a1'
    AND symbol <> 'Visit blast2l.com to claim rewards'
    -- AND tx_hash NOT IN (
    -- SELECT tx_hash FROM optimism.core.ez_native_transfers
    -- WHERE to_address = '0x1572d48a52906b834fb236aa77831d669f6d87a1'
    -- AND from_address <> '0x4200000000000000000000000000000000000006'
    -- )
    qualify rank = 1
    ORDER BY block_timestamp ASC
    ),
    QueryRunArchived: QueryRun has been archived