Question:

How many wallets have pre ordered Saga (the new solana phone) so far? Note: the preorder is a NFT purchase on-chain. Who is preordering the phone? Provide a breakdown of the type of wallets ordering so far. Example metrics to investigate: what other programs are these wallets interacting with, how active have these wallets been on Solana, are they average users or whales?

Preliminaries:

The Solana network is getting its own mobile phone called “Saga,” an Android handset by the blockchain’s key stakeholder, Solana Labs. Solana Labs said it will work with other companies to power the ecosystem to build the phone, including Magic Eden, the top NFT (non-fungible token) marketplace, Phantom, the biggest wallet provider, and Orca, a decentralized finance (DeFi) platform. Executives from all three were on hand to discuss the upcoming mobile experience. To enter the whitelist of Saga, users should be deposited 100 USDC to the mobile store.

This essay concentrated on the wallets that purchased on pre-order of Saga. The characteristics of these purchased and other activity of them have been analyzed in this essay.

Approach:

The methodology of this essay contains the following steps:

1. Identify the purchasers

    from solana.core.fact_transactions
    where  INSTRUCTIONS[0]:parsed:info:mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    and INSTRUCTIONS[1]:programId='781wH11JGQgEoBkBzuc8uoQLtp8KxeHk1yZiS1JhFYKy'
    and SUCCEEDED='TRUE'
   

2. The other activity of purchasers

    from solana.core.fact_transactions join solana.core.dim_labels on 
    t.instructions[0]:programId = l.address -- find the interacted programs
   

3. Time of first received asset

    select TX_TO,
    min(BLOCK_TIMESTAMP) as first_received
    from solana.core.fact_transfers
   

4. Identification of whales

    Introduced based the amount of SOL that they sent
    when sent<=500 then 'Oridinary user'
    when sent>500 then 'Whale'
   

5. TOP NFT collections

    from solana.core.fact_nft_sales s left outer join solana.core.dim_nft_metadata b
    on s.mint=b.MINT
   

Results:

The result section divided into the two main parts:

1. The purchasers of pre-order and the historical data about them.
2. The other activity of these pre order purchasers.

The first part of the results section talks about the identification of pre order purchasers on Saga and the key findings related to this part have been summarized as:

1. Until June 24th, the 1209 unique purchasers have been assigned into the pre order of Saga phone on Solana. The most these purchasers came on June 23th but about 262 users purchased on June 24th.
2. The purchasers on pre-order of Saga phone are active users and has an average number of transaction about 1036 per user on ecosystem.
3. Between the purchasers on pre order, about 55% of them received their first assets on July 2021 to January 2022 and about 45% of them received their first asset since start of 2022.
4. Most of these purchasers are ordinary users about 99% of them and only small part of them like 1% could be considered as Whales.

The main sectors that purchasers on pre order have been participated have been shown in this pie graph. According to this graph, the NFT is the leading sector among pre order purchasers of Saga. After that DEX stands with 30% of transactions.

Purchasers of pre-order

Other activities of purchasers

The analysis of behavior of Saga pre order purchasers shown in the two graphs. According to the first donut, most of the purchasers participated on Metaplex and Magic Eden respectively.

By the use of second chart, the top NFT collections that pre order purchasers participated on displays. According to this graph, the DeFi pirates and Okay Bears are the two most participated NFT collections by Saga purchasers.

The application of DEXs by pre order purchasers shown in this chart.

According to this chart, the Sereum, Jupiter and Mango markets are the top 3 most used DEXs by Saga purchasers.

Other DeFi programs that used by pre order purchasers arranged and reveals in this chart.

Based on this chart, the Solend has dominated the DeFi programs application by pre order purchasers. After that, Marinade Finance stands in the second place of most used DeFi programs.

Conclusion:

• The Purchasers of pre order of Saga phone could be considered as established wallets that are active on Solana ecosystem.
• Their main interest sector is NFT and could say that most of the purchasers are active on NFT sector of Solana ecosystem.
• Based on the definition, most of them are ordinary users and only small part of them could be categorized as Whales.