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!
Decentralizing Power: Governance & the Active Set (Part 2)
Nov 10, 2022 - Props 114, 196 & 337 were all passed in an effort to promote decentralization within the ecosystem. After these proposals, how was governance impacted by this effort? Analyze the participation of the new validators on the governance proposals after the active set increases. Did new validators vote more or less than the original top 66% of validators? Did time play a factor? Analyze changes in governance participation t+30,+60,+90 days after these proposals. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
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?
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.
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!
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.
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
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?
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?
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!
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
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?
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?
$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.
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
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!
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!
Bridger Destinations (redux)
Nov 2, 2022 - Where do people go when they bridge to Optimism from Ethereum? What are the 10 most popular first destinations for users that have just bridged from Ethereum? What has this been for each day in the past month? How has this changed over the last three months? Last six months? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
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.
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.
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!
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!
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!
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?
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
User Activity
Jun 15, 2022 - In this dashboard, first analyze user activity providing and removing liquidity from NFTX vaults. Then I found the top 3 vaults in the last 60 days. And finally I concluded the results
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!
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.
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!
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.
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!
What's All The Hubbub for Hubble Protocol?
Oct 11, 2022 - Hubble Protocol is a financial platform building sustainable Decentralized Finance services on Solana. Hubble's core service centers around a low-interest, stablecoin borrowing mechanism. Hubble's US Dollar-pegged stablecoin, USDH, can be borrowed against a variety of assets, including ETH, BTC, and SOL. Create a KPI dashboard that shows Hubble metrics such as: daily active users, new users, mint/burn rates, different rates of instructions etc. (anything you find relevant). Show the flows of USDH, where it is being used in the Solana ecosystem, is it gaining adoption, and if so how? Hubble also recently launched Kamino Finance: https://blog.hubbleprotocol.io/multicoin-raise-kamino-launch/ Provide metrics on its growth rate and adoption so far. How is it being used?
USDC Declining on Solana?
Oct 7, 2022 - It looks like over the last few weeks the market cap of USDC on Solana has been declining. Source: https://defillama.com/stablecoins/Solana - What appears to be the cause of this? Where is USDC being removed from the ecosystem and where is it being sent to? - Does this trend seem to be driven by a few big whales, or does it seem more broad-based throughout the ecosystem? - Are other stablecoins also dropping in market cap on Solana?
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!
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.