USDC, USDT, UST on Jupiter
Question 31: Create a visualization comparing USDC, USDT, and UST (wormhole) popularity in swaps on Jupiter since December 1st (both in terms of count and amount - swaps from and swaps to). Is there a dominant stablecoin in swaps on Jupiter? What percentage of all Jupiter swaps are stablecoin swaps (as in a swap between USDC, USDT, and UST)? Have we seen more instances of users swapping USDC or USDT for UST over time? Why or why not based on your knowledge of Terra's cross-chain efforts? Sample Query: Select _, address_name, count() as swapcount From solana.swaps s LEFT OUTER JOIN solana.labels l ON ____________ = l.address Where block_timestamp::date >= '2021-12-01' And succeeded = 'True' And (_______ = __________ or _________ = __________ or ___________ = ______________') Group by ____________, ______________ Hint (USDC): https://solscan.io/token/EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v Hint (USDT): https://solscan.io/token/Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB Hint (UST): https://solscan.io/token/9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i