Updated 2024-10-18
    SELECT
    symbol_in,
    symbol_out,
    SUM(amount_in_usd) / NULLIF(SUM(amount_out_usd), 0) AS InOutRatio
    FROM
    polygon.defi.ez_dex_swaps
    WHERE
    platform = 'quickswap-v3'
    GROUP BY
    symbol_in, symbol_out
    HAVING
    InOutRatio IS NOT NULL
    ORDER BY
    InOutRatio DESC
    LIMIT 10;

    QueryRunArchived: QueryRun has been archived