HOLDER_CNT | ELIGIBLE_HOLDER_CNT | PERC | SYMBOL | |
|---|---|---|---|---|
1 | 108816 | 16306 | 14.9849 | MORPHO |
2 | 99369 | 18599 | 18.7171 | ZETA |
3 | 36591 | 4979 | 13.6072 | PLUME |
4 | 183874 | 22249 | 12.1001 | ATH |
5 | 22941 | 5284 | 23.033 | BIGTIME |
6 | 693374 | 54846 | 7.91 | VIRTUAL |
7 | 14052 | 1415 | 10.0697 | SAFE |
8 | 145186 | 34222 | 23.5711 | ONDO |
9 | 1426900 | 10064 | 0.7053 | UXLINK |
tkvresearchsecondary-amethyst
Updated 4 days ago
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 full_list as (
select *
from (values
('0x44ff8620b8cA30902395A7bD3F2407e1A091BF73','VIRTUAL'),
('0x0b3e328455c4059EEb9e3f84b5543F74E24e7E1b','VIRTUAL'),
('0x64Bc2cA1Be492bE7185FAA2c8835d9b824c8a194','BIGTIME'),
('0x1A6B3A62391ECcaaa992ade44cd4AFe6bEC8CfF1','UXLINK'),
('0x58D97B57BB95320F9a05dC918Aef65434969c2B2','MORPHO'),
('0xBAa5CC21fd487B8Fcc2F632f3F4E8D37262a0842','MORPHO'),
('0xbe0ed4138121ecfc5c0e56b40517da27e6c5226b','ATH'),
('0xc87b37a581ec3257b734886d9d3a581f5a9d056c','ATH'),
('0x5afe3855358e112b5647b952709e6165e1c1eeee','SAFE'),
('0xf091867ec603a6628ed83d274e835539d82e9cc8','ZETA'),
('0x0000028a2eB8346cd5c0267856aB7594B7a55308','ZETA'),
('0xfaba6f8e4a5e8ab82f62fe7c39859fa577269be3','ONDO'),
('0x4C1746A800D224393fE2470C70A35717eD4eA5F1','PLUME')
) as l(address,token)
),
list_holder as
(select address,
symbol,
contract_address
from
(select address,
symbol,
contract_address,
sum(amount) as bal
from
(select date(block_timestamp) as datetime,
to_address as address,
amount,
symbol,
contract_address
from bsc.core.ez_token_transfers
where contract_address in (select lower(address) from full_list)
Last run: 4 days ago
9
270B
192s