Balance Range | Total Holders | Total CGX Held | Percentage of Supply | |
---|---|---|---|---|
1 | 0-1000 CGX | 13179 | 4224062.68 | 2.6286% |
2 | 1000-5000 CGX | 4098 | 6790359.94 | 4.2255% |
3 | 10000-50000 CGX | 68 | 1375551.34 | 0.856% |
4 | 100000-1000000 CGX | 18 | 5544429.59 | 3.4502% |
5 | 1000000+ CGX | 10 | 140165028.25 | 87.2222% |
6 | 5000-10000 CGX | 223 | 1715915.63 | 1.0678% |
7 | 50000-100000 CGX | 12 | 883509.42 | 0.5498% |
datavortexholders category
Updated 2025-03-26
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 mints AS (
SELECT
SUM(CAST(decoded_log:value AS FLOAT) / 1e18) AS total_minted
FROM ronin.core.ez_decoded_event_logs
WHERE contract_address = LOWER('0x656fe582b4c6dc95c598ea54dc820eb36152e2f7')
AND event_name = 'Transfer'
AND decoded_log:from = '0x0000000000000000000000000000000000000000'
),
burns AS (
SELECT
SUM(CAST(decoded_log:value AS FLOAT) / 1e18) AS total_burned
FROM ronin.core.ez_decoded_event_logs
WHERE contract_address = LOWER('0x656fe582b4c6dc95c598ea54dc820eb36152e2f7')
AND event_name = 'Transfer'
AND decoded_log:to = '0x0000000000000000000000000000000000000000'
),
transfers AS (
SELECT
from_address,
to_address,
CAST(amount AS FLOAT) AS amount
FROM ronin.core.ez_token_transfers
WHERE contract_address = LOWER('0x656fe582b4c6dc95c598ea54dc820eb36152e2f7')
),
balances AS (
SELECT
address,
SUM(CASE WHEN direction = 'in' THEN amount ELSE -amount END) AS balance
FROM (
SELECT to_address AS address, amount, 'in' AS direction FROM transfers
WHERE to_address != '0x0000000000000000000000000000000000000000'
UNION ALL
SELECT from_address AS address, amount, 'out' AS direction FROM transfers
WHERE from_address != '0x0000000000000000000000000000000000000000'
) t
GROUP BY address
Last run: about 2 months ago
7
309B
6s