jackguyStablecoin Activity on Solana 4
    Updated 2022-12-22
    SELECT
    WEEK(f.BLOCK_TIMESTAMP) AS week,
    count(DISTINCT f.SWAPPER),
    count(DISTINCT tx_id),
    SUM(f.SWAP_TO_AMOUNT) AS total_swap_to_amount
    FROM solana.core.fact_swaps f
    WHERE f.SWAP_TO_MINT IN ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB', 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX')
    GROUP BY 1
    Run a query to Download Data