Hossein-Ahmadzadeh
Going Down The Wormhole
Aug 5, 2022 - Q103. Create a dashboard that can refresh daily with metrics that provide a detailed picture of Wormhole activity both from Ethereum to Solana and from Solana to Ethereum.
$MATIC Liquid Staking
Sep 22, 2022 - Define what liquid staking is in your words, and evaluate the different liquidity staking options based on three different metrics of your choice. Bonus: How do people use these "liquid" derivatives? Do you see any trends?
Aave - 7. AAVE and stAAVE movements
Aug 6, 2022 - Daily AAVE supplied - withdrawn and staked - unstaked on AAVE protocol
Solend Demographics
Aug 3, 2022 - Q101.Solend is the leading lending protocol on Solana. What are the demographics of the Solend userbase?
Aave - 9. Historical APY Search Tool
Aug 12, 2022 - Create a tool that shows historical APY earned/paid on loans over a user-specified date range.
Just Keep Swimming
Jul 26, 2022 - Swim Protocol provides a simple way to transfer tokens across chains via multi-token liquidity pools. It is built on top of one of the most infamous bridges, Wormhole, which allows users to more seamlessly transfer assets across multiple blockchains
Solana Staking Madness
Nov 11, 2022 - How has staking pool behavior on Solana responded to recent events? Analyze Flipside's new staking pools data to analyze staking behavior in the Solana ecosystem over the past week. How are stakers responding to recent events? Have there been any notable inflows or outflows to staking pools? What staking pools have seen the most notable behavior? Can you link any staking behavior to other defi activity or other accounts on Solana? Note any trends or outliers you see.
Flash Bounty: SAFE Airdrop Farmers
Sep 11, 2022 - SafeDAO is currently reworking its SAFE token airdrop in order to include a broader section of their community. However, the DAO wants to ensure those tokens go to the community — not airdrop farmers. So, we want you to use Flipside’s on-chain data and your detective skills to analyze the SAFE airdrop and identify “Safes that have been created and used solely for the purpose of farming SAFE.”
City Amidst the Storm
Nov 15, 2022 - Provide a thoughtful analysis of how NEAR is weathering the market turbulence that occurred as a result of FTX’ insolvency. You can include baseline measures, e.g. token price, transaction volume - but go beyond that and apply your analysis skills. Choose and define at least 2 measures of ecosystem health, and assess how NEAR is performing on those metrics between the week of 11/7 and 11/14.Grand prize winners will also compare NEAR to at least one other Layer 1 blockchain ecosystem (Solana, Algorand, Flow, etc.), using the 2 measures provided. The goal is to gain a better understanding of how both NEAR and other ecosystems respond to market conditions that heavily affect one of their peers (in this case, Solana).
Hop In the Pool
Nov 28, 2022 - Analyze how users join pools on Osmosis. Do they dive in headfirst (add both assets; joinpool) or do they wade in carefully (singleside; join swap extern amount in). Also analyze how deep the pool is (typical swap size in token and USD for both activities).
NEAR Gas Guzzlers
Jul 23, 2022 - What contracts are users spending the most gas on to use? How has this changed over the past week? Past month?
Aave - 8. How does BTC funding affect rates?
Aug 8, 2022 - Supply and lending rates for at least five tokens in Aave V2, and Total amount of Wrapped BTC supplied over time. Measure the correlation between USDC borrow rates and total wBTC supplied.
Decentralizing Power: Governance & the Active Set (Part 1)
Nov 2, 2022 - Props 114, 196 & 337 were all passed in an effort to promote decentralization within the ecosystem. How did the voting power of the top 66% of the active set validators change after these proposals were passed? How did the nakamoto coefficient change after these events? Did time play a factor? Analyze both voting power & the nakamoto coefficient t+30,+60,&+90 days after these proposals.
Open Analytics Bounty: Optimism (August 28)
Sep 2, 2022 - Yearly, Monthly, Weekly, Daily and Hourly review on Optimism protocol.
NEAR City Layout
Nov 9, 2022 - Choose at least two distinct measures of decentralization that can be explored with on-chain data; clearly define those metrics; and outline how NEAR performs based on those metrics. In your view, is NEAR becoming more centralized or decentralized over time?
Total Value Locked (TVL) In The osQETH contract
Jun 30, 2022 - Q1. What is the total value locked in the Opyn Squeeth (osQETH) contract? And where does osQETH draw its value from?
Liquidity Pools - Wallet Composition
Oct 26, 2022 - What type of wallets provide liquidity on Osmosis? Is liquidity concentrated and owned by a small number of whales? Or, are there a diverse range of participants in the LP ecosystem? Do LP composition change based on TVL of the pools themselves?
Daily Active User
Oct 18, 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?
The Law Offices of NEAR
Jul 29, 2022 - Provide your best assessment of the number of contracts deployed on NEAR and clearly outline your methodology (after all, contract lawyers love clearly specified terms).
Seasons in the City
Oct 19, 2022 - It’s autumn in the Northern Hemisphere. What season is it in the City of NEAR? Pick one of the districts from the NEAR Tournament and review how activity there has changed over the past 90 days. What has changed? What trends can you spot? Is it truly “winter” in your chosen “district” or area (NFTs, DeFi, etc.)?
Avalanche Swaps vs Transfers (Redux)
Dec 8, 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?
DUST is in the Air
Sep 4, 2022 - Q107. $Dust is the utility token behind the most popular NFT project on Solana - Degods. The team and the community have been building with $DUST. How is $DUST being used in the Solana ecosystem? What are its most popular use cases and where are buyers of $DUST coming from? Highlight at least 3 metrics showing $DUST trends in Solana.
New NEAR Users
Sep 3, 2022 - Q9. What actions does a user take when they deposit money into the NEAR ecosystem? Show the most common actions taken by users on NEAR (new users using NEAR for the first time) over the past 3 months.
ETH Merge: Actually Good?
Sep 29, 2022 - Recently, ETH devs and observers have opined on Twitter regarding whether the Merge was good or bad for the Ethereum network. We want you to prove one side or the other, with the help of Flipside data. Demonstrate whether the Merge had positive or negative effects on the network. Include least three queries and visualizations in your submission.