TOTAL_DOLPHINS | TOTAL_SWAPS_BY_DOLPHINS | TOTAL_VOLUME_BY_DOLPHINS | |
|---|---|---|---|
1 | 3327 | 624573 | 93658918.2268928 |
datavortextotals 2
Updated 2024-12-13
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
›
⌄
WITH trader_volumes AS (
SELECT
s.trader,
SUM(s.amount_in_usd) AS total_volume,
COUNT(DISTINCT s.tx_hash) AS total_swaps
FROM
near.defi.ez_dex_swaps s
WHERE
s.block_timestamp >= '2024-01-01'
AND s.block_timestamp <= '2024-12-31'
GROUP BY
s.trader
),
categorized_traders AS (
SELECT
trader,
total_volume,
total_swaps,
CASE
WHEN total_volume > 10000 AND total_volume <= 99999 THEN 'Dolphins'
ELSE 'Other'
END AS trader_category
FROM
trader_volumes
)
SELECT
COUNT(DISTINCT trader) AS total_dolphins,
SUM(total_swaps) AS total_swaps_by_dolphins,
SUM(total_volume) AS total_volume_by_dolphins
FROM
categorized_traders
WHERE
trader_category = 'Dolphins';
Last run: 10 days ago
1
32B
580s