Total Users | Whale Users | Normal Users | Total Initial Volume | Whale Initial Volume | Normal Initial Volume | |
|---|---|---|---|---|---|---|
1 | 69620 | 817 | 68803 | 58529390 | 36091361 | 22438030 |
HadisehTotal User
Updated 7 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 user_first_trade AS (
SELECT
origin_from_address AS user_id,
COALESCE(amount_in_usd, amount_out_usd) AS initial_trade_size,
CASE
WHEN initial_trade_size >= 10000 THEN 'Whale'
ELSE 'Normal'
END AS user_category
FROM
avalanche.defi.ez_dex_swaps
WHERE
platform IN ('pharaoh-v1', 'pharaoh-v2')
AND block_timestamp >= '2025-01-01' QUALIFY ROW_NUMBER() OVER (
PARTITION BY origin_from_address
ORDER BY
block_timestamp
) = 1
)
SELECT
COUNT(DISTINCT user_id) AS "Total Users",
COUNT(
DISTINCT CASE
WHEN user_category = 'Whale' THEN user_id
END
) AS "Whale Users",
COUNT(
DISTINCT CASE
WHEN user_category = 'Normal' THEN user_id
END
) AS "Normal Users",
ROUND(SUM(initial_trade_size)) AS "Total Initial Volume",
ROUND(
SUM(
CASE
WHEN user_category = 'Whale' THEN initial_trade_size
END
Last run: 7 days ago
1
46B
2s