crypto_gostTOTAL_SWAP, UNIQUE_SWAPPERS
    Updated 2024-11-14
    SELECT
    COUNT( tx_hash) AS total_swaps,
    COUNT(DISTINCT origin_from_address) AS unique_swappers,
    SUM(amount_in_usd) AS total_volume,
    FROM blast.defi.ez_dex_swaps
    WHERE platform = 'ambient'
    AND block_timestamp >= DATEADD(day, -30, CURRENT_DATE)
    ;


    QueryRunArchived: QueryRun has been archived