namanasynctoken_withdrawals
    Updated 2024-06-26
    select
    block_timestamp,
    tx_hash,
    'crypto withdrawal' type,
    from_address sender_address,
    amount sent_quantity,
    symbol as sent_currency,
    CONTRACT_ADDRESS asset_address,
    to_address received_address,
    0 received_quantity,
    '' received_currency,

    0 as fee_amount,
    '' as fee_currency

    from ethereum.core.ez_token_transfers
    where from_address = lower('0x944fdeA9d4956ce673C7545862cefCcad6Ee1B04')
    and block_timestamp >= DATEADD(day, -60, CURRENT_TIMESTAMP)

    UNION ALL

    select
    block_timestamp,
    tx_hash,
    'crypto deposit' type,
    from_address sender_address,
    0 sent_quantity,
    '' as sent_currency,
    CONTRACT_ADDRESS asset_address,
    to_address received_address,
    amount received_quantity,
    symbol received_currency,

    0 as fee_amount,
    '' as fee_currency

    QueryRunArchived: QueryRun has been archived