hesam
Average Optimism Portfolio
Oct 13, 2022 - What does the average Optimism user's portfolio look like and how has that changed over time? What % of a user's activity (in OP terms) is staked, unstaked, in liquidity pools/farms, in NFTs? How has this trend changed over time?
Tourist Journeys
Oct 26, 2022 - Select one of the key Districts from the NEAR tournament, and compare it to a similar district in another “city” (that is, another Layer 1 blockchain). Look at the past 90 days and visualize the relative progress of these two L1s, using at least 3 metrics of your definition. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
$OP Airdrop (Redux)
Nov 17, 2022 - Earlier this year, Optimism offered an airdrop to users. Let’s examine the airdrop after a few months. How many users claimed optimism airdrop? How much of total airdrop was claimed? How many wallets are still holding tokens from airdrop? How much of users delegated their OPs? Feel free to provide any information that you think is related to token price. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Algorand Price Correlation
Jul 1, 2022 - Is the price of Algorand more closely correlated with the crypto market, and assets such as BTC or ETH, or is it more correlated with network usage such as number of transactions or ALGO transfers? How does this compare to other networks such as Solana? Note your findings and anything else that may be interesting in relation to Algorand's price movement!
OPtimitic or Pessimistic?
Oct 19, 2022 - Are you optimistic or pessimistic about the future of the layer-2 chain known as Optimism? How do you think it will fare going forward compared to other L2s? Make your case with Flipside data. Include at least three visualizations in your submission, and note any particularly interesting trend our outliers you see. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Distinct Wallets (Optimism Bridge)
Jun 17, 2022 - In this dashboard, I counted the number of distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days.
DUST is in the Air
Sep 8, 2022 - $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.
Additional Swaps Required to Offset Emissions
Oct 4, 2022 - Swap/economics: How much swap volume does THORChain need to offset emissions? (maybe a tool?) E.g if we 10x swap volume, the current block emissions can be offset by the additional fees generated from the swaps.
Velodrome Locks
Jul 18, 2022 - Analyze new locks created on Velodrome Finance. Analyze new locks created on Velodrome Finance. What durations are most common? Which wallets have locked the most in the last 4 weeks? Which pools are wallets voting for with their locked tokens most often? For more information on Velodrome, please visit: https://docs.velodrome.finance/
Flash Bounty: SAFE Airdrop Farmers
Sep 13, 2022 - Use your analytical prowess to earn a potential big payout + get some serious spotlight! 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.
NFTs in 2022
Jan 5, 2023 - A retrospective on the NFT market in 2022. NFT project with the highest volume of trades in 2022? Which NFT project had the largest mint by dollar? Which NFT project decreased the most in value this year? Which NFT project gained the most value this year? What was the price of the highest-selling individual NFT? Which NFTs had the longest hold time this year? Which NFT project had the least amount of NFTs listed for sale on an exchange? Which project had the most NFTs listed for sale on an exchange? BONUS: share this 2022 NFT highlight on Twitter and @Flipsidecrypto and any NFT projects who should see your analysis on their performance this year.
Voting Activity
Jun 20, 2022 - This dashboard contains interesting information. Information such as analyze voting activity on Lil Nouns proposals, List of Top holders and the behavior of small holders.
What's Going On With Gnosis?
Oct 16, 2022 - There’s been some unusual activity with Gnosis as pointed out by our community. Time to figure out exactly what’s going on. Take a deep dive into recent activity on Gnosis, especially recent rapid rises in the number of active users, transactions, and more. Make any hypothesis you can about what is driving this activity. Is there a new dapp that launched? Is there some incentive program going on? Or is the spike in users/txns due to some sybil attack? Note any trends or outliers you see.
Optimism DEXs (redux)
Oct 26, 2022 - Let’s take a closer look at DEXs on Optimism. Make a dashboard that compares at least three DEXs based on: Total number of swaps by day over the last month, Total number of wallets swapping by day, What are the most popular asset pairs to swap from and too, Top 10 assets swapping from, Top 10 assets to swap to BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
What makes a Top Shots moment valuable? (Part I)
Jul 25, 2022 - Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume. This week, focus specifically on the play_type column in the flow.core.dim_topshot_metadata table. What play_types do users hold most, and how much volume in sales do these play_types generate? Include any other transactional metrics you can think of.
Ultimate On-Chain Exchange Dashboard
Nov 19, 2022 - We’ve launched our new Algorand database and now it’s time to dive into the new DEFI tables. The challenge here is to build the Ultimate On-chain Exchange Dashboard that will keep Algorand ecosystem users informed about the exchanges in the algorand ecosystem and allow them to compare their options.
The Rainbow Bridge
Jul 13, 2022 - Every city has its monuments, as well as its transit systems. In the City of NEAR, the legendary Rainbow Bridge is an object of great importance to the people: a wondrous object that enables passage to and from other cities. Visualize the Bridge’s activity over the past 90 days, using an activity metric of your choice (in your Methodology section, clearly define your chosen metric). As well, analyze the Bridge usage via at least 3 clearly defined metrics of your choosing (examples: volume, TVL, change in TVL over time, number of repeated trips vs. one-time users, origin and destination).
Welcome to the City
Jul 21, 2022 - Once you’ve bridged to NEAR, what is a user’s first activity? Chart the protocols that users are leveraging after porting tokens through the Rainbow Bridge specifically
Total Value Locked
Jun 30, 2022 - What is the total value locked in the Opyn Squeeth (osQETH) contract? And where does osqeth draw its value from?
Osmosis Governance: 362 and Beyond
Nov 23, 2022 - Let's take a look at the governance behavior surrounding Proposal 362. On the outside, it seems that a ton of voters have been switching their votes - is this actually true, or is it just big whales/validators causing these swings? What is the average wallet size (in OSMO) of the people voting? Of the people who have changed their vote more than once? Compare and contrast voting behavior of validators and average users in this context. Further, is Prop 362 significantly different than other proposals from an engagement perspective? Analyze voting for 362 vs. other recent governance proposals. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Transaction Fees
May 23, 2022 - In this dashboard, in the first part, we dealt with the amount of fees paid in the last 30 days, and then, by examining the transactions, we concluded which type of transaction received greater amount of fees .
Flash Bounty: Reddit NFTs
Oct 29, 2022 - Reddit is officially in the NFT game. Find 3 metrics to compare the Reddit NFT launch to the launches of other major NFTs. Add any other interesting metrics comparing this launch to Polygon NFTs in general BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Flipside's World Cup of Bounties Side Quest: LaLiga Golazos
Dec 6, 2022 - LaLiga Golazos has entered the arena! LaLiga is Dapper Labs latest marketplace for digital moments of players; this past month, Dapper dropped the first LaLiga packs and opened up the secondary marketplace. For this round, create an analysis looking at LaLiga’s first few weeks of action, comparing against the first few weeks of other Flow darlings like NBA TopShot & NFL All Day, as well as Algorand’s FIFA Collect+. How does La Liga compare in terms of overall sales on pack drops? What about on the secondary marketplace? How many users participated in LaLiga in its first few weeks compared to other relevant marketplaces? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Which platform is the king of NFT royalties?
Oct 6, 2022 - Which platform is the king of NFT royalties? Compare royalty payouts of 3 NFT marketplaces. Then choose at least 2 additional metrics to evaluate the impact of royalties on NFT market activity. Bonus: Share your findings on Twitter and tag @flipsidecrypto
SuperFluid Validating
Dec 20, 2022 - There are 16 SuperFluid Staking pools currently available on Osmosis (1, 678, 704, 712, 674, 722, 9, 604, 497, 812, 584, 3, 481, 42, 463, 15). What impact would a slashing event have on the OSMO liquidity of these pools? Analyze the distribution of superfluid-staked OSMO across these pools. Which validators have the most SFS OSMO in total, and per pool? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Velodrome Health (Redux)
Nov 17, 2022 - Create at least 5 metrics on Velodrome with a description for each that showcase traction and success in a data-driven manner. Most importantly, your insights should help our readers answer the question "How healthy is this project?" BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Solana Staking Madness
Nov 14, 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.
Realms vs Snapshot
Aug 31, 2022 - Building off previous recent bounties on Realms and Snapshot, create a dashboard that shows how Realms and Snapshot are growing and used in comparison to one another. Feel free to build off previous bounty work on these platforms. What trends do you see between governance behavior between the two chains? Does a platform seem to capture more market share of its users on their respective chain than the other? What seems to influence voting behavior on each platform? Does one platform have more proposals and voting opportunities than the other? Are whales more powerful on Realms or on Snapshot? How can each platform become more decentralized?
Velodrome Health
Aug 17, 2022 - Create at least 3 metrics on Velodrome with a description for each that showcase traction and success in a data-driven manner. Most importantly, your insights should help our readers answer the question "How healthy is this project?"
Solana Scavenger Hunt 2.0 (Farsi)
Feb 11, 2022 - بنده در 4 مرحله این بانتی را انجام دادم 1- انتقال سول از صرافی به کیف پول فانتوم 2- استک سول از طریق DAOPool در MonkeDao برای دریافت daoSOL 3- واریز daoSOL به استخر daoSOL/SOL و دریافت LP توکن 4- استک lp توکن روی فارم daoSOL و دریافت سود بیشتر
axlUSDC: Soon to be forgotten?
Nov 4, 2022 - Recently, Circle announced the implementation of an IBC-native USDC, inserting itself into an ecosystem where axlUSDC currently dominates. Let's look at how pervasive axlUSDC is within IBC. Track Satellite bridge activity strictly related to axlUSDC transfer. Which app-chains have the most/least flows of axlUSDC? Looking at Osmosis specifically, analyze how dominant axlUSDC has become compared to both ATOM and other USDC assets in trading and pools. Hint: You will need to analyze both Axelar tables and Osmosis tables for the second half of this question. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
The Law Offices of NEAR
Aug 4, 2022 - Provide your best assessment of the number of smart contracts deployed on NEAR and clearly outline your methodology (after all, contract lawyers love clearly specified terms). Visualize the number of new smart contracts deployed over time over a time period of your choosing. What are the top 5 new smart contracts interacted in that period of your choosing?
Daily Transactions and Unique Addresses
Jul 13, 2022 - Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022. In your estimation, discuss whether Polygon is still growing, has reached a plateau, etc.
Folks Finance Scavenger Hunt (Farsi)
May 18, 2022 - در این هانت یاد گرفتیم با Folks Finance کار کنیم. مقداری آلگو از صرافی به کیف پول انتقال دادم و آنرا به Folks Finance دیپوزیت کردم.
Active Wallet Addresses
Jun 22, 2022 - In this dashboard, we are interested in knowing how many users are currently in the ecosystem. In this case, how many are holding $RUNE in their wallet or have an open LP position. What is this number currently, and how has it trended over time?
Distinct Wallets (zkSync)
Jun 17, 2022 - In this dashboard, I counted the number of distinct wallets have deposited ETH into ZkSync in the last 60 days. and show ETH was deposited daily on chart.
What makes a Top Shots moment valuable? (Part II)
Oct 13, 2022 - Building off Part I of this question, released earlier this year, create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume. Note which players, types of plays, or other factors have had changes in value over the past few weeks and months. As you did previously, focus specifically on the play_type column in the flow.core.dim_topshot_metadata table. What play_types do users hold most, and how much volume in sales do these play_types generate? Include any other transactional metrics you can think of.
User Segmentation Analysis
Jan 3, 2023 - Last week we analyzed how users join pools, single or double-sided, which showed that most users join two-sided. This means that most users are already engaged within the Osmosis ecosystem. Let's analyze a typical user journey through Osmosis. Analyze the following: The most common ways of entering Osmosis (Axelar (Satellite) or elsewhere). The most common asset transferred into Osmosis for first transfer. Stay or leave: What do wallets do when they first come to Osmosis? Join to swap and then transfer that asset out? Join to stake OSMO? Join to swap and then LP? Which assets are most commonly swapped for and transferred out? Which assets are most commonly swapped for and then LP'd? Calculate the above from both a volume and # of user standpoint. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!