WEEK | NFT_MINTS | TOTAL_NFT_MINTS | MINTER | TOTAL_MINTERS | SALES_VOLUME | TOTAL_SALES_VOLUME | |
|---|---|---|---|---|---|---|---|
1 | 2024-12-06 20:00:00.000 | 244 | 555 | 240 | 522 | 0 | 0 |
2 | 2024-12-06 19:00:00.000 | 36 | 311 | 36 | 282 | 0 | 0 |
3 | 2024-12-06 18:00:00.000 | 275 | 275 | 246 | 246 | 0 | 0 |
cristinatintoannonz Collection MINTS
Updated 2025-04-15
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
›
⌄
SELECT
date_trunc('hour',x.block_timestamp) as week,
count(distinct case when x.event_resource='Mint' then x.event_data:index:value end) as nft_mints,
sum(nft_mints) over (order by week) as total_nft_mints,
count(distinct case when xx.event_resource='TransferEvent' then xx.event_data:to end) as minter,
sum(minter) over (order by week) as total_minters,
SUM(case when y.event_resource='DepositEvent' then y.event_data:amount/pow(10,8) end) AS sales_volume,
sum(sales_volume) over (order by week) as total_sales_volume
FROM aptos.core.fact_events x
join aptos.core.fact_events xx on x.tx_hash=xx.tx_hash
join aptos.core.fact_events y on x.tx_hash=y.tx_hash
where date_trunc('day',x.block_timestamp)>'2024-10-01' and x.event_resource='Mint' and x.event_module='collection' and xx.event_resource='TransferEvent' and y.event_resource='DepositEvent'
and x.event_data:collection='0x586457e26a358ca6f5ffa30a23840ede1883a3824b186784b6dbd427e23b4c96'
group by 1
order by 1 desc
Last run: about 2 months ago
3
143B
180s