keshan
Yieldly HDL Distribution Pool Exploit
Mar 24, 2022 - At the beginning of March, Yieldly announced they had found wallets abusing the HDL Distribution pool. Let’s look and see if we can identify the wallets or wallets that were taking advantage of the HDL distribution pool logic.
Net Synth Amounts
Apr 29, 2022 - Show the net synth amounts (mints - burns) for each chain and each asset? Are there any patterns?
BanklessDAO Q1 - Member Roles
Mar 9, 2022 - A member is a user who has 35,000 or more $BANK tokens in their wallet (not counting members with Guest passes). A whale is a user who has over 150,000 $BANK tokens in their wallet. Show the number of members and whales on Bankless DAO over time (not counting Guest Passes for members).
Solana Q41-Friktion Bitcoin Volt
Mar 22, 2022 - Friktion is a new DeFi portfolio management project that helps users maximize profits by generating yield. The Friktion BTC Covered Call Volt is one such yield opportunity for interested participants who want to generate income while holding BT
THOR-versary!
Apr 21, 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
Terra Seigniorage
May 5, 2022 - A scenario analysis to understand what percentage of seigniorage would help to get Anchor YR on track
Terra NFT Trading Volume Trends
Feb 11, 2022 - For the 10 most popular project on RandomEarth, what projects have seen the greatest increase in volume in the last 30 days? (LUNA + UST figures) Create a visualization showing percentage change in volume over the past 30 days for these projects. What projects seem to be trending and what seems to be fading?
Active Wallets on Terra
May 2, 2022 - Define "Active Wallets" on Terra. Based on your definition, display the active wallets by day, month, and Year-To-Date in 2022
Acme of Skill
Mar 16, 2022 - Make your own business intelligence dashboard for the Terra community. Build something that you think your fellow LUNAtics would use.
Top LDO Holders
Jun 1, 2022 - Q1. Who are the top LDO holders on ethereum and where have their LDO come from? Did they buy it or was it an airdrop?
Solana fees
Feb 7, 2022 - Question 6: 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.
LUNA Distribution Mvmt 1: The Basics
Jan 23, 2022 - People who do not like crypto often cite wealth inequality as a reason: they claim that the tokens are concentrated in the hands of a few whales. Assess this claim for LUNA. How much of circulating supply is held by the top 100 addresses? Top 1%? Top 10%?
Terra 152 - Anchor Emissions
Feb 21, 2022 - Create a table of all addresses that have made at least one Anchor borrow in the last 3 months. Do some basic analysis and produce at least one interesting insight about Anchor borrowers.
Initial swap volumes of LUNA and UST
Apr 16, 2022 - Measure and compare the first three days of swap volumes of the following tokens: Doge, LUNA and UST
THORChain: Pool Ranks
Apr 13, 2022 - Visualize the TVL of each pool over time. Feel free to get creative here.
Transaction Fees
May 23, 2022 - How many transaction fees are being paid out each day for the past 30 days? Does a certain type of transaction result in a greater amount of fees being collected?
Osmosis: Stablecoin Dominance
Jun 28, 2022 - Q20. Compare the transaction volume for USDC, USDT, and DAI on Osmosis. Is there a stable coin that Osmosis users prefer?
$RUNE Upgrades
Jun 26, 2022 - Q.107 There has been a big push for users to upgrade their ETH.RUNE + BNB.RUNE -> native RUNE, as the wrapped versions will be depreciated.
Symmetric vs Asymmetric LPs
May 31, 2022 - Q99. On THORChain, you are allowed to add liquidity in 1 of 3 ways: Rune-only, asset-only, or symmetric (both Rune + asset). What is the breakdown of liquidity being added, according to those categories? Are there any trends over time or by pool?
Osmosis: Unique Users
Jun 4, 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?
Lockdrops Keep Fallin' On My Head
Jan 26, 2022 - Explain, in your own words, what a “lockdrop” is. Choose a metric for ASTRO tokens (price, circulating supply, amount sold vs. HODL) and display it visually over a time period of your choosing.
Lil Nouns: Voting Activity
Jun 14, 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.
SushiSwap 31: Sushi and Uni Gas
Feb 2, 2022 - Compare the daily ETH gas fees on Sushiswap over the past 2 months to those on Uniswap. Show the average gas fee per transaction as well as total gas fees collected.
State of the Art
Mar 5, 2022 - Imagine a super awesome Terra Console 2.0 or an analytics equivalent to Terra Station: a dashboard users can check daily to stay informed and up-to-date on the Terra ecosystem.
Swap Volume vs. LP Rewards
May 1, 2022 - Chart the weekly swap volume and LP rewards on the same chart. What is the relationship between the two?
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.
ALGO Transaction Payment Size
Mar 28, 2022 - Let’s look at the quantities of ALGOs being sent in transactions since January 1st 2022 to see if we see any upwards or downwards trends. Group the transactions(algorand.payment_transactions) by size 0-10ALGOs, 10-100ALGOs,100-1000ALGOS, 1,000-10,000ALGOs and 10,000+ ALGOs. Count the number of transaction in each size and chart them by day from January 1st 2022 to current.
Stablecoin Popularity for Swaps
Apr 5, 2022 - Which stablecoin is more popular for a wallet to use in swaps(use algorand.swaps table): USDT, USDC, STBL? Compare volumes and number of swaps for each over the month of March 2022.
wETH & wBTC On- and Off- Ramps
Jun 7, 2022 - Q9. On the Osmosis Frontier, there are pools for wETH and wBTC. How do users respond and change their position in these pools in response to governance proposals involving extra incentives for these pools? Do their deposits and withdrawals of wBTC and wETH onto Osmosis change as well?
$RUNE Movement from Crypto.com
Jun 21, 2022 - Q104. Show the in + outflow from cryto.com to native wallets over time. Are there any trends?
Looking For Swap Arbitrage
Mar 30, 2022 - Let’s see if we can find any wallets profiting from arbitrage on the Algorand DEXes. We specifically want to see if anyone is conducting arbitrage with USDT or USDC, Asset ID 31566704 or 312769. The period we will want to look at is From January 1st 2022 to current.
Q150 - Anchor Emissions (Hard Mode)
Feb 24, 2022 - What percentage of Anchor (ANC) borrow emissions are sold within 7 days of receiving them? How has this percentage changed over time?
Top ConstitutionDAO Contributors
Jan 27, 2022 - Who were the top contributors to ConstitutionDAO? Did they redeem their ETH or sell PEOPLE tokens via Uniswap?
Terra 146 - Whale Voters
Feb 12, 2022 - For whale voters, how many of them have voted in at least one Terra/Anchor/Mirror governance vote in the past 90 days? What is the percentage of whales who have voted?
MIM Use Cases
Feb 10, 2022 - How is MIM used in comparison to USDC / USDT / UST or a stablecoin of your choice? Describe user behavior. What protocols or contracts are users interacting with? Compare the count and volume of transactions
Sushiswap: Most Recent Transactions
Jan 27, 2022 - Find the top 10 tokens in terms of liquidity in USD on Sushiswap. Show the 10 most recent transactions on Sushiswap for each of those tokens.
When Do Transactions Fail?
Jan 20, 2022 - Do times of high transaction volume lead to more transaction failures? Create a visualization that shows the relationship between transaction volume and the success rate of transactions throughout the month of December. Are there any noticeable patterns to when transactions are more likely to fail?
Let it burn!
Apr 27, 2022 - Find the week that the most volume of Luna burning happened. What caused this event? Show some effects of this burning had on Terra ecosystem by your opinion.