damideztrend
    Updated 2024-09-03
    WITH ArbOrder AS (
    SELECT
    block_timestamp,
    tx_hash,
    origin_from_address,
    origin_function_signature,
    amount,
    amount_usd,
    'Arbitrum' AS chain
    FROM arbitrum.core.ez_token_transfers
    WHERE
    to_address = '0xc8a8ce0ab010e499ca57477ac031358febcbbf17'
    AND origin_function_signature = '0x413aaa60'
    ),
    EthOrder AS (
    SELECT
    block_timestamp,
    tx_hash,
    origin_from_address,
    origin_function_signature,
    amount,
    amount_usd,
    'Ethereum' AS chain
    FROM ethereum.core.ez_token_transfers
    WHERE
    to_address = '0xc8a8ce0ab010e499ca57477ac031358febcbbf17'
    AND origin_function_signature = '0x413aaa60'
    ),
    OptOrder AS (
    SELECT
    block_timestamp,
    tx_hash,
    origin_from_address,
    origin_function_signature,
    amount,
    amount_usd,
    QueryRunArchived: QueryRun has been archived