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.

Flipside🌲🍄 @flipsidecrypto

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🌲

1:49 PM ∙ Oct 14, 2022

---

5Likes2Retweets

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!

🏈 FLOW

NFL All-Day Tournament [FINAL ROUND]

Bounty: Up to 480.770 FLOW

In this round, you once again have full discretion over what you want to analyze. There's just one requirement: you must use some sort of predictive modeling to analyze any particular aspect of NFL All Day.

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!

Claim bounty.

🔴 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?

Claim bounty.

[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.

Claim bounty.

🧪 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?

Claim bounty.

📊 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?

Claim bounty.

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: 

• Treasury balance in USD over time 

• Treasury balance by tokens 

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:

• Highest % change in token amount in a block for a given day 

• Compare other changes in token amount for other pools for a range of blocks 

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

Claim bounty

📊 Optimism: Open Analytics Bounty

Submit 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.

Claim bounty

Sunday

📊 ETH Open Analytics Bounty

Submit 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! 

Claim bounty

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:

Join Discord

Sharing is caring! Make sure you subscribe and share the Bounty Brief with a friend that wants to get involved in the space:

Share