Ez Stablecoins Supply

-- Latest supply metrics by stablecoin
SELECT 
    label AS stablecoin,
    total_supply,
    amount_in_dex_liquidity_pools,
    amount_in_lending_pools
FROM <blockchain_name>.defi.ez_stablecoins_supply
WHERE block_date = CURRENT_DATE - 1
ORDER BY total_supply DESC;

-- Daily supply changes for a specific stablecoin
SELECT 
    block_date,
    symbol,
    total_supply,
    amount_minted - LAG(amount_minted) OVER (PARTITION BY contract_address ORDER BY block_date) AS daily_minted,
    amount_burned - LAG(amount_burned) OVER (PARTITION BY contract_address ORDER BY block_date) AS daily_burned
FROM <blockchain_name>.defi.ez_stablecoins_supply
WHERE symbol = 'USDC'
    AND block_date >= CURRENT_DATE - 30
ORDER BY block_date DESC;

-- Stablecoin distribution analysis
SELECT 
    block_date,
    label AS stablecoin,
    amount_in_bridges / NULLIF(total_supply, 0) AS pct_in_bridge,
    amount_in_dex_liquidity_pools / NULLIF(total_supply, 0) AS pct_in_dex,
    amount_in_lending_pools / NULLIF(total_supply, 0) AS pct_in_lending,
    amount_in_cex / NULLIF(total_supply, 0) AS pct_in_cex
FROM <blockchain_name>.defi.ez_stablecoins_supply
WHERE block_date = CURRENT_DATE - 1
    AND total_supply > 0
ORDER BY total_supply DESC;