Balance Size | Number of Holders | |
|---|---|---|
1 | <= 1 SWELL | 1439 |
2 | 1-10 SWELL | 381 |
3 | 10-100 SWELL | 1737 |
4 | > 100k SWELL | 51 |
5 | 1k-10k SWELL | 1156 |
6 | 10k-100k SWELL | 243 |
7 | 100-1k SWELL | 2847 |
Eman-RazDistribution of Holders By Balance Size (on Swell Chain)
Updated 9 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 overview as (
with table4 as (
with table3 as (
with table1 as (with tab1 as (SELECT
block_timestamp, tx_hash, origin_from_address,
lower(PARSE_JSON(full_decoded_log):"address"::STRING) AS contract_address,
PARSE_JSON(full_decoded_log):"data"[0]:"value"::STRING AS from_address,
PARSE_JSON(full_decoded_log):"data"[1]:"value"::STRING AS to_address,
(PARSE_JSON(full_decoded_log):"data"[2]:"value"::NUMBER)/pow(10,18) AS amount
from swell.core.ez_decoded_event_logs
where tx_succeeded='TRUE' and event_name='Transfer')
select from_address as address, -amount as amount
from tab1
where contract_address=lower('0x2826D136F5630adA89C1678b64A61620Aab77Aea')),
table2 as (with tab1 as (SELECT
block_timestamp, tx_hash, origin_from_address,
lower(PARSE_JSON(full_decoded_log):"address"::STRING) AS contract_address,
PARSE_JSON(full_decoded_log):"data"[0]:"value"::STRING AS from_address,
PARSE_JSON(full_decoded_log):"data"[1]:"value"::STRING AS to_address,
(PARSE_JSON(full_decoded_log):"data"[2]:"value"::NUMBER)/pow(10,18) AS amount
from swell.core.ez_decoded_event_logs
where tx_succeeded='TRUE' and event_name='Transfer')
select to_address as address, amount
from tab1
where contract_address=lower('0x2826D136F5630adA89C1678b64A61620Aab77Aea'))
select * from table1 union all
select * from table2)
select address, sum(amount) as net_amount
from table3
group by 1)
Last run: 9 days ago
7
149B
4s