crypto_gostdaily swaps
    Updated 2024-11-19
    WITH daily_stats AS (
    SELECT
    DATE_TRUNC('DAY', block_timestamp) AS swap_date,
    COUNT(*) AS daily_swap_transactions,
    COUNT(DISTINCT trader) AS daily_unique_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'
    GROUP BY
    DATE_TRUNC('DAY', block_timestamp)
    ),
    daily_averages AS (
    SELECT
    AVG(daily_swap_transactions) AS avg_daily_swap_transactions,
    AVG(daily_unique_swappers) AS avg_daily_unique_swappers
    FROM
    daily_stats
    )
    SELECT
    swap_date,
    daily_swap_transactions,
    daily_unique_swappers,
    avg_daily_swap_transactions,
    avg_daily_unique_swappers
    FROM
    daily_stats
    CROSS JOIN
    daily_averages
    ORDER BY
    swap_date;
    QueryRunArchived: QueryRun has been archived