Query editor
--------------------------------------------- Calculating CollateralOnly Amount ---------------------------------------------WITH Collateral_Only AS (WITH Silos AS (----------------------- PT-LBTC (29 May 2025) -----------------------SELECTevt_block_time, 'PT-LBTC (29 May 2025)' AS Silo, asset, CAST(amount AS DOUBLE) AS amountFROM silosilo_finance_base.PT_LBTC_29_May_25_evt_DepositWHERE collateralOnlyUNION ALLSELECTevt_block_time, 'PT-LBTC (29 May 2025)' AS Silo, asset, -1 * CAST(amount AS DOUBLE) AS amountFROM silosilo_finance_base.PT_LBTC_29_May_25_evt_WithdrawWHERE collateralOnlyUNION ALL----------------------- SolvBTC -----------------------SELECTevt_block_time, 'SolvBTC' AS Silo, asset, CAST(amount AS DOUBLE) AS amountFROM silo_finance_base.SolvBTC_evt_DepositWHERE collateralOnlyUNION ALLSELECTevt_block_time, 'SolvBTC' AS Silo, asset, -1 * CAST(amount AS DOUBLE) AS amountFROM silo_finance_base.SolvBTC_evt_WithdrawWHERE collateralOnlyUNION ALL----------------------- LBTC -----------------------SELECTevt_block_time, 'LBTC' AS Silo, asset, CAST(amount AS DOUBLE) AS amountFROM silo_finance_base.LBTC_evt_DepositWHERE collateralOnlyUNION ALLSELECTevt_block_time, 'LBTC' AS Silo, asset, -1 * CAST(amount AS DOUBLE) AS amount