SELECT
DATE_TRUNC('week', block_timestamp) AS date,
pool_name,
SUM(jit_swap_volume_usd) AS jit_swap_volume_usd
FROM
ethereum.dex.jit_liquidity_events
WHERE
project = 'uniswap'
AND block_timestamp >= CURRENT_TIMESTAMP() - INTERVAL '24 months'
GROUP BY
ALL
ORDER BY
date DESC,
jit_swap_volume_usd DESC
LIMIT
500000
2024-09-16T00:00:00
Uniswap: INF-TITANX 10000
2024-09-16T00:00:00
Uniswap: USDC-WETH 500
2024-09-16T00:00:00
Uniswap: Neiro-WETH 10000
2024-09-16T00:00:00
Uniswap: USDC-USDT 100