Date | Number of Holders | Chain | |
|---|---|---|---|
1 | 2025-04-05 00:00:00.000 | 43524 | Ethereum |
2 | 2025-04-05 00:00:00.000 | 7826 | Swell Chain |
Eman-RazTotal Number of Holders By Chain
Updated 2025-04-05
999
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 swell_chain as (
with transactions 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 block_timestamp::date as date, 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 block_timestamp::date as date, to_address as address, amount
from tab1
where contract_address=lower('0x2826D136F5630adA89C1678b64A61620Aab77Aea'))
select * from table1 union all
select * from table2),
date_list as (
select
block_timestamp :: date as date
from
Last run: 20 days ago
2
93B
20s