flipside

    11
    zyroq11
    Updated 2025-05-29
    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
    platform,
    SUM(COALESCE(amount_in_usd, amount_out_usd, 0)) AS total_volume_usd,
    COUNT(DISTINCT swapper) AS unique_swappers,
    COUNT(tx_hash) AS total_swaps
    FROM aptos.defi.ez_dex_swaps
    WHERE block_timestamp >= DATEADD(DAY, -7, CURRENT_DATE) -- Last 7 days
    GROUP BY platform,date
    ORDER BY date DESC;
    Last run: 18 days ago
    DATE
    PLATFORM
    TOTAL_VOLUME_USD
    UNIQUE_SWAPPERS
    TOTAL_SWAPS
    1
    		2025-05-29 00:00:00.000thala498748.3638267331571164965
    2
    		2025-05-29 00:00:00.000animeswap560.1345637451622052
    3
    		2025-05-29 00:00:00.000hyperfluid03770151134
    4
    		2025-05-29 00:00:00.000liquidswap909287.31744738674410815
    5
    		2025-05-29 00:00:00.000hippo372.36747313169
    6
    		2025-05-29 00:00:00.000auxexchange373.24009117764159
    7
    		2025-05-29 00:00:00.000sushi568615.7146677782142758
    8
    		2025-05-29 00:00:00.000pancake672229.7347479287729124
    9
    		2025-05-29 00:00:00.000cetus1076.57047202422236
    10
    		2025-05-29 00:00:00.000batswap207.3627795471141
    11
    		2025-05-29 00:00:00.000cellana3016402.241573159285221
    12
    		2025-05-28 00:00:00.000thala717390.8222724611782250490
    13
    		2025-05-28 00:00:00.000cetus1849.57317398730380
    14
    		2025-05-28 00:00:00.000animeswap1030.0363446932153273
    15
    		2025-05-28 00:00:00.000auxexchange863.98841793983228
    16
    		2025-05-28 00:00:00.000sushi977001.7728963582664368
    17
    		2025-05-28 00:00:00.000hyperfluid06698185490
    18
    		2025-05-28 00:00:00.000hippo548.7891059411103
    19
    		2025-05-28 00:00:00.000cellana5465611.522759081832143115
    20
    		2025-05-28 00:00:00.000batswap204.378908241941
    88
    5KB
    2s