pecio222ALL DEXES WETH USDC
Updated 2024-12-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
SELECT
PLATFORM,
POOL_NAME,
SUM(COALESCE(AMOUNT_OUT_USD, AMOUNT_IN_USD, 0)) AS VOLUME,
SUM(COALESCE(AMOUNT_OUT_USD, AMOUNT_IN_USD, 0)) / SUM(SUM(COALESCE(AMOUNT_OUT_USD, AMOUNT_IN_USD, 0))) OVER () AS VOLUME_PCT
FROM
arbitrum.defi.ez_dex_swaps
WHERE
BLOCK_TIMESTAMP > TO_TIMESTAMP(1719792000)
AND (
TOKEN_IN = '0xaf88d065e77c8cc2239327c5edb3a432268e5831'
OR TOKEN_OUT = '0xaf88d065e77c8cc2239327c5edb3a432268e5831'
)
AND (
TOKEN_IN = '0x82af49447d8a07e3bd95bd0d56f35241523fbab1'
OR TOKEN_OUT = '0x82af49447d8a07e3bd95bd0d56f35241523fbab1'
)
GROUP BY
PLATFORM,
POOL_NAME
ORDER BY
VOLUME desc
QueryRunArchived: QueryRun has been archived