Query editor
WITH tether_addresses AS (-- 🧱 Collect only relevant Ethereum mint/redeem/destroy addressesSELECT DISTINCT LOWER(CAST(evt_tx_from AS VARCHAR)) AS addr, 'mint' AS typeFROM tether_multichain.tether_usd_evt_issueWHERE chain = 'ethereum'UNIONSELECT DISTINCT LOWER(CAST(evt_tx_to AS VARCHAR)) AS addr, 'redeem' AS typeFROM tether_multichain.tether_usd_evt_redeemWHERE chain = 'ethereum'UNIONSELECT DISTINCT LOWER(CAST(evt_tx_to AS VARCHAR)) AS addr, 'destroy' AS typeFROM tether_ethereum.Tether_USD_evt_DestroyedBlackFunds),thether_supply AS (SELECTDATE_TRUNC('day', evt_block_time) AS date,'USDT' AS symbol,'ethereum' AS chain,SUM(amount / 1e6) AS minted,0 AS redeemed,0 AS destroyedFROM tether_multichain.tether_usd_evt_issueWHERE chain = 'ethereum'GROUP BY 1,2,3UNION ALLSELECTDATE_TRUNC('day', evt_block_time),'USDT','ethereum',0,SUM(amount / 1e6),0FROM tether_multichain.tether_usd_evt_redeemWHERE chain = 'ethereum'GROUP BY 1,2,3UNION ALLSELECTDATE_TRUNC('day', evt_block_time),'USDT','ethereum',0,0,SUM(_balance / 1e6)FROM tether_ethereum.Tether_USD_evt_DestroyedBlackFundsGROUP BY 1,2,3),thether_daily AS (SELECT