Algorand Free Square
Jun 29, 2022 - Q110. Time to get creative and explore! We want you to dig into a topic/project/protocol on Algorand that you find relevant and interesting and create an analysis around it. Bonus points for creativity and uniqueness!
Assets Removed from Osmosis
Jun 11, 2022 - On June 8th, a critical bug was found on Osmosis that led to the theft of several million dollars from liquidity pools. In an effort to help provide the Osmosis team with important data, we’ve curated these flash bounties to surface metrics that the team has requested. The upgrade that contained the exploited bug occurred at block height 4707300, and the chain was halted at block 4713064. What was the total dollar amount of assets that was improperly removed from pools due to the bug, and what is the list of addresses that had joined a pool since the upgrade? What is the dollar value deposited of those addresses joining pools? What is the cumulative value of funds that joined and exited?
Market Volatility
May 24, 2022 - Q82. 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.
Active Wallets on Terra
Apr 30, 2022 - Define "Active Wallets" on Terra. Based on your definition, display the active wallets by day, month, and Year-To-Date in 2022.
LP-er Retention
Apr 22, 2022 - Take a look at THORChain addresses that have ever added liquidity. Group them by the month of their first date of adding liquidity. What % are still providing liquidity in the THORChain ecosystem? How does it look if you filter those that provided at least $10,000 in liquidity?
Seasonality
Mar 15, 2022 - Question 53: Is it true that the average gas fee paid by users is lower during festive seasons? Choose two festive seasons in 2021 to put this claim to the test! What else can we say about the festive seasons?
Head to Head
Mar 26, 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?
ALGO Transaction Payment Size
Mar 30, 2022 - Q43. Let’s look at the quantities of ALGOs being sent in transactions since January 1st 2022 to see if we see any upwards or downwards trends. Group the transactions(algorand.payment_transactions) by size 0-10ALGOs, 10-100ALGOs,100-1000ALGOS, 1,000-10,000ALGOs and 10,000+ ALGOs. Count the number of transaction in each size and chart them by day from January 1st 2022 to current.
Saber Proposals & Gauges
May 29, 2022 - Q79. Create a visualization showing the total amount of SBR locked over time and voter participation rates.
% of Solana Staked
Feb 11, 2022 - Using the "Events" table, what percentage of Solana that has been transacted is staked? How has that percentage changed throughout the month of January? Create a visualization showing % SOL staked over time. What is the average amount of Solana staked during a staking transaction?
Price vs Volume
Feb 11, 2022 - Look at the price of the Sushi token and volume on Sushiswap over the past 30 days. Does the price of the Sushi token seem to impact volume on Sushiswap?
$RUNE Upgrades
Jun 27, 2022 - Q.107 There has been a big push for users to upgrade their ETH.RUNE + BNB.RUNE -> native RUNE, as the wrapped versions will be depreciated. Have you seen an uptick in the amount of $RUNE being upgraded recently? Look at both the $RUNE volume + number of wallets. What is the trend over time + also how much is ETH vs BNB?
Whale Dependency Index
Jan 26, 2022 - NOTE: There is data mismatch on terra.daily_balances table
Open Analytics Bounty: Optimism (August 7)
Aug 11, 2022 - Flipside Crypto has built pathways and provides the tooling for you to develop deep and thorough crypto analysis. Now, we want to see what you can do with them. Submit any dashboard you think is worthy of being shared with our partners, and with the world. We’ll select the best for payment and amplification through our social and content channels.