piper
Apollo - 105. Apolloβs Treasure
Dec 6, 2021 - During the $HALO farming event, how much new volume entered the Apollo vaults? Do you detect any trends? Provide at least one visualization to support your answer.
Solana - Unique Programs
Feb 10, 2022 - One way to track developer growth in an ecosystem is through the number of unique contracts used. Create a visualization of the number of unique programs used per day since the beginning of January. What are the 5 most commonly used programs over that timeframe? What do those programs do and why do you think they are so popular?
Fees on Wormhole vs Others
Jan 12, 2022 - 128. Fees on Wormhole vs Others Analyze transaction fees on Wormhole vs. other bridges. In your view, what is causing the difference & how could it be addressed? BONUS: assess this over time rather than at a specific point in time.
Rari Capital - Fuse Pool DAI Allocation
May 21, 2022 - Q1. How are the tokens in the DAI Vault being allocated into the various Fuse Pools?
Apollo Sunchaser Hunt
Oct 13, 2021 - I did two transactions, one for MINE-UST and one for ANC-UST
Solana - Most Popular Jupiter Swaps
Feb 27, 2022 - Jupiter is the best swap aggregator on Solana, meaning that it optimizes the best token swap rate across all decentralized exchanges for users. Since February 1st, what have been the 10 most popular tokens to swap away? Over that same timeframe, what have been the 10 most popular tokens to swap for? What are the 10 most popular swapping pairs (combination of swap away to swap for)? Define 'popular' as the number of swaps and create a visualization showing total number of swaps over that time frame, highlighting these most popular tokens.