crypto_gosttotal swaps
    Updated 2024-11-19
    SELECT
    COUNT(*) AS total_swaps,
    SUM(CASE
    WHEN token_in_contract = 'nearvember-337.meme-cooking.near' THEN amount_in_usd
    WHEN token_out_contract = 'nearvember-337.meme-cooking.near' THEN amount_out_usd
    ELSE 0
    END) AS total_volume_usd,
    COUNT(DISTINCT trader) AS total_swappers
    FROM
    NEAR.defi.ez_dex_swaps
    WHERE
    token_in_contract = 'nearvember-337.meme-cooking.near'
    OR token_out_contract = 'nearvember-337.meme-cooking.near';

    QueryRunArchived: QueryRun has been archived