Query editor
withbalance_SiloFinance AS (SELECTblock_time, SUM(output) AS amountFROM (SELECT'Deposit on Silo' AS evt_type,evt_block_time AS block_time,evt_tx_hash AS tx_hash,(assets/1e18) AS outputFROM silo_finance_v2_sonic.silo1_id3_evt_depositWHERE 1=1 AND"owner" = 0x7d4c78a4d8a5cbfeec4a3498885749079fab590cUNION ALLSELECT'Withdraw from Silo' AS evt_type,evt_block_time AS block_time,evt_tx_hash AS tx_hash,(-1)*(assets/1e18) AS outputFROM silo_finance_v2_sonic.silo1_id3_evt_withdrawWHERE 1=1 AND"owner" = 0x7d4c78a4d8a5cbfeec4a3498885749079fab590c)GROUP BY 1,outputORDER BY block_time DESCLIMIT 1)SELECT * FROM balance_SiloFinance