WEEK | DEX_CHAIN | SUM(WEEKLY_VOLUME_USD) | |
|---|---|---|---|
1 | 2024-04-01 00:00:00.000 | uniswap-v2_ethereum | 38262.5 |
2 | 2025-02-10 00:00:00.000 | uniswap-v2_ethereum | 1414819.07 |
3 | 2024-03-25 00:00:00.000 | uniswap-v2_ethereum | 266203.61 |
4 | 2024-01-08 00:00:00.000 | uniswap-v2_ethereum | 4070086.59 |
5 | 2025-02-03 00:00:00.000 | uniswap-v3_ethereum | 465.85 |
6 | 2024-12-09 00:00:00.000 | uniswap-v3_polygon | 54742.21 |
7 | 2025-01-13 00:00:00.000 | uniswap-v3_polygon | 53144.26 |
8 | 2025-05-12 00:00:00.000 | uniswap-v3_polygon | 26503.18 |
9 | 2025-02-03 00:00:00.000 | uniswap-v3_polygon | 91599.67 |
10 | 2024-06-10 00:00:00.000 | uniswap-v2_ethereum | 3391207.43 |
11 | 2024-07-08 00:00:00.000 | uniswap-v2_ethereum | 1912050.15 |
12 | 2025-04-21 00:00:00.000 | uniswap-v2_ethereum | 1006597.22 |
13 | 2024-01-15 00:00:00.000 | uniswap-v3_ethereum | 997968.17 |
14 | 2024-04-22 00:00:00.000 | uniswap-v3_ethereum | 4439.79 |
15 | 2025-03-17 00:00:00.000 | uniswap-v3_ethereum | 89.65 |
16 | 2024-05-13 00:00:00.000 | quickswap-v2_polygon | 136124.3 |
17 | 2024-09-02 00:00:00.000 | quickswap-v2_polygon | 57769.22 |
18 | 2024-06-03 00:00:00.000 | quickswap-v3_polygon | 31.09 |
19 | 2024-12-02 00:00:00.000 | uniswap-v3_base | 350131.56 |
20 | 2025-01-06 00:00:00.000 | uniswap-v3_base | 81059.25 |
alessio9567IXS Swap Volume by Chain
Updated 20 hours ago
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with ixs_swaps AS (
SELECT
DATE_TRUNC('week', block_timestamp) AS week,
'ethereum' AS chain,
platform AS dex,
contract_address as pool_address,
CONCAT(symbol_in, '-', symbol_out) AS pool_pair,
SUM(COALESCE(amount_in_usd, amount_out_usd)) AS weekly_volume_usd
FROM
ethereum.defi.ez_dex_swaps
WHERE
(
symbol_in = 'IXS'
OR symbol_out = 'IXS'
)
AND amount_in_usd IS NOT NULL
AND amount_out_usd IS NOT NULL
and block_timestamp BETWEEN '{{start_day}}'
AND '{{end_day}}'
GROUP BY
week,
chain,
dex,
pool_address,
pool_pair
UNION
all
SELECT
DATE_TRUNC('week', block_timestamp) AS week,
'polygon' AS chain,
platform AS dex,
contract_address as pool_address,
CONCAT(symbol_in, '-', symbol_out) AS pool_pair,
SUM(COALESCE(amount_in_usd, amount_out_usd)) AS weekly_volume_usd
FROM
Last run: about 20 hours agoAuto-refreshes every 24 hours
...
308
18KB
155s