CryptoIcicleMarinade's Non-Fungible Chefs (Part II) - # of Wallets
    Updated 2022-05-03
    -- 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