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
23
24
›
⌄
SELECT
PLATFORM,
POOL_NAME,
CONTRACT_ADDRESS,
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
base.defi.ez_dex_swaps
WHERE
BLOCK_TIMESTAMP > TO_TIMESTAMP(1719792000)
AND (
TOKEN_IN = '0x4200000000000000000000000000000000000006'
OR TOKEN_OUT = '0x4200000000000000000000000000000000000006'
)
AND (
TOKEN_IN = '0x833589fcd6edb6e08f4c7c32d4f71b54bda02913'
OR TOKEN_OUT = '0x833589fcd6edb6e08f4c7c32d4f71b54bda02913'
)
GROUP BY
PLATFORM,
CONTRACT_ADDRESS,
POOL_NAME
ORDER BY
VOLUME desc
QueryRunArchived: QueryRun has been archived