ORIGINAL_MINTERS | CURRENT_OWNERS | TOTAL_SUPPLY | OWNERSHIP_CONCENTRATION_RATE | |
|---|---|---|---|---|
1 | 794 | 579 | 888 | 65.2 |
optimus_primeFF Founder Pass
Updated 2025-03-24
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
›
⌄
WITH mint_stats AS (
SELECT
COUNT(DISTINCT decoded_log:minter::string) AS unique_minters,
SUM(decoded_log:actualMintQuantity::int) AS total_supply
FROM ronin.core.ez_decoded_event_logs
WHERE contract_address = LOWER('0xa8e9fdf57bbd991c3f494273198606632769db99')
AND topic_0 = '0xc884ac06fa0e1f50615760ef5892d20264bd60ffa869be6a71ced0e87d936b0f'
AND decoded_log:param:nftContract::string = LOWER('0x3fa1e076bd4e7f4b7469ad1646332c09b275082d')
),
owner_stats AS (
SELECT
COUNT(DISTINCT owner) AS current_owners
FROM (
SELECT
'0x' || SUBSTRING(topics[2]::string, 27, 40) AS owner,
ROW_NUMBER() OVER (PARTITION BY livequery.utils.udf_hex_to_int('s2c', topics[3]::string)
ORDER BY block_timestamp DESC) AS rn
FROM ronin.core.fact_event_logs
WHERE contract_address = LOWER('0x3fa1e076bd4e7f4b7469ad1646332c09b275082d')
AND topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
)
WHERE rn = 1
)
SELECT
m.unique_minters AS original_minters,
o.current_owners,
m.total_supply,
ROUND(o.current_owners * 100.0 / m.total_supply, 2) AS ownership_concentration_rate
FROM mint_stats m, owner_stats o;
Last run: about 1 month ago
1
20B
8s