Query editor
--bring in all tablesWITH tables AS (SELECT s.*,"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),time_range AS (SELECT generate_series('20220318', now(), INTERVAL '1 {{period}}') AS time),liq AS (SELECT time, (SELECTCOALESCE(SUM("fee"/1e18),0) AS liq_feesFROM tables sWHERE ((LOWER(market) = '{{market}}' OR LOWER(all_markets) = '{{market}}') OR (market = '{{market}}' OR all_markets = '{{market}}'))AND 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'AND DATE(s.evt_block_time) = time) AS liquidation_fees,(SELECTCOALESCE(SUM("fee"/1e18),0) AS liq_feesFROM tables sWHERE ((LOWER(market) = '{{market}}' OR LOWER(all_markets) = '{{market}}') OR (market = '{{market}}' OR all_markets = '{{market}}'))AND 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'AND DATE(s.evt_block_time) <= time) AS total_feesFROM time_range)SELECT time, liquidation_fees, total_feesFROM liq tWHERE date_trunc('day', time) > date_trunc('day',now()) - interval '{{trailing num days}} days'AND 1 = (CASE WHEN '{{show today}}' = 'yes' THEN 1WHEN '{{show today}}' = 'no' AND date_trunc('day',t.time) != date_trunc('day', now()) THEN 1