Query editor
--------------------------------------------- Calculating CollateralOnly Amount ---------------------------------------------WITH Collateral_Only AS (WITH Silos AS (----------------------- DLCBTC -----------------------SELECTevt_block_time, 'DLCBTC' AS Silo, asset, CAST(amount AS DOUBLE) AS amountFROM silo_finance_arbitrum.DLCBTC_evt_DepositWHERE collateralOnlyUNION ALLSELECTevt_block_time, 'DLCBTC' AS Silo, asset, -1 * CAST(amount AS DOUBLE) AS amountFROM silo_finance_arbitrum.DLCBTC_evt_WithdrawWHERE collateralOnlyUNION ALL----------------------- DPX -----------------------SELECTevt_block_time, 'DPX' AS Silo, asset, CAST(amount AS DOUBLE) AS amountFROM silo_finance_arbitrum.Silo_DPX_evt_DepositWHERE collateralOnlyUNION ALLSELECTevt_block_time, 'DPX' AS Silo, asset, -1 * CAST(amount AS DOUBLE) AS amountFROM silo_finance_arbitrum.Silo_DPX_evt_WithdrawWHERE collateralOnlyUNION ALL----------------------- ETH+ -----------------------SELECTevt_block_time, 'ETH+' AS Silo, asset, CAST(amount AS DOUBLE) AS amountFROM silo_finance_arbitrum.ETH_plus_evt_DepositWHERE collateralOnlyUNION ALLSELECTevt_block_time, 'ETH+' AS Silo, asset, -1 * CAST(amount AS DOUBLE) AS amount