banbannard
New Users on Algorand vs. Ethereum vs. Solana vs. Terra
May 4, 2022 - Algorand, Ethereum, Solana and Terra What trends do you see?
LoftyAI Tokenized Real Estate
Mar 2, 2022 - Rank the properties listed by LoftyAI based on total token investment price. (Each property has its own asset created by the address 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'). How many wallets have bought a token for at least one property? What wallet has invested in the most Lofty AI properties? How many properties are they invested in?
New NFT Mints
May 16, 2022 - How many total new NFT projects have appeared on Magic Eden per day since the start of the new year (as in new projects that have minted that day)? Compare that to the total number of new NFT projects that were minted/created on Ethereum? Create a dashboard comparing the growth rates of the number of new NFT projects on Solana and Ethereum and understanding the amount of sales activity on ""new projects"" for each chain.
Looking For Swap Arbitrage
Mar 31, 2022 - Let’s see if we can find any wallets profiting from arbitrage on the Algorand DEXes. We specifically want to see if anyone is conducting arbitrage with USDT or USDC, Asset ID 31566704 or 312769. The period we will want to look at is From January 1st 2022 to current. We will want to grab wallets swapping USDC or USDT to another asset then their next swap being back out of that other asset(with the same amount of it) back to USDT or USDC in their next transaction. If we find a wallets conducting this behavior, let’s look if they end up with more USDT or USDC they started with in the initial swap. If we find users doing this, let's look at the top 10 wallets successfully earning more USDT or USDC. What assets do we see them swapping for when they commit this arbitrage? Show and explain your methodology if we don't see this arbitrage occurring.
⚡ Streaming Swaps
Aug 11, 2023 - An Overview of Streaming Swaps on THORChain. If you find this dashboard helpful, please leave a ❤️ to show your support!
Magic Eden vs OpenSea vs Random Earth
Mar 22, 2022 - What has been the rate of change of these metrics since the start of the new year and are there any signs of growth of a certain marketplace or ecosystem of NFTs? Highlight the 5 most popular NFT collections for each marketplace over that timeframe in terms of sales volume. Is the turnover rate (number of transactions) for collections on Magic Eden noticeably higher than on OpenSea and Random Earth? Provide some insights on these findings.
Bridgesplit and MonkeDAO's DAOJONES
Feb 21, 2022 - Create a chart showing daily transaction volume and the number of distinct wallets that transacted with DAOJONES. When was the peak amount of trading volume and seemingly ""hype"" around DAOJONES? What was the most amount of distinct wallets that made a transaction with DAOJONES in a day? Provides some insights around why these numbers peaked when they did.
Bubblegoose Ballers Mint
Jun 15, 2022 - How many unique wallets minted a Bubblegoose Baller NFT and how many NFTs did these wallets purchase on average? How many NFTs were purchased with ETH using Crossmint? Identify any notable trends in minting activity and secondary market sales in the days following the launch. Which group(s) was most likely to "diamond fin" their NFTs?
It's the Catalina Whale Mixer
May 17, 2022 - Catalina Whales are a popular NFT collection on Solana with an experienced team from the entertainment industry. Chart their sales history and unique holder trends over time. The project has a tier system of holders (5 whales gets you tier 2 status and 10 whales gets you tier 3 status), has this noticeably influenced wallet activity? The project recently announced that you had to own a whale before 5/11 at noon EST in order to qualify for the whitelist of an extremely hyped mint Bubblegoose Ballers along with other benefits. How has that influenced sales activity and holder activity over the past few weeks?"
DAI Volume (May 13)
May 14, 2022 - How does the daily volume of DAI transactions compare to other stablecoins? What is DAI most used for?
Algorand Blockchain Block Performance
Jan 17, 2022 - Let's take a deeper dive into Algorand's blockchain performance! First, let's look at block times: What’s the average time between block and how has this changed over time What’s the max recorded time between two blocks? What’s the minimum recorded time between blocks? Next, let's look at block size: How many transactions did the biggest block have? And what was the make up of this block(i.e. what type of transactions did it contain?)? Has the number of transactions per block increased as network adoption increased(Chart the number of transactions per block over time)?"
Staking Rewards and Swap Data of Holders
Aug 29, 2022 - This dashboard goes through THOR Staking Rewards and Swap Data of THOR and vTHOR holders.
Flipside Crypto: Nouns DAO
Jun 8, 2022 - Part 1: Analyze the mint and secondary NFT marketplace activity for Nouns DAO. Can we conclude if there are certain types of traits (body, accessory, etc.) that are causing some Nouns to sell or mint for more than others? Part 2: Who is typically settling Nouns auctions? Does the winner settle the auction, or does an eager new bidder settle the current auction to begin the next auction?
The State of DeGods and DUST Before Minting y00ts (33.3%)
Sep 4, 2022 - What did y00ts do to DeGods and DUST?
Swap Volume and Ukraine War
Apr 19, 2022 - How has the Ukraine war affected the swap volume on Sushi and Uniswap? Has there been a surge in demand for a particular token?
Fuse Pool Analysis
May 23, 2022 - Are the DAI and USDC Vaults using the same Fuse Pools to seek yield? What differences can you identify?
Facts_Lending
Mar 12, 2022 - Build a query for a fact table about sushi's lending activity on Polygon. What questions does your table answer(At least Two questions)? What other dimensions could potentially be extracted from sushi contracts and added to this table to make it more valuable?
Proof-of-Work on Ethereum
Sep 9, 2022 - We will explore Ethereum miners and their transaction count per mined block in this dashboard
Market Share Dashboard
Aug 29, 2022 - [DAILY UPDATED] This dashboard tracks affiliate fee of Thorchain affiliates
Users’ First Activity and Destination After Bridging from Ethereum to Optimism
Sep 12, 2022
Contractually Obligated
Mar 8, 2022 - Based on your analysis for #161, provide the top 20 smart contract addresses that users interact with or the top 2 smart contract addresses per each of the protocols that you previously analyzed. Grand prize-winning submissions will assess both!
GMT and SOL into StepN
May 5, 2022 - GMT is the governance token for StepN that will provide holders with a share of all fees earned within the app. However, recently StepN has made some changes to require using GMT in the game mechanics itself to give it additional utility and incentivize burning of the supply. Currently, the only way acquire GMT is by trading for it (you can not currently earn it in the game, this will change soon). Track the flow of GMT into the app. How are users acquiring GMT? Is by swapping using a DEX like Jupiter, or do flows seem to be coming from centralized exchanges? How often is GST (the token earned in the game) swapped for GMT? What other actions are wallets that are sending GMT into the app doing? Additionally, where do SOL inflows into the app seem to be coming from? Does it seem like most StepN users were already active within the Solana ecosystem, or is there a lot of activity that originated from inflows from centralized exchanges? Essentially, is StepN onboarding users into Solana? Create visualizations showing these inflows of GMT and SOL into the StepN app and if the announcement of Coinbase adding StepN to their list of tokens sparked additional interest from sources outside of the Solana ecosystem."
Transaction Fees
Feb 3, 2022 - All transactions on Algorand have a transaction fee of .001 but lets dive a little deeper into fees generated on Algorand. What is the total amount of fees generated on Algorand since the first block? Plot fees generated over time by day on Algorand since the beginning of 2021. Create a table of the top 10 wallets that have generated the most amount of fees in 2022. List both number of transactions and fees of the wallets. Using the asset transfers table, what are the top 10 assets besides Algos that have generate the most fees?
L1 Unique Users
Mar 15, 2022 - Compare the number of unique wallets that have sent a transaction since February 1st on Solana vs Ethereum vs Terra. How does user adoption seem to be trending for Solana compared to these other major chains? Does it appear that market conditions are slowing down growth or activity on the networks?