Query editor
SELECTperiod,-- DAI issued against Collateral-- On Maker Burn (https://makerburn.com/#/rundown)SUM(CASE WHEN ilk = 'ETH-A' THEN exposure ELSE 0 END) AS "ETH-A",SUM(CASE WHEN ilk = 'ETH-B' THEN exposure ELSE 0 END) AS "ETH-B",SUM(CASE WHEN ilk = 'ETH-C' THEN exposure ELSE 0 END) AS "ETH-C",SUM(CASE WHEN ilk = 'WBTC-A' THEN exposure ELSE 0 END) AS "WBTC-A",SUM(CASE WHEN ilk = 'WBTC-B' THEN exposure ELSE 0 END) AS "WBTC-B",SUM(CASE WHEN ilk = 'WBTC-C' THEN exposure ELSE 0 END) AS "WBTC-C",SUM(CASE WHEN ilk = 'WSTETH-A' THEN exposure ELSE 0 END) AS "WSTETH-A",SUM(CASE WHEN ilk = 'WSTETH-B' THEN exposure ELSE 0 END) AS "WSTETH-B",SUM(CASE WHEN ilk = 'UNIV2DAIUSDC-A' THEN exposure ELSE 0 END) AS "UNIV2DAIUSDC-A",SUM(CASE WHEN ilk = 'DIRECT-SPARK-DAI' THEN exposure ELSE 0 END) AS "DIRECT-SPARK-DAI",SUM(CASE WHEN ilk = 'DIRECT-SPARK-MORPHO-DAI' THEN exposure ELSE 0 END) AS "DIRECT-SPARK-MORPHO-DAI",SUM(CASE WHEN ilk = 'TELEPORT-FW-A' THEN exposure ELSE 0 END) AS "TELEPORT-FW-A",SUM(CASE WHEN ilk = 'LITE-PSM-USDC-A' THEN exposure ELSE 0 END) AS "PSM LITE (USDC)",SUM(CASE WHEN ilk = 'PSM-USDC-A' THEN exposure ELSE 0 END) AS "PSM (USDC)",SUM(CASE WHEN ilk = 'PSM-PAX-A' THEN exposure ELSE 0 END) AS "PSM (USDP)",SUM(CASE WHEN ilk = 'PSM-GUSD-A' THEN exposure ELSE 0 END) AS "PSM (GUSD)",SUM(CASE WHEN ilk = 'RWA014-A' THEN exposure ELSE 0 END) AS "Coinbase Custody", -- USDC-- DAI issued against Collateral-- Past and Other Crypto-Backed exposureSUM(CASE WHEN ilk = 'BAT-A' THEN exposure ELSE 0 END) AS "BAT-A",SUM(CASE WHEN ilk = 'TUSD-A' THEN exposure ELSE 0 END) AS "TUSD-A",SUM(CASE WHEN ilk = 'ZRX-A' THEN exposure ELSE 0 END) AS "ZRX-A",SUM(CASE WHEN ilk = 'KNC-A' THEN exposure ELSE 0 END) AS "KNC-A",SUM(CASE WHEN ilk = 'MANA-A' THEN exposure ELSE 0 END) AS "MANA-A",SUM(CASE WHEN ilk = 'LRC-A' THEN exposure ELSE 0 END) AS "LRC-A",SUM(CASE WHEN ilk = 'LINK-A' THEN exposure ELSE 0 END) AS "LINK-A",SUM(CASE WHEN ilk = 'COMP-A' THEN exposure ELSE 0 END) AS "COMP-A",SUM(CASE WHEN ilk = 'YFI-A' THEN exposure ELSE 0 END) AS "YFI-A",SUM(CASE WHEN ilk = 'BAL-A' THEN exposure ELSE 0 END) AS "BAL-A",SUM(CASE WHEN ilk = 'UNI-A' THEN exposure ELSE 0 END) AS "UNI-A",SUM(CASE WHEN ilk = 'RENBTC-A' THEN exposure ELSE 0 END) AS "RENBTC-A",SUM(CASE WHEN ilk = 'UNIV2DAIETH-A' THEN exposure ELSE 0 END) AS "UNIV2DAIETH-A",SUM(CASE WHEN ilk = 'AAVE-A' THEN exposure ELSE 0 END) AS "AAVE-A",SUM(CASE WHEN ilk = 'UNIV2WBTCETH-A' THEN exposure ELSE 0 END) AS "UNIV2WBTCETH-A",SUM(CASE WHEN ilk = 'UNIV2USDCETH-A' THEN exposure ELSE 0 END) AS "UNIV2USDCETH-A",SUM(CASE WHEN ilk = 'UNIV2UNIETH-A' THEN exposure ELSE 0 END) AS "UNIV2UNIETH-A",SUM(CASE WHEN ilk = 'UNIV2LINKETH-A' THEN exposure ELSE 0 END) AS "UNIV2LINKETH-A",SUM(CASE WHEN ilk = 'UNIV2ETHUSDT-A' THEN exposure ELSE 0 END) AS "UNIV2ETHUSDT-A",SUM(CASE WHEN ilk = 'UNIV2DAIUSDC-A' THEN exposure ELSE 0 END) AS "UNIV2DAIUSDC-A",SUM(CASE WHEN ilk = 'UNIV2WBTCDAI-A' THEN exposure ELSE 0 END) AS "UNIV2WBTCDAI-A",SUM(CASE WHEN ilk = 'UNIV2AAVEETH-A' THEN exposure ELSE 0 END) AS "UNIV2AAVEETH-A",SUM(CASE WHEN ilk = 'MATIC-A' THEN exposure ELSE 0 END) AS "MATIC-A",SUM(CASE WHEN ilk = 'GUNIV3DAIUSDC1-A' THEN exposure ELSE 0 END) AS "GUNIV3DAIUSDC1-A",SUM(CASE WHEN ilk = 'DIRECT-AAVEV2-DAI' THEN exposure ELSE 0 END) AS "DIRECT-AAVEV2-DAI",SUM(CASE WHEN ilk = 'GUNIV3DAIUSDC2-A' THEN exposure ELSE 0 END) AS "GUNIV3DAIUSDC2-A",SUM(CASE WHEN ilk = 'CRVV1ETHSTETH-A' THEN exposure ELSE 0 END) AS "CRVV1ETHSTETH-A",SUM(CASE WHEN ilk = 'RETH-A' THEN exposure ELSE 0 END) AS "RETH-A",SUM(CASE WHEN ilk = 'DIRECT-COMPV2-DAI' THEN exposure ELSE 0 END) AS "DIRECT-COMPV2-DAI",SUM(CASE WHEN ilk = 'GNO-A' THEN exposure ELSE 0 END) AS "GNO-A",SUM(CASE WHEN ilk = 'ALLOCATOR-SPARK-A' THEN exposure ELSE 0 END) AS "ALLOCATOR-SPARK-A",-- Stability Fee-- On Maker Burn (https://makerburn.com/#/rundown)SUM(CASE WHEN ilk = 'ETH-A' THEN rate ELSE 0 END) AS "ETH-A Rate",SUM(CASE WHEN ilk = 'ETH-B' THEN rate ELSE 0 END) AS "ETH-B Rate",SUM(CASE WHEN ilk = 'ETH-C' THEN rate ELSE 0 END) AS "ETH-C Rate",SUM(CASE WHEN ilk = 'WBTC-A' THEN rate ELSE 0 END) AS "WBTC-A Rate",