flipside

    Transaction activity by day of the week
    maymoth55Transaction activity by day of the week
    Updated 2024-09-17
    SELECT EXTRACT(DOW FROM BLOCK_TIMESTAMP) AS day_of_week, COUNT(TX_ID) AS transaction_count
    FROM solana.defi.fact_swaps_jupiter_summary
    WHERE BLOCK_TIMESTAMP BETWEEN '2024-09-01' AND '2024-09-30'
    GROUP BY day_of_week
    ORDER BY transaction_count DESC;

    QueryRunArchived: QueryRun has been archived