flipside

    11
    zyroq11
    Updated 11 hours ago
    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: about 11 hours ago
    DATE
    PLATFORM
    TOTAL_VOLUME_USD
    UNIQUE_SWAPPERS
    TOTAL_SWAPS
    1
    		2025-04-07 00:00:00.000pancake810687.1248642570915368
    2
    		2025-04-07 00:00:00.000cellana2014726.51702802201358021
    3
    		2025-04-07 00:00:00.000cetus2468.41757006385040
    4
    		2025-04-07 00:00:00.000liquidswap1056618.42731762324827624
    5
    		2025-04-07 00:00:00.000hippo11061.413180169112042
    6
    		2025-04-07 00:00:00.000sushi826024.0518700183355566
    7
    		2025-04-07 00:00:00.000batswap339.1084375796150
    8
    		2025-04-07 00:00:00.000thala472516.47701556974410906
    9
    		2025-04-07 00:00:00.000auxexchange887.909486908100563
    10
    		2025-04-07 00:00:00.000animeswap956.6319414093954772
    11
    		2025-04-06 00:00:00.000cellana4961420.397264812674138790
    12
    		2025-04-06 00:00:00.000cetus3105.574439514206405
    13
    		2025-04-06 00:00:00.000pancake1087376.184431120619192
    14
    		2025-04-06 00:00:00.000liquidswap1789206.09018216858443853
    15
    		2025-04-06 00:00:00.000hippo17528.431143635152131
    16
    		2025-04-06 00:00:00.000animeswap1349.5675980274115804
    17
    		2025-04-06 00:00:00.000batswap365.7180129427103
    18
    		2025-04-06 00:00:00.000sushi1115035.822873674645989
    19
    		2025-04-06 00:00:00.000auxexchange1613.159169162112810
    20
    		2025-04-06 00:00:00.000thala1324759.15790353106514292
    80
    5KB
    3s