Pmisha-llIHxU
Waiting for Aurory
Jul 19, 2022 - Aurory is one of the most highly anticipated games to come out on any chain. Create a dashboard highlighting wallet trends around both the tokens and NFTs. Does the price of Aurory token has positive correlation with volume of nft sales? How have token staking and nft expedition patterns changed in the bear market? What have wallets been doing with their airdropped NFTs?
NFT Wallet Behavior Comparison
Jul 18, 2022 - Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to Ethereum and Solana. Is there more or less "whale" activity on Flow compared to each of the other chains? What do "whales" tend to focus on in Flow? How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains, or do wallets tend to hold onto their NFTs? Are wallets more interested in new projects, or already existing projects on Flow?
Celsius Swaps
Jun 22, 2022 - Q95. Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. From which one of their wallets did they conduct most of the swaps?
Optimism DEXs
Aug 3, 2022 - Q8. Let’s take a closer look at DEXs on Optimism, specifically Velodrome. Make a dashboard that compares Velodrome to any other Optimism DEX.
NFDomains
Jun 23, 2022 - Q107. NFDomains are .ALGO domains NFTs that have launched on Algorand. Lets look how many domains NFDomains have sold -Look at number of NFDomains have sold by day and how much revenue they have generated for NFDomains? -Look at how many wallets have bought an NFDomain by day. -Show the distribution of the number of NFDomains purchased by wallet. -Show the distribution of the amount of ALGOs spent on NFDomains purchased by wallet. -What are the top 10 biggest NFDomain sales? -Note any other interesting insights such as fees generated from secondary sales or average purchase price of an NFDomain sale.
What makes a Top Shots moment valuable? (Part I)
Jul 24, 2022 - Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume. This week, focus specifically on the play_type column in the flow.core.dim_topshot_metadata table. What play_types do users hold most, and how much volume in sales do these play_types generate? Include any other transactional metrics you can think of.
Daily Transactions and Unique Addresses
Jul 13, 2022 - Q1. Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022. In your estimation, discuss whether Polygon is still growing, has reached a plateau, etc.
New Wallets In May
Jun 16, 2022 - Q101. How many wallets have a balance greater than 1 ALGO? And how many of those wallets sent or received a transaction in May? How many new wallets were created in May? What % of total wallets with more than 1 ALGO is this? Additionally, show the distribution of ALGO holdings for these new wallets. What is the average ALGO holding of these new wallets? What other ASAs do these new wallets from May hold? How many of these wallets have performed a swap?
Polygon Block Performance
Jul 27, 2022 - What is the average time between blocks on Polygon? What was the maximum and minimum recorded time between two blocks? How many transactions are done in a block on average? How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
Quixotic NFT Dashboard
Aug 3, 2022 - Q7. Create a secondary market dashboard for NFT sales on Quixotic, the largest NFT marketplace on Optimism!
Sushi Revenue
Jun 29, 2022 - Q98. What is the breakdown of revenue by unit for sushi? (swaps, kashi, etc)