Query editor
--------------------------------------------- Calculating CollateralOnly Amount ---------------------------------------------WITH Collateral_Only AS (WITH Silos AS (----------------------- pzETH -----------------------SELECTevt_block_time, 'pzETH' AS Silo, asset, CAST(amount AS DOUBLE) AS amountFROM silo_ethereum.Silo_Ethereum_pzETH_evt_DepositWHERE collateralOnlyUNION ALLSELECTevt_block_time, 'pzETH' AS Silo, asset, -1 * CAST(amount AS DOUBLE) AS amountFROM silo_ethereum.Silo_Ethereum_pzETH_evt_WithdrawWHERE collateralOnlyUNION ALL----------------------- Re7LRT -----------------------SELECTevt_block_time, 'Re7LRT' AS Silo, asset, CAST(amount AS DOUBLE) AS amountFROM silo_ethereum.Silo_Ethereum_Re7LRT_evt_DepositWHERE collateralOnlyUNION ALLSELECTevt_block_time, 'Re7LRT' AS Silo, asset, -1 * CAST(amount AS DOUBLE) AS amountFROM silo_ethereum.Silo_Ethereum_Re7LRT_evt_WithdrawWHERE collateralOnlyUNION ALL----------------------- amphrETH -----------------------SELECTevt_block_time, 'amphrETH' AS Silo, asset, CAST(amount AS DOUBLE) AS amountFROM silo_ethereum.Silo_Ethereum_amphrETH_evt_DepositWHERE collateralOnlyUNION ALLSELECTevt_block_time, 'amphrETH' AS Silo, asset, -1 * CAST(amount AS DOUBLE) AS amount