Query editor
WITH All_Silos AS (SELECT 'ARB' 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_ARB_evt_DepositUNION ALLSELECT 'ARB' 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_ARB_evt_WithdrawUNION ALLSELECT 'ARB' 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_ARB_evt_BorrowUNION ALLSELECT 'ARB' 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_ARB_evt_RepayUNION ALLSELECT 'ARB' 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_ARB_evt_LiquidateUNION ALLSELECT 'wstETH' 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_wstETH_evt_DepositUNION ALLSELECT 'wstETH' 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_wstETH_evt_WithdrawUNION ALLSELECT 'wstETH' 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_wstETH_evt_BorrowUNION ALLSELECT 'wstETH' 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_wstETH_evt_RepayUNION ALLSELECT 'wstETH' 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_wstETH_evt_LiquidateUNION ALLSELECT 'WBTC' 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_wbtc_evt_DepositUNION ALLSELECT 'WBTC' 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_wbtc_evt_WithdrawUNION ALLSELECT 'WBTC' 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_wbtc_evt_BorrowUNION ALLSELECT 'WBTC' 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_wbtc_evt_RepayUNION ALLSELECT 'WBTC' 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_wbtc_evt_LiquidateUNION ALLSELECT 'rETH' 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_RETH_evt_DepositUNION ALLSELECT 'rETH' 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_RETH_evt_WithdrawUNION ALLSELECT 'rETH' 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_RETH_evt_BorrowUNION ALLSELECT 'rETH' 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_RETH_evt_RepayUNION ALLSELECT 'rETH' 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_RETH_evt_LiquidateUNION ALLSELECT 'PENDLE' 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_PENDLE_evt_DepositUNION ALLSELECT 'PENDLE' 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_PENDLE_evt_WithdrawUNION ALLSELECT 'PENDLE' 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_PENDLE_evt_BorrowUNION ALLSELECT 'PENDLE' 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_PENDLE_evt_RepayUNION ALLSELECT 'PENDLE' 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_PENDLE_evt_LiquidateUNION ALLSELECT 'PT-eETH(25 Apr)' 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_PT_eETH_evt_DepositUNION ALLSELECT 'PT-eETH(25 Apr)' 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_PT_eETH_evt_WithdrawUNION ALL