CryptoIcicleMarinade's Non-Fungible Chefs (Part II) - # of Wallets
Updated 2022-05-03Copy Reference Fork
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
›
⌄
-- Payout 1.53 SOL
-- Grand Prize 4.59 SOL
-- Level Intermediate
-- Marinade Finance Non-fungible Chef NFTs began minting on April 4, 2022.
-- How many unique holders of the NFTs are there?
-- Create a chart showing trading activity and SOL volumes on Magic Eden.
-- Aside from Marinade Finance, what other Solana DeFi protocols are most used by holders of the Non-fungible Chef NFTs?
-- Highlight any trends in protocol usage.
-- What other NFTs have these holders purchased and sold previously?
-- Are holders active NFT traders on Solana, or are they first-time NFT users?
with txns as (
select
*
from solana.fact_events
where
program_id = 'ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL'
and instruction:parsed:info:mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey'
and block_timestamp::date >= '2022-04-04'
),
mint_txns as (
select
instruction:parsed:info:amount/1e9 as amount,
instruction:parsed:info:source as wallet,
CASE
WHEN amount between 1000 and 4999 THEN 'Level 1'
WHEN amount between 5000 and 24999 THEN 'Level 2'
WHEN amount between 25000 and 99999 THEN 'Level 3'
WHEN amount between 1e5 and 249999 THEN 'Level 4'
WHEN amount > 250000 THEN 'Level 5'
ELSE 'Level 0'
END as category,
*
from solana.fact_events
Run a query to Download Data