feyikemiAptos Daily Trends
    Updated 2025-03-25
    WITH Stats AS (
    SELECT
    DATE_TRUNC('day', block_timestamp) AS Date,
    Tx_hash,
    Swapper,
    COALESCE(amount_in_usd, amount_out_usd) AS Volume
    FROM
    aptos.defi.ez_dex_swaps
    WHERE block_timestamp::DATE >= '{{Start_Date}}'
    AND amount_in_usd < 1e6
    AND amount_out_usd < 1e6
    ),

    DailyStats AS (
    SELECT
    Date,
    COUNT(DISTINCT Tx_hash) AS Total_trades,
    COUNT(DISTINCT Swapper) AS Total_Traders,
    SUM(Volume) AS Total_Traded_Volume
    FROM Stats
    GROUP BY Date
    )

    SELECT
    Date,
    Total_trades,
    Total_Traders,
    Total_Traded_Volume,
    SUM(Total_trades) OVER (ORDER BY Date) AS Cumulative_Trades,
    SUM(Total_Traders) OVER (ORDER BY Date) AS Cumulative_Traders,
    SUM(Total_Traded_Volume) OVER (ORDER BY Date) AS Cumulative_Volume
    FROM DailyStats
    ORDER BY Date DESC
    Last run: 2 months ago
    DATE
    TOTAL_TRADES
    TOTAL_TRADERS
    TOTAL_TRADED_VOLUME
    CUMULATIVE_TRADES
    CUMULATIVE_TRADERS
    CUMULATIVE_VOLUME
    1
    2025-03-25 00:00:00.000565134124472.1834354042583633742593319186556919.94382
    2
    2025-03-24 00:00:00.0003512861874325815.842998122583577242591979186432447.76039
    3
    2025-03-23 00:00:00.000967318423739359.752102082580064442530109182106631.91739
    4
    2025-03-22 00:00:00.0001279119602453745.707775212579097142511689178367272.16529
    5
    2025-03-21 00:00:00.0001952022664151933.037816232577818042492089175913526.45751
    6
    2025-03-20 00:00:00.0002830475313944439.340947782575866042469429171761593.4197
    7
    2025-03-19 00:00:00.00036645115284745192.395810752573035642394119167817154.07875
    8
    2025-03-18 00:00:00.00047648185456367254.836735012569371142278839163071961.68294
    9
    2025-03-17 00:00:00.0003236341455992508.813032482564606342093389156704706.8462
    10
    2025-03-16 00:00:00.0002092832373134900.781322842561370042051939150712198.03317
    11
    2025-03-15 00:00:00.0001665625892555068.802648332559277242019569147577297.25185
    12
    2025-03-14 00:00:00.0001574025123052182.331406712557611641993679145022228.4492
    13
    2025-03-13 00:00:00.0002693335436083788.655354442556037641968559141970046.11779
    14
    2025-03-12 00:00:00.0002700930046513091.751613082553344341933129135886257.46244
    15
    2025-03-11 00:00:00.000658261232212361035.41056322550643441903089129373165.71082
    16
    2025-03-10 00:00:00.00054819610712090927.45361252544060841779869117012130.30026
    17
    2025-03-09 00:00:00.0004126539819040771.786195582538578941718799104921202.84665
    18
    2025-03-08 00:00:00.00053740170954363883.479907832534452441678989095880431.06045
    19
    2025-03-07 00:00:00.000628431456511220590.06459152529078441508039091516547.58055
    20
    2025-03-06 00:00:00.0003829798727304554.128091362522794141362389080295957.51595
    ...
    450
    39KB
    16s