coinsatrap
EVM-15 New Users Challenge
Mar 22, 2023 - Find the top 10 projects on Ethereum mainnet by volume during the past 7 days Analyst are expected to; observe different ethereum tables, filter by only 10 project with the most volume, and truncate dates to find past 7 days.
SOLANA-30 New Users Challenge
Mar 26, 2023 - Analyze data related to Solana, and answer the following questions: 1. What is the current market dominance of Solana compared to the other blockchain platforms in the market? 2.What is the daily trading volume for Solana on the top 3 DEXs and how does it compare to the daily volume of centralized exchanges herein (Binance and Coinbase)? 3. What is the current transaction throughput for Solana and how does it compare to the levels from one month ago?
HOW NFTS ARE FARING IN 2023
Feb 7, 2023 - Using the table ethereum.core.ez_nft_mints, select one or a few recent project mints and determine how “successful” they were. How success is defined, is up to you! You could look at: volume of ETH spent, number of NFTs minted, unique addresses minting the project, fees spent in ETH by minters.