Solana-Foundation-2.Tracking USDC & USDT on Solana

-- Q2. What's the current market share for USDC and USDT on Solana relative to other stablecoins in the ecosystem -- (look into USDC, USDT, UXD, USDH, PAI, NIRV, UST, DAI, FRAX)? -- Create a visualization showing the amount of transaction volume for USDC vs. USDT etc. do display popularity within Solana. -- For USDC and USDT specifically, breakdown the transaction activity by contract and exchange flows -- (i.e. which dapps and addresses hold the majority of USDC and USDT and what do cumulative flows to and from exchanges look like over time)? -- Reference these older dashboards by ltirrell and adriaparcerisas as examples: -- https://app.flipsidecrypto.com/dashboard/stablecoin-popularity-UOlg-v -- https://app.flipsidecrypto.com/dashboard/solana-stables-EJCpX0

Since we don't have the balances table, we take the marketshare information from Solscan for each token.
- Example: https://solscan.io/token/BQcdHdAQW1hczDbBi9hiegXAR7A98Q9jx3X3iBBBDiq4
USDT has the highest marketshare byfar with ~ 400M

Create a visualization showing the amount of transaction volume for USDC vs. USDT etc. do display popularity within Solana.

Given below is the transaction volume in terms of swap volume and number of swaps.
USDC-->USDC and USDC-->USDT are the most common type of swaps happening on Solana.
USDC-->UST were the second most common when Terra was a dominant force.

USDC vs USDC Transaction activity by Swap Program

Given below are all the dominant dexes, ORCA is the most common DEX used to swap to USDT
Jupiter is the most common dex used to swap from USDC.
Till date 5.3B has been swapped to USDT on ORCA and 7.3B from USDC on ORCA.

USDC vs USDC Transaction activity by Exchange Inflow vs Outflow

USDC inflow happens the most from FTX, till date 15B USDC has inflown from FTX.
USDC outflow happens the most from FTX, till date 12B USDC has outflown from FTX.
USDT inflow happens the most from FTX, till date 2B USDT has inflown from FTX.
USDT outflow happens the most from FTX, till date 2B USDT has outflown from FTX.