Updated 2024-04-04
    WITH
    all_tkx as (
    SELECT
    symbol,
    block_timestamp,
    amount,
    amount_usd,
    tx_hash,
    to_address,
    from_address,
    origin_from_address,
    contract_address,
    'eth' as chain
    FROM
    ethereum.core.ez_token_transfers
    UNION ALL
    SELECT
    symbol,
    block_timestamp,
    amount,
    amount_usd,
    tx_hash,
    to_address,
    from_address,
    origin_from_address,
    contract_address,
    'arb' as chain
    FROM
    arbitrum.core.ez_token_transfers
    UNION ALL
    SELECT
    symbol,
    avax_tkx.block_timestamp,
    avax_tkx.amount,
    avax_tkx.amount_usd,
    avax_tkx.tx_hash,
    QueryRunArchived: QueryRun has been archived