0xHaM-dMint Over Time
Updated 2024-04-21
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 TokenPrices AS (
SELECT
hour::date as p_date,
symbol,
avg(PRICE) as usd_price
FROM aptos.price.ez_hourly_token_prices
WHERE symbol = 'APT'
GROUP by 1,2
)
, mintTb as (
SELECT
BLOCK_TIMESTAMP,
TX_HASH,
EVENT_DATA:address as nft_token,
EVENT_DATA:collection_address as collection_address,
EVENT_DATA:owner as minter,
EVENT_DATA:price as price,
gas_used,
gas_unit_price,
((gas_used * gas_unit_price)/1e8) as gas,
FROM aptos.core.fact_events a
JOIN aptos.core.fact_transactions b using(BLOCK_TIMESTAMP, TX_HASH)
WHERE EVENT_DATA:collection_address = '0xdf7175d95f236ac3f9fb581645498857bc42f90ff030527bcefe30c1558a6eac'
AND a.EVENT_RESOURCE = 'MintNftEvent'
AND a.EVENT_MODULE = 'tradeport_launchpad'
)
SELECT
date_trunc('{{Time_Interval}}', BLOCK_TIMESTAMP) as date,
count(DISTINCT tx_hash) as n_mints,
count(DISTINCT minter) as n_minters,
sum(price) as "Mints Volume [$APT]",
sum(price*usd_price) as "Mints Volume [$USD]",
sum(gas) as "Fees [$APT]" ,
sum(gas*usd_price) as "Fees [$USD]",
count(nft_token) as n_minted_nfts,
sum(n_mints) over (ORDER by date) as cum_n_mints,
QueryRunArchived: QueryRun has been archived