TOTAL_HOLDERS | |
|---|---|
1 | 1284 |
Kruys-CollinsHolder distribution metrics
Updated 9 days ago
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
›
⌄
with base as (
SELECT
TO_ADDRESS as Wallet
, AMOUNT
from ronin.core.ez_token_transfers
WHERE 1=1
AND contract_address = lower('0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2')
UNION ALL
SELECT
FROM_ADDRESS as Wallet
, -AMOUNT
from ronin.core.ez_token_transfers
WHERE 1=1
AND contract_address = lower('0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2')
),
refine as (
SELECT
wallet
, SUM (amount) as balance
from base
Group by 1
having balance > 0.00000000001
)
SELECT
count(distinct wallet) as total_holders from refine
Last run: 9 days ago
1
8B
2s