Query editor
with prices_all as(selectcontract_address,ROW_NUMBER() OVER (PARTITION BY contract_address ORDER BY evt_block_time DESC) as index,"lastPrice" / 1e18 as pricefrom synthetix."FuturesMarket_evt_PositionModified"),prices as(select contract_address, price from prices_all where index = 1),pnl as (selectaccount,t1.contract_address,max(date_trunc('week', t1.evt_block_time)) as time,sum("tradeSize") as size,- sum("lastPrice" * "tradeSize") / 1e36 - sum("fee" / 1e18) + sum("tradeSize") * max(price) / 1e18 as PNL,- sum("lastPrice" * "tradeSize") / 1e36 + sum("tradeSize") * max(price) / 1e18 as PNL_grossfrom synthetix."FuturesMarket_evt_PositionModified" as t1 left join prices as t2 on t1.contract_address = t2.contract_addressgroup by account, t1.contract_address),pnl_open as(selecttime,sum(PNL) as "Net PNL",sum(PNL_gross) as "Gross PNL"from pnlwhere size <> 0group by time)select * from pnl_open