feyikemiWeekday traders
    Updated 2025-03-25
    --Weekday analysis learned from Ali3n https://flipsidecrypto.xyz/Ali3N/dashboards

    SELECT
    dayname(to_date(block_timestamp::date)) as weekday,
    COUNT(DISTINCT TX_HASH) AS Total_Trades,
    COUNT(DISTINCT SWAPPER) AS Total_Traders,
    SUM((AMOUNT_IN_USD + AMOUNT_OUT_USD)/2) AS Total_Traded_Volume
    FROM aptos.defi.ez_dex_swaps
    WHERE BLOCK_TIMESTAMP :: DATE >= '{{Start_Date}}'
    GROUP BY 1
    ORDER BY 3 DESC


    Last run: 2 months ago
    WEEKDAY
    TOTAL_TRADES
    TOTAL_TRADERS
    TOTAL_TRADED_VOLUME
    1
    Tue523281847623781432804699.8802
    2
    Thu4910810475038135020151900.915
    3
    Mon532675042227970553387953.4881
    4
    Wed5002549420220134841092730.984
    5
    Fri4736924413609102953355969.357
    6
    Sun4512804401118109417009963.49
    7
    Sat428840937239866973222551.9037
    7
    280B
    15s