Query editor
--bring in all tablesWITH tables AS (SELECT s.*,m."address" AS market_addr,m."marketKey_str" AS market,CASEWHEN 2+2=4 THEN 'All'END AS all_marketsFROM synthetix."FuturesMarket_evt_PositionLiquidated" sLEFT JOIN (SELECT DISTINCTregexp_replace(replace(encode(asset, 'escape'), '\000', ''), '^s', '') AS asset_str,replace(encode("marketKey", 'escape'), '\000', '') AS "marketKey_str",market AS addressFROM synthetix."FuturesMarketManager_evt_MarketAdded") m ON s.contract_address = m.address),prices AS (SELECTs.contract_address AS market_addr,s.evt_block_time,AVG(s."lastPrice"/1e18) AS priceFROM synthetix."FuturesMarket_evt_PositionModified" sLEFT JOIN tables t on s.contract_address = t.market_addrGROUP BY 1, 2)SELECTCOALESCE(SUM(ABS("size"/1e18)*p.price),0) AS amt_liquidated,market,market AS colorFROM tables sLEFT JOIN prices p ON s.contract_address = p.market_addr AND s.evt_block_time = p.evt_block_timeWHERE 1 = (CASE WHEN '{{show today}}' = 'yes' THEN 1WHEN '{{show today}}' = 'no' AND date_trunc('day',s.evt_block_time) != date_trunc('day', now()) THEN 1ELSE 0END)AND date_trunc('day', s.evt_block_time) > date_trunc('day',now()) - interval '{{trailing num days}} days'GROUP BY 2,3ORDER BY 1 DESC