jackguy
HODL or Sell?
Jun 11, 2022 - Identify accounts that have staked ETH with Lido when the price of ETH was much higher or much lower than it is now. Have they held or sold their stETH?
Stablecoins on Kashi
Jun 11, 2022 - You can include USDC, USDT, DAI and UST in your analysis and look for the transactions where they are deposited on Kashi for lending. The event name would be 'LogAddAsset'. Removing them will generate 'LogRemoveAsset'.
Impermanent Loss
Jan 8, 2022 - Show the dollar amount of tokens lost to impermanent loss each week over the past year. Do the same for the dollar amount of tokens saved by impermanent loss. What are some measures users can take to prevent impermanent loss?
Node Operator vs Liquidity Provider Yield
May 7, 2022 - What is the aggregate weekly APY for active node operators vs liquidity providers? How has it looked over time? It would be good to show node provider APY showing 2 different ways: including all nodes and just including active nodes.
Algorand Foundation New CEO Staci Warden
Mar 10, 2022 - Algorand Foundation appointed a new CEO Staci Warden on February 10th 2022. How did this impact the Algorand ecosystem?
The People like the Clay Dinos
Mar 20, 2023 - Comprehensive Insights into Solana's Rising Star NFT Project
Kashi TVL
Apr 11, 2022 - What is the Total Value Locked (TVL) by liquidity pool on Kashi? draw a weekly chart for 2022. what are the top 10 pools?
Humans on Solana
Jun 19, 2022 - How many unique humans (rather than unique wallets) are actively using Solana? Can you identify which wallets are 'bots' and remove them from the ""active wallet"" calculation?
CEX to DEX and DEX to CEX
Apr 8, 2022 - Examine the flow of UNI into and out of Centralized exchanges. Which exchanges have the most volume, in terms of USD? Is more flowing in or out?
USDC Deposits
Jun 20, 2022 - In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
Gaming Tokens
Jan 29, 2022 - Find the 5 largest crypto gaming tokens on Sushiswap. How did volume on Sushiswap get impacted when each of these tokens got added to the protocol? What tokens are most often used to exchange into new gaming crypto tokens?
Are NFT Creators Minting Money?
Jun 19, 2022 - What is the average and median return on investment for candy machine NFT creators? As in how much revenue are NFT creators making off mint and then off royalties? How has that trended over time and how do you see this shaping the NFT landscape on Solana?
Active Wallets
Jun 16, 2022 - What are active wallets doing more broadly? What type of activities are the most common on average, and what are the whales doing? Is there a way to identify real users and organic transaction activity?