Ericmoore_11Optimism : Number of Transactions over Time
    Updated 2024-10-09
    SELECT
    date_trunc('day', block_timestamp) AS Date,
    --origin_from_address,
    --amount_in_usd,
    platform,
    --symbol_in,
    COUNT(DISTINCT tx_hash) AS No_Of_Transaction
    --event_name
    FROM optimism.defi.ez_dex_swaps
    WHERE amount_in_usd IS NOT NULL
    AND DATE(block_timestamp) >= '2023-01-01'
    GROUP BY 1, 2
    ORDER BY No_Of_Transaction DESC