flipside

    Uniswap-v3 Total Number of Transactions from 2023
    feyikemiUniswap-v3 Total Number of Transactions from 2023
    Updated 2024-02-21
    -- Total number of transactions from January 2023

    SELECT
    platform,
    COUNT(DISTINCT tx_hash) AS no_of_transaction

    FROM ethereum.defi.ez_dex_swaps

    WHERE platform = 'uniswap-v3'
    AND block_timestamp :: date >= '2023-01-01'

    GROUP BY 1

    ORDER BY 1 DESC

    LIMIT 1000

    Last run: over 1 year ago
    PLATFORM
    NO_OF_TRANSACTION
    1
    		uniswap-v319042434
    1
    25B
    6s