AnalyticSagesUniswap V3 : Total Number of Transactions
    Updated 2024-02-19
    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 ethereum.defi.ez_dex_swaps
    WHERE event_name = 'Swap'
    AND amount_in_usd IS NOT NULL
    AND platform = 'uniswap-v3'
    AND DATE(block_timestamp) >= '2023-01-01'
    GROUP BY 1 --, 3, 4, 5, 7
    ORDER BY 1 DESC
    LIMIT 1000
    Last run: 11 months ago
    PLATFORM
    NO_OF_TRANSACTION
    1
    uniswap-v316395967
    1
    25B
    4s