Flipside Crypto - Bounty Brief #75
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! 🏈 FLOWNFL All Day Tournament [Round 2] Bounty: Up to 67.204 FLOW 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:
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:
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 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 #74
Friday, September 9, 2022
Are you ready for some football (bounties)🏈 🪙 📊?
Bounty Brief #73
Friday, September 2, 2022
Find five new bounties and learn more about the future of Flipside
Bounty Brief #72
Friday, August 26, 2022
New bounties + $35000 prize
Bounty Brief #71
Monday, August 22, 2022
New bounties + Flipside's biggest reward ever.
Bounty Brief #70
Friday, August 12, 2022
New bounties, hot + fresh from the oven 🌶️ ♨️📊
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. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏