HOLDER | CHAIN | |
|---|---|---|
1 | 39 | Ethereum |
2 | 4 | Avalanche |
3 | 3 | Polygon |
4 | 3 | Arbitrum |
5 | 2 | Optimism |
6 | 2 | Aptos |
tkvresearchlow-blush
Updated 2025-03-23
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 list_contract as (
select *
from (values
('0x7712c34205737192402172409a8F7ccef8aA2AEc'),
('0xA6525Ae43eDCd03dC08E775774dCAbd3bb925872'),
('0xa1CDAb15bBA75a80dF4089CaFbA013e376957cF5'),
('0x2893Ef551B6dD69F661Ac00F11D93E5Dc5Dc0e99'),
('0x53FC82f14F009009b440a706e31c9021E1196A2F')
) as l(address)
)
--ethereum, optimism, arbitrum, polygon, avalanche
select count(distinct address) as holder,
chain
from
(select
address,
chain,
sum(amt) as total_bal
from
(select date(block_timestamp) as datetime,
'Ethereum' as chain,
to_address as address,
amount as amt
from ethereum.core.ez_token_transfers
where contract_address in (select lower(address) from list_contract)
and
from_address = '0x0000000000000000000000000000000000000000'
union all
select date(block_timestamp) as datetime,
'Ethereum',
from_address,
-amount
from ethereum.core.ez_token_transfers
where contract_address in (select lower(address) from list_contract)
and
Last run: about 1 month ago
6
89B
37s