SYMBOL | HOLDER_CNT | AVG_HOLDING_USD | |
|---|---|---|---|
1 | AUKI | 15016 | 12835 |
2 | GEOD | 4580 | 1265.6 |
3 | BREW | 2081 | 1060 |
4 | HIBER | 11524 | 48.8 |
tkvresearchsplendid-red
Updated 2025-04-02
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_data as (
select *
from(values
('AGiXT', 'F9TgEJLLRUKDRF16HgjUCdJfJ5BK6ucyiW8uJxVPpump', 'Solana'),
('GEOD', '7JA5eZdCzztSfQbJvS8aVVxMFfd81Rs9VvwnocV1mKHu', 'Solana'),
('AUKI', '0xF9569cFb8FD265e91aa478d86ae8c78b8AF55Df4', 'Base'),
('HIBER', 'FHKiJEg2zmhv9DEeaXMSZa7R4P8BPFX5VTRrzrtJpump', 'Solana'),
('BREW', '2hXQn7nJbh2XFTxvtyKb5mKfnScuoiC1Sm8rnWydpump', 'Solana'),
('mxyz', 'UCYaUNhgB2344N8Qpg4t712V9RHahcpTCejwXKspump', 'Solana'),
('RobOS', '5Tfwxm9pA3oiAUUyQ7HkAyomCo6i6Jr4h4c8U91Xpump', 'Solana'),
('daige', 'HsNx7RirehVMy54xnFtcgCBPDMrwNnJKykageqdWpump', 'Solana'),
('XRT', '0x7dE91B204C1C737bcEe6F000AAA6569Cf7061cb7', 'Ethereum'),
('SAM', '0xd0174292C4d6dfa7c4Ee20F371f3b6D401782cd5', 'Base'),
('MROBOTICS', 'DMzVMP3eBvmXS45HWsn3VSKLm8CxP5ge8erpJZ8Cpump', 'Solana')
) l(token,address,chain)
),
--base,arb,bsc,eth,sol,polygon,blast
evm_tab as
(select date(block_timestamp) as datetime,
symbol,
to_address as user,
amount as amt
from arbitrum.core.ez_token_transfers
where contract_address in (select lower(address) from full_data)
union all
select date(block_timestamp) as datetime,
symbol,
from_address,
-amount
from arbitrum.core.ez_token_transfers
where contract_address in (select lower(address) from full_data)
union all
select date(block_timestamp) as datetime,
symbol,
Last run: 24 days ago
4
83B
545s