Number of Chain | Number of Holders | |
---|---|---|
1 | 1 | 48740 |
2 | 2 | 3037 |
Eman-RazDistribution of Addresses Based on the Number of Chains Where They Hold SWELL Tokens
Updated 2025-05-17Copy Reference Fork
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 final_table as (with overview as (with swell as (with tab2 as (with tab1 as
(SELECT lower(from_data.value:"value"::STRING) AS user --from_address,
,-amount_data.value:"value"::NUMBER/pow(10,18) AS amount
FROM swell.core.ez_decoded_event_logs,
LATERAL FLATTEN(input => full_decoded_log:"data") from_data,
LATERAL FLATTEN(input => full_decoded_log:"data") to_data,
LATERAL FLATTEN(input => full_decoded_log:"data") amount_data
WHERE from_data.value:"name" = 'from'
AND to_data.value:"name" = 'to'
AND amount_data.value:"name" = 'value'
and event_name='Transfer'
and tx_succeeded='TRUE'
and lower(full_decoded_log:"address"::STRING)=lower('0x2826D136F5630adA89C1678b64A61620Aab77Aea')
union all
SELECT
lower(to_data.value:"value"::STRING) AS user --to_address,
,amount_data.value:"value"::NUMBER/pow(10,18) AS amount
FROM swell.core.ez_decoded_event_logs,
LATERAL FLATTEN(input => full_decoded_log:"data") from_data,
LATERAL FLATTEN(input => full_decoded_log:"data") to_data,
LATERAL FLATTEN(input => full_decoded_log:"data") amount_data
WHERE from_data.value:"name" = 'from'
AND to_data.value:"name" = 'to'
AND amount_data.value:"name" = 'value'
and event_name='Transfer'
and tx_succeeded='TRUE'
and lower(full_decoded_log:"address"::STRING)=lower('0x2826D136F5630adA89C1678b64A61620Aab77Aea'))
select user, sum(amount) as balance
from tab1
group by 1)
select user as "Holder", balance, 'Swell Network' as "Chain"
from tab2
Last run: about 2 months ago
2
20B
11s