Updated 2024-11-19
    WITH buyer_data AS (
    SELECT
    block_timestamp,
    tx_hash,
    platform,
    trader,
    amount_out,
    amount_out_usd
    FROM
    near.defi.ez_dex_swaps
    WHERE
    token_out_contract = 'nearvember-337.meme-cooking.near'
    )

    SELECT
    COUNT(DISTINCT trader) AS unique_buyers,
    COUNT(DISTINCT tx_hash) AS total_transactions
    FROM
    buyer_data;

    QueryRunArchived: QueryRun has been archived