jackguy
Orca Trading Pairs
Mar 7, 2022 - Create a visualization showing the 5 most popular swapping pairs (by USD amount) for each day since February 1st on Orca. Which trading pairs remain in the top 5 each day? Are there any tokens that seem to currently be trending based on their swap volume on Orca? Why are those tokens popular to swap for on Orca right now?
Bubblegoose Ballers Mint
Jun 14, 2022 - How many unique wallets minted a Bubblegoose Baller NFT and how many NFTs did these wallets purchase on average? How many NFTs were purchased with ETH using Crossmint? Identify any notable trends in minting activity and secondary market sales in the days following the launch. Which group(s) was most likely to "diamond fin" their NFTs?
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?
Where in the world are Solana Users
Jun 22, 2022 - Solana has often been mocked as a ""chain for the poor"" by some in the crypto community due to its low fees and barrier to entry. This is actually a positive in that Solana is built be accessible to everyone, including in emerging markets.
LP Size Distribution
May 1, 2022 - What is the current distribution of LP size for each pool? You will have to use both 'add_liquidity' and 'remove_liquidity' to determine which LPs are stil current.
Post-op Interop
Mar 15, 2023 - Exploring the Interop Summit's Impact on Satellite Bridge and Squid Router Growth
Onboarding with Solana NFTs
Jun 12, 2022 - It has been said that Solana NFTs have become a powerful onboarding tool into the Solana ecosystem. Is this narrative true? Which NFTs have captured the most first time users of the Solana blockchain? What kinds of activities do these wallets tend to do after buying their first NFT? Do you think the NFT growth on Solana will spill over into Defi?
Compressed NFTs
Apr 26, 2023 - A Deep Dive into Cost Savings and Efficiency on the Solana Blockchain
Polygon Hard Fork
Feb 20, 2023 - Assessing the Impact of the Polygon Hard Fork on Network Health and Performance
Coinbase L2 Testnet
Mar 8, 2023 - Tracking the Progress and Performance of Coinbase's Base Testnet
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.
When Do Transactions Fail
Jan 19, 2022 - Do times of high transaction volume lead to more transaction failures? Create a visualization that shows the relationship between transaction volume and success rate of transactions throughout the month of December. Are there any noticeable patterns to when transactions are more likely to fail?
RocketPool: User Profile - LIDO vs. RocketPool
Apr 27, 2022 - 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.