intellidegentitsdctime Class Bounty 2
Updated 2023-01-31
999
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
›
⌄
--We would like to determine the relative success of the most recent (minted in 2023) NFT projects
-- First, create base layer of data we are interested in
with base as (
SELECT
nft_address,
project_name,
nft_to_address as minting_wallet,
nft_count as num_nfts_minted,
mint_price_eth,
mint_price_usd
FROM ethereum.core.ez_nft_mints
WHERE event_type = 'nft_mint' AND
block_timestamp::date > '2023-01-01'
GROUP BY 1,2,3,4,5,6
),
-- Determine the number of unique addresses that minted an NFT, total NFTs minted, the ratio of nfts/wallets, and the total value of all NFTs minted in USD
base_2 as (
SELECT
nft_address,
project_name,
count(DISTINCT (minting_wallet)) as total_unique_wallets,
SUM(num_nfts_minted) as total_nfts_minted,
SUM(mint_price_USD) as total_paid_for_mint,
SUM(num_nfts_minted)/count(DISTINCT (minting_wallet)) as avg_nfts_per_wallet
FROM base
GROUP BY
nft_address,
project_name
HAVING
-- exclude free mints as the user did not have to make a financial commitment to the project
total_paid_for_mint >0 AND
-- exclude projects with less than 1K unique wallets
total_unique_wallets > 1000
Run a query to Download Data