piperSolana - More Mints: Growth of unique purchases
Updated 2022-04-22
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
›
⌄
⌄
/*
Discord: piper#6707
Twitter: https://twitter.com/der_piper
Solana - More Mints
Q56. Metaplex is an open source protocol that allows for the creation and minting
of NFTs using a standardized format across wallets and applications. It is essentially
the backbone architecture for Solana NFTs.
How many NFTs have been minted over the past week? Since the beginning December, how
many NFTs have been minted per week? Chart the growth of unique purchasers over time.
What percentage of all mints have been via Metaplex's Candy Machine?
*/
SELECT
date_trunc('day', block_timestamp) AS day,
COUNT(DISTINCT(tx_id)) AS number_of_purchases,
SUM(number_of_purchases) OVER (ORDER BY day) AS "Cumulated Number of Purchses"
FROM
solana.fact_transfers
WHERE
mint = 'So11111111111111111111111111111111111111112'
AND
block_timestamp BETWEEN '2021-12-01' AND '2022-04-15'
GROUP BY day
ORDER BY day ASC
/* The End! */
Run a query to Download Data