Mint Category | Total Minters | Total Minted (CGX) | Percentage of Total Supply | |
|---|---|---|---|---|
1 | 0-1000 | 4 | 2950.12 | 0.0018% |
2 | 1000-5000 | 1 | 2097.67 | 0.0013% |
3 | 100000-1000000 | 3 | 1737834.13 | 1.0861% |
4 | 1000000+ | 2 | 159199237 | 99.4995% |
5 | Total | 7 | 160942118.92 | 100.5888% |
datavortexminter 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
decoded_log:to AS minter_address,
CAST(decoded_log:value AS FLOAT) / 1e18 AS mint_amount
FROM ronin.core.ez_decoded_event_logs
WHERE contract_address = LOWER('0x656fe582b4c6dc95c598ea54dc820eb36152e2f7')
AND event_name = 'Transfer'
AND decoded_log:from = '0x0000000000000000000000000000000000000000'
),
mint_categories AS (
SELECT
minter_address,
mint_amount,
CASE
WHEN mint_amount <= 1000 THEN '0-1000'
WHEN mint_amount <= 5000 THEN '1000-5000'
WHEN mint_amount <= 10000 THEN '5000-10000'
WHEN mint_amount <= 50000 THEN '10000-50000'
WHEN mint_amount <= 100000 THEN '50000-100000'
WHEN mint_amount <= 1000000 THEN '100000-1000000'
ELSE '1000000+'
END AS mint_range
FROM mints
),
category_summary AS (
SELECT
mint_range AS "Mint Category",
COUNT(DISTINCT minter_address) AS "Total Minters",
ROUND(SUM(mint_amount), 2) AS "Total Minted (CGX)",
ROUND((SUM(mint_amount) / 160000000) * 100, 4) || '%' AS "Percentage of Total Supply"
FROM mint_categories
GROUP BY mint_range
),
total_summary AS (
SELECT
'Total' AS "Mint Category",
Last run: about 2 months ago
5
181B
2s