Query editor
--------------------------------------------- Calculating CollateralOnly Amount ---------------------------------------------WITH Collateral_Only AS (WITH Silos AS (----------------------- ARB -----------------------SELECTevt_block_time, 'ARB' AS Silo, asset, CAST(amount AS DOUBLE) AS amountFROM silo_finance_arbitrum.Silo_ARB_evt_DepositWHERE collateralOnlyUNION ALLSELECTevt_block_time, 'ARB' AS Silo, asset, -1 * CAST(amount AS DOUBLE) AS amountFROM silo_finance_arbitrum.Silo_ARB_evt_WithdrawWHERE collateralOnlyUNION ALL----------------------- wstETH -----------------------SELECTevt_block_time, 'wstETH' AS Silo, asset, CAST(amount AS DOUBLE) AS amountFROM silo_finance_arbitrum.Silo_wstETH_evt_DepositWHERE collateralOnlyUNION ALLSELECTevt_block_time, 'wstETH' AS Silo, asset, -1 * CAST(amount AS DOUBLE) AS amountFROM silo_finance_arbitrum.Silo_wstETH_evt_WithdrawWHERE collateralOnlyUNION ALL----------------------- WBTC -----------------------SELECTevt_block_time, 'WBTC' AS Silo, asset, CAST(amount AS DOUBLE) AS amountFROM silo_finance_arbitrum.Silo_wbtc_evt_DepositWHERE collateralOnlyUNION ALLSELECTevt_block_time, 'WBTC' AS Silo, asset, -1 * CAST(amount AS DOUBLE) AS amount