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
Let's Make Money from Farming
Thursday, January 9, 2025
CRYPTODAY 140 ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Ripple CEO Brad Garlinghouse hails Donald Trump meeting as US crypto engagement grows
Wednesday, January 8, 2025
Trump's pro-crypto stance sees Ripple and other crypto leaders engaging in transformative talks at Mar-a-Lago. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
DeFi & L1L2 Weekly — 📈 Weekly active addresses on L2s were 5x higher than on Ethereum; Ethena plans to launch iUS…
Wednesday, January 8, 2025
Weekly active addresses on L2s were 5x higher than on Ethereum. Ethena plans to launch iUSDe for financial institutions in February. Solayer launched the Solayer Foundation and LAYER governance token ͏
DeFi & L1L2 Weekly — 📈 Weekly active addresses on L2s were 5x higher than on Ethereum; Ethena plans to launch iUS…
Wednesday, January 8, 2025
Weekly active addresses on L2s were 5x higher than on Ethereum. Ethena plans to launch iUSDe for financial institutions in February. Solayer launched the Solayer Foundation and LAYER governance token ͏
What opportunities are there in combining DePin with AI? What difficulties are there?
Wednesday, January 8, 2025
This podcast episode features a discussion between Wu Blockchain founder Colin Wu and EO Hao, CEO and founder of Future Money Group. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Bitcoin sell-side liquidity hits lowest level since 2018 fueling BTC rally
Tuesday, January 7, 2025
Whales quietly accumulate as sell-side liquidity hits five-year low, driving new BTC highs. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Bitcoin’s 16th Birthday
Tuesday, January 7, 2025
Celebrating 16 years since the inception of a novel asset class ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
How does Bybit's CEO Ben view memecoins, listing strategies, and the insistence on applying for a Hong Kong licens…
Tuesday, January 7, 2025
Recently, Bybit held an online media conference where CEO Ben Zhou and Shunyet Jan, Head of Institutional and Derivatives Business, shared updates on Bybit's current development and outlook. ͏ ͏ ͏
MicroStrategy buys 1,070 BTC as Saylor declares interest in Bitcoin advisory for Trump
Monday, January 6, 2025
MicroStrategy's Bitcoin investment soars, yet company flags risks of debt reliance and unstable crypto markets. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
📈 US spot BTC and ETH ETFs saw a $35 billion and $2.7 billion net inflow in 2024, respectively; Crypto.com signed…
Monday, January 6, 2025
US spot BTC and ETH ETFs saw a $35 billion and $2.7 billion net inflow in 2024, respectively; Crypto.com signed an MoU with Dubai Islamic Bank; Crypto.com launched Crypto.com Custody Trust Company ͏ ͏