Bounty Brief #76
And then there were 16 🏈 🏆...
Hey bounty hunters,
We’re getting down to the wire in our FLOW NFL ALL DAY Bounty Tournament.
We’ll be announcing the qualifiers for the Round of 16 later today, and opening up the next round of the tournament with a special challenge question for this all-star group of analysts. That, plus NEAR and Optimism bounties today, and more coming this weekend.
Check it all out below!
🏈 FLOW
NFL All Day Tournament [Round of 16]
Bounty: Up to 67.204 FLOW
Round 3 of the NFL All-Day Tournament will build off of Round 2’s question. Previously, you analyzed what contributes to a moment’s value by normalizing for play type or player for descriptive analysis. This round, take that a step further and build a more diagnostic analysis: Uncover deeper insights on a moment's sales trends by looking further into the details of the moment's description. For example:
How much more valuable, on average, are touchdown rushes than a rush that did not result in a touchdown? For this, you could compare sales of a rushing touchdown like this one vs. a 50-yard rush that did not result in a touchdown like this one. Since whether the play was a touchdown is not always present in the description, you could take a sample set to test your hypothesis.
What about for quarterbacks, or wide receivers?
Defense vs. Offense analysis, looking at how well sales of OL plays that result in the team scoring vs. defensive linemen highlights like a sack.
If the player's team won the game, does that correlate to higher sales for that individual moment vs. a play where the team lost?
The purpose of this question is to uncover more meaningful insights within the description of the dim_allday_metadata table’s MOMENT_STATS_FULL column. This round notches up the difficulty considerably - given the structure of the data, finding answers to some of the above prompts will be a serious challenge. Thus creativity, meticulousness, and attention-to-detail will be required to make it to the Round of 8.
☀️ NEAR
[Hard] District Deep Dive: Contracts Deployed
Bounty: Up to 24.945 NEAR
Building on work from The Law Offices of NEAR , provide an updated view of contracts deployed over time on NEAR. (Hint: the transactions table will help with this).
What factors do you think might influence the number of contracts deployed?
How might NEAR boost the number of developers and deployments within its ecosystem?You can rely on earlier work - yours and that of others - but clearly reference anyone whose work you use.
Similarly, you are free to use GokuStats for inspiration (see the attached image), but the core part of this task is providing your own original insights.
Grand Prizes will focus on well-reasoned, creative assessments on what drives developer activity on NEAR.
🔴 Optimism
[Medium] $OP Airdrop
Bounty: Up to 75 USDC
Earlier this summer, Optimism offered an airdrop to users. Let’s examine the airdrop after a few months.
How many users claimed optimism airdrop? How much of total airdrop was claimed? How many wallets are still holding tokens from airdrop? How much of users delegated their OPs?
Feel free to provide any information that you think is related to token price.
[Hard] Quix vs Magic Eden vs OpenSea
Bounty: Up to 112.5 USDC
Create a dashboard highlighting at least 3 metrics comparing marketplace performance and adoption between Quix (formerly Quixotic) on Optimism, Magic Eden on Solana, and OpenSea on Ethereum, since July of this year.
What has been the rate of change of these metrics since the start of the new year and are there any signs of growth of a certain marketplace or ecosystem of NFTs? Highlight the 5 most popular NFT collections for each marketplace over that timeframe in terms of sales volume. Is the turnover rate (number of transactions) for collections on Magic Eden noticeably higher than on OpenSea and Random Earth? Provide some insights on these findings.
Coming Soon™️
Want more? Here are some more bounties coming this weekend.
Saturday
🧑🏫 Education Bounties
[Easy] Solana swaps: Skill-building Bounty 12
This week we’ll take a second look at our Solana Educational bounties: swaps on Orca https://flipsidecrypto.xyz/drops/solana-educational-bounties-swap-volume-on-orca-7189af .
In the live call, we’ll go over the swaps and labels table (solana.core.fact_swaps and solana.core.dim_labels) to recreate a dashboard showcasing the following:
Swap volumes of SOL in September 2022 both swap into and out of SOL
Swap volumes and transaction count of SOL swaps for each dex
What assets was SOL swapped for the most?
What assets were swapped to SOL the most?
Equip your charts with proper labels
[Hard] Finding holders for a specific token: Skill-building Bounty 13
A month ago we looked at how to query the top 10 holders for a specific token using the ethereum.core.ez_current_balances table.
This time, the task is to create a query to show the daily count of existing token holders for a specific token. The query should also be able to show the list of token holders at any specific day.
Hint: Use the ethereum.core.ez_balance_deltas table. You are encouraged to also use Etherscan to cross check your answer. For example, the token holders for sushi tokens can be found here: https://etherscan.io/token/0x6B3595068778DD592e39A122f4f5a5cF09C90fE2#balances
Don’t forget to join us for a walkthrough for this bounty in our live SQL sessions on discord on September 27. You can also catch the previous live SQL session recordings on our Youtube channel
📊 ETH vs Solana: 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.
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!
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: