Query editor
WITH erc20_stable_contracts_eth AS (SELECT*FROM query_3071683),data AS (SELECTtime,SUM(CAST(amounts AS DOUBLE)) FILTER (WHERE category = 'Fiat-collateralized') AS fiat_supply,SUM(CAST(amounts AS DOUBLE)) FILTER (WHERE category = 'Crypto over-Collateralized') AS crypto_supply,SUM(CAST(amounts AS DOUBLE)) FILTER (WHERE category = 'Algorithmic') AS algo_supplyFROM (SELECTDATE_TRUNC('day', evt_block_time) AS time,eth.category,-SUM(value/POW(10, decimals)) AS amountsFROM erc20_ethereum.evt_Transfer AS trLEFT JOIN erc20_stable_contracts_eth AS eth ON eth.contract_address = tr.contract_addressWHERE tr.contract_address IN (SELECT contract_address FROM erc20_stable_contracts_eth)AND "to" = 0x0000000000000000000000000000000000000000AND evt_block_time >= TIMESTAMP '2017-01-01'GROUP BY 1,2UNION ALLSELECTDATE_TRUNC('day', evt_block_time) AS time,eth.category,SUM(value/POW(10, decimals)) AS amountsFROM erc20_ethereum.evt_Transfer AS trLEFT JOIN erc20_stable_contracts_eth AS eth ON eth.contract_address = tr.contract_addressWHERE tr.contract_address IN (SELECT contract_address FROM erc20_stable_contracts_eth)AND "from" = 0x0000000000000000000000000000000000000000AND evt_block_time >= TIMESTAMP '2017-01-01'GROUP BY 1,2UNION ALLSELECTDATE_TRUNC('day', evt_block_time) AS time,eth.category,-SUM(value/POW(10, decimals)) AS amountsFROM erc20_ethereum.evt_Transfer AS trLEFT JOIN erc20_stable_contracts_eth AS eth ON eth.contract_address = tr.contract_addressWHERE tr.contract_address IN (SELECT contract_address FROM erc20_stable_contracts_ethWHERE symbol = 'USDT')AND "to" = 0xc6cde7c39eb2f0f0095f41570af89efc2c1ea828AND evt_block_time >= TIMESTAMP '2017-01-01'GROUP BY 1,2UNION ALL