alleria
Fuse Pool Analysis
May 22, 2022 - Q3. Are the DAI and USDC Vaults using the same Fuse Pools to seek yield? What differences can you identify?
117. [Hard] Terrarbitage, Part 1
Dec 12, 2021 - How should we utilize the bLUNA/LUNA pool in Terraswap? Let's find out
Pooly NFTs
Jun 21, 2022 - Q2. How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
45. Net Swapping Ratios
Jan 15, 2022 - Which tokens have the highest and lowest ratio of being swapped from/to?
20. [THORChain] Liquidity
Nov 7, 2021 - Of the wallets that have supplied liquidity in THORChain pools, what percentage have removed at least some of the liquidity?
LUNA Total Supply
May 8, 2022 - Q202. Display the LUNA Total Supply and LUNA non-circulating supply over 30, 60, 90 days and one year. Compare your solution to at least one other data benchmark, e.g. Smart Stake, Terra Station, CoinMarketCap.
[Osmosis] Unique Users
Jun 6, 2022 - Q7. How many unique wallets are active on Osmosis per day? How has this changed over time? What has been the largest event that has brought the most wallet activity to Osmosis? Hint: Determine events by comparing to news sources as well as on-chain data.
16. [Hard] Affiliate Fees
Nov 4, 2021 - What Addresses are being used to collect affiliate fees? What is the total affiliate fees over time?
[Pool Together] Prizes
Jun 22, 2022 - Q3. In the past 60 days, how many PoolTogether prizes have been awarded and claimed? What’s the USD value of these prices?
Anchor Emissions
Feb 22, 2022 - Let's have a look at Anchor users that had borrowed at least once in the past 3 months!
[Loop] Airdrop Actually Claimed
Oct 17, 2021 - How many LOOP airdrops are claimed, and what percentage of all addresses was the airdrop was made available? Let's find out!
[Stark Net] ETH Deposited or Withdrawn
Jun 26, 2022 - Q1. StarkNet is a layer-2 chain that ensures interoperability with Ethereum mainnet. People are using it to move real ETH to starknet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to StarkNet or vice versa? and by how many depositors?
Swapping for YLDLY on DEXs
May 21, 2022 - Show us the total volume inflow and outflow of Yieldly(YLDY: Asset ID: 226701642) by day in 2022 then break it out by DEX as well. Is swapping for YLDY more popular on some DEXs than others? Additionally what assets are users swapping for YLDLY? Are there any standout days of swap volume for Yieldly? If so, write about what may have caused that spike.
Arbitrum - The Halt of the Odyssey
Aug 6, 2022 - The Arbitrum Odyssey went to a halt on week 2. What happened? Let's find out!
[Galactic Punks] The Fate of the Minted Galactic Punks
Oct 16, 2021 - In this dashboard, we will be looking at some of the statistics on the minting process of Galactic Punks, which includes the unique wallets participated and number of Galactic Punks minted per wallet. Besides, we will also look on the after-market transactions, sales and volume of the Galactic Punks in RandomEarth.
4. [Hard] LBP Analysis
Dec 23, 2021 - Let's see some of the statistics on the Haloswap Liquidity Bootstraping Pool (LBP) event!
Bridge Users (Hop Protocol)
Jun 21, 2022 - Q1. How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.
1. [Easy] Daily Reward Distribution
Oct 23, 2021 - Let us take a look at the daily block rewards distributed to nodes and Liquidity Pools every day.
[Lil Nouns] Voting Activity
Jun 18, 2022 - Q1. The Lil Nouns DAO is controlled via onchain voting by token holders. Using the ethereum database, analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant.
Swing and a Miss
Feb 12, 2022 - Question 147: In honor of the Terra <> Washington Nationals partnership, let's find out the percentage of successful vs. unsuccessful transactions on Wormhole on Terra.
Transaction Failures
May 28, 2022 - Q6. Establish the failed transaction rate for Osmosis over the last 4 months. Make a case for what is causing the failed transaction rate that you assess and provide recommendations to mitigate it.
[Loop] Free Square: Distribution of the LOOP Airdrop Claimers (not involved in LPs)
Oct 22, 2021 - Among the LOOP Airdrop claimers, who are those users that sold their airdrops or transferred out their LOOP tokens? Who did not do any transactions at all after claiming the airdrops? Let us find out!
2. Visualize governance staking of $MINE over time
Nov 5, 2021 - In this dashboard, we will compare $MINE staking trends with $LUNA staking trends over time. Will a lockup period be beneficial for MINE? For those that have stopped staking MINE, what did they decide to do instead?