Query editor
-- Cumulative per-subaccount volume (quote terms). Set {{cutoff_ts}} to a UNIX timestamp in seconds-- (e.g. 1733798400 for 2024-12-10 00:00:00 UTC). Use 0 for all-time.WITH params AS (-- Use TRY_CAST so missing/blank param doesn't break parsing; default to 0 (all-time)SELECT COALESCE(TRY_CAST('{{cutoff_ts}}' AS BIGINT), 0) AS cutoff_ts),fills AS (SELECTblock_time,CONCAT('0x', LOWER(SUBSTRING(CAST(topic3 AS VARCHAR), 3, 64))) AS subaccount,CAST(BYTEARRAY_TO_INT256(BYTEARRAY_SUBSTRING(data, 1 + 32 * 9, 32)) AS DOUBLE) / 1e18 AS quote_deltaFROM ink.logsWHERE contract_address = 0x8373C3Aa04153aBc0cfD28901c3c971a946994abAND topic0 = 0xb563bd3722620e7af6c3dae109897ca2f45fbbc5975fb6553bb2d53b77e54bf3AND ((SELECT cutoff_ts FROM params) = 0OR block_time <= FROM_UNIXTIME((SELECT cutoff_ts FROM params)))),agg AS (SELECTsubaccount,SUM(ABS(quote_delta)) AS volume_quoteFROM fillsGROUP BY subaccount),as_of_cte AS (SELECTCASEWHEN p.cutoff_ts = 0 THEN MAX(f.block_time)ELSE FROM_UNIXTIME(p.cutoff_ts)END AS as_ofFROM params pLEFT JOIN fills f ON TRUEGROUP BY p.cutoff_ts)SELECTas_of_cte.as_of,subaccount,ROUND(volume_quote, 4) AS volume_quoteFROM aggCROSS JOIN as_of_cteORDER BY volume_quote DESC;