deevhyn2024-03-05 11:12 AM
    Updated 2024-03-31
    SELECT
    --date_trunc('day',block_timestamp) AS Date,
    -- origin_from_address,
    platform,
    --symbol_in,
    -- amount_in_usd,
    --event_name,
    COUNT(DISTINCT tx_hash) AS No_Of_Transactions
    FROM ethereum.defi.ez_dex_swaps
    WHERE
    platform IN('uniswap-v3','curve', 'sushiswap')
    AND amount_in_usd IS NOT NULL
    --AND event_name= 'Swap'
    GROUP BY 1
    ORDER BY 1 DESC


    QueryRunArchived: QueryRun has been archived