![Algorand Blockchain Block Performance Algorand Blockchain Block Performance](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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)?"
Stability Fee
May 15, 2022 - How impactful is the stability fee (the interest rate) on DAI loans in terms of the impact on volume and dollar amount of loans taken out? How does activity with DAI tokens change when the stability fee is different?
Realized APY
May 14, 2022 - Visualize the realized APY of LP-ers that have removed liquidity from THORChain. What was their actual APY vs HODL (accounting for impermanent loss) when you pro-rate it for how long they were LP-ing for? Are certain pools out-performing others?
Market Share Dashboard
Aug 29, 2022 - [DAILY UPDATED] This dashboard tracks affiliate fee of Thorchain affiliates
![Common LP Pairs Common LP Pairs](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Common LP Pairs
Jan 8, 2022 - Of Rune wallet addresses providing liquidity in 2+ pools, what are the most common combinations?
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.
![Synth Utilization Synth Utilization](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Synth Utilization
Apr 13, 2022 - Calculate the synth_utilisation of each pool and chart over time.
![Is 2 Really Better than 1? (A Comparison Between Optimism and Ethereum) Is 2 Really Better than 1? (A Comparison Between Optimism and Ethereum)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Is 2 Really Better than 1? (A Comparison Between Optimism and Ethereum)
Aug 4, 2022 - Lets compare the differences between Layer 1 (Ethereum) and Layer 2 (Optimism)!
![ETH Staked ETH Staked](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
ETH Staked
Apr 4, 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?
![Have staking rewards impacted the amount of $RUNE bonded or in LPs? Have staking rewards impacted the amount of $RUNE bonded or in LPs?](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Have staking rewards impacted the amount of $RUNE bonded or in LPs?
May 22, 2022 - Chart an analysis on Staking 2.0’s effect on the pendulum incentive. Have there been meaningful impacts?
![Algorand Stablecoin Popularity USDC vs USDT Algorand Stablecoin Popularity USDC vs USDT](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Algorand Stablecoin Popularity USDC vs USDT
Feb 8, 2022 - What’s the number of people who currently hold USDC vs USDT (Tip: Use the Account asset table) Create a time series chart counting the number of transactions a day for each stablecoin(Tip: Use the asset_transfer_transaction table) Create 1 chart for each stablecoin visualizing the current distribution of holders. 3a. Does one have a better distribution than the other? If so, explain why.
![Have staking rewards impacted the amount of $RUNE bonded or in LPs? Have staking rewards impacted the amount of $RUNE bonded or in LPs?](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Have staking rewards impacted the amount of $RUNE bonded or in LPs?
May 29, 2022 - Before Staking 2.0, users participated in single-sided staking that rewarded LP-ers via emissions. Now, $THOR stakers receive a liquid token of their staked allocation, in addition to a percentage of fees from swaps. Chart an analysis on Staking 2.0’s effect on the pendulum incentive. What’s been the impact on the flow of funds into staking from LPs or bonded $RUNE, (have users been swapping from $RUNE to $THOR and staking?), and how that might be affecting the ratio of capital in LPs vs in bonds.
Flow vs Other L1s
Jun 20, 2022 - How does Flow compare to other L1s in terms of user retention? Is a user who made a transaction previously likely to make another transaction a week or a month later? Compare and contrast this type of activity vs other L1s like Solana and Ethereum
![Is Avalanche an Ethereum-Killer? (A Comparison Between Avalanche and Ethereum) Is Avalanche an Ethereum-Killer? (A Comparison Between Avalanche and Ethereum)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Is Avalanche an Ethereum-Killer? (A Comparison Between Avalanche and Ethereum)
Aug 4, 2022 - Let's compare Avalanche and Ethereum!
![Anchor Dominance Anchor Dominance](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Anchor Dominance
Feb 16, 2022 - What is the “Anchor dominance” for wallets on Terra? For active Terra wallets*, how much of their total asset value is held in Anchor at the time of analysis?
Exploring FRED Economic Data vs RUNE Price
Aug 3, 2023 - U.S Economic Data's Impact on RUNE's Price using Flipside's LiveQuery. If you find this dashboard helpful, please leave a ❤️ to show your support!
![Facts_Lending Facts_Lending](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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?
![Transaction Failure Transaction Failure](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Transaction Failure
Mar 20, 2022 - Establish the failed transaction rate for Terra over a time period of your choosing. Is this analysis correct? Additionally, make a case for what is causing the failure transaction rate you assess, and provide recommendations to mitigate it.
![Al Goannas
Al Goannas](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Al Goannas
May 26, 2022 - 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
![Liquidity and Volume Liquidity and Volume](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Liquidity and Volume
Jan 16, 2022 - For the past 30 days show the following: daily liquidity on Sushiswap and daily volume on Sushiswap. Which pools are contributing the most to each of these metrics?
![RocketPool: User Profile - LIDO vs. RocketPool RocketPool: User Profile - LIDO vs. RocketPool](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
RocketPool: User Profile - LIDO vs. RocketPool
Apr 25, 2022 - Compare and contrast activity on RocketPool vs. Lido over the past three months. Is one growing more quickly than the other? Can we conclude if one of these applications is better for users than the other? Are there different types of users using RocketPool compared to Lido, or are the user profiles similar? Visualize and explain your conclusions.
![Astroport Rewards Analysis Astroport Rewards Analysis](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Astroport Rewards Analysis
Apr 15, 2022 - How much ASTRO is allocated for rewards? What percent is currently being used and how is this changing over time?
![Impact of Terra integration on new wallets created Impact of Terra integration on new wallets created](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Impact of Terra integration on new wallets created
Apr 16, 2022 - Show the daily number of new Thorchain wallets created in the 10 days prior to and after the integration of LUNA and UST.
![THOR-versary! THOR-versary!](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
THOR-versary!
Apr 19, 2022 - THORChain Chaosnet just hit its 1-year anniversary. Calculate the following metrics, comparing THORChain in its first 30 days vs the last 30 days: total number of swaps, volume of swaps (in USD), TVL, # of pools, # of chains. Feel free to add any other metrics you feel would be interesting / relevant.
Solana Fees
Feb 5, 2022 - One of the main advantages for a user of Solana is the extremely low fees relative to other blockchains. Create a visualization showing transaction fees per day accumulated since the beginning of January. Also create a visualization that shows transaction fees per transaction on each day. Do fees ever seem to spike or is it consistent?
![Humble Swap Launch Humble Swap Launch](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Humble Swap Launch
Jun 23, 2022 - A new dex has launched on Algorand built by the reach team: humbleswap(humble.sh). Let’s look at how its launched: -Total number of swaps by day over time -total number of wallets swapping by day -What are the most popular asset pairs to swap from and too -Top 10 assets swapping from -top 10 assets to swap to
![Top Pool Analytics Top Pool Analytics](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Top Pool Analytics
Jan 10, 2022 - For the top 10 Sushi liquidity pairs (by liquidity) show the following: liquidity, 24 hour volume, 7 day volume, 24 hour fees, 7 day fees, and one year fees as a percentage.
Proof-of-Work on Ethereum
Sep 9, 2022 - We will explore Ethereum miners and their transaction count per mined block in this dashboard
![L1 Unique Users L1 Unique Users](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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?
![Dynamic Rate, Mvmt. I Dynamic Rate, Mvmt. I](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Dynamic Rate, Mvmt. I
Mar 21, 2022 - Based on defensible assumptions for key inputs (e.g. Anchor’s collateral blend and growth, as well as rates paid to borrowers), define a target range (+/- 1.5%) for the Anchor Earn rate that you think would be sustainable without regular capital infusions Assess the impact of declines in “earn rate” for other protocols, e.g. Aave, Compound, on key protocol metrics (e.g. user growth/decline, rate of user growth/decline, capital deposited, etc.)