![5. [Hard] Meteors, Eggs, and Dust, oh my! 5. [Hard] Meteors, Eggs, and Dust, oh my!](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
5. [Hard] Meteors, Eggs, and Dust, oh my!
Dec 15, 2021 - -How many unique owners are there for Meteors -How many unique owners are there for Eggs? -How many unique owners are there for Dusts?
![Flipside Payout Addresses Flipside Payout Addresses](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Flipside Payout Addresses
Aug 16, 2021 - Some SQL Statement to see which addresses got paid and what are their current holdings
![Optimism Scavenger Hunt (June 14) Optimism Scavenger Hunt (June 14)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Optimism Scavenger Hunt (June 14)
Jun 14, 2022 - To complete the scavenger hunt, create a dashboard showing at least three of the following transactions
![24. [Easy] Unique Addresses 24. [Easy] Unique Addresses](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
24. [Easy] Unique Addresses
Oct 24, 2021 - Visualize the daily unique new addresses that use Aave on mainnet.
![Sushiswap Transactions Sushiswap Transactions](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Sushiswap Transactions
Aug 28, 2021 - Over the last 30 days, find SushiSwap transacters from the dex_swaps table. How many of these addresses also exist on Polygon, and have swapped with SushiSwap there? Compare the average fees paid per swap for these addresses on Ethereum vs. Polygon.
![Validator Ranking Validator Ranking](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Validator Ranking
Jul 11, 2021 - Are the same validators that were in the top 10 (by rewards received) last month in the top 10 this month? Break this down by change over the weeks in the past 2 months as well.
![Katana wLUNA Pool Katana wLUNA Pool](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Katana wLUNA Pool
Feb 20, 2022 - Katana's primary offering is a suite of accessible vaults that execute automated yield strategies in the background. One of such vaults is its Wormhole LUNA covered call vault, which offers appealing yield opportunities on LUNA especially during times of volatility.
![32. [Hard] THORChain Wallet Address Growth by Time Segment 32. [Hard] THORChain Wallet Address Growth by Time Segment](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
32. [Hard] THORChain Wallet Address Growth by Time Segment
Dec 17, 2021 - What has been the rate of THORChain growth in terms of the number of new THORChain addresses being created? How do the following time periods compare? 1. Pre-hack (before July 16, 2021) 2. Pre-Network Halt (Sep 24 - Nov 11) 3. Post-Network Halt (Nov 18 - present) Hint: use liquidity_actions, swaps, bond_actions, transfers, and upgrades to get all the THORChain addresses
![46. [Easy] Fee Volatility 46. [Easy] Fee Volatility](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
46. [Easy] Fee Volatility
Aug 14, 2021 - What has the day over day change in fee generation been for Uniswap V3 over the past 1 month?
![106. [Easy] New Money 106. [Easy] New Money](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
106. [Easy] New Money
Dec 4, 2021 - Of the TVL for the community farming event, how much was new money (from outside Apollo’s vault) vs. a transfer from Apollo’s existing vaults? Defend your answer!
![Uniswap - Voting Power Distribution Uniswap - Voting Power Distribution](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Uniswap - Voting Power Distribution
Jun 25, 2021 - To vote on governance in Uniswap, you can choose to self delegate or delegate to a trusted party to vote on proposals for the protocol. In the past 30 days, what is the distribution of addresses to votes? How many smaller volume addresses are voting vs. larger volume addresses? Please include your defintion of larger vs. small. Learn more about voting here: https://uniswap.org/docs/v2/governance/guide-to-voting/ Example transaction: https://etherscan.io/tx/0xb8d9a5b7dc439111e7a3123fdce18edf586ff8eac377ca94cfd9a9ae778ac172
![29. [Hard] $RUNE Price after Cap Raises 29. [Hard] $RUNE Price after Cap Raises](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
29. [Hard] $RUNE Price after Cap Raises
Dec 12, 2021 - During the chaosnet phase, THORChain has limited the amount of funds stored in liquidity pools to allow for gradual growth of the ecosystem and reduce downside risk in the case of a hack. They have now gone through several periods where the caps have been raised and additional liquidity is allowed to flow into the network (you have have noticed the #RAISETHECAPS battlecry of the THORChads in the ecosystem). Is there a noticeable pattern of the price of $RUNE during these times where the caps are raised?
![26. [Easy] Biggest Liquidations 26. [Easy] Biggest Liquidations](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
26. [Easy] Biggest Liquidations
Oct 30, 2021 - What are the top 10 liquidation events that have occurred in the past year?
![LUNA Market Cap LUNA Market Cap](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
LUNA Market Cap
May 7, 2022 - Q201. Back to basics! Display the LUNA price and market cap trend over 30, 60, 90 days; the past year; and all time.
![3. [Easy] Brace for (Meteor) Impact 3. [Easy] Brace for (Meteor) Impact](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
3. [Easy] Brace for (Meteor) Impact
Dec 15, 2021 - Measure the impact of Levana Meteors! -How many meteors are there? -What is the breakdown/count of Legendary, Ancient, Rare, and Common? -How many have been cracked, and how many remain uncracked?
![74. [Easy] Airdrop Price Impact 74. [Easy] Airdrop Price Impact](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
74. [Easy] Airdrop Price Impact
Oct 4, 2021 - How do airdrops impact the price of a token? Find and analyze at least one example in the data.
![17. [Hard] Pool Depth 17. [Hard] Pool Depth](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
17. [Hard] Pool Depth
Nov 6, 2021 - What is the current depth of each pool based on the number of LP-ers currently providing liquidity?
![102. [Elite] Burn, Baby, Burn (Elite Edition) 102. [Elite] Burn, Baby, Burn (Elite Edition)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
102. [Elite] Burn, Baby, Burn (Elite Edition)
Nov 14, 2021 - Using at least two metrics of your choice (transaction speed, volume, price action, wealth concentration…possibilities abound), assess the market impact of the LUNA burn. As well, make a data-driven forecast around how the resulting UST supply is likely to affect the Terra ecosystem (and the wider crypto space).
![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 - Q169. Make reference to this tweet: https://twitter.com/alphaDefi_/status/1504522066674003972/photo/1 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.
![Terra LFG Terra LFG](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Terra LFG
Mar 9, 2022 - Create a dashboard that updates daily to display the Luna Foundation Guard yield reserve. As well, provide at least one visualization and one metric that you think is related to the yield reserve’s growth or depletion. Tweet this out with the hashtag #LFG and #bestanalyticalminds.
![2. [Easy] Active Weekly Users 2. [Easy] Active Weekly Users](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
2. [Easy] Active Weekly Users
Dec 4, 2021 - Show the number of unique users (wallets) per week that transacted with Orbs over the past year.
![Tokenflow Trailblazers Tokenflow Trailblazers](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Tokenflow Trailblazers
Mar 20, 2022 - Q1. Dive into the Tokenflow data and tell us what you find.
![20. [Hard] Aave Staking Reward Flows 20. [Hard] Aave Staking Reward Flows](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
20. [Hard] Aave Staking Reward Flows
Oct 11, 2021 - Analyze how Aave rewards (staking) are spent on mainnet -- are they reinvested into positions? Used to pay down loans? Simply liquidated/swapped for ETH?
![3. [Easy] Number of Users of THORChain Bridges by Asset 3. [Easy] Number of Users of THORChain Bridges by Asset](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
3. [Easy] Number of Users of THORChain Bridges by Asset
Oct 23, 2021 - Show the number of users interacting with THORChain broken down by chain.
![Bonded vs. Unbonded LUNA Bonded vs. Unbonded LUNA](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Bonded vs. Unbonded LUNA
Aug 20, 2021 - Compare the quantity of Bonded Luna to unbonded Luna. Visualize the changes in each over a time period of your choice, and provide a quick explanation of the insights or significance: what can we learn from the ratio of bLUNA to LUNA?
![54. [Easy] V2 vs. V3 Volume 54. [Easy] V2 vs. V3 Volume](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
54. [Easy] V2 vs. V3 Volume
Sep 12, 2021 - Visualize the volume of trades on v2 vs. v3 over the past 6 months. Has the difference between the two stabilized or is it still dynamic? Elaborate. Hint: Use the dex_swaps table.
![117. [Hard] Terrarbitage, Part 1 117. [Hard] Terrarbitage, Part 1](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
117. [Hard] Terrarbitage, Part 1
Dec 13, 2021 - Fluctuations in the bLUNA/LUNA pool allow for arbitrage opportunities for users to gain more LUNA. Explore the potential yield (APY) from arbitrage in the pool. -How frequently do these premiums come about? -What strategies yield the best returns (burning on Anchor vs swapping BLUNA back to LUNA)? -At what premium should users swap their LUNA and bLUNA to generate the most yield?
![21. [Hard] Preferred C-Ratio 21. [Hard] Preferred C-Ratio](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
21. [Hard] Preferred C-Ratio
Oct 11, 2021 - What is the collateralization-ratio (c-ratio) that people like to keep their loans at? What is the distribution of this preferred value across addresses that volume that different borrowing addresses work with (small accounts vs. whales)? How does this ratio change with the price action of the collateral?
![Terra - New User Inflow Terra - New User Inflow](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Terra - New User Inflow
Jun 25, 2021 - Show new user inflow to Terra. Relate this to new user inflow to Mirror and Anchor - for example, are the majority of Mirror and Anchor users new to the Terra ecosystem? Are the Whales on the Terra ecosystem engaging with Mirror and Anchor? Note: Please include how you define "Whales"