Query editor
--------------------------------------------- Calculating CollateralOnly Amount ---------------------------------------------WITH Collateral_Only AS (WITH Silos AS (----------------------- wstETH -----------------------SELECTevt_block_time, 'wstETH' AS Silo, asset, CAST(amount AS DOUBLE) AS amountFROM silo_ethereum.Silo_wstETH_evt_DepositWHERE collateralOnlyUNION ALLSELECTevt_block_time, 'wstETH' AS Silo, asset, -1 * CAST(amount AS DOUBLE) AS amountFROM silo_ethereum.Silo_wstETH_evt_WithdrawWHERE collateralOnlyUNION ALL----------------------- weETH -----------------------SELECTevt_block_time, 'weETH' AS Silo, asset, CAST(amount AS DOUBLE) AS amountFROM silo_ethereum.Silo_weETH_evt_DepositWHERE collateralOnlyUNION ALLSELECTevt_block_time, 'weETH' AS Silo, asset, -1 * CAST(amount AS DOUBLE) AS amountFROM silo_ethereum.Silo_weETH_evt_WithdrawWHERE collateralOnlyUNION ALL----------------------- WBTC -----------------------SELECTevt_block_time, 'WBTC' AS Silo, asset, CAST(amount AS DOUBLE) AS amountFROM silo_ethereum.Silo_WBTC_evt_DepositWHERE collateralOnlyUNION ALLSELECTevt_block_time, 'WBTC' AS Silo, asset, -1 * CAST(amount AS DOUBLE) AS amount