jackguy
Algorand Price Correlation
Jun 30, 2022 - 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?
Bridge Users (Hop Protocol)
Jun 18, 2022 - 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.
Hop Whales
Jun 22, 2022 - Are whales choosing Hop to go to L2s? Or are they choosing the native bridges? Compare Hop vs the native bridges for Polygon, Optimism, and Arbitrum over the following metrics: unique users on each, frequency of use, and the average amount of assets moved on each?
Voting Activity
Jun 18, 2022 - The Lil Nouns DAO is controlled via onchain voting by token holders. 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.
Solana blockchain speed
Jun 13, 2022 - In this dashbaord we will compair the TPS of Solana to Ethereum and Algorand
Celsius Swaps
Jun 19, 2022 - Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. From which one of their wallets did they conduct most of the swaps?
Top TOKE Holders
Jun 21, 2022 - Identify the top holders of the TOKE token in January 2022, have they kept their position today?
MDAO Multisigs
Feb 15, 2023 - Exploring the Operations and Finances of MetricsDAO on Polygon, Ethereum, Near, Terra
Long vs Short Option Contracts
Jun 30, 2022 - How many long vs short option contracts have been bought on opyn? What’s their value? Has there been any liquidations?
New Celsius Wallets
Jun 13, 2022 - Recently, Celsius made the decision to halt trading activity due to ‘extreme market conditions’, including a pair of events that had a severe impact: the depegging of stakehound eth STETH and the Luna crash. Potential Celsius owned addresses have been circulating on twitter and we want to know the behaviors surrounding these addresses. Build a dashboard that tracks the activity of the newly identified Celsius wallets. Let’s look at incoming vs. outgoing transactions over time. What is the average amount being moved?
Secondary Sales Activity
Jun 18, 2022 - How many Lil Nouns have been sold on a secondary exchange within 24 hours of being minted? Are there any common traits among these Lil Nouns? Which Lil Noun’s have the biggest difference (positive or negative) between their mint price and secondary sale price? Visualize and analyze your findings.
Pooly NFTs
Jun 20, 2022 - How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
USDC on Ethereum
Mar 2, 2023 - Tracking the Performance and Activity of USDC on the Ethereum Blockchain
Metamask vs. Other Platforms
Jun 24, 2022 - How many users are swapping via MetaMask vs other platforms? How much volume have these users done? Chart a comparison between the two, and show the following metrics over a time period of your choosing: transaction volume, average amount swapped, and a comparison of fees.