princefarzamWhat is USDH most commonly swapped for overtime?
    Updated 2022-04-19
    SELECT
    ADDRESS_NAME,
    SUM(SWAP_FROM_AMOUNT) AS USDH_swap_amount
    FROM solana.fact_swaps a JOIN solana.dim_labels b ON a.SWAP_TO_MINT=b.ADDRESS
    WHERE SWAP_FROM_MINT='USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' --USDH contract address
    AND SUCCEEDED = TRUE
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 10
    Run a query to Download Data