Bounty Brief #75
Tournaments 🏆, 🏗️ buildathons, 📊bounties, and more.
Hey bounty hunters,
Whew, it’s been a busy week. We had the merge and flash bounties surrounding it, NFT bounties, a FLOW Scavenger Hunt, and more. And we’re not stopping yet.
We’ve got our Axelar buildathon ongoing, the FLOW NFL ALL DAY Bounty Tournament kicking into high gear with the first elimination round, NEAR and Polygon bounties today, and more this weekend.
Check it all out bounties below!
🏈 FLOW
NFL All Day Tournament [Round 2]
Bounty: Up to 67.204 FLOW
Is there a type of play that is more valuable, or do valuable players sell at higher prices regardless of play type?
Try to normalize/control for player and play type to determine which is more important. For example, take some metrics of a high-value player's moment sales regardless of play type. Then, similarly, look at play types regardless of players for this analysis.
Lastly, see if there was any meaningful purchasing behavior for certain players who outperformed in Week 1. For example, did Saquon Barkley's sales increase after he ran for 160 yards and scored a touchdown
☀️ NEAR
[Hard] NEAR Meta-Analysis
Bounty: Up to 24.945 NEAR
The SWEAT token has launched, to great fanfare! Give us your best open analysis of SWEAT's launch and the role of SWEAT in the NEAR ecosystem.
What impact has SWEAT had on NEAR? What percentage of activity does it make up? What else should NEARians know about SWEAT?
As usual: cite the source for any outside work or explanations that you use. No need to provide an overview of SWEAT - you can assume a knowledgeable audience - so concentrate on doing interesting analyses, comparisons, deep dives, and assessments.
🟪 Polygon
[Easy] $MATIC Staking
Bounty: Up to 37.5 USDC
How many $MATIC have been staked since July 1, 2022? What is the staking ratio of $MATIC (amount of $MATIC staked vs circulating $MATIC) during the same time frame?
Has it changed or are there any visible trends? What is the daily amount of $MATIC being staked and unstaked?
[Hard] $MATIC Liquid Staking
Bounty: Up to 150 USDC
Define what liquid staking is in your words, and evaluate the different liquidity staking options based on three different metrics of your choice.
Bonus: How do people use these "liquid" derivatives? Do you see any trends?
Reference: https://blog.polygon.technology/defiforall-introduction-to-liquid-staking-on-polygon/“it
💥 Flash Bounties
[Hard] Flash Bounty: GMX Protocol Overview
Bounty: Up to 112.5 USDC
GMX, a perp protocol, has been attracting attention recently for the massive fee revenue being generated. Examine and compare the protocol over recent days and weeks on Arbitrum.
How has the protocol been performing over the past month? Three months? How is it absorbing these massive fees?
Note any overarching themes or narratives that you find.
[Elite] Flash Bounty: GMX Traders
Bounty: Up to 225 USDC
Analyze the traders utilizing this platform on Arbitrum.
Identify the top-performing wallets in trades. Compare how traders are performing across various assets, and how traders are performing in relation to liquidity providers.
Note any trends or outliers you may see.
Coming Soon™️
Want more? Here are some more bounties coming this weekend.
Saturday
🧑🏫 Education Bounties
[Easy] Recreating the ETH Burn Dashboard: Skill-building Bounty 10
This week, we’ll be recreating the EIP 1559 ETH Burn dashboard here https://bi.etherscan.io/public/dashboards/ORfoxXZXVdCGQ4ShYL2Ndk7ji6n0hLy9RwSrvt4w?org_slug=default .
We’ll only recreate 4 metrics in our dashboard: Total burnt fees in USD, total burnt fees in ETH, highest daily burn and a cumulative chart of burnt fees.
Hint: Use the ethereum.core.fact_blocks table and look at the columns ‘gas_used’ and ‘block_header_json’
[Hard] Etherscan 'Internal transactions’: Skill-building Bounty 11
We’ve all seen Etherscan transactions with entries in the ‘internal transactions’ tab, but what do those mean and how do we query those?
https://etherscan.io/tx/0xe91b076db193dac2ed4bbb931151ad26bb7fb54b56641043f9e0aa30b26be5a2/advanced
The sample transaction above is one with internal transactions with the following details:
A transaction to settle an NFT auction in the SuperRare platform
NFT contract address: 0x233FFf5F31Dc468936194fdD44BB237F31095D90, TokenId: 4
Distribute the NFT to the winning bidder
Distribute the funds to the seller
Using a combination of fact_transactions, event_logs and the traces table, create a raw table that shows all ‘settle auction’ transactions with this NFT contract address for all TokenIds. The table would have the following:
tokenId
Winning bidder address
How much ETH was sent to the Superrare Treasury address
How much ETH did the seller receive
Don’t forget to join us for a walkthrough for these bounties in our live SQL sessions on discord on September 20. 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: