Query editor
-- ============================================================-- API3 Treasury Assets (Daily) — consolidated & optimized-- Drop-in replacement for query 6604104 ("Api3 Treasury").-- Same output columns, self-contained (no query_NNN references).---- vs the 6-sub-query chain:-- * vault share flows + supply mints/burns in one scan (was 2)-- * vault accruals + deposit/withdraw samples in one scan (was 2)-- * all pricing via prices.day instead of minute-level prices.usd-- * every scan keeps a single-contract-set filter so partition pruning-- stays tight (merging unrelated scans with OR raised credit cost)-- ============================================================WITH days AS (SELECT day FROM UNNEST(SEQUENCE(DATE '2025-12-01', CURRENT_DATE, INTERVAL '1' DAY)) AS t(day)),-- ---------------- daily prices (partition-pruned, day granularity) ----------------px AS (SELECT CAST(timestamp AS DATE) AS day, contract_address, priceFROM prices.dayWHERE blockchain = 'ethereum'AND contract_address IN (0x0b38210ea11411557c13457D4dA7dC6ea731B88a, -- API30xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2, -- WETH0x7f39C581F595B53c5cb19bD0b3f8dA6c935E2Ca0 -- wstETH)AND timestamp >= TIMESTAMP '2025-12-01'),api3_px AS (SELECT day, price FROM px WHERE contract_address = 0x0b38210ea11411557c13457D4dA7dC6ea731B88a),eth_px AS (SELECT day, price FROM px WHERE contract_address = 0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2),wsteth_px AS (SELECT day, price FROM px WHERE contract_address = 0x7f39C581F595B53c5cb19bD0b3f8dA6c935E2Ca0),-- ---------------- wallet token flows (separate scans keep partition pruning tight) ----------------usdc_flows AS (SELECT DATE_TRUNC('day', evt_block_time) AS day,SUM(CASE WHEN "to" IN (0x8e03609ed680B237C7b6f8020472CA0687308b24, 0xBBE0dE9757F93e3306aDBfeBE906AB285EDD13DA,0xD9F80Bdb37E6Bad114D747E60cE6d2aaF26704Ae, 0x556ecbb0311d350491ba0ec7e019c354d7723ce0, 0xb7fa2cb302c5dc127e61f27b92bec411cbf0ae4a,0x2df880C697B65b52A79FA3322Ee8A2bBFF21F0Ef, 0x5a9AA3219dD1cBEF6A18Fd221464E071DF2677c2) THEN CAST(value AS DOUBLE) ELSE 0 END) / 1e6 -SUM(CASE WHEN "from" IN (0x8e03609ed680B237C7b6f8020472CA0687308b24, 0xBBE0dE9757F93e3306aDBfeBE906AB285EDD13DA,0xD9F80Bdb37E6Bad114D747E60cE6d2aaF26704Ae, 0x556ecbb0311d350491ba0ec7e019c354d7723ce0, 0xb7fa2cb302c5dc127e61f27b92bec411cbf0ae4a,0x2df880C697B65b52A79FA3322Ee8A2bBFF21F0Ef, 0x5a9AA3219dD1cBEF6A18Fd221464E071DF2677c2) THEN CAST(value AS DOUBLE) ELSE 0 END) / 1e6 AS net_flowFROM erc20_ethereum.evt_TransferWHERE contract_address = 0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48AND ("to" IN (0x8e03609ed680B237C7b6f8020472CA0687308b24, 0xBBE0dE9757F93e3306aDBfeBE906AB285EDD13DA,0xD9F80Bdb37E6Bad114D747E60cE6d2aaF26704Ae, 0x556ecbb0311d350491ba0ec7e019c354d7723ce0, 0xb7fa2cb302c5dc127e61f27b92bec411cbf0ae4a,0x2df880C697B65b52A79FA3322Ee8A2bBFF21F0Ef, 0x5a9AA3219dD1cBEF6A18Fd221464E071DF2677c2)OR "from" IN (0x8e03609ed680B237C7b6f8020472CA0687308b24, 0xBBE0dE9757F93e3306aDBfeBE906AB285EDD13DA,0xD9F80Bdb37E6Bad114D747E60cE6d2aaF26704Ae, 0x556ecbb0311d350491ba0ec7e019c354d7723ce0, 0xb7fa2cb302c5dc127e61f27b92bec411cbf0ae4a,0x2df880C697B65b52A79FA3322Ee8A2bBFF21F0Ef, 0x5a9AA3219dD1cBEF6A18Fd221464E071DF2677c2))AND evt_block_time >= TIMESTAMP '2025-12-01'GROUP BY 1),api3_flows AS (SELECT DATE_TRUNC('day', evt_block_time) AS day,SUM(CASE WHEN "to" IN (0x8e03609ed680B237C7b6f8020472CA0687308b24, 0xBBE0dE9757F93e3306aDBfeBE906AB285EDD13DA,0xD9F80Bdb37E6Bad114D747E60cE6d2aaF26704Ae, 0x556ecbb0311d350491ba0ec7e019c354d7723ce0, 0xb7fa2cb302c5dc127e61f27b92bec411cbf0ae4a) THEN CAST(value AS DOUBLE) ELSE 0 END) / 1e18 -SUM(CASE WHEN "from" IN (0x8e03609ed680B237C7b6f8020472CA0687308b24, 0xBBE0dE9757F93e3306aDBfeBE906AB285EDD13DA,0xD9F80Bdb37E6Bad114D747E60cE6d2aaF26704Ae, 0x556ecbb0311d350491ba0ec7e019c354d7723ce0, 0xb7fa2cb302c5dc127e61f27b92bec411cbf0ae4a) THEN CAST(value AS DOUBLE) ELSE 0 END) / 1e18 AS net_flowFROM erc20_ethereum.evt_TransferWHERE contract_address = 0x0b38210ea11411557c13457D4dA7dC6ea731B88a