flipside

    Algo-99.New Wallets from NFTs - Wallet Distribution - Not May/June
    CryptoIcicleAlgo-99.New Wallets from NFTs - Wallet Distribution - Not May/June
    Updated 2022-06-08
    -- Payout 177.66 ALGO
    -- Grand Prize 532.97 ALGO
    -- Level Intermediate

    -- Q99. Let’s look at the month of May and June to understand if the Algorand NFT scene is onboarding new wallets.
    -- For this we want to focus on wallets that have >1 ALGO and look at two different groups all wallets >1 ALGO
    -- and wallets created in May and June with >1 ALGO. Also note we only want to look at arc69 NFTs.

    -- What are the total number of wallets that have >1 ALGO? How many of these wallets(what percent) were created in May/June 2022?
    -- What percent of each of these wallets groups hold an NFT?
    -- What percent of each wallet group(total & May/June) received an NFT in May/June?
    -- How many wallets received an NFT in May compared to April?
    -- For wallets that were created in May/June and received an NFT- what is the distribution of these wallets balances?
    -- For wallets that were NOT created in May/June and received an NFT in May/June- what is the distribution of these wallets balances?
    -- How do these compare? Do we see these new wallets having more or less ALGO balance.
    -- How many of the new wallets in May/June that received an NFT, received more than 1 NFT
    -- Do we see NFT adoption spurring the creation new wallets? In other words, are new wallets being created to buy NFTS?
    -- Note any other findings on new wallets that are being created to enter the Algorand NFT space!

    -- Tips: NFT criteria All NFTs have a supply of 1 and 0 decimal places For NFTs configured to the arc69 stanard,
    -- look at asset_configuration transactions such as 6Z5R47GSIMQC4JDCTRAPLPC5BTNCC5K5DJ2QKSACW4KV5RZFZDQQ and decode the note
    -- using try_base64_decode_string(tx_message:txn:note::string).
    -- try_PARSE_JSON(TRY_BASE64_DECODE_STRING(tx_message:txn:note::string)):standard::string = 'arc69'
    -- You will find in the note the asset has been configured to the arc69 community standard: https://github.com/algokittens/arc69."

    with
    wallets as (
    select
    iff(block_timestamp between '2022-05-01' and '2022-06-30','may_june', 'non_may_june') as type,
    address
    from flipside_prod_db.algorand.account a
    join flipside_prod_db.algorand.block b on a.created_at = b.block_id
    where balance > 1
    ),
    nfts as (
    select
    Run a query to Download Data