TOTAL_HOLDERS | |
|---|---|
1 | 54 |
Updated 2025-03-17
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 contracts AS (
SELECT LOWER(address) AS address
FROM (VALUES
('0x7712c34205737192402172409a8f7ccef8aa2aec'), -- Ethereum
('0x6a9DA2D710BB9B700acde7Cb81F10F1fF8C89041'), -- Ethereum
('0xA6525Ae43eDCd03dC08E775774dCAbd3bb925872'), -- Arbitrum
('0xa1CDAb15bBA75a80dF4089CaFbA013e376957cF5'), -- Optimism
('0x2893Ef551B6dD69F661Ac00F11D93E5Dc5Dc0e99'), -- Polygon
('0x53FC82f14F009009b440a706e31c9021E1196A2F') -- Avalanche
) AS data(address)
),
-- Ethereum holders
ethereum_transfers AS (
SELECT from_address AS address,
-SUM(amount) AS bal
FROM ethereum.core.ez_token_transfers
WHERE LOWER(contract_address) IN (SELECT address FROM contracts)
and to_address = '0x0000000000000000000000000000000000000000'
GROUP BY from_address
UNION ALL
SELECT to_address AS address,
SUM(amount) AS bal
FROM ethereum.core.ez_token_transfers
WHERE LOWER(contract_address) IN (SELECT address FROM contracts)
and from_address = '0x0000000000000000000000000000000000000000'
GROUP BY to_address
),
ethereum_holders AS (
SELECT address, SUM(bal) AS holdings
FROM ethereum_transfers
GROUP BY address
),
Last run: about 1 month ago
1
6B
90s