Metiocre
Godmode: The Typical Minter
Jun 8, 2022 - Analyze the Ethereum profile of those who minted during the first hour after launch. How many of them moved the minimum .1 ETH into their minting wallet vs. already had at least .1 ETH in that wallet? How many of them have been active in NFT purchases over the past six months? Can you construct a “typical minter” profile/profiles based on their wallet behavior?
bLUNA vs. bETH collateral provided on anchor
Feb 3, 2022 - We will compare the total amount of bLUNA and bETH provided on anchor up to this time in point and also daily amount of bLUNA and bETH provided to anchor protocol. First we will take a look at the Total amount_usd result table and pie chart.
🐼 Ethereum 2.0 Validators🐼
Sep 17, 2022 - On September 15, 2022 one of the biggest events in the history of crypto happened. The Eth 2.0 merge. Let's take a look at what that is and how have people and platforms reacted to it.
Quixotic Marketplace Analysis
Aug 3, 2022 - Come with me to explore everything about Quixotic, the biggest nft marketplace on optimism.
Uniswap-v3 vs Sushiswap gas comparison
Feb 3, 2022 - In this dashboard, we will compare uniswap and sushiswap average and total daily gas fees in the past two months. First of all, let's look at the data table we get by running the query. then we will look at the total and average daily gas_used in two separate charts. as you can see, uniswap has much more volume so it has more total gas_used but sushiswap has lower average gas_used so it might be a better alternative to uniswap..
Solana Fees
Feb 5, 2022 - In this dashboard we are going to compare fees on the Solana network and compare it on several timeframes. reading this will answer the following questions: 1- what is the daily volume of transaction fees collected on Solana? 2- are fees on Solana volatile or are they stable? - what is the average fee on Solana regularly? - what is the fee stability like compared to other blockchains? 3- what is the best day of week to do transactions on Solana? 4- what is the best time of day to do transactions on Solana? all of the charts shown in this dashboard are since the beginning of 2022 and onwards.
New year, new LUNA
Jan 11, 2023 - Purpouse of this dashboard is to document significant trends in transactions, wallets, supply, staking, development, or other aspects of the Terra ecosystem.
Terra Whale Voters
Feb 16, 2022 - In this dashboard we are going to find out who the whales of the terra ecosystem are, and how often they vote on governance. we will use the terra.daily_balances, terra.gov_vote tables for this porpuse.
Algorand: Tinyman LP Actions
Mar 3, 2022 - In this dashboard we are going to talk about Tinyman and burn and mint actions and the top pools.
Pleasure to Burn(LUNA burn vs. UST supply)
Feb 27, 2022 - In this dashboard we are going to see how much LUNA has been burned in the past 30 days and how that has affected the UST supply.
Unique Users on Algorand
Apr 7, 2022 - Q46. Compare the number of unique wallets that have sent a transaction since February 1st on Algorand vs Solana vs Ethereum vs Terra. How does user adoption seem to be trending for Algorand compared to these other major chains? Does it appear that market conditions are slowing down growth or activity on the networks? -Chart daily unique wallets by day since February 1st for each major blockchain(Algorand, Solana, Ethereum, Terra) -Does it appear that market conditions are slowing down growth or activity on the networks?
SOL Swaps on Jupiter
Feb 18, 2022 - In this dashboard we are going to talk about Jupiter and how much sol is being daily traded on it. Jupiter: The best swap aggregator on Solana. Built for smart traders who like money.
Optimistic Bears | Network analysis
Aug 10, 2022 - Q9. Analyze Optimism during the month of July as markets were get turbulent, showing whatever metrics you care to unearth.
ASA Asset Transfers
Apr 7, 2022 - Q41. What have been the most popular assets to transfer since the beginning of February 2022 by the number of asset transfers and number of users who have transferred that asset? What announcements could have lead to these assets being popular? Create a table using the asset_transfer_transaction table that show the top 10 assets by number of transfers since February 2022. Chart these transfers over time by day as well. Create a table using the asset_transfer_transaction table that show the top 10 assets by number of wallets that initiated a transfer since February 2022. What announcements and events could have led to the popularity of some of these assets?
🍣Sushiswap: Trend of Pools
May 18, 2022 - Q78. What kind of pools do user usually withdraw or deposit into for the last 90 days? is there any pattern/trend we can see from it?
NFL All[ThanksGiving]Day
Nov 29, 2022 - The NFL's annual Thanksgiving games recently drove record viewership in the U.S., with 42 million people tuning in to see the Giants take on the Cowboys. Did FLOW NFT project NFL ALL DAY see similar boosts in popularity?
Algorand:Most Popular ASA To Swap From ALGOs
Apr 14, 2022 - Q50. Let’s look at what ASAs(Algorand Standard Assets) are most popular to swap into from ALGOs in 2022 using the swaps table Create a bar chart visualization of the top 10 ASAs by total ALGO swap volume. (Tip: This means we want to look at swaps where the wallet is sending in ALGOs(asset ID: 0) and receiving another asset in return. The volume would in ALGOs would be the sum of all the ALGOs wallets sent in to receiver the asset). Create a table for the top 10 ASAs found in part 1. In this table, list the ALGO swap volume and the average amount of ALGOs involved in a swap. Create a time series chart to look at the number of swaps (from ALGOs) to each of these 10 ASAs over time by day since the beginning of 2022. Note any trends on the increasing or decreasing popularity of any of the ASAs.
Algorand: Active daily wallets
Mar 3, 2022 - in this dashboard we are going to compare the number of active daily wallets for the month of January 2022 vs January 2021 and December 2021
Polygon: Opensea Fees
Aug 1, 2022 - Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
Sushiswap🍣 : Whale swaps
May 4, 2022 - Question: How many swaps are above x$ and how much total amounts were swapped in such transactions? Default: 150000
Tornado Cash Addresses
Aug 10, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online. Let's take a look at the addresses analyze them.
Solana TPS
Feb 23, 2022 - In this dashboard we are going to see the daily TPS ( Transactions Per Second ) on Solana.
Getting Your Feet Wet, Part 2
Mar 10, 2022 - Assess the extent to which new users interact with each of the following projects. For Definition, clearly define what “interact with” means, e.g. “at least 1 transaction”, “at least 5 transactions”, etc. Anchor, Mirror, Pylon, Astroport, Terraswap, Prism, Mars Bonus: to be eligible for the grand prize, complete at least one of the following: Display at least one visualization to demonstrate project participation, e.g.. “total # of users who have used each project”, “total # of transactions by project”, “TVL by project”. Include Randomearth, Knowhere and your analysis
🍣Sushiswap: Stablecoin Landscape on DEX
Jun 7, 2022 - Q87. Analyse the stablecoin landscape on Sushiswap, identifying the various tokens available and their main metrics (volume, number of swaps, TVL, and other relevant for you). Which one is the most successful? Is it the same at Uniswap?
Saber and daoSOL
Feb 18, 2022 - In this dashboard we are going to talk about Saber and the trends of it. Saber is the leading cross-chain stablecoin and wrapped assets exchange on Solana Questions: 1-Since the start of February, how much liquidity has been deposited in the daoSOL-SOL pool per day? 2-How many unique wallets have added liquidity to that pool since February 1st?
Terra: User Growth Per Sector
May 1, 2022 - What sectors / Apps are driving user growth on Terra ?Choose the top apps per sector (DEXs, Borrowing, Staking, NFTs ...) and create a dashboard of user growth per sector and App. Are there any sectors / apps that are driving more user growth than others? Share your findings.
Sushi: Market Volatility II
May 25, 2022 - Q83. Analyze the effects of the recent spike in market volatility on the sushi token. What was the supply and demand dynamic for it? What did the liquidity of SUSHI on uniswap and sushiswap look like? How about the staking situation for SUSHI? Did many SUSHI’s get unstaked?
Most Popular Jupiter Swaps
Feb 27, 2022 - In this dashboard we are going to see what are the most popular tokens on Jupiter in terms of them being SwappedAway, SwappedInto and the SwapPairs.
Flow: When Do Transactions Fail?
May 27, 2022 - Q2. Do times of high transaction volume lead to more transaction failures? Create a visualization that shows the relationship between transaction volume and success rate of transactions since May 9th. Are there any noticeable patterns to when transactions are more likely to fail? Were there specific events that seem to cause transaction failures?
Overtime Markets - Volume
Aug 24, 2022 - In this dashboard we will dive into Overtime markets and volume of bets/games/sports on the platform.
Solana Phantom Wallet Growth
Feb 9, 2022 - In this dashboard we will compare the months of January and February in terms of new wallets created. we want to know if the introduction of phantom wallet on phone had any impact on number of daily wallets created. since the Solana tables were running extremely slowly I couldn't get the query to run for 8 hours so I just had to end it with one chart so here it is.
Thorchain: Weighted-Average LP Duration
Apr 29, 2022 - What is the weighted average of LP duration in Thorchain?
Algorand Stablecoin Popularity USDC vs USDT
Feb 10, 2022 - In the following dashboard we are going to answer the following questions. 0-Introduction 1- What’s the number of people who currently hold USDC vs USDT. 2- Number of transactions each day for USDT and USDC. 3- What is the distribution of tokens for USDT and USDC.
Luna, Steady As She Goes
Mar 2, 2022 - In this dashboard we are going to see if LUNA is resistant to market crashes in crypto or not and how it compares to the likes of ETH and SOL.
Osmosis: Governance Reaction to Terra
May 24, 2022 - The period between May 8th - May 13th was a busy week for Osmosis governance. What was the community response like to these proposals? How quickly did these proposals hit quorum compared to the last two months of proposals? What was the voter turnout for these proposals vs the last two months of proposals? Hint: Use the msg_attributes table and select transactions that have an appropriate msg_type for delegator voting. For payment, submit the address of your Osmosis wallet.
Algorand: Al Goannas NFT deep dive
May 26, 2022 - Q80. Al Goanna is Algorand’s premier bluechip NFT with a collection of 489 original NFTs. Let’s take a look at the collection. Show the number of Al Goanna’s each wallet holds. Show the amount of fees Al Goanna sales have generated for the DAO over time. Show Al Goanna sales and ALGO volume over time. -Show the distribution of ALGO balances of Al Goanna holders Note any other insights you find about the Al Goanna sales or holders!
Algorand: What Are Whales Swapping For?
Apr 14, 2022 - Q48. Let's look at the whales are swapping for on the DEXes. First identify current whales with the balance field in the algorand.account table. Describe your methodology of what signifies a whale What percent of whales participate in swaps(use the algorand.swaps table)? Additionally show the distribution of the number of swaps per whale in 2022. What assets are whales swapping from? Display this over time starting at the beginning of 2022. What assets are whales swapping into? Display this over time starting at the beginning of 2022.