CryptoIcicle
Osmo-13.Osmosis Governance
Jun 18, 2022 - -- Q13. Create a dashboard that maps community participation in governance. On average, how long does it take for a new wallet to become active in Osmosis governance? Do wallets that are active in governance vote on every proposal? -- Or do they only vote on select proposals?
Optimism-7.Quixotic NFT Dashboard
Aug 4, 2022 - Q7. Create a secondary market dashboard for NFT sales on Quixotic, the largest NFT marketplace on Optimism!
Poly-3.Polygon NFT
Jul 15, 2022 - -- Q3. How popular are NFTs on Polygon? Track daily volume over the past month/year/etc. -- How many Polygon users started off with NFTs? Who made the most profit?
NFL All Day Tournament [Round 1]
Sep 14, 2022 - -- For the first round of this tournament, create an analysis that shows top-line NFL All Day metrics and stats. -- Chart total sales and sales volume growth, user analysis, player. Track metrics by player and position, -- and see if there are any notable spikes in sales so far this preseason. -- Only the top 32 most stellar dashboards submitted will receive payment + make it to the next round, so get creative with your analysis to stand out!
Osmo-9.wETH & wBTC On- and Off- Ramps
Jun 5, 2022 - Q9. On the Osmosis Frontier, there are pools for wETH and wBTC. How do users respond and change their position in these pools in response to governance proposals involving extra incentives for these pools? Do their deposits and withdrawals of wBTC and wETH onto Osmosis change as well?
Flash Bounty: Reddit NFTs
Oct 30, 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!
Flow NFT Comparison
Sep 16, 2022 - -- Compare and contrast the NFT market and ecosystem across at least three different chains -- (you can do more if you wish, but there must be at least three included.) -- Explain how the various chains differ in terms of metrics such as: -- Total Sales -- Total Unique Buyers -- Total Volume -- Average Sales/Day -- Average Buyers/Day -- Average Sales Price/Day
Osmo-The Unstakeeeeers
Jul 17, 2022 - -- How frequently do users on Osmosis unstake their Osmosis? -- What do they do with the OSMO once unstaked? -- Do they re-delegate, enter a LP position, or swap into another token? -- Do they re-delegate to certain validators more frequently than others? -- Why might this be so?
Avalanche Swaps vs Transfers (Redux)
Dec 5, 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 -- Note anything else interesting about USDC transactions
Optimism NFT Purchasing Behavior
Oct 20, 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?
Open Analyitics Bounty: Optimism
Jul 24, 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. (Please note that many dashboards submitted to this bounty will not be rewarded with payment — only the best of the best will do here.) As you dive in and work through your analyses, we would love to see what insights you find and dashboards you develop. Feel free to submit your work via this bounty card for internal review. Elite tier work will be shared out on our social channels and to partners highlighting the analyst. Be sure to use the Optimism tables, which can be found under the "Optimism
Optimism Free Square Question
Jun 25, 2022 - -- Show us what you can do with this new Optimism data!
What's going on with Optimism?
Jul 22, 2022 - What's going on with Optimism? This is an open-ended bounty, what we call a Free Square, and it’s an opportunity for you to show us what you’ve got. Any topic is fair game; The goal here is to explore the data in creative ways and show off your explorations with visualizations (or even a tool/frontend if you’ve got eyes on the grand prize).
User Behavior (redux)
Oct 24, 2022 - -- How is user behavior different on Optimism compared to L1? -- Specifically, create a comparison between swaps and transactions on ETH mainnet vs Optimism, looking for things like daily swap volume, -- daily active users, and average volume swapped (use a single DEX for your comparison, either Uniswap or Sushiswap). -- L2 is far cheaper, but by how much? What are the average fees for a swap on Optimism compared to ETH Mainnet? -- BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Solana-103.Going Down The Wormhole
Aug 9, 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. -- How are tokens being bridged from chain to chain and which actions seem to be popular among users of Wormhole? -- What actions seem to influence bridging behavior? -- What are users doing before and after bridging? -- Do users seem to think that bridging is safe or more risky relative to transfers to centralized exchanges?
Seasons in the City - The Financial District
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.)?
LUNA Price vs 30 Day Moving Average
Dec 8, 2021 - Calculate a rolling 30-day time-weighted average price (TWAP) for LUNA.
Open Analytics Bounty: Velodrome (August 15)
Aug 16, 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.
Osmo-7.In The Stars
May 29, 2022 - -- Q7. Stargaze Zone is an IBC NFT launchpad and marketplace, and new launchpad projects drop on mint every Friday at 4:00 PM EST. -- Does the volume of swaps involving Stars change around this time? -- Analyze the volume of swaps involving STARS from March 20th until present. -- Hint: Use the msg_attributes table and select transactions that have an appropriate msg_type for swaps. -- The token address for STARS and other tokens can be found by joining to the labels table.
FLOW NFT Ecosystem
Sep 25, 2022 - Happy Flow NFT Day! As part of today’s celebration of FLOW NFTs, we want you to dive deep into the ecosystem. Treat this as an open analytics bounty specifically focusing on the FLOW ecosystem. Open Analytics (OA) bounties are bounties without specific prompts, just a direction, and a reward. It’s your chance to have your brain follow your heart — got a spark of interest, or a loose thread, or a weirdly-specific question gnawing at the back of your mind? Follow it as far as you can!
Velodrome Locks
Jul 13, 2022 - -- 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/ -- Hint: -- -A sample query to look at new locks can be found here. -- -Sample voting tx: 0x516c3537d534415e5d00845b6b718d93d5f2066e1f9aa795931177b21b5bf5b0
Flow-10.NFT Buying Behavior on Flow
Jun 12, 2022 - -- Q10. Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to on Ethereum and Solana. -- Is there more or less "whale" activity on Flow compared to each of the other chains? -- What do "whales" tend to focus on in Flow? -- How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains, or do wallets tend to hold onto their NFTs? -- Are wallets more interested in new projects, or already existing projects on Flow?