Flipside Crypto - Bounty Brief #79
Hey bounty hunters, We’ve got some exciting data announcements to share! We’re proud to announce that we have officially backfilled our Optimism and Solana data, giving you even more data to solve bounties, answer your own analytical questions, and DYOR. ![]() What does it mean that @solana data is backfilled?
Everything that's happened on Solana from block 1 (and everything that ever will) is yours to query!
@DeGodsNFT sales, @MagicEden activity, you name it.
If you're a $SOL maxi looking for answers, try flipside.new🌲 We’ve also got some Optimism bounties going live today to celebrate. Still want more? No worries, we’ve got plenty more bounties to keep you busy all weekend. Check it all out below! 🏈 FLOWNFL All-Day Tournament [FINAL ROUND] Bounty: Up to 480.770 FLOW I.e. Could you build a model that predicts floor price after a certain designated period for a particular player? Once again, anything is fair game; we’d like to see what you come up with given the requirement of using ML. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts! 🔴 Optimism[Medium] Optimism NFT Purchasing Behavior Bounty: Up to 75 USDC 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? [Elite] OPtimistic or Pessimistic? Bounty: Up to 187.5 USDC 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. 🧪 Osmosis[Hard] Daily Active User Bounty: Up to 103.592 OSMO 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? 📊 NEAR[Hard] Seasons in the City Bounty: Up to 35.489 NEAR 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.)? Grand Prize questions (11 or 12) will go deeper into the why - what is driving any of these changes? Coming Soon™️Want more? Here are some more bounties coming this weekend. Saturday🧑🏫 Skill-building Bounties[Easy] Displaying Treasury Balance: Skill-building Bounty 18 This week, we’ll use the Ethereum balance table to display treasury balances. In our example, we’ll use the nouns dao treasury but you can use any treasury address of your choice. Nouns Dao treasury address: 0x0BC3807Ec262cB779b38D65b38158acC3bfedE10 Plot the following:
Don’t forget to join us for a walkthrough for this bounty in our live SQL sessions on discord on October 18. You can also catch the previous live SQL session recordings on our Youtube channel [Hard] Address balance on a block level: Skill-building Bounty 19 With the same table used in the easy bounty, we can also use it to show the changes of assets in a liquidity pool on a block level. For example: 0x88e6A0c2dDD26FEEb64F039a2c41296FcB3f5640 - this is a Uniswap V3 USDC-WETH pool address. We can look at the changes in the token amount by block. With this information, we can look at:
Don’t forget to join us for a walkthrough for this bounty in our live SQL sessions on discord on October 18. You can also catch the previous live SQL session recordings on our Youtube channel 📊 Optimism: Open Analytics BountySubmit a deep dive dashboard that explores a specific topic in detail. 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! For this bounty, submissions should compare ETH + Solana in some way. Sunday📊 ETH Open Analytics BountySubmit a deep dive dashboard that explores a specific topic in detail. 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! Good luck with your bounties this week🤞🍀 Make sure you join our community on Discord to keep up with all things bounties and get answers to any questions you have about solving our queries: Sharing is caring! Make sure you subscribe and share the Bounty Brief with a friend that wants to get involved in the space: If you liked this post from The Bounty Brief , why not share it? |
Older messages
Bounty Brief #78
Friday, October 7, 2022
Sports (Bounties)! 🏈⚽🏀
Bounty Brief #77
Friday, September 30, 2022
Get lucky with eight new bounty questions dropping this weekend!
Bounty Brief #76
Friday, September 23, 2022
And then there were 16 🏈 🏆...
Bounty Brief #75
Friday, September 16, 2022
Tournaments 🏆, 🏗️ buildathons, 📊bounties, and more.
Bounty Brief #74
Friday, September 9, 2022
Are you ready for some football (bounties)🏈 🪙 📊?
You Might Also Like
Texas doubles down on crypto with new $250 million Bitcoin reserve bill
Tuesday, March 11, 2025
Texas' second crypto bill seeks to enhance state and local government participation in digital asset investments. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
How-ey Can Get Out of Here
Tuesday, March 11, 2025
How On-Chain Data Can Clarify the Regulation of Cryptoassets ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
February CEX Data Report: Significant Decline in Trading Volume Across Major CEXs - Spot Down 21%, Derivatives Dow…
Tuesday, March 11, 2025
In February 2025, the spot trading volume of major CEXs decreased by 21% compared to January. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
El Salvador defies IMF, continues Bitcoin purchases amid market downtrend
Monday, March 10, 2025
El Salvador's Bitcoin holdings grow to $504 million, challenging IMF directives amid sharp price declines. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
🖊️ Trump signed an Executive Order for a US Strategic Bitcoin Reserve; Cronos proposed to reissue 70 billion CRO …
Monday, March 10, 2025
Trump signed an Executive Order for a US Strategic Bitcoin Reserve; Cronos proposed to reissue 70 billion CRO for a Cronos Strategic Reserve; Texas's Senate passed bitcoin reserve bill SB-21 ͏ ͏ ͏
Vitalik TAKO AMA: ETH Positioning, Sequencer Centralization, L1 vs L2, Governance, and Success Metrics
Monday, March 10, 2025
On the evening of February 19th at 12 PM UTC and lasting until 12 PM UTC on February 20th, Vitalik Buterin, the founder of Ethereum, was invited to participate in a flash text interview on Tako (a
Donald Trump Creates U.S. Bitcoin Reserve
Monday, March 10, 2025
March 10th, 2025 Sign Up Your Weekly Update On All Things Crypto TL;DR Donald Trump Creates US Bitcoin Reserve Diddy Shows 'Kindness' To Sam Bankman-Fried Robinhood Conducts $1M Crypto Trivia
Bitcoin’s realized volatility surges in as traders face extreme price swings
Sunday, March 9, 2025
Volatility clustering in Bitcoin reveals the impact of turbulent rallies and sharp pullbacks. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Asia's weekly TOP10 crypto news (Mar 3 to Mar 9)
Sunday, March 9, 2025
Ms. Sun Xueling, Minister of State, Ministry of Home Affairs of Singapore, said that cryptocurrency fraud cases accounted for a quarter of the total loss amount involved in fraud last year. ͏ ͏ ͏ ͏ ͏ ͏
Trump declares end to ‘war on crypto,’ vows to propel America to Bitcoin supremacy
Saturday, March 8, 2025
Trump brands the Biden era as a crypto setback, .President Trump vows to make America the Bitcoin leader, ending Operation Chokepoint 2.0 and bolstering crypto strategies. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏