Query editor
WITH All_Silos AS (SELECT 'DLCBTC' AS Silo, evt_block_time, contract_address, amount, 'Deposit' AS Action, asset, depositor AS user, evt_tx_hash, 'arbitrum' AS blockchain, collateralOnly FROM silo_finance_arbitrum.DLCBTC_evt_DepositUNION ALLSELECT 'DLCBTC' AS Silo, evt_block_time, contract_address, -amount AS amount, 'Withdraw' AS Action, asset, depositor AS user, evt_tx_hash, 'arbitrum' AS blockchain, collateralOnly FROM silo_finance_arbitrum.DLCBTC_evt_WithdrawUNION ALLSELECT 'DLCBTC' AS Silo, evt_block_time, contract_address, -amount AS amount, 'Borrow' AS Action, asset, user, evt_tx_hash, 'arbitrum' AS blockchain, NULL AS collateralOnly FROM silo_finance_arbitrum.DLCBTC_evt_BorrowUNION ALLSELECT 'DLCBTC' AS Silo, evt_block_time, contract_address, amount, 'Repay' AS Action, asset, user, evt_tx_hash, 'arbitrum' AS blockchain, NULL AS collateralOnly FROM silo_finance_arbitrum.DLCBTC_evt_RepayUNION ALLSELECT 'DLCBTC' AS Silo, evt_block_time, contract_address, - seizedCollateral AS amount, 'Liquidate' AS Action, asset, user, evt_tx_hash, 'arbitrum' AS blockchain, NULL AS collateralOnly FROM silo_finance_arbitrum.DLCBTC_evt_LiquidateUNION ALLSELECT 'DPX' AS Silo, evt_block_time, contract_address, amount, 'Deposit' AS Action, asset, depositor AS user, evt_tx_hash, 'arbitrum' AS blockchain, collateralOnly FROM silo_finance_arbitrum.Silo_DPX_evt_DepositUNION ALLSELECT 'DPX' AS Silo, evt_block_time, contract_address, -amount AS amount, 'Withdraw' AS Action, asset, depositor AS user, evt_tx_hash, 'arbitrum' AS blockchain, collateralOnly FROM silo_finance_arbitrum.Silo_DPX_evt_WithdrawUNION ALLSELECT 'DPX' AS Silo, evt_block_time, contract_address, -amount AS amount, 'Borrow' AS Action, asset, user, evt_tx_hash, 'arbitrum' AS blockchain, NULL AS collateralOnly FROM silo_finance_arbitrum.Silo_DPX_evt_BorrowUNION ALLSELECT 'DPX' AS Silo, evt_block_time, contract_address, amount, 'Repay' AS Action, asset, user, evt_tx_hash, 'arbitrum' AS blockchain, NULL AS collateralOnly FROM silo_finance_arbitrum.Silo_DPX_evt_RepayUNION ALLSELECT 'DPX' AS Silo, evt_block_time, contract_address,- seizedCollateral AS amount, 'Liquidate' AS Action, asset, user, evt_tx_hash, 'arbitrum' AS blockchain, NULL AS collateralOnly FROM silo_finance_arbitrum.Silo_DPX_evt_LiquidateUNION ALLSELECT 'ETH+' AS Silo, evt_block_time, contract_address, amount, 'Deposit' AS Action, asset, depositor AS user, evt_tx_hash, 'arbitrum' AS blockchain, collateralOnly FROM silo_finance_arbitrum.ETH_plus_evt_DepositUNION ALLSELECT 'ETH+' AS Silo, evt_block_time, contract_address, -amount AS amount, 'Withdraw' AS Action, asset, depositor AS user, evt_tx_hash, 'arbitrum' AS blockchain, collateralOnly FROM silo_finance_arbitrum.ETH_plus_evt_WithdrawUNION ALLSELECT 'ETH+' AS Silo, evt_block_time, contract_address, -amount AS amount, 'Borrow' AS Action, asset, user, evt_tx_hash, 'arbitrum' AS blockchain, NULL AS collateralOnly FROM silo_finance_arbitrum.ETH_plus_evt_BorrowUNION ALLSELECT 'ETH+' AS Silo, evt_block_time, contract_address, amount, 'Repay' AS Action, asset, user, evt_tx_hash, 'arbitrum' AS blockchain, NULL AS collateralOnly FROM silo_finance_arbitrum.ETH_plus_evt_RepayUNION ALLSELECT 'ETH+' AS Silo, evt_block_time, contract_address, - seizedCollateral AS amount, 'Liquidate' AS Action, asset, user, evt_tx_hash, 'arbitrum' AS blockchain, NULL AS collateralOnly FROM silo_finance_arbitrum.ETH_plus_evt_LiquidateUNION ALLSELECT 'gUSDC' AS Silo, evt_block_time, contract_address, amount, 'Deposit' AS Action, asset, depositor AS user, evt_tx_hash, 'arbitrum' AS blockchain, collateralOnly FROM silo_finance_arbitrum.gUSDC_evt_DepositUNION ALLSELECT 'gUSDC' AS Silo, evt_block_time, contract_address, -amount AS amount, 'Withdraw' AS Action, asset, depositor AS user, evt_tx_hash, 'arbitrum' AS blockchain, collateralOnly FROM silo_finance_arbitrum.gUSDC_evt_WithdrawUNION ALLSELECT 'gUSDC' AS Silo, evt_block_time, contract_address, -amount AS amount, 'Borrow' AS Action, asset, user, evt_tx_hash, 'arbitrum' AS blockchain, NULL AS collateralOnly FROM silo_finance_arbitrum.gUSDC_evt_BorrowUNION ALLSELECT 'gUSDC' AS Silo, evt_block_time, contract_address, amount, 'Repay' AS Action, asset, user, evt_tx_hash, 'arbitrum' AS blockchain, NULL AS collateralOnly FROM silo_finance_arbitrum.gUSDC_evt_RepayUNION ALLSELECT 'gUSDC' AS Silo, evt_block_time, contract_address, - seizedCollateral AS amount, 'Liquidate' AS Action, asset, user, evt_tx_hash, 'arbitrum' AS blockchain, NULL AS collateralOnly FROM silo_finance_arbitrum.gUSDC_evt_LiquidateUNION ALLSELECT 'JOE' AS Silo, evt_block_time, contract_address, amount, 'Deposit' AS Action, asset, depositor AS user, evt_tx_hash, 'arbitrum' AS blockchain, collateralOnly FROM silo_finance_arbitrum.Silo_JOE_evt_DepositUNION ALLSELECT 'JOE' AS Silo, evt_block_time, contract_address, -amount AS amount, 'Withdraw' AS Action, asset, depositor AS user, evt_tx_hash, 'arbitrum' AS blockchain, collateralOnly FROM silo_finance_arbitrum.Silo_JOE_evt_WithdrawUNION ALLSELECT 'JOE' AS Silo, evt_block_time, contract_address, -amount AS amount, 'Borrow' AS Action, asset, user, evt_tx_hash, 'arbitrum' AS blockchain, NULL AS collateralOnly FROM silo_finance_arbitrum.Silo_JOE_evt_BorrowUNION ALLSELECT 'JOE' AS Silo, evt_block_time, contract_address, amount, 'Repay' AS Action, asset, user, evt_tx_hash, 'arbitrum' AS blockchain, NULL AS collateralOnly FROM silo_finance_arbitrum.Silo_JOE_evt_RepayUNION ALLSELECT 'JOE' AS Silo, evt_block_time, contract_address, - seizedCollateral AS amount, 'Liquidate' AS Action, asset, user, evt_tx_hash, 'arbitrum' AS blockchain, NULL AS collateralOnly FROM silo_finance_arbitrum.Silo_JOE_evt_LiquidateUNION ALLSELECT 'PEAS' AS Silo, evt_block_time, contract_address, amount, 'Deposit' AS Action, asset, depositor AS user, evt_tx_hash, 'arbitrum' AS blockchain, collateralOnly FROM silo_finance_arbitrum.PEAS_evt_DepositUNION ALLSELECT 'PEAS' AS Silo, evt_block_time, contract_address, -amount AS amount, 'Withdraw' AS Action, asset, depositor AS user, evt_tx_hash, 'arbitrum' AS blockchain, collateralOnly FROM silo_finance_arbitrum.PEAS_evt_WithdrawUNION ALL