![THOR-10. [Easy] Pool Sizes - Depth](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png "THOR-10. [Easy] Pool Sizes - Depth")
THOR-10. [Easy] Pool Sizes - Depth
Oct 31, 2021 - -- What is the volume of each pool by TVL? -- How does that compare to the depth of each pool in terms of the unique number of liquidity providers? -- Hint: use daily_pool_stats + liquidity_actions
Planetwatch Rewards
Jan 27, 2022 - PlanetWatch is an environmental monitoring company that pays users in Planets to carry air quality sensors(Tokens: https://support.planetwatch.io/hc/en-gb/articles/4407510456721-Daily-rewards-for-the-Type-4-sensor). How many wallets have been rewarded for participating in the PlanetWatch Air monitoring program? Show us how the number of wallets being rewarded daily changes over time. Show us how the number of daily rewards has changed over time What day were the most rewards issued? Was there an event correlated with this? Who are the top 10 earners of Planets? Rewards Wallet Address: ZW3ISEHZUHPO7OZGMKLKIIMKVICOUDRCERI454I3DB2BH52HGLSO67W754 Asset ID: 27165954
Algo-Yieldly Staking Pool
Jan 22, 2022 - Lets head on over to Yieldly and look at Yieldly’s(app_id: 233725850) main staking pool -> Stake Yieldly to earn Yldly/Algo(this pool has an app_id:233725848) and get a better understanding of how users use the pool. We want to understand how wallets are using this staking pool. It's a relatively open ended question that you are welcome to explore but here are some starting points: What is the total YLDY TVL overtime for this pool? How long does a wallet keep their YLDY staked in this pool? Does this change based on the amount the user staked? What are the total ALGO and YLDY rewards claimed from this staking pool? How often do users claim their rewards from this staking pool? Tip: Here is a tx_group_id of a claim to get you started 5DnDY5kRHuEW0H+rjoBYosUx4kEm74xUK2GI6wtgNWQ= . Additionally Yieldly's address is FMBXOFAQCSAD4UWU4Q7IX5AV4FRV6AKURJQYGXLW3CTPTQ7XBX6MALMSPY"
Uniswap - 1. Active AMM Users
Mar 18, 2022 - -- Show the number of active users (wallets) on Uniswap and Sushiswap over the past year. -- Describe how they compare using at least two metrics (such as unique users per month, -- transactions per user per month, or anyhting you find interesting). -- Give insights on the differences or changes between the two platforms. -- Choose either Polygon, Ethereum, or both for your analysis.
41. Terra Fees & transaction volume correlation
Aug 10, 2021 - How have fees changed over time on Terra? Is this correlated with total transaction volume on Terra?
Stader-2. [Easy] LunaX HODLers
Dec 22, 2021 - How many users HODL LunaX (Stader's liquid token)? How has this number changed over time? What are the balances of these LunaX HODlers? How have these balances changed over time?
THOR-32. [Easy] LP Duration
Dec 19, 2021 - Of the users currently LP-ing, how long have they been LP-ing on THORChain? Hint: use thorchain.liquidity_actions
Harmony 4. [Easy] Transactions
Mar 3, 2022 - -- Visualize daily transactions on Harmony blockchain over a period of your choice? What interesting patterns you observe? Why could be the reason?
THOR-20. [Easy] Liquidity
Nov 6, 2021 - Of the wallets that have supplied liquidity in THORChain pools, what percentage have removed at least some of the liquidity? Hint: use liquidity_actions
Uniswap - 8. Bot Detection.
Mar 18, 2022 - -- Using Polygon data from January 2022, what percentage of swaps were presumably completed by bots? -- A bot is defined as an address that swaps more than 300 times per month.
Sushi-63.Trend Analysis
Apr 3, 2022 - -- Q63. Analyze the trend of active users and number of swaps for sushiswap and draw a comparison with Uniswap. -- Describe the trends that you see
Thor-96.THORChain and $vTHOR Overlap
May 23, 2022 - What % of $THOR staking wallets also are currently LP-ing on THORChain?
Algo-105.Wildlife Warriors NFT Drop
Jun 24, 2022 - -- Q105. Wildlife Warriors was a project established by Steve Irwin in 2002 as a way to include and involve other caring people to -- support the protection of injured, threatened or endangered wildlife. They recently had an NFT drop(https://twitter.com/wildwarriors) -- on Algorand to support the project. Lets look at the wallets that own one of these NFTs: -- -Look at when the wallets were created(created_at) that own a wildlife warrior. -- Were wallets created recently for the drop or are they more established wallets? -- -Look at the ALGO balances of wallets that own a wildlife warrior and show the distribution balances -- -Look at how many Wildlife Warriors each wallet holds. -- -Is there a correlation between how many Wildlife Warriors a wallet holds and their ALGO balance?
Terra-123. [Easy] Anchor Borrows and Deposits
Jan 2, 2022 - How have the average and total borrows and deposits on Anchor changed over time?
[Terra-44] Top Delegator Overlap
Aug 17, 2021 - Which validators do the top 25 delegators (by volume) delegate to? Do they tend to delegate to the same validators, or to different ones?
THOR-2. [Easy]Volume of THORChain Bifrost Activity by Asset
Oct 26, 2021 - -- Show the volume of non-native rune being upgraded to native RUNE, broken down by chain (ETH + BNB) -- HINT: use the Upgrades table
Terra-73 Airdrop Query Repo
Oct 5, 2021 - Using the best airdrop-oriented submissions so far, curate a repository of boilerplate queries for finding the addresses that projects airdrop to.
Thor-93.$THOR Staking Reward + APY
May 25, 2022 - -- Q93. 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. -- Show the daily / weekly staking rewards and calculate the daily / weekly APR for $THOR stakers. How has it progressed since staking was introduced?
3. Solana: 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?
2. yveCRV Rewards
Sep 19, 2021 - -- yveCRV Vault users can claim rewards weekly, yvBOOST users have their rewards automatically claimed -- and reinvests into yveCRV to compound rewards. -- How many users are claiming rewards weekly in yveCRV? -- How much gas have yveCRV holders spent since yvBoost launched? -- Have users of the yveCRV vault made good decisions about claiming tokens with regard to gas fees?
Sushi-37. Swap Sizes
Feb 6, 2022 - -- Question 37: Show the daily average swap size over time for the 10 largest liquidity pools (in terms of value locked). -- How has this swap size changed over time? Why might this be?
4. [Hard] User Journey and Outflows
Dec 22, 2021 - Show the number of users leaving the Stader ecosystem everyday (those that haven't made a transaction in over a month and have no liquidity provided). Where are those users going?
156.Terra-Terra Builders
Mar 1, 2022 - Terra Q156: Imagine you are a Terra Developer. What are your main pain points? What tooling, services, and resources would make you more productive? Describe at least 2 pain points that make building on Terra more difficult (these can be technical but non-technical pain points are also acceptable). Describe at least two (2) services/tools/capabilities that would address these pain points. Provide a concise explanation for each of them and the value they would unlock. For example: Graph queries for Terra NFT index for Terra like Open Sea API used on Ethereum Terra Developer documentation For each capability you describe, provide a real-world example from another ecosystem and show how it enables/empowers developers in that ecosystem (can be another blockchain, but non-crypto examples are also acceptable).
Paraswap-1. [Easy] New Active Users
Dec 12, 2021 - Show the number of new unique users (wallets) per day that transacted with ParaSwap over the past two months.
2. CVX in Treasury Impact on Price
Feb 5, 2022 - How does total CVX in a treasury of another asset like BTRFLY impact price correlation between assets
Thor-102.Terra LP-ers
Jun 22, 2022 - -- Q102. What did people that were LP-ing in the Terra pools do? Are they just holding onto their $RUNE now -- or are they back in the arena LP-ing somewhere? Or did they sell their $RUNE and leave the ecosystem completely.
36.Solana-Magic Eden Volume Trends
Mar 12, 2022 - -- Create a visualization of Magic Eden total sales volume per day since January 1st. -- How has sales volume trended over time? -- Are there any trends to when sales volume seems to go up or down on certain days of the week or during certain times of the day? -- Are users more likely to trade a NFT during the week or the weekend?
Angel-2. [Easy] Restore Earth
Jan 1, 2022 - How much UST has been donated to the Restore Earth campaign? Which wallets are the top 10 donors and to whom do you think they belong? Conduct your own on-chain analysis to show your conclusions. To be eligible for the grand prize, add your own analysis of charitable donations to Restore Earth and make recommendations for charitable giving to reduce crypto-tax burdens in a jurisdiction of your choice. HINT: make a small sample transaction and use the transaction to identify the Restore Earth wallet.
[Terra-54] Delegator Churn
Aug 30, 2021 - How often do delegators change which validator they are delegating to? Has this (delegator churn) changed over time?
45.Sushi-Seasonal Analysis - Monthly
Feb 20, 2022 - -- Question 45: Conduct a seasonal analysis on sushi swap activity. -- Is there a particular month or day where there is more activity?
Algo-82.Algofi Recursive Borrowing
May 26, 2022 - Q82. Let’s look at AlgoFi Recursive borrowing! This is where you supply the same asset you borrow. -- How many users are supplying and borrowing the same asset on AlgoFi ? -- What is the average amount of each asset being supplied for recursive borrowers? -- How much rewards did they receive in 2022 ? -- What is the percent of these users of total suppliers & borrowers ? -- Note any other interesting findings relating to AlgoFi recursive borrowing -- Tips https://docs.algofi.org/algofi-lending/master/depositing-funds https://docs.algofi.org/algofi-lending/master/borrowing-assets -- https://docs.algofi.org/algofi-lending/mainnet-contracts
OlympusDAO - 2. Market Value <> Holders Overtime
Apr 14, 2022 - Does the market value of OlympusDAO correlate with the number of OHM holders?
LUNA Distribution Mvmt 1: The Basics
Jan 22, 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%? BONUS: compare this to wealth distribution vs. a country or an index of your choosing.
111. [Hard] Wealth Equality, Pt. 1
Dec 9, 2021 - What is the wealth distribution for UST? Relying on at least two metrics* of your choice, how equal/unequal is this distribution? Good answers will go a step beyond balance summaries. In other words: don’t just tell us how much UST a given pool contains, e.g. $PSI-UST, but assess UST’s distribution by staking address. *Note: in future questions, we will ask you to compare UST to USDC and USDT, using these metrics.
Algo-51.USDC Transfer Volumes
Apr 13, 2022 - -- Q51. Compare USDC transfer volumes on Algorand, Solana, Ethereum in 2022. -- Chart the daily volume of USDC that is sent between wallets on each blockchain for 2022. -- Chart the daily # of USDC transactions that are sent between wallets on each blockchain for 2022. -- Find the average USDC transfer size for each blockchain in 2022. -- Compare the trends of USDC transfers on each chain and note your findings.
142. Quis Custodiet Ipsos Custodies?
Feb 2, 2022 - Flipside conducted a Community Call in December 2021 to discuss Validator transparency. It is clear from that call that potential delegators would benefit from metrics and behaviors that are not currently public or easily accessible to Terra users. In that spirit, we would like your input to determine what metrics could go into a public view of Validator behaviors. For this bounty, suggest the 3 most important such metrics, produce them for the current validators on Terra, and explain how they would be interpreted/used by potential delegators.
Pool-1.Pooly NFTs
Jun 23, 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?
2. NFT Paper Hands on Ethereum
Oct 31, 2021 - What are the top 100 most paperhanded (bought and sold for a loss usually within a short period of time) trades on Ethereum over the past 2 months?"
Algo-80.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. -- Show the number of Al Goanna’s each wallet holds. -- Show the amount of fees Al Goanna sales have generated for the DAO over time. -- Show Al Goanna sales and ALGO volume over time. -- -Show the distribution of ALGO balances of Al Goanna holders