Flipside Crypto - Bounty Brief #76
Hey bounty hunters, We’re getting down to the wire in our FLOW NFL ALL DAY Bounty Tournament. We’ll be announcing the qualifiers for the Round of 16 later today, and opening up the next round of the tournament with a special challenge question for this all-star group of analysts. That, plus NEAR and Optimism bounties today, and more coming this weekend. Check it all out below! 🏈 FLOWNFL All Day Tournament [Round of 16] Bounty: Up to 67.204 FLOW
The purpose of this question is to uncover more meaningful insights within the description of the dim_allday_metadata table’s MOMENT_STATS_FULL column. This round notches up the difficulty considerably - given the structure of the data, finding answers to some of the above prompts will be a serious challenge. Thus creativity, meticulousness, and attention-to-detail will be required to make it to the Round of 8. ☀️ NEAR[Hard] District Deep Dive: Contracts Deployed Bounty: Up to 24.945 NEAR Building on work from The Law Offices of NEAR , provide an updated view of contracts deployed over time on NEAR. (Hint: the transactions table will help with this). What factors do you think might influence the number of contracts deployed? Similarly, you are free to use GokuStats for inspiration (see the attached image), but the core part of this task is providing your own original insights. Grand Prizes will focus on well-reasoned, creative assessments on what drives developer activity on NEAR. 🔴 Optimism[Medium] $OP Airdrop Bounty: Up to 75 USDC Earlier this summer, Optimism offered an airdrop to users. Let’s examine the airdrop after a few months. How many users claimed optimism airdrop? How much of total airdrop was claimed? How many wallets are still holding tokens from airdrop? How much of users delegated their OPs? Feel free to provide any information that you think is related to token price. [Hard] Quix vs Magic Eden vs OpenSea Bounty: Up to 112.5 USDC Create a dashboard highlighting at least 3 metrics comparing marketplace performance and adoption between Quix (formerly Quixotic) on Optimism, Magic Eden on Solana, and OpenSea on Ethereum, since July of this year. What has been the rate of change of these metrics since the start of the new year and are there any signs of growth of a certain marketplace or ecosystem of NFTs? Highlight the 5 most popular NFT collections for each marketplace over that timeframe in terms of sales volume. Is the turnover rate (number of transactions) for collections on Magic Eden noticeably higher than on OpenSea and Random Earth? Provide some insights on these findings. Coming Soon™️Want more? Here are some more bounties coming this weekend. Saturday🧑🏫 Education Bounties[Easy] Solana swaps: Skill-building Bounty 12 This week we’ll take a second look at our Solana Educational bounties: swaps on Orca https://flipsidecrypto.xyz/drops/solana-educational-bounties-swap-volume-on-orca-7189af . In the live call, we’ll go over the swaps and labels table (solana.core.fact_swaps and solana.core.dim_labels) to recreate a dashboard showcasing the following:
Equip your charts with proper labels [Hard] Finding holders for a specific token: Skill-building Bounty 13 A month ago we looked at how to query the top 10 holders for a specific token using the ethereum.core.ez_current_balances table. This time, the task is to create a query to show the daily count of existing token holders for a specific token. The query should also be able to show the list of token holders at any specific day. Hint: Use the ethereum.core.ez_balance_deltas table. You are encouraged to also use Etherscan to cross check your answer. For example, the token holders for sushi tokens can be found here: https://etherscan.io/token/0x6B3595068778DD592e39A122f4f5a5cF09C90fE2#balances Don’t forget to join us for a walkthrough for this bounty in our live SQL sessions on discord on September 27. 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 #75
Friday, September 16, 2022
Tournaments 🏆, 🏗️ buildathons, 📊bounties, and more.
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.
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. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏