DATE | CHAIN | NEW_HOLDERS | CUMULATIVE_HOLDERS | |
|---|---|---|---|---|
1 | 2024-03-04 00:00:00.000 | Ethereum | 1 | 1 |
2 | 2024-03-18 00:00:00.000 | Ethereum | 5 | 6 |
3 | 2024-03-25 00:00:00.000 | Ethereum | 4 | 10 |
4 | 2024-04-01 00:00:00.000 | Ethereum | 9 | 19 |
5 | 2024-04-08 00:00:00.000 | Ethereum | 3 | 22 |
6 | 2024-04-15 00:00:00.000 | Ethereum | 1 | 23 |
7 | 2024-04-22 00:00:00.000 | Ethereum | 3 | 26 |
8 | 2024-04-29 00:00:00.000 | Ethereum | 11 | 37 |
9 | 2024-05-06 00:00:00.000 | Ethereum | 1 | 38 |
10 | 2024-05-13 00:00:00.000 | Ethereum | 1 | 39 |
11 | 2024-05-20 00:00:00.000 | Ethereum | 2 | 41 |
12 | 2024-05-27 00:00:00.000 | Ethereum | 1 | 42 |
13 | 2024-06-03 00:00:00.000 | Ethereum | 11 | 53 |
14 | 2024-06-10 00:00:00.000 | Ethereum | 2 | 55 |
15 | 2024-06-17 00:00:00.000 | Ethereum | 1 | 56 |
16 | 2024-06-24 00:00:00.000 | Ethereum | 2 | 58 |
17 | 2024-07-01 00:00:00.000 | Ethereum | 13 | 71 |
18 | 2024-07-08 00:00:00.000 | Ethereum | 6 | 77 |
19 | 2024-07-15 00:00:00.000 | Ethereum | 2 | 79 |
20 | 2024-07-22 00:00:00.000 | Ethereum | 1 | 80 |
Updated 2025-03-14
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 contracts AS (
SELECT LOWER(address) AS address
FROM (VALUES
('0x7712c34205737192402172409a8f7ccef8aa2aec'),-- Ethereum
('0x6a9DA2D710BB9B700acde7Cb81F10F1fF8C89041'), -- Ethereum
('0xA6525Ae43eDCd03dC08E775774dCAbd3bb925872'), -- Arbitrum
('0xa1CDAb15bBA75a80dF4089CaFbA013e376957cF5'), -- Optimism
('0x2893Ef551B6dD69F661Ac00F11D93E5Dc5Dc0e99'), -- Polygon
('0x53FC82f14F009009b440a706e31c9021E1196A2F') -- Avalanche
) AS data(address)
),
holders AS (
-- Ethereum Holders
SELECT
DATE_TRUNC('week', block_timestamp) AS holder_date,
'Ethereum' AS chain,
COUNT(DISTINCT to_address) AS new_holders
FROM ethereum.core.ez_token_transfers
WHERE LOWER(contract_address) IN (SELECT address FROM contracts)
AND from_address = '0x0000000000000000000000000000000000000000'
GROUP BY 1
UNION ALL
-- Optimism Holders
SELECT
DATE_TRUNC('week', block_timestamp),
'Optimism',
COUNT(DISTINCT to_address) AS new_holders
FROM optimism.core.ez_token_transfers
WHERE LOWER(contract_address) IN (SELECT address FROM contracts)
AND from_address = '0x0000000000000000000000000000000000000000'
GROUP BY 1
UNION ALL
Last run: 3 months ago
...
114
5KB
57s