Query editor
withleverage as (selectcast(sizeChanged as decimal) / 1e30 as volume,account as address,'1' as pnl_sig,'0' as pnl_abs,cast(feeValue as decimal) / 1e30 as feefromlevel_finance_bnb.Pool_evt_IncreasePositionunion allselectcast(sizeChanged as decimal) / 1e30 as volume,account as address,json_query(pnl, 'lax $.sig') as pnl_sig,json_query(pnl, 'lax $.abs') as pnl_abs,cast(feeValue as decimal) / 1e30 as feefromlevel_finance_bnb.Pool_evt_DecreasePositionunion allselect0 as volume,account as address,json_query(pnl, 'lax $.sig') as pnl_sig,json_query(pnl, 'lax $.abs') as pnl_abs,cast(feeValue as decimal) / 1e30 as feefromlevel_finance_bnb.Pool_evt_LiquidatePosition),temp as (selectaddress,volume,fee,case pnl_sigwhen '1' then cast(pnl_abs as decimal) / 1e30else cast(pnl_abs as decimal) / -1e30end as pnlfromleverage)selectaddress,sum(volume) as volume,sum(fee) as fee,sum(pnl) as pnlfromtempgroup byaddressorder by volume desc