giteez-dex-uniswap-v2/v3
Updated 2023-12-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
POOL_NAME,
CASE
when PLATFORM = 'uniswap-v3' then 'uniswap'
when PLATFORM = 'uniswap-v2' then 'uniswap'
else PLATFORM
end as Platform_Simple,
sum(AMOUNT_IN_USD) as Volume
FROM
ethereum.defi.ez_dex_swaps
WHERE
AMOUNT_IN_USD IS NOT NULL
GROUP BY
POOL_NAME,
PLATFORM
ORDER BY
Volume DESC
LIMIT
10
Run a query to Download Data