Query editor
--------------------------------------------- Calculating CollateralOnly Amount ---------------------------------------------WITH Collateral_Only AS (WITH Silos AS (----------------------- ID8 -----------------------SELECTevt_block_time, 'ID8' AS Market, 'S' AS asset, CAST(assets AS DOUBLE) AS amountFROM silo_finance_v2_sonic.silo0_id8_evt_depositprotectedUNION ALLSELECTevt_block_time, 'ID8' AS Market, 'S' AS asset, -1 * CAST(assets AS DOUBLE) AS amountFROM silo_finance_v2_sonic.silo0_id8_evt_withdrawprotectedUNION ALL----------------------- ID23 -----------------------SELECTevt_block_time, 'ID23' AS Market, 'wstkscUSD' AS asset, CAST(assets AS DOUBLE) AS amountFROM silo_finance_v2_sonic.silo0_id23_evt_depositprotectedUNION ALLSELECTevt_block_time, 'ID23' AS Market, 'wstkscUSD' AS asset, -1 * CAST(assets AS DOUBLE) AS amountFROM silo_finance_v2_sonic.silo0_id23_evt_withdrawprotectedUNION ALL----------------------- ID22 -----------------------SELECTevt_block_time, 'ID22' AS Market, 'wOS' AS asset, CAST(assets AS DOUBLE) AS amountFROM silo_finance_v2_sonic.silo0_id22_evt_depositprotectedUNION ALLSELECTevt_block_time, 'ID22' AS Market, 'wOS' AS asset, -1 * CAST(assets AS DOUBLE) AS amountFROM silo_finance_v2_sonic.silo0_id22_evt_withdrawprotectedUNION ALL