Metiocre
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.
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.
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.
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
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?
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
🍣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?
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.
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.
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.
What makes a Top Shots moment valuable? (Part I)
Jul 25, 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.
![NFL All[ThanksGiving]Day](https://res.cloudinary.com/dsr37ut2z/image/url2png/c_crop,g_north_west,h_600,q_auto,w_1200,x_0,y_0/v1675649148/https://next.flipsidecrypto.xyz/previews/dashboards/27fec71e-945d-4bd5-b4d2-d0f37bf14616%3Ftype%3Dcover "NFL All[ThanksGiving]Day")
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: 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: 2022 Yieldly Staking Pool Analysis
May 21, 2022 - Q75. Let's get a better understanding of the YLDY staking pool usage in 2022. In 2022 what have been the most popular Yieldly staking pools by the amount of YLDY staked, the total number of stakers, and the average amount staked? Additionally, show us how staking pool participating has evolved over time in 2022. Do we see more wallets participating in staking pools now or less? Do we see more wallets participating in staking pools but committing less amounts? Note how behavior has changed around these staking pools. Does the price of ALGO impact the number of users participating and staking pools? Are there any standout wallets that have staked in a lot of these Yieldly staking pools? Note any other interesting findings about the Yieldly staking pools and their usage.
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..
Quixotic Marketplace Analysis
Aug 3, 2022 - Come with me to explore everything about Quixotic, the biggest nft marketplace on optimism.
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.
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?
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.
Overtime Markets - Volume
Aug 24, 2022 - In this dashboard we will dive into Overtime markets and volume of bets/games/sports on the platform.
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.
ETH + USD in the FWB Treasury
Feb 23, 2022 - In this dashboard we are going to check the Friends With Benefits treasury wallet and the assets it is holding and compare them over time.
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?
Solana TPS
Feb 23, 2022 - In this dashboard we are going to see the daily TPS ( Transactions Per Second ) on Solana.
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.
🐼 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.
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
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.
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.
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?
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.
🍣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?