monaretta
Cryptopunk Sales and Traders
Aug 28, 2022 - Which 10 wallets are the most successful Cryptopunk traders? Successful could either mean the wallet has accumulated a large balance from sales or has accumulated a large number of Punks. Explain your methodology and findings.
Bridger Destinations
Aug 1, 2022 - Q5. Where do people go when they bridge to Polygon from Ethereum? What are the 10 most popular first destinations for Polygon addresses that have just bridged from Ethereum?
Polygon NFT
Jul 15, 2022 - Q3. How popular are NFTs on Polygon? Track daily volume over the past month/year/etc. How many Polygon users started off with NFTs? Who made the most profit?
Total Value Locked
Jun 30, 2022 - Q1. What is the total value locked in the Opyn Squeeth (osQETH) contract? And where does osqeth draw its value from?
Top TOKE Holders
Jun 21, 2022 - Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
Total Metamask Users
Jun 26, 2022 - Q1. How many total Metamask wallet holders are there? What’s the average value of ETH. held in wallets? What percentage of wallets are engaging in a higher order activity, like staking?
Optmistic Bears
Aug 10, 2022 - Q9. Analyze Optimism during the month of July as markets were get turbulent, showing whatever metrics you care to unearth. You can choose any topic you’d like: How did the network perform? What about market performance? Were there significant inflows or outflows on bridges? Were there any notable patterns in user behavior?
zkSync Scavenger Hunt
Jun 13, 2022 - Entering the zkSync ecosystem, Funding a new wallet and swapping tokens.
Velodrome Locks
Jul 18, 2022 - Analyze new locks created on Velodrome Finance. Analyze new locks created on Velodrome Finance. What durations are most common? Which wallets have locked the most in the last 4 weeks? Which pools are wallets voting for with their locked tokens most often? For more information on Velodrome, please visit: https://docs.velodrome.finance/
Untitled Board
Sep 4, 2022 - Show the distribution of swap sizes in both $RUNE and USD, both for all pools as well as broken down by pool.
Transactions by Protocol
Jul 14, 2022 - Q115. Using the following App ID lists from Folks Finance, AlgoFi, Tinyman, and AlgoDex, lets look at what percent of transactions their app calls and associated transactions(transactions in the same tx_group_id) make up on the Algorand blockchain. How have the number of transactions changed over time for each Protocol? Also how much in fees have been spent on transactions relating to each protocol? Other things that can be explored are what type of transactions are each protocol producing, or has the price of ALGO been an influence on the number of transactions produced by each protocol.
Just Keep Swimming
Jul 27, 2022 - Swim Protocol provides a simple way to transfer tokens across chains via multi-token liquidity pools. It is built on top of one of the most infamous bridges, Wormhole, which allows users to more seamlessly transfer assets across multiple blockchains Create a dashboard for Swim on Solana including at least the following metrics (add anything else you find interesting): Total Volumes Total unique users Most popular destinations from Solana Most popular stablecoins and non-stablecoins traded over time
Algorand Free Square
Jun 30, 2022 - Q110. Time to get creative and explore! We want you to dig into a topic/project/protocol on Algorand that you find relevant and interesting and create an analysis around it. Bonus points for creativity and uniqueness!
Solana NFT Project Feature
Jul 18, 2022 - Choose a NFT project from the following list and create a dashboard with the new Flipside dashboard layout that can refresh once a day highlighting at least 4 metrics of your choosing that helps show the "health" of the project. Note any noticeable trends or current events for the project. Highlight how liquidity is flowing in and out of the project and what types of buyers and sellers are interacting with the project.
The Law Offices of NEAR
Aug 2, 2022 - Q7. Provide your best assessment of the number of smart contracts deployed on NEAR and clearly outline your methodology (after all, contract lawyers love clearly specified terms). Visualize the number of new smart contracts deployed over time over a time period of your choosing. What are the top 5 new smart contracts interacted in that period of your choosing?
Lil Nouns Voting Activities
Jun 17, 2022 - Question :Using the Ethereum database, analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant.
Celsius And Sushi
Jul 13, 2022 - \ Q104. Find out what Celsius platform has done on sushi (swaps, lending, LP'ing, farming). Make sure to use cross-chain tables as much as possible to capture data on all chains. currently, we have swaps, lending, and borrowing data cross-chain. Hint: you can find all addresses belonging to Celsius network by querying this table: flipside_prod_db.crosschain.address_labels
NEAR Scavenger Hunt
Jul 12, 2022 - By the end of this tutorial, you should be able to… Create a NEAR wallet Fund your wallet with NEAR Use Ref.finance to swap, buy, or stableswap NEAR for USN.
StarkWare Scavenger Hunt (July 16)
Jul 16, 2022 - Acquire GETH Acquire TST Swap tokens via myswap
NEAR Gas Guzzlers
Jul 25, 2022 - What contracts are users spending the most gas on to use? How has this changed over the past week? Past month?
Folk Finance Liquidation
Jul 14, 2022 - Q118. Dig into liquidations on Folks Finance to help us better understand liquidations that have happened on the platform! -Total daily liquidations count over time by asset. Do we see a spike when the markets capitulated in May? -Total daily liquidation volume, by asset. Do we see a spike when the markets capitulated in May? -Total daily liquidators profit (difference between the value of collateral liquidated and the total amount paid by liquidators). -Average and total amount that has been liquidated on Folks Finance for each asset? Note any other interesting information around liquidations on folks finance such largest liquidation by asset or anything else you find interesting.
Quixotic NFT Dashboard
Aug 3, 2022 - Q7. Create a secondary market dashboard for NFT sales on Quixotic, the largest NFT marketplace on Optimism! Include any data you think is relevant in our Optimism tables and tell us the most interesting trends you can find with the secondary NFT market.
Hop Protocol (Bridge Users)
Jun 20, 2022 - Q1. How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.
Tracking Realms DAOs
Aug 15, 2022 - Q104. We now have Solana Realms governance data! Their team would love to be able to see a list of DAOs / multisigs built on SPL Governance, and understand their: Number of Members (assuming unique voters is what he means here) Total Votes Number of Proposals Date of Last Proposal Date of Creation
Flow vs Other L1s (II)
Jul 16, 2022 - How does Flow compare to other L1s in terms of user retention? Is a user who made a transaction previously likely to make another transaction a week or a month later? Compare and contrast this type of activity vs other L1s like Solana and Ethereum
Optimism Scavenger Hunt
Jun 29, 2022 - To complete the scavenger hunt, create a dashboard showing at least three of the following transactions Acquiring SNX Transferring of SNX to your Metamask or other wallet Bridging your SNX from Ethereum to Optimistic Ethereum Staking SNX Collecting Rewards
NFT Buying Behavior on Flow
Jul 17, 2022 - 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?
Near Performance
Jul 20, 2022 - How does NEAR stock up to other L1s in terms of speed and performance? How fast is NEAR, and compare it with other blockchain speeds in terms of transactions per minute and percentage of transactions that fail.
Opensea Fees
Jul 30, 2022 - Q6. Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
What makes a Top Shots moment valuable? (Part I)
Jul 24, 2022 - Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume. This week, focus specifically on the play_type column in the flow.core.dim_topshot_metadata table. What play_types do users hold most, and how much volume in sales do these play_types generate? Include any other transactional metrics you can think of.