WEEK | POOL_PAIR | SUM(WEEKLY_VOLUME_USD) | |
|---|---|---|---|
1 | 2024-07-15 00:00:00.000 | IXS-WETH_ethereum | 2190419.04 |
2 | 2024-08-12 00:00:00.000 | IXS-WETH_ethereum | 1079634.19 |
3 | 2024-10-07 00:00:00.000 | other | 47.64 |
4 | 2024-05-06 00:00:00.000 | other | 147463.58 |
5 | 2024-12-23 00:00:00.000 | other | 23075.55 |
6 | 2025-03-31 00:00:00.000 | other | 15882.51 |
7 | 2024-09-02 00:00:00.000 | other | 25.69 |
8 | 2024-11-04 00:00:00.000 | IXS-WMATIC_polygon | 91617.75 |
9 | 2024-12-30 00:00:00.000 | other | 44662.79 |
10 | 2025-01-13 00:00:00.000 | IXS-WETH_base | 142281.03 |
11 | 2024-08-26 00:00:00.000 | IXS-WETH_ethereum | 2219922.11 |
12 | 2025-01-20 00:00:00.000 | other | 101079.06 |
13 | 2025-05-19 00:00:00.000 | other | 29307.99 |
14 | 2024-01-08 00:00:00.000 | IXS-WMATIC_polygon | 200518.06 |
15 | 2025-03-17 00:00:00.000 | other | 22218.07 |
16 | 2025-05-05 00:00:00.000 | IXS-WETH_base | 45489.2 |
17 | 2024-06-17 00:00:00.000 | IXS-WETH_ethereum | 4361632.17 |
18 | 2024-11-25 00:00:00.000 | IXS-WMATIC_polygon | 143931.94 |
19 | 2024-10-28 00:00:00.000 | IXS-WETH_ethereum | 1506607.71 |
20 | 2024-01-29 00:00:00.000 | IXS-WMATIC_polygon | 71563.4 |
alessio9567IXS Swap Volume by Pool
Updated 22 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
polygon.defi.ez_dex_swaps
Last run: about 22 hours agoAuto-refreshes every 24 hours
...
246
13KB
137s