Abbas_ra21Traders
Updated 2024-10-04
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 (
-- Calculate the total volume per trader
SELECT
TRADER,
COALESCE(SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)), 0) AS total_volume
FROM
near.defi.ez_dex_swaps
where
BLOCK_TIMESTAMP between '{{START_DATE}}'
and '{{END_DATE}}'
GROUP BY
TRADER
),
volume_distribution AS (
-- Assign traders to volume categories using numbers
SELECT
TRADER,
total_volume,
CASE
WHEN total_volume between 0 and 100 THEN '0-100' -- Category 1
WHEN total_volume between 100 and 1000 THEN '100-1,000' -- Category 2
WHEN total_volume between 1000 and 10000 THEN '1,000-10,000' -- Category 3
WHEN total_volume between 10000 and 100000 THEN '10,000-100,000' -- Category 4
else '100,000+'
END AS volume_category
FROM
trader_volumes
)
SELECT
volume_category,
COUNT(*) AS trader_count
FROM
volume_distribution
QueryRunArchived: QueryRun has been archived