SELECT

DATE_TRUNC('{{Granularity}}', date) AS week,

stablecoin,

AVG(circulating) AS avg_circulating

FROM

external.defillama.fact_stablecoin_supply

WHERE

date >= CURRENT_TIMESTAMP - INTERVAL '{{DAYS}} days' AND date < '2024-08-01'

AND circulating > 0

AND stablecoin IN (

'Tether', 'USD Coin', 'Dai', 'Ethena USDe', 'First Digital USD',

'GYEN', 'USDD', 'PayPal USD', 'TrueUSD', 'BlackRock USD',

'Neutrino USD', 'Frax', 'USDB Blast', 'Binance Peg BUSD',

'Ondo US Dollar Yield', 'HUSD', 'CJPY', 'flexUSD', 'Dola',

'Usual USD', 'Pax Dollar', 'crvUSD', 'Gemini Dollar',

'Liquity USD', 'Frax Price Index', 'Tether Gold'

)

GROUP BY

DATE_TRUNC('{{Granularity}}', date),

stablecoin