Bounty Brief #82
New bounties, hot + fresh out of the oven ♨️ ♨️ ♨️
Hey bounty hunters,
We’ve got some fresh bounties ready for you — plus our NFL ALL DAY Scavenger Hunt for returning users!
Check it all out below, and don’t forget to subscribe to get all our bounties in your inbox each week!
Still want more? No worries — our friends at MetricsDAO have you covered. Check out their Twitter feed or visit their Discord to see all the great analytic challenges and activities they’ve got coming up.
🟢 Flow
NFL ALL DAY Scavenger Hunt (November 4) (RETURNING USERS)
Bounty: Up to 9.146 FLOW
Welcome to the Flow Ecosystem! We hope this Flow Scavenger Hunt will help you find an easy and enjoyable entry point into Flow.
🧪 Osmosis
[Hard] Decentralizing Power: Governance & the Active Set (Part 2)
Bounty: Up to 157.563 OSMO
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.
🔴 Optimism
[Medium] Average Optimism Portfolio
Bounty: Up to 75 USDC
What does the average Optimism user's portfolio look like and how has that changed over time?
What % of a user's activity (in OP terms) is staked, unstaked, in liquidity pools/farms, in NFTs? How has this trend changed over time?
[Elite] Optimistic Bears (Redux)
Bounty: Up to 187.5 USDC
Analyze Optimism during the recent bear as markets were turbulent, showing whatever metrics you care to unearth.
You can choose any topic you’d like: How did the network perform? What about market performance? Were there significant inflows or outflows on bridges? Were there any notable patterns in user behavior?
📊 NEAR
[Hard] NEAR City Layout
Bounty: Up to 36.645 NEAR
How centralized or decentralized is NEAR, really?
Choose at least two distinct measures of decentralization that can be explored with on-chain data; clearly define those metrics; and outline how NEAR performs based on those metrics.
In your view, is NEAR becoming more centralized or decentralized over time?
You are welcome to draw on any past submissions in your work, but ensure you credit and link to the original creator (bonus points if you shout them out on Twitter).
Grand Prize submissions will also explore these metrics for at least one other blockchain.
Coming Soon™️
Want more? Here are some more bounties coming this weekend.
Saturday
🧑🏫 Skill-building Bounties
[Easy] Ethereum Base Tables Explained: Skill-building Bounty 24
What exactly are the Ethereum base tables? Well these are the blocks, transactions, traces and event logs tables. It is through these 4 tables that the ‘ez’ tables like ez_nft_sales are created.
In this week’s live call, we’ll dive deep into explaining each base table and how you can utilize these tables to your advantage.
For this easy bounty though, we’d like you to explore these 3 transactions below and explain what information you are able to extract from each table. In other words, which tables are used to get what information?
The 3 transactions are as follows:
https://etherscan.io/tx/0x56cf02194da2afc277ab20852a4287890f7ea8d8c42691fe0b2e0f5a5aa273c3 (A deposit into Ribbon’s R-Earn Vault)
https://etherscan.io/tx/0x5647099add0ce24708cc25757d265d17b822e35191942e1711efe68e9c4ede00 (A swap on Sushiswap using the 0x Exchange contract
https://etherscan.io/tx/0x9da99cd244b8d55648843567c2298dfeab65b42f9b8ee412e4c8babac76cf753 (NFT Sales on Blur marketplace)
Don’t forget to join us for a walkthrough for this bounty in our live SQL sessions on discord on November 8. You can also catch the previous live SQL session recordings on our Youtube channel
[Hard] Combining Ethereum Base Tables: Skill-building Bounty 25
What exactly are the Ethereum base tables? Well these are the blocks, transactions, traces and event logs tables. It is through these 4 tables that the ‘ez’ tables like ez_nft_sales are created.
In this week’s live call, we’ll dive deep into explaining each base table and how you can utilize these tables to your advantage.
For this hard bounty, we’d like you to explore these 3 transactions below. Utilizing the base tables (except the blocks table) , create tables that showcase all the necessary information from the transaction. For instance, for the NFT transaction, create a table that showcases the buyer, seller, sale price, royalty fees if any all in one table.
The 3 transactions are as follows:
https://etherscan.io/tx/0x56cf02194da2afc277ab20852a4287890f7ea8d8c42691fe0b2e0f5a5aa273c3 (A deposit into Ribbon’s R-Earn Vault)
https://etherscan.io/tx/0x5647099add0ce24708cc25757d265d17b822e35191942e1711efe68e9c4ede00 (A swap on Sushiswap using the 0x Exchange contract
https://etherscan.io/tx/0x9da99cd244b8d55648843567c2298dfeab65b42f9b8ee412e4c8babac76cf753 (NFT Sales on Blur marketplace)
Don’t forget to join us for a walkthrough for this bounty in our live SQL sessions on discord on November 8. You can also catch the previous live SQL session recordings on our Youtube channel
📊 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.
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: