saeedmznunion
    Updated 2024-05-13
    with eth_transfers as (
    select
    tx_hash ,
    BLOCK_TIMESTAMP,
    AMOUNT_USD,
    ORIGIN_FROM_ADDRESS ,
    ORIGIN_TO_ADDRESS ,
    'ETH' symbol
    from blast.core.ez_native_transfers
    limit 100
    ),
    token_transfers as (
    select
    tx_hash,
    BLOCK_TIMESTAMP ,
    AMOUNT_USD,
    ORIGIN_FROM_ADDRESS,
    ORIGIN_TO_ADDRESS ,
    SYMBOL
    from blast.core.ez_token_transfers
    limit 100
    )
    select * from eth_transfers
    UNION
    select * from token_transfers

    QueryRunArchived: QueryRun has been archived