TRADING_PAIR | DOLPHIN_VOLUME | |
|---|---|---|
1 | wNEAR -> USDC | 9745863.85965953 |
2 | USDC -> wNEAR | 7676026.39293367 |
3 | USDt -> USDC | 6821425.29468886 |
4 | USDC -> USDt | 6335605.3629848 |
5 | USDC -> USDC.e | 4264543.37656135 |
datavortexscared-coral
Updated 3 days 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 trader_volumes AS (
SELECT
s.trader,
s.symbol_in,
s.symbol_out,
SUM(s.amount_in_usd) AS total_volume
FROM
near.defi.ez_dex_swaps s
WHERE
s.block_timestamp >= '2024-01-01'
AND s.block_timestamp <= '2024-12-31'
AND s.symbol_in IS NOT NULL
AND s.symbol_out IS NOT NULL
GROUP BY
s.trader,
s.symbol_in,
s.symbol_out
),
dolphin_trading_pairs AS (
SELECT
CONCAT(symbol_in, ' -> ', symbol_out) AS trading_pair,
SUM(total_volume) AS dolphin_volume
FROM
trader_volumes
WHERE
total_volume > 10000
AND total_volume <= 99999
GROUP BY
symbol_in,
symbol_out
)
SELECT
trading_pair,
dolphin_volume
FROM
dolphin_trading_pairs
Last run: 3 days ago
5
174B
264s