mondovtop traded pairs past 4 month - uni
    Updated 2023-04-15
    SELECT (SYMBOL_IN || '-' || SYMBOL_OUT) as pair, DATE_TRUNC('week', BLOCK_TIMESTAMP) AS week, COUNT(*) AS swap_count
    FROM optimism.core.ez_dex_swaps
    WHERE PLATFORM = 'uniswap-v3' AND BLOCK_TIMESTAMP > DATEADD(day, -120, CURRENT_TIMESTAMP)
    GROUP BY pair, week
    ORDER BY week DESC, swap_count DESC

    Run a query to Download Data