Kaskoazul
LUNA Market Cap
May 7, 2022 - Q201. Back to basics! Display the LUNA price and market cap trend over 30, 60, 90 days; the past year; and all time.
Algorand Foundation New CEO Staci Warden
Mar 17, 2022 - Question 31: 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?
StepN Growth
Feb 26, 2022 - StepN is a Solana based ""move-to-earn' game (you earn the game's native token GST by moving around using their NFT sneakers and GPS system). The game has seen steady growth in popularity since it launched at the end of December (transitioned from a private beta mode to its current public mode). Create a visualization showing the number of unique wallets that have transacted with GST by day since January 1st. How much total GST has been transacted per day since January 1st? Provide some insights over the adoption of GST and how long it can accommodate its limitless supply as an in-game token.
Bots and success rate
Apr 25, 2022 - Compare the success rate of transactions executed by bots in the past 60 days with average users' transactions in the same time period. Is there any difference and any trends identifiable?
Borrowing On Folks Finance
May 14, 2022 - Q69. Let’s look at borrows on Folks.Finance a borrowing and lending protocol built on Algorand. We want to get an understanding of how what assets users most want to borrow, how often borrows are happening, and the average collateral ratio between the collateral offered and the asset that is borrows. Ultimately, we want to get a better understanding of what people are borrowing, and what the collateral ration looks like.
New DEX Users
Mar 26, 2022 - Q40. Let's use the algorand.swap table to look at users who are using the new DEXes(Decentralized Exchange): PactFi, AlgoFi, WagmiSwap and whether or not they previously used the Tinyman exchange? What percent of wallets for each of the new DEXes(swap_programs:PactFi, AlgoFi, Wagmiswap) had previously used Tinyman to perform a swap?
P2P NFT Lending with Yawww
May 8, 2022 - Q70. There is a growing trend in the Solana NFT space of using NFTs as collateral for loans, therefore making rather illiquid assets more liquid. Yawww is a protocol that has offered services for both person to person NFT trades, and now person to person NFT loans.
LoftyAI Tokenized Real Estate
Feb 28, 2022 - Algorand Q27: LoftyAI is a tokenized real estate platform(https://www.lofty.ai/). You can invest in property via tokens distributed by Lofty AI, each being worth $50. Rank the properties listed by LoftyAI based on total token investment price. (Each property has its own asset created by the address 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'). How many wallets have bought a token for at least one property? What wallet has invested in the most Lofty AI properties? How many properties are they invested in?
What Are Users Swapping gALGO3 For?
Apr 28, 2022 - gALGO3 is an asset that is pegged to ALGO. Users can lock their ALGO up on Folks.finance for governance and while their ALGO is locked they receive gALGO3 and you can use it for other defi activities. Read more about it here: https://docs.folks.finance/protocol-architecture/algo-liquid-governance Let’s look what users are swapping their gALGO3 for while their ALGO is locked in governance.
Gard.Money Algorand’s First Algorithmic Stablecoin
Apr 23, 2022 - Q55. GARD is the world's first algorithmic stablecoin on Algorand's blockchain. Let’s look at the collateral debt positions(CDP) users are taking on. This is where users put ALGOs up as collateral and in turn get GARD(Asset ID 684649988) in return. Gard is a stable coin pegged to $1 in value.
Bot Activity
May 13, 2022 - Q86. Create a way of identifying bots within THORChain (could be something like a certain number of swaps / day made). What % of the swaps and swap volume are made by bots? Are there certain strategies you can see them employing (most of them are likely arbitrage bots)? Are there many bots or mainly just a few that conduct a high % of bot activity?
Synth Mints + Burns
Apr 12, 2022 - Q58. Show the minting + burning of synthetic assets over time.
ASA Dex Degens
Mar 24, 2022 - Q38. Let's look at DEX wallet behavior with the algorand.swaps table to get an idea of how many swaps wallets are being conducted and see how many ASAs wallets are trading. Chart the distribution of the number of swaps wallets have conducted in 2022(Count the number of swaps a wallet has performed create a distribution of these wallets). Chart the distribution of the number of ASAs a wallet has swapped for (Count the number of assets a wallet swapped for and create a distribution of the number of assets per wallet).
The Rise of DeGods
Mar 30, 2022 - Q42. 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?
LP Size Distribution
May 3, 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.
ETH Staked
Apr 3, 2022 - Q5. What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
Node Churning Events
May 5, 2022 - In the THORChain ecosystem, a "churn" happens when one node goes from "Active" -> "Standby" or "Disabled" and another goes from "Ready" -> "Active". Show the cadence of node churning events over time.
Tinyman LP Actions
Mar 3, 2022 - Algorand Q28: Let's look at LP actions on Tinyman since launching Tinyman 1.1 at the beginning of 2022. -Show the number of mint and burn actions each day. -Create a table of the LP pools with the most mint and burn actions
Crypto Pixels meet Mainstream Sports
Jun 13, 2022 - This dashboard analyzes the trends in NFT sales volume on Flow since May 9 and is a submission to Flipside's Flow Bounties Q3 "Trending NFT Projects"
Tinyman TVL
Jun 22, 2022 - How can the TVL of a whole DEX in Algorand be calculated? Using the available on-chain data from Flipside Crypto we can calculate the TVL and really get deep into how much value do users deposit on a platform like Tinyman.
Fuse Pool USDC Allocation
Mar 23, 2022 - Q2. How are the tokens in the USDC Vault being allocated into the various Fuse Pools?
Terra Bounty: LUNA Distribution
Jan 27, 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.
Outbound Traffic
Mar 15, 2022 - Question 166: 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?
State of the Art
Mar 5, 2022 - Question 158: 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. For Completeness, touch on the two points: What data do Terra users want to see displayed daily - besides price, what do you want to check on a daily or weekly basis, e.g. active users/MAU/WAU, number of protocols? Describe the features that would be important to include. While you can mention non-data features, e.g. “integration with an airdrops calendar” or “links to Terra Bites podcasts”, the majority of your analysis should focus on data features. For Visualization: display at least two existing resources, e.g. this or this, that you think are excellent, or provide your own simple mockup or wireframe of a Terra analytics dashboard."
USDC Transfer Volumes
Apr 14, 2022 - Compare USDC transfer volumes on Algorand, Solana, Ethereum in 2022.
Head to Head
Mar 25, 2022 - Q172. Excluding the respective foundations, what are the top 10 addresses by amount of UST held? What are the top 10 addresses by amount of DAI held? Do you have any guesses to whom those addresses belong?
More Mints
Apr 19, 2022 - Q56. Metaplex is an open source protocol that allows for the creation and minting of NFTs using a standardized format across wallets and applications. It is essentially the backbone architecture for Solana NFTs. How many NFTs have been minted over the past week? Since the beginning December, how many NFTs have been minted per week? Chart the growth of unique purchasers over time. What percentage of all mints have been via Metaplex's Candy Machine?
Bot addresses and transactions - overview by chain (Ethereum and L2s)
Jan 18, 2023 - Ethereum and its L2s
Solana bounty: New User Activity
Feb 11, 2022 - For new users, what is the most common first program that users interact with on Solana (as in what is the most popular first transaction for a new wallet)? What is the average number of transactions a "new wallet" makes in their first 24 hours? (New wallet defined when a wallet makes its first transaction). Do you think this is more or less than other chains? Note: Limit this analysis to the month of February.
Most Popular Jupiter Swaps
Feb 27, 2022 - Jupiter is the best swap aggregator on Solana, meaning that it optimizes the best token swap rate across all decentralized exchanges for users. Since February 1st, what have been the 10 most popular tokens to swap away? Over that same timeframe, what have been the 10 most popular tokens to swap for? What are the 10 most popular swapping pairs (combination of swap away to swap for)? Define 'popular' as the number of swaps and create a visualization showing total number of swaps over that time frame, highlighting these most popular tokens.
New Users on Algorand vs. Ethereum vs. Solana vs. Terra
May 4, 2022 - Create a Dashboard for new users on : Algorand, Ethereum, Solana and Terra What trends do you see?
LUNA Staking and Trends
May 9, 2022 - Q203. Over the past 30/60/90 days and the past year, how much LUNA has been staked per day? What is the staking percentage (LUNA staked/Circulating Supply), and how has it changed over time?
Raydium Swaps
Apr 2, 2022 - Q44. Raydium is an automated market maker (AMM) built on the Solana blockchain that shares liquidity with the Serum decentralized exchange. Create a visualization comparing the quantity of swaps and number of unique wallets on Rayidum, Jupiter, and Orca since January 1st. What have been the ten most popular tokens to swap and swap for on Raydium during that time period? What tokens have become more popular over time?
Bot Swappers
Apr 27, 2022 - This bounty will analyse the behaviour of swap bots in Terra for different metrics and compare it to average swappers or humans. I will use a dynamic definition of bot swappers using the new parameters functionality in Flipside's tables to let the reader make its own assumptions.
stETH vs. ETH
Apr 1, 2022 - Q6. How has the price of stETH compared to ETH? Are there any events that triggered a big difference in price between the two tokens?
L1 Unique Users
Mar 12, 2022 - Question 37: Compare the number of unique wallets that have sent a transaction since February 1st on Solana vs Ethereum vs Terra. How does user adoption seem to be trending for Solana compared to these other major chains? Does it appear that market conditions are slowing down growth or activity on the networks?
Forefront Treasury
Mar 29, 2022 - Q3. 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?
User journey through Osmosis
Jan 1, 2023 - User Segmentation Analysis @ Flipside Bounty Program
Validator Pageant
Mar 16, 2022 - Question 164: Select one validator outside the top 10 and make a case for why newcomers to Terra should delegate to that validator. Define any metric of your choosing that marks a good validator (airdrops, voting, community benefits, uptime); assess the average for the full set of ~130 validators (i.e. if you pick airdrops, assess how many of them offer an airdrop); and assess how your chosen validator performs based on that metric.