CarlOwOs
Bridge Users (Hop Protocol)
Jun 19, 2022 - June 19th, 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.
Applications on Algorand
Jun 28, 2022 - June 28th, 2022. How have the number of application calls changed in the first 6 months of 2022 compared to the last 6 months of 2021?
Hop Whales
Jun 20, 2022 - June 19th, 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?
Distinct Wallets (zkSync)
Jun 15, 2022 - June 15th, 2022. Q1. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
Merge Staking Providers: Rocket Pool
Sep 3, 2022 - Quick overview at the Rocket Pool liquid ETH staking platform
Ethereum Miners Block Size Preference
Sep 9, 2022 - An in-depth look at what the blocks miners prefer to mint based on transaction count
Exchange Flows in the Bear
Aug 13, 2022 - Let's understand whether the bear market and recent issues with CeFi products have changed centralized exchange users' behavior.
Secondary Sales Activity
Jun 18, 2022 - June 17th, 2022. Q2. 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.
New Wallets in May
Jun 16, 2022 - June 16th, 2022. Q101. How many wallets have a balance greater than 1 ALGO? And how many of those wallets sent or received a transaction in May?
Algorand Price Correlation
Jun 28, 2022 - June 28th, 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?
Swapping for YLDLY on DEXs
May 20, 2022 - May 20, 2022. In this dashboard, we break down the way in which the Yieldly (YLDLY) asset is being swapped in the Algorand ecosystem. We show the overall demand for YLDLY on the Algorand DEXs as well as the volume of YLDLY related to its price and tokenomics.
Trend of Pools
May 17, 2022 - May 18, 2022. We explore the behavior of the most relevant Liquidity Pools in Sushiswap for Ethereum for the past 90 days.
Top TOKE Holders
Jun 21, 2022 - June 20th, 2022. Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
SUSHI Noobs II
Jun 21, 2022 - June 20th, 2022. Q94. What is the first thing new users do when they acquire SUSHI?
Pooly NFTs
Jun 22, 2022 - June 22nd, 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?
Hadeswap Wash Trading
Oct 21, 2022 - A new sector of NFT marketplaces have begun to gain popularity on Solana, the NFT AMM. One of the most notable NFT AMMs on Solana so far is Hadeswap.
Avalanche Swaps vs Transfers (Redux)
Dec 5, 2022 - Examine Avalanche USDC swaps vs transfers and mints vs burns using the new fact_event_logs data and avalanche.core.fact_traces data.
Voting Activity
Jun 17, 2022 - June 17th, 2022. Q1. The Lil Nouns DAO is controlled via on-chain 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.
Flipside's World Cup Kick Off: Gas Guzzlers
Nov 13, 2022 - To qualify for this tournament, create a gas tracking dashboard that looks at gas usage by a chain over the last couple of months
Sushiswap DEX Loyal Users
May 6, 2022 - Ranking of the wallets that performed most swaps last month, since the beginning of this year, and since the beginning of time. We also show the count of the number of days wallets swapped tokens in Sushiswap for the same timeframes.
Al Goannas
May 26, 2022 - May 26, 2022. On this dashboard, we take a look at the Al Goannas NFT collection in the Algorand blockchain. We first assess the distribution of the NFTs by wallets. Later we also study the secondary market sales and volume of the collection over time.
Sushi Activity on Ethereum
Jun 29, 2022 - June 29th, 2022. How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings?
ETH Deposited or Withdrawn
Jun 26, 2022 - June 26th, 2022. Starknet is a layer 2 chain, like polygon, that ensures interoperability with Ethereum mainnet. People are using it to move real ETH to starknet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to starknet or vice versa? and by how many depositors?