Flow NFT Comparison
Sep 16, 2022 - -- Compare and contrast the NFT market and ecosystem across at least three different chains -- (you can do more if you wish, but there must be at least three included.) -- Explain how the various chains differ in terms of metrics such as: -- Total Sales -- Total Unique Buyers -- Total Volume -- Average Sales/Day -- Average Buyers/Day -- Average Sales Price/Day
Algo-31.Algorand Foundation New CEO Staci Warden
Mar 9, 2022 - -- Question 31: Algorand Foundation appointed a new CEO Staci Warden on February 10th 2022. How did this impact the Algorand ecosystem? -- The week following announcement did we see an increase of ALGOs being moved from CEXs(centralized exchanges) to wallets? -- Or did we see an increase of ALGOs being moved from wallets back to CEXs? -- Tips: Use the labels table to look at addresses labelled as CEXs
Osmosis - 2022 Stablecoin of choice ?
Jan 26, 2023 - Submit a deep dive dashboard that explores a specific topic in detail using Osmosis data. 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!
Polygon Scavenger Hunt: Bentobox
May 24, 2022 - Welcome to the Sushiswap and Bentobox Ecosystem! We hope this scavenger hunt is an enjoyable entry into using Bentobox
THOR-15. [Hard] On-ramping
Nov 3, 2021 - What is the breakdown of new users on-ramping onto thorchain by chain? Show a breakdown of each wallet’s first thorchain transaction. Which chain are they coming from? Are they swapping for RUNE or for an asset on another chain? Hint: use swaps + transfers
Sushi-108.Sushi Pairs on Avalanche and BSC
Aug 6, 2022 - Create a document that includes all addresses for all Swap pairs on Avalanche for sushi, plus the addresses of the two tokens belonging to each pair. Create a document that includes all addresses for all Swap pairs on the BSC chain for sushi, plus the addresses of the two tokens belonging to each pair. Create a document that includes all addresses for all Kashi pairs on Avalanche for sushi, plus the addresses of the two tokens belonging to each pair. Ideally, define which one is the main asset and which one is the collateral. Create a document that includes all addresses for all Kashi pairs on the BSC chain for sushi, plus the addresses of the two tokens belonging to each pair. Ideally, define which one is the main asset and which one is the collateral.
Flow-10.NFT Buying Behavior on Flow
Jun 12, 2022 - -- Q10. Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to on Ethereum and Solana. -- Is there more or less "whale" activity on Flow compared to each of the other chains? -- What do "whales" tend to focus on in Flow? -- How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains, or do wallets tend to hold onto their NFTs? -- Are wallets more interested in new projects, or already existing projects on Flow?
Terra - 8. New Year’s Resolutions
Jan 16, 2023 - 2022 was a rough year for Terra and $LUNA. So what will the future hold — and what New Year’s Resolutions could the protocol make to ensure 2023 is better than 2022? Identify at least three goals that the Terra ecosystem and community should have in the New Year, how they can achieve them, and what good fortune those changes would bring. Back up your assertions with on-chain data.
Polygon Mega Dashboard
Jul 31, 2022 - Q7. Combine prior grand-prize-winning submissions into a single, interactive dashboard that can give users a broad view into the Polygon ecosystem. Flash and flair win the day here — we want to see not just a summary of the best data analysis, but a functioning front-end, plus a competent and insightful narrative to help readers understand the data. Dashboards must be industry-standard level and offer high-level insights to be considered for the grand prize
Algo-109.Algorand Price Correlation
Jun 29, 2022 - -- Q109. Is the price of Algorand more closely correlated with the crypto market, -- and assets such as BTC or ETH, or is it more correlated with network usage such as number of transactions or ALGO transfers?
34.Algo-Algorand Governance Period 2 Voting
Mar 10, 2022 - -- Show wallet votes over time -- Which had more individual wallet votes, A or B? -- Show the voting result(A vs B) based on the ALGOs committed by wallets for this governance period.
OPtimitic or Pessimistic?
Oct 18, 2022 - Are you optimistic or pessimistic about the future of the layer-2 chain known as Optimism? How do you think it will fare going forward compared to other L2s?
OlympusDAO - 6. OHM Treasury
Apr 22, 2022 - Track the daily balance of the Olympus DAO treasury. Show the balance over time of the main underlying assets of the treasury.
NEAR - 6. NEAR Foundation Transparency Report: Q3, 2022
Jan 10, 2023 - Each quarter, the NEAR Foundation publishes data to help the NEAR community understand the health of the ecosystem as part of their NEAR Foundation Transparency Report. We want your help in making the NEAR ecosystem even more transparent. How can you improve on the existing Transparency Report? Explain which metrics should be taken into consideration and why. Then, analyze those metrics over the last several weeks and draw your own conclusions on the health of the NEAR ecosystem.
6.Solana-Solana Fees
Feb 5, 2022 - -- Question 6: One of the main advantages for a user of Solana is the extremely low fees relative to other blockchains. -- Create a visualization showing transaction fees per day accumulated since the beginning of January. -- Also create a visualization that shows transaction fees per transaction on each day. -- Do fees ever seem to spike or is it consistent?
Metamask-2.Most Common Transactions
Jun 25, 2022 - -- Q2. What are the most common transactions for Metamask users? -- Create an analysis that shows the most common wallet activities and the most common platforms for those activities.
Solana-97.Solana Protocol Feature Saber - To SOL
Jul 13, 2022 - -- Q97. Choose a defi protocol from the following list and create a dashboard with the new Flipside layout that can refresh -- once a day highlighting at least 4 metrics of your choosing that helps show the "health" of the protocol and what is happening on it. -- Note any noticeable trends or current events for the protocol. Highlight how liquidity is -- flowing in and out of the protocol and which pools are popular.
[Polygon-5] Daily Transactions and Unique Addresses
Aug 28, 2021 - Count and plot the number of daily transactions and unique addresses on polygon, beginning June 1, 2021. In your estimation, discuss whether polygon is still launching up, has reached a plateau, etc.
TokenFlow-2.The Merge
Mar 22, 2022 - -- Q2. "As we near ‘The Merge’, are there any new trends within the ETH2 Deposit Contract -- (0x00000000219ab540356cBB839Cbe05303d7705Fa), or other synthetic staked ETH assets, such as Lido stETH?
VISOR-3. Gamma Gas Savings
Jan 31, 2022 - Assuming a wallet would have changed its Uniswap v3 position range when the Gamma pool does, how much gas has been saved among all the wallets for the most popular Gamma pool (most popular pool can be determined by the pool with the most number of wallets)?
160.Terra-Getting Your Feet Wet, Part 1
Mar 5, 2022 - -- Question 160: Make a table containing wallet addresses whose first transaction was 90 days ago or less. -- Analyze how active they have been since that first transaction, based on either -- 1) the number of transactions; -- 2) the number of protocols interacted with, or -- 3) the number of different types of transactions undertaken. (deposit, delegate, vote)
DAI-DAI Volume
Jan 19, 2022 - How does the daily volume of DAI transactions compare to other stablecoins? What is DAI most used for?
Flow During Market Downturn
Jun 28, 2022 - Q.14 Analyze Flow during the month of May when markets began to get turbulent, showing whatever metrics you care to unearth.
Sushi-57.Sushi on Polygon
Mar 19, 2022 - Q57. What are the 10 largest sushi liquidity pools on Polygon? What is their volume and TVL?
THOR-12. [Easy] Wallet population
Nov 2, 2021 - Show the number of unique thorchain wallet addresses that have been created and done at least 1 transaction on thorchain. Show daily numbers as well as cumulative. Hint: use transfers
Hot-11.Hop Bridge Volume
Apr 22, 2022 - -- Q11. How many Matic token were bridged in 2022 per day from ethereum to layer2 using Hop? -- Use Ethereum_core schema. -- Hints: -- contract address for ethereum bridge for Matic : 0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2 -- MATIC contract address on ethereum: 0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0 -- Event name that sends token from user's wallet to the bridge is 'Transfer' -- Event name that sends token from the bridge to the layer 2 wallet is 'TransferSentToL2'
Hot-19.RocketPool: User Profile - LIDO vs. RocketPool
Apr 24, 2022 - -- Lido is another application that also offers ETH2 liquid staking. -- Compare and contrast activity on RocketPool vs. Lido over the past three months. -- Is one growing more quickly than the other? Can we conclude if one of these applications is better for users than the other? -- Are there different types of users using RocketPool compared to Lido, or are the user profiles similar? -- Visualize and explain your conclusions.
Polygon-3.Price + Circulating Supply
Jun 4, 2022 - -- Q3. Draw a chart showing MATIC’s circulating supply from the start till today. Compare it with MATIC’s price.
Lido-9.ETH Staked
Jun 13, 2022 - -- Q5. What is the total amount of ETH that has been staked with Lido? -- Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
Algo-37.Yieldly HDL Distribution Pool Exploit
Mar 23, 2022 - Q37. At the beginning of March, Yieldly announced they had found wallets abusing the HDL Distribution pool (https://twitter.com/YieldlyFinance/status/1500060434296033282?s=20&t=reW0nw6ggkQy5acX540UWA). Let’s look and see if we can identify the wallets or wallets that were taking advantage of the HDL distribution pool(https://app.yieldly.finance/distribution?id=596947890 ) logic. Identify the wallets that were taking advantage of the pool by looking at their application call transactions. We can identify the actions wallets were taking on this pool by using the algorand.application_call_transaction and decoding the application call action (try_base64_decode_string(tx_message:txn:apaa[0]::string)). For the wallets that were demonstrating odd behavior, is there a pattern to the actions they were taking in the distribution pool? If so, tell us what their behavior looked like.
![[Terra-55] UNI Airdrop Recipients](https://res.cloudinary.com/dsr37ut2z/image/url2png/c_crop,g_north_west,h_600,q_auto,w_1200,x_0,y_0/v1675436387/https://next.flipsidecrypto.xyz/previews/dashboards/5284de95-2e64-4b00-8555-3125454af0d1%3Ftype%3Dcover "[Terra-55] UNI Airdrop Recipients")
[Terra-55] UNI Airdrop Recipients
Sep 1, 2021 - -- How many addresses received the original Mirror airdrop to UNI holders? -- How many addresses received the original Mirror airdrop to LUNA stakers? -- Investigate which Terra addresses received a UNI airdrop-size inflow from the Ethereum bridge soon after the UNI airdrop -- Are you confident these Terra addresses received the UNI airdrop? -- If so, are there any Terra addresses received both airdrops?
Flow-9.Crossover with NBA Top Shot
Jun 12, 2022 - -- Q9. Which Flow NFT projects appear to have the most crossover of buyers with NBA Top Shot addresses? -- Is NBA Top Shot an effective onboarding tool in getting users interested into other Flow collections? -- Does this crossover tend to come from Top Shot "whales", or does the crossover come from average to smaller players? -- How can Flow projects better attract liquidity from Top Shot players?
38.Solana-Fractionalized Dragons
Mar 13, 2022 - -- Question 38: Bridgesplit enables any unique asset to become liquid and yield generative via NFT-collateralized lending, indexes, and more. -- Bridgesplit's Floor Indexes are a new NFT / DeFi primitive that enables users to create instant liquidity for their NFT assets with a fungible -- token that tracks the ""floor price"" of the respective NFT collection. -- The product was first introduced on March 1, 2022 in partnership with the Boryoku Dragonz. -- Users can deposit their dragon NFTs in exchange for $DRGNZ tokens or buy $DRGNZ on the open market and then deposit their tokens into the DRGNZ-SOL -- liquidity pool to earn passive income in the form of trading fees. -- LPs can also start farming $BOKU rewards by staking their LP tokens. -- A total of 8,500 $BOKU tokens are expected to be distributed during the farming rewards period. -- Create a graph showing the total volume of $DRGNZ traded -- The total deposits into the DRGNZ-SOL liquidity pool over time. -- Highlight the largest deposits and largest withdrawals from the pool to date. -- How many $BOKU tokens have been farmed so far from this rewards program?
NEAR - 10. The Path to Decentralization
Jan 29, 2023 - -- Create a stylish, refined dashboard that enables viewers to assess both individual validators on NEAR, and validation as -- a whole (bonus points if you find a way to enable parameters or dropdowns that display different validators). -- As ever, you are welcome to draw on past/existing work that explores governance on NEAR, as long as you provide credit to -- your original sources.
Algo-15. AB2 Gallery NFTs
Feb 3, 2022 - Let's take a look at one of the most popular NFT marketplaces AB2 Gallery get a better understanding of their marketplace performance. -Total Number of Assets Sold from AB2 Gallery? Daily Volume of sales in ALGOs from Assets being sold from AB2 Gallery? Daily Volume of assets being sold in from AB2 Gallery? What was the largest sale on AB2 Gallery? Tips: Here is an asset transfer example of an asset being purchased from AB2 Gallery tx_group_id = 'wWE2i1LDwQBpKv+RGPNGcNvKm7VrmskGUyV4snkFS1w=' -To look at transfer transactions in involving AB2 Gallery use: where try_base64_decode_string(tx_message:txn:note::string) = 'ab2.gallery'
ALGO-4. Governance Period 1 Breakdown
Jan 8, 2022 - - For governance period one, what was the voting breakdown? - How did this change by the size of the algo wallet? - How does this change by number of algos committed?
In the News - 12. Groundhog Day
Jan 17, 2023 - It’s been a harsh few months of winter in the crypto market, with token prices falling hard and once-stable companies and organizations reducing workforces or even vanishing overnight. With Coinbase announcing another layoff of nearly 20% of employees, some might be feeling like Bill Murray in Groundhog Day, forced to relive events over and over again. With that in mind, let’s turn to our friend the groundhog for an early crypto-winter prediction: are we nearly through to spring, or will winter’s cold snap continue on even longer? Back your assertion by creating a dashboard with on-chain data that supports your arguments in favor of either a continued downturn in the space or a soon-to-come rally.
FLOW NFT Ecosystem
Sep 25, 2022 - Happy Flow NFT Day! As part of today’s celebration of FLOW NFTs, we want you to dive deep into the ecosystem. Treat this as an open analytics bounty specifically focusing on the FLOW ecosystem. 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!
Terra-189.What Happens To Liquidated Collateral?
Apr 12, 2022 - -- Q179. What do users do with liquidated collateral after winning a bid? Possible actions are: sell, swap (i.e. bLUNA->LUNA), hold, deposit into Anchor, etc.
Solana-MonkeDAO Validator
Feb 18, 2022 - -- The MonkeDAO was the first NFT DAO on Solana and also was the first NFT DAO to set up a validator in an effort to help decentralize -- and secure the network. -- When a user decides to stake their Solana, they delegate which validator to support with their staked Solana. -- How many unique wallets since February 1st have decided to delegate their staked Solana to the MonkeDAO validator? -- Create a visualization showing delegations per day.