datavortexminters categories
    Updated 2025-03-25
    WITH mints AS (
    SELECT
    origin_from_address AS minter_address,
    CAST(amount AS FLOAT) AS mint_amount
    FROM ronin.core.ez_token_transfers
    WHERE contract_address = LOWER('0x656fe582b4c6dc95c598ea54dc820eb36152e2f7')
    AND from_address = '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",
    COUNT(DISTINCT minter_address) AS "Total Minters",
    Last run: 2 months ago
    Mint Category
    Total Minters
    Total Minted (CGX)
    Percentage of Total Supply
    1
    0-100042950.120.0018%
    2
    1000-500012097.670.0013%
    3
    100000-100000021737834.131.0861%
    4
    1000000+515919923799.4995%
    5
    Total9160942118.92100.5888%
    5
    181B
    3s