datavortexTrends
Updated 2024-12-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
DATE_TRUNC('hour', block_timestamp) AS hour,
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
FROM
aptos.core.fact_events
WHERE
event_data:collection = '0xa5305cd24f8f39299d4e0abadab3700160be02cc8d1686313c1d07ee16d5143c'
AND DATE_TRUNC('day', block_timestamp) > '2024-12-01'
GROUP BY
hour
ORDER BY
hour DESC;
QueryRunArchived: QueryRun has been archived