Mojtaba-Banaei
#11.Synth Mints + Burns
Apr 12, 2022 - Q58. Show the minting + burning of synthetic assets over time. Use the thorchain.swaps table. A mint is when the to_asset has a ""/"" in it, like ""TERRA/LUNA"" instead of ""TERRA.LUNA"". Similarly, a burn is when the from_asset has a ""/"" in it.
Velodrome Health (Redux)
Nov 4, 2022 - In this dashboard, we want to answer the above question by examining different statistical data-driven metrics.
#8. Friktion Bitcoin Volt
Mar 22, 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.
#4. First Time Deposits at Mango Markets
Feb 20, 2022 - Mango Markets is a decentralized, cross-margin trading platform with lightning speed and near-zero fees because it is natively built on Solana. There is a one time fee of .035 SOL to open a trading account on Mango Markets. How many new trading accounts have been created by users since February 10th? How much SOL has been transferred into Mango Markets (don't count the one time fee) since February 10th from first time deposits? What was the average deposit amount? Create a visualization showing these trends over the time specified.
#14.Rand Gallery NFT Sales
May 4, 2022 - Rand Gallery is one of the largest NFT marketplaces on Algorand. Let’s take a deeper look into rand gallery’s history and the performance of the marketplace.
#4. Anchor Emissions (Hard Mode)
Feb 24, 2022 - Question 150: What percentage of Anchor (ANC) borrow emissions are sold within 7 days of receiving them? How has this percentage changed over time? BONUS: What insights would you offer the Anchor team on how to reduce the percent of emissions that are being sold shortly after receiving them?
#6. Terra Super Dashboard
Mar 9, 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.
#7. Facts Lending
Mar 16, 2022 - Build a query for a fact table about sushi's lending activity on Polygon. What questions does your table answer(At least Two questions)? What other dimensions could potentially be extracted from sushi contracts and added to this table to make it more valuable?
#17.Algorand NFTs
May 25, 2022 - Q78. Let’s look at wallets that buy from AB2 Gallery to get a better understanding of purchasing behavior.
#17.Al Goannas
May 26, 2022 - Q80. Al Goanna is Algorand’s premier bluechip NFT with a collection of 489 original NFTs. Let’s take a look at the collection.
#10. MonkeDAO Vote
Apr 6, 2022 - 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.
#13.Fractional.art NFT Sales
Apr 27, 2022 - Q16. Using the Ethereum_core schema, analyze the 3 most actively traded fractional NFT vaults on Fractional over the past 3 months. How many NFTs are in these collections? What is the total trading volume? Add any other data points to your analysis that you find valuable.
#4.MonkeDAO Validator Popularity
Feb 19, 2022 - The MonkeDAO was the first NFT DAO on Solana and also was the first NFT DAO to set up a validator in an effort to help decentralize and secure the network. When a user decides to stake their Solana, they delegate which validator to support with their staked Solana. How many unique wallets since February 1st have decided to delegate their staked Solana to the MonkeDAO validator? Create a visualization showing delegations per day.
#7.The Road So Far, Mvmt. I: Validators
Mar 16, 2022 - As the bounty program nears its one year anniversary, it's time for a recap. We'll start with a handful of the most important topics in crypto: decentralization, network security, and governance.
OSMOSIS Wallet Balances & Ecosystem Growth
Oct 20, 2022 - With the launch of Flipside's new Balances table, let's take a look at how the story of Osmosis can be told through wallet balances. Provide insights into following metrics: - How has the ratio of liquid to staked OSMO changed overtime? - Are the top 100 OSMO holders the same now as they were at the start of the year? - What is the current average OSMO per wallet? How has that value changed over time? Plot average OSMO/wallet against user growth. - Do wallets normally hold a majority of OSMO, or another token? How has this changed over time?
#13.Validator Voting vs. Investor Inclinations
Apr 27, 2022 - Analyze the last 5 governance proposals. Out of the total Luna that voted in favor, how many % are from validators vs. retail investors for each proposal and on average? Grand Prize Worthy: are there any cases you can identify where retail voters and major validators tended to vote against each other?
NEAR Gas Guzzlers
Jul 27, 2022 - What contracts are users spending the most gas on to use? How has this changed over the past week? Past month?
#18. Crazy Goose Flock and $CRUMB Token
Jun 7, 2022 - Q97. Crazy Goose Flock is one of the strongest growing NFT communities on Algorand. Let’s look at the holders of the CGF!
Hadeswap Wash Trading Analysis
Oct 20, 2022 - A new sector of NFT marketplaces have begun to gain popularity on Solana, the NFT AMM. One of the most notable NFT AMMs on Solana so far is Hadeswap. Create a definition for 'wash trading 'and use that to track sales activity on Hadeswap with our newly curated models in the NFT sales table. How much of the volume seems "legit"? Are there certain accounts that seem to be creating the majority of the volume? What collections have had the most activity on Hadeswap, and how much of that was from 'wash trading'?
OP Price vs Swapper Activity - Is there a Relationship?
Oct 5, 2022 - Is there a relationship between OP price and trade volume?
#17. THORChain and $vTHOR Overlap
May 24, 2022 - Q96. Since vTHOR and THOR Staking 2.0 was released in May, we’re interested in finding out more about how the community has embraced the staking rewards What % of $THOR staking wallets also are currently LP-ing on THORChain?
#5.Tokemak Popularity
Mar 2, 2022 - Tracer Q3: Tokemak is a protocol that allows tracer governance token holders (TCR) to seek further ROI by way of yield farming. What is the popularity of Tokemak among tracer users? Hint: Tokemak_tTracer address: 0x15A629f0665A3Eb97D7aE9A7ce7ABF73AeB79415
#13.Fractional.art Top NFT Collections
Apr 27, 2022 - Q17. Which 5 NFT collections (for example; BAYC, MAYC, ArtBlocks, etc.) have been deposited into Fractional vaults the most over the past 3 months? Are there any trends with these collections? How does having highly sought after NFTs in the vault impact trading volume?
USDC Analysis on Avalanche: Swaps vs Transfers & Mints vs Burns
Nov 16, 2022 - Lets look at volume of USDC swaps vs transfer by hour since 7/1. What is the average amount of USDC transferred vs swapped? Show number of unique swapper addresses vs transfer addresses by day for USDC Next lets look at mints and burns of pairs involving Lets look at the volume of USDC mints and burns by hour since 7/1 How many unique wallets are minting and burning USDC by day What is the average mint vs burn for USDC by day Note anything else interesting about USDC transactions
#11. Distributed Validator Technology
Apr 13, 2022 - Q1. Explain what Distributed Validator Technology (DSV) through the Obol network is and why it might help with decentralization on Ethereum 2.0 or other Proof-of-Stake chains.
#10. ASA Asset Transfers
Apr 7, 2022 - What have been the most popular assets to transfer since the beginning of February 2022 by the number of asset transfers and number of users who have transferred that asset? What announcements could have lead to these assets being popular?
#5-Most Popular Jupiter Swaps
Feb 27, 2022 - Solana Q27: Jupiter is the best swap aggregator on Solana, meaning that it optimizes the best token swap rate across all decentralized exchanges for users.
#20. Bridge Users (Hop Protocol)
Jun 22, 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.
USDC Declining on Osmosis?
Oct 12, 2022 - Analyze your favorite token’s LP & trading activity on Osmosis over the past week. Please provide volume and user growth metrics into this analysis and focus on deep insights on ONE token.
#5.Tracer Voters
Mar 2, 2022 - Tracer Q2: How many people (addresses) have voting rights in tracer? How much of that has been deposited in major decentralized exchanges(DEX)? what is the breakdown per DEX Hint: TCR Token address: 0x9c4a4204b79dd291d6b6571c5be8bbcd0622f050
#9. Forefront Curators
Mar 29, 2022 - Q2. Forefront has token-permissioned governance and curation channels that require holders owning at least 1000 FF tokens. Create a visualization of the number of curator roles in Forefront over time. Are more curators being added over time? In your own words, how could Forefront incentivize growth in curator roles? Hint: Read more about Forefront from https://www.forefront.club/ and https://forefront.mirror.xyz/
FLOW User Retention vs Other Chains
Nov 29, 2022 - How sticky are the users on Flow? Create a detailed analysis comparing user retention on Flow vs. other L1 chains like Ethereum and Solana. How often do users who make a transaction come back and make another transaction one month later? How do monthly active users compare between chains?
#10. Song That Own Itself(STOI) Airdrop #3
Apr 7, 2022 - Q44. Let's look at how many wallets have claimed the STOI Song #3 “Million Scars” Airdrop. How many users have claimed the airdrop? Chart the STOI Song #3 airdrop token distribution by day.
#11.SOL Staker Activity
Apr 13, 2022 - Q52. How frequently are SOL stakers interacting with DeFi protocols over the past month? Which protocols are they interacting most with? Which actions are they mostly taking? Staking? Farming? Swapping? Mining?
#20. USDC Deposits on PoolTogether
Jun 22, 2022 - Q1. In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
#11. What Are Whales Swapping For?
Apr 14, 2022 - Let’s look at what ASAs (Algorand Standard Assets) are most popular to swap into from ALGOs in 2022 using the swaps table
Profiling the Daily Active User on Osmosis
Oct 17, 2022 - What does a Daily Active User look like on Osmosis? First, plot out how many DAUs there are on Osmosis. For this exercise, consider a DAU would be any wallet transacting on Osmosis a majority of days every week. Once you have the DAUs, what does their activity look like? Do they LP more or swap more? How often do they transfer tokens into Osmosis? Where are these transfers coming from?
#9. The Rise of DeGods
Mar 30, 2022 - DeGods have risen to become one of the most valuable NFT collections on Solana with an extremely devoted community. Create visualizations showing sales volume and unique wallet purchases since January 1st on Magic Eden. Using the NFT metadata, are there certain traits that have become more popular over time in anticipation of DeadGods? $DUST is the token created by DeGods for NFT auctions and will be a necessity for modifying the DeGod art to a DeadGod. Who is swapping for $DUST on Jupiter? Is it correlated with the wallets that have purchased the most DeGods? What do you think will happen to the price of the DeGods collection and $DUST when DeadGods launches on March 31st?
#9. Mind Your Ps and Ys
Mar 30, 2022 - Make your case for the relative value of pLUNA or yLUNA! Define the key inputs to the relative valuation for each; various methods of valuation (discounted flows, comparables, growth-based models) will be accepted as long as you make a reasonable case for them and support them with evidence.. Over a time period of your choosing, how has pLUNA or yLUNA’s price changed as these key inputs have changed? Note: Grand prize winners will assess both pLUNA and yLUNA.
Polygon NFT Market Analysis
Jul 8, 2022 - In this dashboard, we are going to analyze the daily sales volume of NFTs on Avalanche and see which collections are the most popular among users, which NFTs are the most sold, and the what is the number of active NFT traders. How much is Fee in this network and has it affected the activity of users or not?