CryptoLionUntitled Query
    Updated 2021-08-05
    -- (
    -- SELECT trunc(block_timestamp, 'day') as date,COUNT(DISTINCT tx_id) as total_swaps,platform
    -- FROM ethereum.dex_swaps
    -- WHERE platform IN ('uniswap-v3') AND date >= CURRENT_DATE - 90
    -- GROUP BY 1,3
    -- ORDER BY 1 DESC
    -- )
    -- UNION ALL
    -- (
    SELECT trunc(block_timestamp, 'day') as date,COUNT(DISTINCT tx_id) as total_swaps,platform
    FROM ethereum.dex_swaps
    WHERE platform IN ('uniswap-v2') AND date >= CURRENT_DATE - 90
    GROUP BY 1,3
    ORDER BY 1 DESC
    -- )
    Run a query to Download Data