kasadegh
Flipside's World Cup of Bounties Side Quest: Fifa+ Collect Collection Scorecard
Nov 13, 2022
Opensea Fees
Jul 31, 2022 - Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
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?
Pooly NFTs
Jun 21, 2022 - Q2. How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
ETH Deposited or Withdrawn
Jun 29, 2022 - Q1. StarkNet is a layer-2 chain that ensures interoperability with Ethereum mainnet. People are using it to move real ETH to starknet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to StarkNet or vice versa? and by how many depositors?
Distinct Wallets (zkSync)
Jun 15, 2022 - Q1. ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design. You can read more about ZkSync here. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both
Trending NFT Projects
Jun 13, 2022 - Q8. Create a visualization showing NFT sales volume on Flow since May 9th. Which NFT projects are trending on Flow right now and what is the general trend of NFT sales over the last month? Do the projects that are trending seem to have common wallets or is there not much crossover between buyers/sellers?
ERC20 Tokens (zkSync)
Jun 16, 2022 - Q2. ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design. You can read more about ZkSync here. Users can also deposit ERC20 tokens into ZkSync. Which ERC20 tokens have been deposited the most (in $ volume and total count) in the last 60 days? Visualize and explain both findings
NBA Playoff Usage
Jun 27, 2022 - Q.15 Analyze the start of the NBA playoffs (mid-April) and determine whether it had an impact on Flow transaction volume. What about NBA Top Shots?
Algorand Price Correlation
Jun 28, 2022 - Q109. Is the price of Algorand more closely correlated with the crypto market, and assets such as BTC or ETH, or is it more correlated with network usage such as number of transactions or ALGO transfers? How does this compare to other networks such as Solana? Note your findings and anything else that may be interesting in relation to Algorand's price movement!
Polygon NFT
Jul 13, 2022 - Q3. How popular are NFTs on Polygon? Track daily volume over the past month/year/etc. How many Polygon users started off with NFTs? Who made the most profit?
ETH Staked
Jun 15, 2022 - What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
Bridger Destinations
Jul 31, 2022 - Where do people go when they bridge to Polygon from Ethereum? What are the 10 most popular first destinations for Polygon addresses that have just bridged from Ethereum?
NEAR Performance
Jul 18, 2022 - How does NEAR stock up to other L1s in terms of speed and performance? How fast is NEAR, and compare it with other blockchain speeds in terms of transactions per minute and percentage of transactions that fail.
Wildlife Warriors NFT Drop
Jun 23, 2022 - Q105. Wildlife Warriors was a project established by Steve Irwin in 2002 as a way to include and involve other caring people to support the protection of injured, threatened or endangered wildlife. They recently had an NFT drop(https://twitter.com/wildwarriors) on Algorand to support the project. Lets look at the wallets that own one of these NFTs: -Look at when the wallets were created(created_at) that own a wildlife warrior. Were wallets created recently for the drop or are they more established wallets? -Look at the ALGO balances of wallets that own a wildlife warrior and show the distribution balances -Look at how many Wildlife Warriors each wallet holds. -Is there a correlation between how many Wildlife Warriors a wallet holds and their ALGO balance? Tips: To look at the list of the asset_ids of the NFTs: select * from algorand.asset where asset_name like 'Warrior Croc%' and (creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU' or creator_address = ‘SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ')"