Binance Bonanza
Nov 2, 2022 - On October 28th, 2022 Binance became the first CEX to list spot trading for $OSMO. Abruptly, OSMO price shot up around 32%. How did this news impact trading on Osmosis. Analyze OSMO trading activity on October 28th and this past week vs. daily & weekly averages. This analysis should occur against two time periods: the 60-day averages & the 60-days prior to the May Terra collapse. Did any other tokens see a spike in trading on Osmosis? Further, can you trace OSMO liquidity flowing into Binance in the last few days? Centralized exchange listings of OSMO are permissionless so liquidity on Binance should be funded through purchases on Osmosis. Note: given this question is being released BEFORE the week of analysis in question please structure your queries accordingly to capture the data that will be populated in the future. Please create dynamically updated queries. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Average Solana Portfolio
Jun 30, 2022 - What does the average Solana user's portfolio look like and how has that changed over time? What % of a user's activity (in SOL terms) is staked, unstaked, in liquidity pools/farms, in NFTs? How has this trend changed since the start of 2022?
![Realms vs Snapshot Realms vs Snapshot](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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?
Merry $BONK-ing Christmas
Jan 4, 2023 - It's still Christmas for Solana's dog coin $BONK — people all over crypto twitter are giving away billions of $BONK tokens, and its price has risen over 40% in the last day (NFA). Bring the world up to speed on Bonk Inu, with all of our favorite metrics: Total # of holders. % of holders that are active wallets. Average amount $bonk in holder wallets. Average time holding bonk. Any other notable trends or outliers you see. Then, give us context! What kinds of Solana users are $bonk holders? How active are they, what other tokens do they tend to hold, etc. Has Solana activity as a whole risen in conjunction with recent $bonk activity, and how much Solana activity does Bonk Inu account for?And as always, don't forget to tweet about your dashboard and $bonk, to share your insights with others!
City Amidst the Storm
Nov 16, 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. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
$RUNE Movement from Crypto.com
Jun 20, 2022 - I showed the in + outflow from cryto.com to native wallets over time in this dashboard. I also prepared and displayed a series of additional data for further study.
![Active Wallet Addresses Active Wallet Addresses](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Active Wallet Addresses
Jun 28, 2022 - 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?
Gains Network vs GMX
Nov 5, 2022 - A war of the trading platforms? GMX (native to Arbitrum) - GNS (native to polygon, but announced will be launching on Arbitrum soon). Both platform native tokens (GMX - GNS) have seen meteoric price growth during a bear market. Since June GNS has gone from $0.68 to $3.68 and GMX has gone from $13.70 to $41.56. Observe Trading volume. Has one platform absorbed more volume than the other? How impactful is GNS volume to polygon? GMX volume to Arbitrum? Are there any insights that can reveal why Gains Network wants to move into the Arbitrum ecosystem? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
![Stablecoin Dominance Stablecoin Dominance](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Stablecoin Dominance
Jun 28, 2022 - Compare the transaction volume for USDC, USDT, and DAI on Osmosis. Is there a stable coin that Osmosis users prefer? Extra credit: Is stablecoin dominance the same on Osmosis as it is on Sushiswap and Thorchain? Why might this be or not be the case?
Tornado Cash Addresses
Aug 10, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online. (Hint: we also have them in our crosschain address labels table as well). Using those addresses: - Which of the Tornado Cash addresses received the most # of transactions in the last month, quarter, year - Which addresses received the most transaction volume (worth) in the last month, quarter, year - Over all the addresses, group the transactions into buckets by value.
![Quixotic NFT Dashboard Quixotic NFT Dashboard](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Quixotic NFT Dashboard
Aug 4, 2022 - Create a secondary market dashboard for NFT sales on Quixotic, the largest NFT marketplace on Optimism! Include any data you think is relevant in our Optimism tables and tell us the most interesting trends you can find with the secondary NFT market.
Swap Pairs on Optimism
Jul 20, 2022 - Create a document that includes all addresses for all swap pairs for Sushiswap on Optimism plus the addresses of the two tokens belonging to each pair. Getting the decimals for each of the tokens in the pair would be a bonus. If you are using sources from sushi github, please include the link.
Axelar Token Launch
Sep 28, 2022 - Axelar recently launched its native token, AXL, and we're celebrating with some bounties! For this bounty, analyze the activity within the AXL/OSMO pool (#812), as well as trading activity on the Osmosis DEX. Note any trends or outliers you see. BONUS: The best dashboards will update over time
![Solend Demographics Solend Demographics](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Solend Demographics
Aug 4, 2022 - Solend is the leading lending protocol on Solana. What are the demographics of the Solend userbase? What is the user distribution by size of account? (How many have between $1-1,000, 1,000 - 100k, etc). Is the protocol largely influenced by whales, or by average Solana users?
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
Stablecoin Pegs
May 13, 2022 - I compared 7 USD-pegged stablecoins from different blockchains over a 5-day period in terms of price (peg stability), volume and number of transactions.
FLOW Speed (redux)
Dec 12, 2022 - Flow is fast, but how fast? 6 months ago, we asked for a comparative analysis on blockchain speed - how has Flow increased its speed in transaction per minute since? Compare Flow and other L1 blockchains in terms of speed: identify the monthly average for transactions per minute, and how that's improved or worsened since the beginning of 2022. What types of events have raised or decreased the blockchain's performance over that time period? Are there bursts of transaction volume or interest on the chain? Compare Flow's speed to at least two other blockchains. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
![Polygon Block Performance Polygon Block Performance](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Polygon Block Performance
Jul 27, 2022 - What is the average time between blocks on Polygon? What was the maximum and minimum recorded time between two blocks? How many transactions are done in a block on average? How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
The Great Solana Royalty Debate
Nov 7, 2022 - The most controversial topic on Solana over the past month has been NFT royalties. After platforms like Yawww and Solanart moved to 0% creator royalties, and eventually Magic Eden followed, the market has been in a chaotic state. Magic Eden had cited that almost all funds for a project are coming from the mint, not royalties: https://twitter.com/MagicEden/status/1580367439824826368 Is this accurate, or a misrepresentation of how successful NFT projects have been operating? What projects have been more reliant on NFT royalties than others? What collections were wallets pivoting towards using 0% royalties more frequently? Higher royalty percentages? Higher floor volumes? Are flowing royalties a sign of project health and sustainability? How much volume from 0% royalty sales can be accounted for by wash trading rather than actual user interest? Was this actual user demand, or were decisions made based on inflated data? Compare the rise of 0% royalty market behavior on Solana to on Ethereum. Are users less likely to pay royalties on Solana?
![LUNA Distribution, Mvmt II LUNA Distribution, Mvmt II](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
LUNA Distribution, Mvmt II
Feb 10, 2022 - I have listed 100 wallets (wallet balances sorted) that have been deposited or withdrawn in the last 90 days. Of course, I only filtered transactions that were greater than 0.
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!
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.
NFL ALL (THANKSGIVING) DAY
Dec 6, 2022 - The NFL's annual Thanksgiving games recently drove record viewership in the U.S., with 42 million people tuning in to see the Giants take on the Cowboys. Did FLOW NFT project NFL ALL DAY see similar boosts in popularity? Create a dashboard that analyzes NFL ALL DAY NFT activity over the past week, and compares it to activity over the past year. Include at least these metrics, along with any others you find notable or interesting: Sales volume (daily), Total Sales Volume, Daily Average Sales Price and 7-day moving average, Total Unique Buyers, Average Buyers/Day BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Optimism NFT Purchasing Behavior
Oct 18, 2022 - Show the distribution of all NFT sales on Optimism by price. What percentage of all sales have been above .01 ETH? Above .1 ETH? 1 ETH? Do you think that there is a limit to how high a floor for a NFT collection on Optimism can reach compared to on Ethereum? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Wallet Balances & Ecosystem Growth
Oct 26, 2022 - With the launch of Flipside's new Balances table, let's take a look at how the story of Osmosis can be told through wallet balances. Provide insights into following metrics: How has the ratio of liquid to staked OSMO changed overtime? Are the top 100 OSMO holders the same now as they were at the start of the year? What is the current average OSMO per wallet? How has that value changed over time? Plot average OSMO/wallet against user growth. Do wallets normally hold a majority of OSMO, or another token? How has this changed over time? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Axelar Fee Generation
Dec 8, 2022 - Axelar currently generates fees in $axlUSDC for all transfers via Satellite. Map out these fee streams. How much total $axlUSDC has been generated via Satellite. What origin chains have generated the most fees? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
![Seedclub Members Seedclub Members](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Seedclub Members
Mar 13, 2022 - Here we intend to address 2 questions; first, How many members have joined the Seedclub? And How many projects have successfully launched and received their CLUB tokens? The first thing I did was research the main site seedclub.xyz and get information from it.
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!
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!
![Distributed Validator Technology Distributed Validator Technology](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Distributed Validator Technology
Apr 13, 2022 - In this article, the Obol network and how it works, as well as its impact on Ethereum 2.0, are fully investigated.
BAYC and Ape Staking
Dec 7, 2022 - In light of the Bored Ape Yacht Club's introduction of Staking, provide an analysis on the token and project. Provide data on APE token distribution in March 2022 and show how the activity has evolved since. Share analysis on future emissions schedule. How have the first hours of APE staking been? How do the staking rewards for each pool compare? Provide any relevant data. BONUS: Show the BAYC community what you’ve uncovered. Share your dashboard and tag @BoredApeYC and @flipside on Twitter.
![Lofty AI Platform Dashboard Lofty AI Platform Dashboard](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Lofty AI Platform Dashboard
Jul 14, 2022 - 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. The goal of this bounty is to create a visually appealing dashboard using the new multicolumn layout or the visualization tool of your choice to illustrate all the properties(assets), the tokenized revenue Lofty has generated through sales, and the total asset value that Lofty AI manages. If you have the ability, set the refresh rate to daily.
Ailing Alameda
Nov 9, 2022 - Analyze what Alameda is experiencing. Rumors over the weekend began swirling that alameda research is on the brink of insolvency. Observe net in and outflows of USD tokens from known Alameda or FTX accounts throughout different chains. Are they going somewhere specifically? Are there any signs of potential insolvency? Note any other interesting trends or events you see. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and anywallets
![Tracking Realms DAOs Tracking Realms DAOs](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Tracking Realms DAOs
Aug 16, 2022 - We now have Solana Realms governace data! Their team would love to be able to see a list of DAOs / multisigs built on SPL Governance, and understand their: - Number of Members (assuming unique voters is what he means here) - Total Votes - Number of Proposals - Date of Last Proposal - Date of Creation Track these metrics and any other metrics that you find interesting for the following DAOs: Mango-Grape-Psy Finance-Solend-MonkeDAO-Metaplex-Jet-Serum-The Imperium of Rain-Synthetify
![Daily Transactions and Unique Addresses Daily Transactions and Unique Addresses](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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.
Pool Props: Decentralized Sports Exchange
Nov 30, 2022 - Pool Props just surpassed $1M USD in volume on their decentralized sports exchange where players can purchase and trade assets based on game and player odds and receive payouts based on the results. Let’s create a parameterized dashboard(based on wallet address) to help players understand their activity on pool props: How many pools they’ve traded in. how many positions they’ve taken. How much they’ve won or lost, in USD and native currency. At the top of your dash create a top 10 all-time leaderboard show both the biggest winners and losers, how many they’ve taken and how much they’ve won or lost. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
![ETH Deposited or Withdrawn ETH Deposited or Withdrawn](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
ETH Deposited or Withdrawn
Jun 30, 2022 - StarkNet is a layer 2 chain, that ensures interoperability with the Ethereum mainnet. People are using it to move real ETH to StarkNet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to StarkNet or vice versa? and by how many depositors?