itsxenux
Sushiswap DEX Loyal Users
May 7, 2022 - Q77. Rank wallets that used SushiSwap based on the number of trades and number of days they used the DEX. How many users keep coming back to the platform ? Use different frequencies for the ranking : Last month, Year to date and since inception
LP Size Distribution
Apr 29, 2022 - What is the current distribution of LP size for each pool? You will have to use both 'add_liquidity' and 'remove_liquidity' to determine which LPs are stil current.
Holder Behaviors
May 31, 2022 - Explore the behavior of top 5 LDO holders.Include: LDO balances and history Typical actions with LDO
Sushi Activity on Ethereum
Jun 25, 2022 - How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings?
Friktion Bitcoin Volt
Mar 19, 2022 - Q41. 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 BTC. - Provide some insight on how this type of strategy works. For users that have deposited BTC into the Friktion BTC Covered Call Volt since January 28th (Epoch 6), what other DeFi protocols have those wallets interacted with? - How many unique wallets have deposited into this BTC Volt and list the top 10 wallets in terms of amount deposited since Epoch 6. - Has the Volt become more popular over time for ""whales"" or the average Solana wallet?
Total Metamask Users
Jun 24, 2022 - How many total Metamask wallet holders are there? What’s the average value of ETH held in wallets? What percentage of wallets are engaging in a higher order activity, like staking?
CLUB Liquidity
Mar 16, 2022 - What’s the liquidity of the CLUB token on decentralized exchanges? Analyze the trade volume on Uniswap, what is the largest trade? Did that trade affect the balance of tokens in the pool significantly?
MonkeDAO Vote
Apr 6, 2022 - Q49. A month ago, the MonkeDAO pressed the Solana Monkey Business team for various changes to be made to the royalty and NFT structure to foster growth for the collection. Ultimately this resulted in the first NFT on-chain vote on Solana to accept or reject the SMB team's proposal, with a 'no' likely resulting in a separation of the two groups. In the end, the MonkeDAO voted to unify with the SMB team and to grow their relationship together. Track the wallets that voted yes and no for the SMB proposal. What were people's voting preferences based on the number of SMBs that they owned? What have these wallets done with their SMBs since the voting? Was the nearly unanimous voting a bullish event? Have wallets that voted yes bought more monkes? Were those who voted no more likely to sell after the fact and on which marketplace? What percentage of all monke sales involved a selling wallet that voted at all?
Pooly NFTs
Jun 21, 2022 - How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
DEX Popularity: Tinyman, Algofi, Pactfi
May 17, 2022 - Since the beginning of April, how has the growth of AlgoFi and PactFi impacted swaps on Tinyman? Show us how the Algorand DEX ecosystem is changing as each DEX grows.
Market Volatility
May 22, 2022 - The second week of May saw some huge volatility in the market and prompted many to sell their volatile assets and take a flight to safety.
Getting Started with Terra Bounties 2.0
Feb 11, 2022 - in this dashboard we can see last 6 months deposit UST to anchor platform.
Stargate User Growth
Apr 22, 2022 - How many unique users are staking capital on Stargate on Ethereum each day since its inception? What might this suggest about the protocol's growth?
Friktion's Crab Strategy
Apr 27, 2022 - Friktion recently launched a new product offering, Volt #03 - a volatility yield strategy for stablecoins in crab markets. 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?
GMT Airdrop
Mar 23, 2022 - Q38. GMT, the governance token of StepN, was airdropped to its 5000 trailblazers (early adopters and supporters of the game) on 3/15. The airdrop amount was calculated from the amount of time played in the game. Create a graphic showing the wallets that received the GMT airdrop and highlight the top recipients of the airdrop. What have recipients done with the airdrop? Are these ""trailblazers"" holding their airdrop or are they selling? Have the top recipients been more or less likely to hold onto their tokens?
USDC Deposits
Jun 21, 2022 - In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
New NFT Mints
May 15, 2022 - Q76. 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?
AB2 Gallery Wallets
May 23, 2022 - Let’s look at wallets that buy from AB2 Gallery to get a better understanding of purchasing behavior.
Acquiring goBTC and goETH
Apr 6, 2022 - Q47. Where are users acquiring goBTC and goETH? Are they acquiring the assets by swapping or by minting? Has this changed over time? Explain the insights you find.
Outbound Traffic
Mar 16, 2022 - The Terra Bridge has expanded its capabilities: https://twitter.com/Speicherx/status/1501883479457288193 Create a dashboard to track the outflows of LUNA and UST to Osmosis, Secret, Axelar, and Injective. What conclusions can you draw from the outflows thus far?
New Active Users
May 7, 2022 - Q1. Show the number of new unique users (wallets) per day that transacted with ParaSwap over the past two months.
Highest Sales Volume
Jun 10, 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.
Votes, Votes, Votes
Apr 22, 2022 - Q185. On average, how much voting power (in Luna) was used to vote 'YES' for governance proposals? Out of this, how much Luna comes from validators vs regular wallets?
Transaction Fees
May 20, 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?
Bridge Transactions (Across)
Jun 19, 2022 - Analyze bridge transactions via the Across bridge over the last two weeks. What assets are users bridging from Ethereum, and to what chains?
User Growth per Sector
May 1, 2022 - What sectors / Apps are driving user growth on Solana? Choose the top apps per sector (DEXs, Borrowing, Staking, NFTs ...) and create a dashboard of user growth per sector and App. Are there any sectors / apps that are driving more user growth than others? Share your findings.
New Users on Algorand vs. Ethereum vs. Solana vs. Terra
May 2, 2022 - Create a Dashboard for new users on : Algorand, Ethereum, Solana and Terra What trends do you see?
Net Synth Amounts
Apr 29, 2022 - Show the net synth amounts (mints - burns) for each chain and each asset? Are there any patterns?
Marinade's Non-Fungible Chefs (Part II)
May 4, 2022 - Marinade Finance Non-fungible Chef NFTs began minting on April 4, 2022. How many unique holders of the NFTs are there? Create a chart showing trading activity and SOL volumes on Magic Eden.
Early Pool Activity
May 13, 2022 - Q79. For each pool, show the swap volume and the liquidity after its first week going live (you can use the first swap date to determine when a pool went live)
Who's That Going Across My Bridge (Redux)
Apr 18, 2022 - Q186. Pick one bridge from Terra and a destination of your choice. (e.g. Shuttle bridge Terra <-> Ethereum or Wormhole Terra <-> Solana). Assess the daily and cumulative amount of UST that goes through that bridge, both inflow and outflow. How many users are using the bridge on a daily basis? How many transactions take place on a daily basis?