DATE | VOLUME_RANGE | CATEGORY_NAME | NUM_SWAPPERS | |
|---|---|---|---|---|
1 | 2025-02-22 00:00:00.000 | <$10 | Tiny Swapper (<$10) | 46 |
2 | 2025-02-22 00:00:00.000 | $10 - $99 | Small Swapper ($10 - $99) | 135 |
3 | 2025-02-22 00:00:00.000 | $100 - $499 | Medium Swapper ($100 - $499) | 157 |
4 | 2025-02-22 00:00:00.000 | $500 - $999 | Large Swapper ($500 - $999) | 42 |
5 | 2025-02-22 00:00:00.000 | ≥ $1000 | Whale Swapper (≥ $1000) | 175 |
6 | 2025-02-23 00:00:00.000 | <$10 | Tiny Swapper (<$10) | 65 |
7 | 2025-02-23 00:00:00.000 | $10 - $99 | Small Swapper ($10 - $99) | 171 |
8 | 2025-02-23 00:00:00.000 | $100 - $499 | Medium Swapper ($100 - $499) | 136 |
9 | 2025-02-23 00:00:00.000 | $500 - $999 | Large Swapper ($500 - $999) | 54 |
10 | 2025-02-23 00:00:00.000 | ≥ $1000 | Whale Swapper (≥ $1000) | 99 |
11 | 2025-02-24 00:00:00.000 | <$10 | Tiny Swapper (<$10) | 175 |
12 | 2025-02-24 00:00:00.000 | $10 - $99 | Small Swapper ($10 - $99) | 112 |
13 | 2025-02-24 00:00:00.000 | $100 - $499 | Medium Swapper ($100 - $499) | 159 |
14 | 2025-02-24 00:00:00.000 | $500 - $999 | Large Swapper ($500 - $999) | 51 |
15 | 2025-02-24 00:00:00.000 | ≥ $1000 | Whale Swapper (≥ $1000) | 78 |
16 | 2025-02-25 00:00:00.000 | <$10 | Tiny Swapper (<$10) | 61 |
17 | 2025-02-25 00:00:00.000 | $10 - $99 | Small Swapper ($10 - $99) | 281 |
18 | 2025-02-25 00:00:00.000 | $100 - $499 | Medium Swapper ($100 - $499) | 185 |
19 | 2025-02-25 00:00:00.000 | $500 - $999 | Large Swapper ($500 - $999) | 77 |
20 | 2025-02-25 00:00:00.000 | ≥ $1000 | Whale Swapper (≥ $1000) | 90 |
feyikemiDaily Distribution of Swappers
Updated 2025-03-26
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 swap_data AS (
SELECT
ORIGIN_FROM_ADDRESS AS swapper,
Date_trunc('day', Block_timestamp) AS date,
SUM(AMOUNT_USD) AS total_volume
FROM ronin.core.ez_token_transfers
WHERE ORIGIN_TO_ADDRESS = '0x5f0acdd3ec767514ff1bf7e79949640bf94576bd'
AND ORIGIN_FUNCTION_SIGNATURE = '0x3593564c'
AND SYMBOL = 'Ronke'
AND BLOCK_TIMESTAMP::date >= '2025-02-22'
GROUP BY ORIGIN_FROM_ADDRESS, date
),
volume_brackets AS (
SELECT
swapper,
date,
total_volume,
CASE
WHEN total_volume < 10 THEN '<$10'
WHEN total_volume >= 10 AND total_volume < 100 THEN '$10 - $99'
WHEN total_volume >= 100 AND total_volume < 500 THEN '$100 - $499'
WHEN total_volume >= 500 AND total_volume < 1000 THEN '$500 - $999'
ELSE '≥ $1000'
END AS volume_range,
CASE
WHEN total_volume < 10 THEN 'Tiny Swapper (<$10)'
WHEN total_volume >= 10 AND total_volume < 100 THEN 'Small Swapper ($10 - $99)'
WHEN total_volume >= 100 AND total_volume < 500 THEN 'Medium Swapper ($100 - $499)'
WHEN total_volume >= 500 AND total_volume < 1000 THEN 'Large Swapper ($500 - $999)'
ELSE 'Whale Swapper (≥ $1000)'
END AS category_name
FROM swap_data
)
SELECT
Last run: 2 months ago
...
165
11KB
2s