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? |
Key phrases
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
Holy Grail! We’re live with a $100k prize pool 🏆
Tuesday, May 7, 2024
Swap, borrow, and stake to earn yield and get a chance to win a slice of the massive prize pool. Flipside Crypto Holy Grail! 🏆 Aptos Grail Tournament with $100k in prizes starts today! Keep doing what
US Bitcoin ETFs see record outflows as Hong Kong counterparts thrive
Tuesday, May 7, 2024
Hong Kong spot Bitcoin and Ethereum ETFs recorded significant inflows of more than $300 million last week. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
The Usage & Evolution of Decentralized Exchanges (DEX’s)
Tuesday, May 7, 2024
Checking in on liquidity pools, trading volumes and adoption across Ethereum DEX's ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
What is Based Rollup, and How Does it Inherit Ethereum's Liveness?
Tuesday, May 7, 2024
By 0XNATALIE, Researcher at @ChainFeedsxyz Source: With the completion of the Cancun upgrade and the reduction of L2 gas fees, the market's focus has once again shifted to L2. There are currently
Bitcoin network celebrates 1 billion transactions as a Satoshi-era wallet awakens
Monday, May 6, 2024
Bitcoin's 1 billion transactions is over a decade faster than Visa. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Crypto Market Pulse Weekly – 💸 HK Spot Bitcoin ETFs Saw ~$250M Inflows in 3 Days
Monday, May 6, 2024
Hong Kong Spot Bitcoin ETFs saw US$250M net inflows in 3 days. Morgan Stanley filed with the US SEC to permit exposure to Bitcoin ETFs. Australia is reportedly considering the launch of Bitcoin ETFs. ͏
Mining News in April: Bitcoin Halving Effect Emerges, Runes Boom Fades, Angola Paraguay Mining Ban, sponsored by B…
Monday, May 6, 2024
Title sponsored by Bitdeer, a NASDAQ-listed mining company. 1. Bitcoin mining company Bitfarms will invest nearly $240 million to upgrade its Bitcoin mining equipment, aims to remain profitable after
Chainalysis And Tether Team Up To Combat Illicit Activity
Monday, May 6, 2024
We bring you the top stories in crypto every week! Stories like... Monday May 6, 2024 Sign Up Your Weekly Update On All Things Crypto TL;DR Chainalysis And Tether Team Up To Combat Illicit Activity
Liquidation heatmap shows volatility ahead as Bitcoin drops to $57k
Sunday, May 5, 2024
Liquidation heatmap analysis forecasts turbulent times ahead for Bitcoin as it struggles to regain $57000. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Asia's weekly TOP10 crypto news (Apr 29 to May 5)
Sunday, May 5, 2024
1. Hong Kong Bitcoin Spot ETF Holds 4218 BTC Three Days After Launch link After three days of trading, the Hong Kong Bitcoin spot ETF holds a total of 4218 BTC. Among these holdings, the ChinaAMC