Lil-Nouns-1.Voting Activity
Jun 17, 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.
Thor-58. Synth Mints + Burns
Apr 10, 2022 - -- Synth Mints + Burns -- Show the minting + burning of synthetic assets over time.
Algonauts-3- Governance rewards- what was the total governance rewards of period one [medium]
Jan 1, 2022
Most Popular Centralized Exchange For Algorand Wallets
Feb 23, 2022 - Let's look at the popularity of centralized exchanges(CEX) when it comes to Algorand. Chart the volume of ALGOs moved to each CEX by day since the beginning of 2021. Chart the volume of ALGOs moved from each CEX by day over time since the beginning of 2021. Are there any notable days of volume for any of the CEXs? What happened?
Uniswap - 11. Stablecoin Trends - Uniswap
Mar 23, 2022 - -- Describe trends in stablecoin usage on Uniswap over a time period of your choosing. -- What is the most popular stablecoin? Have any stablecoins seen noticeable growth or decline? -- Be sure to define what makes a stablecoin popular -- (number of swaps, transaction volume in USD, or other metric of your choosing),and visualize this over the time period. -- Include at least the top 5 stable coins (USDT, USDC, BUSD, UST, DAI) in your analysis
THOR-5. [Easy] Swapping
Oct 26, 2021 - Show the number of swaps as well as the unique number of swappers in total and by pool, today and daily. HINT: use swaps table
THOR-31. [Easy] Net Liquidity
Dec 19, 2021 - How much liquidity is being added and removed from the THORChain pools over time? Is there a noticeable trend? Hint: use thorchain.liquidity_actions
Anchor-7.Cross-chain Anchor
Mar 29, 2022 - Q7. Compare the Earn sides of Anchor protocol on Terra vs. Avalanche. What does the Earn side look like on Avalanche? In the last week, are people using it more? Is there more volume?
Sushi-1. Active Weekly Users
Nov 13, 2021 - Show the number of active users (wallets) per week on Uniswap and Sushiswap over the past year. How do these two charts compare? Why might this be?
Uniswap - 23. CEX to DEX and DEX to CEX
Apr 6, 2022 - -- Examine the flow of UNI into and out of Centralized exchanges. -- Which exchanges have the most volume, in terms of USD? Is more flowing in or out?
4. [Hard] LBP Analysis
Jan 2, 2022 - Analyze the recent HaloSwap LBP event that concluded on 12/22/21. Provide summary metrics of your choice, as well as your assessment of the LBP as a fundraising mechanism for Angel and how it could improve. Use the link below as a guideline for the type of analysis that will be useful. Note: the top 3 submissions that are most helpful to Angel Protocol will receive a $HALO reward in addition to the grand prize! https://blog.perp.fi/everything-you-need-to-know-about-the-first-liquidity-bootstrapping-pool-lbp-60a61b368c82
ENS-11. [Easy] Claims vs Price
Dec 31, 2021 - Is ENS just for cred? Or do people actually use their ENS-addresses? Look at all addresses with an ENS registration in the last 6 months, what percent of those addresses have done transactions?
What Are Users Swapping gALGO3 For?
Apr 25, 2022 - -- Show the number of trades to gALGO3 and from gALGO3 by day? -- Also chart the volume of trades to gALGO3 and from gALGO3 by day? -- Are there any notable days? If so, what may have caused this? -- What DEXes are users swapping gALGO3 on? Show the breakout of number of gALGO3 swaps(to or from) by day for each dex. -- What are the top 10 most popular to swap from to get gALGO3? -- What are the top 10 most popular to swap to from gALGO3?
Polygon vs Harmony
May 29, 2022 - -- Q1. Draw a chart comparing Polygon with Harmony on the following metrics: -- Average tx_fee -- Average number of transactions per hour
47.Sushi-xSushi vs Meowshi
Feb 27, 2022 - -- Question 47: How many/what percentage of xSushi holders have interacted with the Bentobox to obtain Meowshi and further improve their gain? -- What is the total volume?
Algo-45.Stablecoin Popularity for Swaps
Apr 6, 2022 - -- Q45. 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. -- Tips: USDC(31566704) USDT(312769) STBL (465865291)
Thor-59.Average Age of Synth Holders
Apr 11, 2022 - -- Average Age of Synth Holders -- Create a chart displaying how long synth holders keep their synth for. -- Ideal format is a bar chart of % of users, and # days holding for.
Thorra-Luna-UST
Apr 15, 2022 - -- How have the RUNE-UST, RUNE-LUNA pools been performing on Thorswap? -- How do the fees generated from these pools compare to other pools? -- Do the swaps in these 2 pools tend to be balanced or are they typically going in a certain direction -- (e.g. are there more swaps from $LUNA or to $LUNA)?
ENS-1. [Easy] Airdrop Stats
Dec 9, 2021 - How many wallets were eligible for the airdrop? How many addresses have claimed the airdrop? What percentage of all ENS that has been airdropped been claimed? Note: This question is somewhat similar to question 3. We suggest completing them together to save some time!
MIM + Its Peg
Feb 9, 2022 - How has MIM performed at holding/regaining its peg over the past few weeks. Is MIM depegging correlated with the price of other stablecoins, especially UST?
Thor-60.Average Price Shift for Synth Holders - Average
Apr 10, 2022 - -- Q60. What is the typical price shift experienced by a synth holder? -- Compare the current price of the asset vs the price when they minted (relative to $RUNE). -- Ideal format is a bar chart of % of users, and current price relative to the price at the time of the synth mint. -- Hint: use thorchain.prices and thorchain.swaps. 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.
Let it burn!
Apr 24, 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.
Uniswap Weekly Volume Breakdown
Aug 4, 2021 - For the past 10 weeks, what has been the week over week change in total volume for Uniswap? What has been the week over week change in total volume for each of the top 5 pools by volume (ranking determined by most recent week)?
ENS-15. [Hard] Renewal Timeline
Jan 1, 2022 - -- Create a visualization depicting how likely a renewal is to happen as time approaches the expiration -- date of the domain. Are more renewals done right before expiration or is it a more gradual distribution?
Hop-3.Hop Whales
Jun 20, 2022 - -- Are whales choosing Hop to go to L2s? Or are they choosing the native bridges? -- Compare Hop vs the native bridges for Polygon, Optimism, and Arbitrum over the following metrics: -- unique users on each, frequency of use, and the average amount of assets moved on each?
Algo-78.AB2 Gallery Wallets
May 26, 2022 - Q78. Let’s look at wallets that buy from AB2 Gallery! How many wallets are buying NFTs on AB2 gallery. What is the total number of unique wallets that have purchased from AB2? Create a distribution plot of how many NFTs each wallet has purchased from AB2. Are we seeing new wallets purchasing on AB2 or is it only wallets that have purchased from AB2 before? Chart the first purchase on AB2 by wallet over time. Create a table of the top 10 wallets that are purchasing from AB2 by ALGOs and number of NFTs Tips: Check out this analysis for some inspiration on how to write your queries: https://app.flipsidecrypto.com/dashboard/15-ab-2-gallery-nf-ts-77b-ew https://ab2.gallery/ Here is an asset transfer example of an asset being purchased from AB2 Gallery tx_group_id = 'wWE2i1LDwQBpKv+RGPNGcNvKm7VrmskGUyV4snkFS1w=' -To look at transfer transactions in involving AB2 Gallery use: where try_base64_decode_string(tx_message:txn:note::string) = 'ab2.gallery' NFT Statistics and Explorer: https://www.nftexplorer.app/stats
Algonauts - Top 10 assets by volume of transactions
Dec 25, 2021 - Time series of chart of transactions per day by assets (for top 10 assets by volume of transactions)
SUSHI-16. [Easy] User Liquidity Spread
Dec 29, 2021 - How spread out is your average Sushi liquidity provider in terms of pools where they provide liquidity? Is it optimal to stick to a smaller number of pools or spread your capital across a bunch of different liquidity pools?
Distinct Wallets (Optimism Bridge)
Jun 15, 2022 - -- Q1. Many blockchain bridges exist allowing users to move assets between different blockchains. -- One of the blockchains currently receiving a lot of bridge volume is Optimism. -- There are several bridges you can use to move tokens to Optimism, but for this bounty we are particularly interested in -- Optimism’s bridge. You can find more information on their native bridge here and here. -- How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the -- last 60 days? Visualize your findings.
THOR-30. [Hard] Sankey Swap Diagrams
Dec 12, 2021 - Produce a Sankey chart of the most common swaps. Velocity doesn’t currently support Sankey charts, so feel free to get creative with how you produce them! Hints Use thorchain.swaps Python package: https://www.python-graph-gallery.com/sankey-diagram-with-python-and-plotly
ENS-8.[Easy] Multiple Domains
Dec 19, 2021 - How many wallets have multiple domains? Are holders more likely to have one domain or multiple domains?
SUSHI-Liquidity and Volume
Jan 17, 2022 - For the past 30 days show the following: daily liquidity on Sushiswap and daily volume on Sushiswap. Which pools are contributing the most to each of these metrics?
Algo-98.Swap Increase on May 11 + 12
Jun 7, 2022 - -- Q98. On May 11th and 12th we saw a spike in number of swaps and volume across the DEXs. Breakdown what happened? -- What were users swapping from and to? -- Were users swapping from ALGO to stables? -- Was the average swap size bigger than normal? -- Is this tied to the price of ALGO? -- Help us understand what took place and why the volume and number swaps increased!
[MIRROR-1]. [Easy] Asset Transaction Volume - Overall
Dec 1, 2021 - Analyze the aggregate and per asset transaction volume in the last 90 days. Note any trends in the data.
Standardized TVL Over Time (1 Pool)
Apr 23, 2022 - -- Select one pool of your choice and show the total number of asset tokens (non-RUNE tokens) in that pool over time
Stargate TVL Metrics
Apr 23, 2022 - -- Show how the Total Value Locked (TVL) of Stargate on Ethereum has changed since its inception. -- What percentage of the TVL is made up by each token staked on Stargate?
74. [Easy] Airdrop Price Impact
Oct 6, 2021 - How do airdrops impact the price of a token? Find and analyze at least one example in the data.
Uniswap - 20. Power Users.
Mar 30, 2022 - -- Using data from January 2022, what percentage of swappers were also liquidity providers at some point -- in January? You may answer using data from any blockchain were Uniswap is available.
Algo-41.ASA Asset Transfers
Apr 6, 2022 - -- Q41. 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? -- Create a table using the asset_transfer_transaction table that show the top 10 assets by number of transfers since February 2022. -- Chart these transfers over time by day as well. -- Create a table using the asset_transfer_transaction table that show the top 10 assets by number of wallets that initiated a transfer since February 2022. -- What announcements and events could have led to the popularity of some of these assets?
Anchor ANC Holding Prop-18
Mar 12, 2022 - Analyze the age of ANC holdings (average is good, distribution of ages is even better) for wallets who voted YES on Poll 18: https://app.anchorprotocol.com/poll/18 Are these voters longtime holders, or are they acquiring ANC for the purpose of voting in this proposal?
Solana-73.It's the Catalina Whale Mixer
May 17, 2022 - -- Q73. Catalina Whales are a popular NFT collection on Solana with an experienced team from the entertainment industry. -- Chart their sales history and unique holder trends over time. -- The project has a tier system of holders (5 whales gets you tier 2 status and 10 whales gets you tier 3 status), -- has this noticeably influenced wallet activity? -- The project recently announced that you had to own a whale before 5/11 at noon EST in order to qualify for the whitelist -- of an extremely hyped mint Bubblegoose Ballers along with other benefits. -- How has that influenced sales activity and holder activity over the past few weeks?"