DATE | HOLDER_CNT | |
|---|---|---|
1 | 2025-01-14 00:00:00.000 | 35 |
2 | 2024-08-28 00:00:00.000 | 17 |
3 | 2024-12-23 00:00:00.000 | 31 |
4 | 2025-02-18 00:00:00.000 | 38 |
5 | 2024-07-11 00:00:00.000 | 16 |
6 | 2024-09-21 00:00:00.000 | 20 |
7 | 2025-02-20 00:00:00.000 | 38 |
8 | 2024-07-07 00:00:00.000 | 14 |
9 | 2024-12-12 00:00:00.000 | 29 |
10 | 2024-06-18 00:00:00.000 | 12 |
11 | 2024-06-02 00:00:00.000 | 1 |
12 | 2024-10-23 00:00:00.000 | 24 |
13 | 2024-10-14 00:00:00.000 | 23 |
14 | 2024-12-07 00:00:00.000 | 29 |
15 | 2024-06-25 00:00:00.000 | 13 |
16 | 2025-02-01 00:00:00.000 | 37 |
17 | 2024-09-10 00:00:00.000 | 19 |
18 | 2025-02-28 00:00:00.000 | 39 |
19 | 2025-03-11 00:00:00.000 | 39 |
20 | 2024-09-27 00:00:00.000 | 20 |
tkvresearchverbal-gold
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
holder as
(select datetime,
address,
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
to_address = '0x0000000000000000000000000000000000000000'
union all
select date(block_timestamp) as datetime,
Last run: about 1 month ago
...
300
9KB
27s