datavortexTotals
Updated 2024-12-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
⌄
/*
SELECT
SPLIT_PART(event_type, '::', 3) AS resource_name,
event_data
FROM aptos.core.fact_events
WHERE event_data:collection = '0xa5305cd24f8f39299d4e0abadab3700160be02cc8d1686313c1d07ee16d5143c'
AND DATE_TRUNC('day', block_timestamp) > '2024-12-01'
ORDER BY block_timestamp DESC
*/
;
SELECT
MAX(CAST(event_data:index.value AS INTEGER)) AS total_mint,
3333 AS total_nft_supply,
1000000 AS non_refundable_price,
MAX(CAST(event_data:index.value AS INTEGER)) AS total_minters,
MAX(CAST(event_data:index.value AS INTEGER)) * 1000000 AS total_gui_volume,
(MAX(CAST(event_data:index.value AS INTEGER))::DECIMAL / 3333) * 100 AS percentage_minted -- Percentage of total supply minted
FROM aptos.core.fact_events
WHERE event_data:collection = '0xa5305cd24f8f39299d4e0abadab3700160be02cc8d1686313c1d07ee16d5143c'
AND DATE_TRUNC('day', block_timestamp) > '2024-12-22';
QueryRunArchived: QueryRun has been archived