SELECT BLOCK_TIMESTAMP, TX_ID AS TX, TX_FROM AS SENDER, TX_TO AS RECEIVER, AMOUNT, MINT

FROM solana.core.fact_transfers

WHERE MINT IN ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB') AND

BLOCK_TIMESTAMP::DATE BETWEEN CURRENT_DATE -180 AND CURRENT_DATE -1 AND

AMOUNT > 0 AND AMOUNT IS NOT NULL

SELECT BLOCK_TIMESTAMP::DATE AS DAYS,

SUM(AMOUNT) "Amount_of_stablecoin_transferred", COUNT(TX) "Number_of_transfers",

"Amount_of_stablecoin_transferred" / "Number_of_transfers" AS "Average_amount_per_transfer",

COUNT(DISTINCT(SENDER)) "Number_of_senders",

CASE

WHEN MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' THEN 'USDC'

WHEN MINT = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' THEN 'USDT'

END AS Stablecoin

FROM Solana_Stablecoin_Transfers

GROUP BY DAYS, Stablecoin

ORDER BY DAYS