namanasync2024-06-27 12:53 PM
    Updated 2024-06-27
    select
    block_timestamp,
    tx_hash,
    'crypto withdrawal' type,
    'nft' asset_type,
    nft_from_address sender_address,
    1 sent_quantity,
    (project_name || ' #' || tokenid) as sent_currency,
    nft_address asset_address,
    nft_to_address received_address,
    0 received_quantity,
    '' received_currency,

    0 as fee_amount,
    '' as fee_currency

    from ethereum.nft.ez_nft_transfers
    where nft_from_address = lower('0x944fdeA9d4956ce673C7545862cefCcad6Ee1B04')
    and block_timestamp >= DATEADD(day, -60, CURRENT_TIMESTAMP)

    UNION ALL

    select
    block_timestamp,
    tx_hash,
    'crypto deposit' type,
    'nft' asset_type,
    nft_from_address sender_address,
    0 sent_quantity,
    '' as sent_currency,
    nft_address asset_address,
    nft_to_address received_address,
    1 received_quantity,
    (project_name || ' #' || tokenid) received_currency,

    0 as fee_amount,
    QueryRunArchived: QueryRun has been archived