kumbayaaBASE-TOTAL TXNS OVER-TIME
    Updated 2024-04-15
    -- forked from BASE-TOTAL TXNS @ https://flipsidecrypto.xyz/edit/queries/3e172521-eb33-4887-9dde-ce3601214643

    SELECT
    date_trunc('day' , block_timestamp) as date,
    COUNT(tx_hash) AS total_transactions,

    FROM base.defi.ez_dex_swaps
    WHERE date(block_timestamp) >= '2024-04-01'
    GROUP BY 1
    ORDER BY 1 DESC


    QueryRunArchived: QueryRun has been archived