banbannard
Whale Dependency Index
Jan 25, 2022 - Create a Bar Chart Graph displaying DEX pool vs total liquidity on Loop - with the number of total wallets holding LP tokens typed on each bar.
Secondary Sales Activity
Jun 20, 2022 - How many Lil Nouns have been sold on a secondary exchange within 24 hours of being minted? Are there any common traits among these Lil Nouns? Which Lil Noun’s have the biggest difference (positive or negative) between their mint price and secondary sale price? Visualize and analyze your findings.
Forefront Treasury
Mar 28, 2022 - Create a visualization showing Forefront's treasury holdings over time. How have they allocated funds over time between FF holdings, USDC holdings and ETH holdings? Has the structure of holdings changed as Forefront has transitioned to "Season 2"? Provide some insight on Forefront's new structure of incentivizing contributions and how the treasury can best be set up to do this. What percentage of payments made by the treasury are in USDC vs FF?
Active Wallet Growth
Jan 29, 2022 - What is the number of unique active wallets (signers) over the past 7 days? Create a visualization showing the number of active wallets per day since the start of 2022. What trends do you see?
Unique Users on Algorand
Apr 7, 2022 - 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?
Node Operator vs Liquidity Provider Yield
May 7, 2022 - What is the aggregate weekly APY for active node operators vs liquidity providers? How has it looked over time? It would be good to show node provider APY showing 2 different ways: including all nodes and just including active nodes.
Learning Snapshot (August 16)
Aug 20, 2022 - This dashboard tracks votes and voters, proposals, voting choices and spaces on Snapshot
Algorand Foundation New CEO Staci Warden
Mar 9, 2022 - Algorand Foundation appointed a new CEO Staci Warden on February 10th 2022. How did this impact the Algorand ecosystem? The week following announcement did we see an increase of ALGOs being moved from CEXs(centralized exchanges) to wallets? Or did we see an increase of ALGOs being moved from wallets back to CEXs?
SUSHI Noobs
Jun 20, 2022 - From which address do users acquire their first $SUSHI token ? is it CEX ? DEX ? Dual LP Staking Rewards ? Airdrop ?
Member Roles
Mar 6, 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).
TCR Distributed Per Day
Feb 26, 2022 - Out of the initial allocation of funds in the treasuryDAO, how much (in TCR) has been distributed per day to the users?
Sushi during Volatile Times II
May 31, 2022 - During the recent spike in market volatility, which chain saw the most activity in swaps for sushi? Polygon, Ethereum or Harmony?
Voting Records
Jan 16, 2022 - Select two Terra Validators of your choice and compare their voting history (governance votes). Off-chain data can be used to support your answer, but you must also utilize Flipside data in your answer to be eligible for full payment.
The Nightmare Scenario
Apr 21, 2022 - Recently, attacks have been leveled against Terra, suggesting that it is doomed to collapse as UST reaches unsustainable levels. Specifically, concerns have been raised that at a low enough LUNA price, users will no longer be able to redeem $1 of UST for $1 of LUNA. In what circumstances would the price and supply of LUNA and the supply of UST constitute a serious threat to UST redemption, i.e. create an imbalance wherein the UST-LUNA exchange mechanism would no longer function properly? What is the likelihood of such a scenario, and how might it be mitigated?
Polygon vs Harmony
May 30, 2022 - Draw a chart comparing Polygon with Harmony on the following metrics: Average tx_fee Average number of transactions per hour
Stablecoin Arbitrage on Jupiter
Mar 20, 2022 - Since February 1st, what percentage of all swaps (with a size of at least $100) where a wallet starts the transaction with USDC or USDT and ends the transaction with either USDC or USDT have resulted in at least a 1% gain? - Are there any patterns behind the most common sources of arbitrage on Jupiter? List the top 10 wallets in terms of total arbitrage gains and provide insight over their strategy.
Governance Reaction to Terra
May 23, 2022 - The period between May 8th - May 13th was a busy week for Osmosis governance. What was the community response like to these proposals? How quickly did these proposals hit quorum compared to the last two months of proposals? What was the voter turnout for these proposals vs the last two months of proposals?
New Celsius Wallets
Jun 15, 2022 - Build a dashboard that tracks the activity of the newly identified Celsius wallets. Let’s look at incoming vs. outgoing transactions over time. What is the average amount being moved? What are the wallet compositions by token?
$THOR Staking Distribution
May 22, 2022 - What is the distribution of $THOR currently staked? Are there any notable whales? You will need to calculate the net amount staked + unstaked to get the current amount.
Foundation Mint and Sales
Apr 21, 2022 - Using the Ethereum_core schema, analyze mint and sales activity on the Foundation platform over the past 3 months. How does the token transfer volume on foundation compare to that of OpenSea Shared Mints?
Airdrop Assessment
May 9, 2022 - Paraswap recently undertook a novel approach to conducting their airdrop. Provide a well-reasoned assessment: was this an effective airdrop design or not? What does it demonstrate about how to conduct airdrops to accomplish particular goals? How are you measuring these?
Let’s look into wallet activity with regards to Algorand NFTs
Jun 2, 2022 - How many active wallets are buying/selling/transferring NFTs monthly? What percent of Algo wallets hold an NFT? What’s the number of total wallets that have minted NFTs and put them up for sale, month over month and cumulatively? What projects are the most popular, generating the most transaction volume this month?
Saber Locked Over Time
Mar 30, 2022 - Create a visualization showing the amount of SBR locked in governance over time since January 1st. Are there any notable trends on when SBR has been locked or wallets have exited from their locked positions? For example, have there been certain dates when we can expect there to be more locking activity than others? Provide some insight on locking behavior.
Staking goBTC and goETH for Rewards
May 21, 2022 - AlgoMint launch rewards programs with multiple protocols throughout the Algorand ecosystem so we want to understand where is the best place to stake goBTC and goETH to earn rewards? Let’s look at where other wallets are staking their goETH and goBTC to get an understanding where we should stake ours. Look at items such as mint and burn actions over time as well as the amount of goBTC and goETH being staked over time to help us determine where the most popular place to stake your goETH and goBTC. Additionally, are there any places not listed that you can stake your goETH and goBTC for rewards and are users staking them there?
User Activity
Jun 11, 2022 - Analyze user activity providing and removing liquidity from NFTX vaults. Which three vaults have seen the most activity over the past 60 days? Are there any similarities between these vaults or NFT projects? Explain and visualize your findings.
Increasing Positions
Jun 28, 2022 - Compare users terminating vs increasing positions over the last 30 days. By how much are they increasing positions? How much are they receiving back after terminating?
Transaction Failures
May 27, 2022 - 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.
Friktion's Crab Strategy
Apr 27, 2022 - Track the deposit activity into the Crab Volt. How many unique wallets have used the strategy since April 11th? What other Friktion Volts have these wallets used since March 1st? What is the crossover between the Volt #1 Bitcoin strategy and the Crab Volt? Why would a wallet prefer to use this Crab Volt instead of the other products?
Local vs. Full Memberships
Feb 22, 2022 - Create a visualization of the number of holders of $FWB token over time. Also create a histogram showing $FWB wallet balances. How many wallets have a “Local Membership”. How many wallets have a “Full Membership”. Is there a strong concentration of wallets holding just over 5 $FWB and just over 75 $FWB? Do you think this token model makes sense compared to say owning a NFT? Why?
$RUNE Movement from Crypto.com
Jun 19, 2022 - Show the in + outflow from cryto.com to native wallets over time. Are there any trends?
Highest Sales Volume
Jun 11, 2022 - Which 3 NFT collections have the most total sales volume in the last 60 days on NFTX? These are transactions where someone redeems their NFTX tokens for a specific NFT.
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?
Swap Fees
Jun 28, 2022 - Do fees on Osmosis differ when users swap to or from different tokens? On average, which tokens have the highest and lowest swap fees on Osmosis?