Query editor
WITH daily_supply AS (SELECTdate_trunc('day', evt_block_time) AS day,SUM(CASE WHEN "to" = 0x0000000000000000000000000000000000000000 THEN -CAST(value AS double) / 1e18WHEN "from" = 0x0000000000000000000000000000000000000000 THEN CAST(value AS double) / 1e18ELSE 0 END) AS usds_net_mintFROM erc20_ethereum.evt_TransferWHERE contract_address = 0xdC035D45d973E3EC169d2276DDab16f1e407384FGROUP BY 1),usds_supply AS (SELECTday,SUM(usds_net_mint) OVER (ORDER BY day) AS total_usds_supplyFROM daily_supply),susds_balance AS (SELECTdate_trunc('day', evt_block_time) AS day,SUM(CASE WHEN "to" = 0xa3931d71877C0E7a3148CB7Eb4463524FEc27fbD THEN CAST(value AS double) / 1e18WHEN "from" = 0xa3931d71877C0E7a3148CB7Eb4463524FEc27fbD THEN -CAST(value AS double) / 1e18ELSE 0 END) AS susds_net_depositFROM erc20_ethereum.evt_TransferWHERE contract_address = 0xdC035D45d973E3EC169d2276DDab16f1e407384FGROUP BY 1),susds_tvl AS (SELECTday,SUM(susds_net_deposit) OVER (ORDER BY day) AS total_susds_depositsFROM susds_balance)SELECTu.day,u.total_usds_supply / 1e6 AS usds_supply_millions,s.total_susds_deposits / 1e6 AS susds_deposits_millions,CASE WHEN u.total_usds_supply > 0THEN s.total_susds_deposits / u.total_usds_supply * 100ELSE 0 END AS susds_pct_of_supplyFROM usds_supply uLEFT JOIN susds_tvl s ON u.day = s.dayWHERE u.day >= DATE '2024-09-01'AND u.total_usds_supply > 0ORDER BY u.day