Query editor
WITHvault_list (contract, vault) AS (VALUES -- ETH, USDC, ARB, weETH, USDT, ARB, wstETH(0xeAbBfca72F8a8bf14C4ac59e69ECB2eB69F0811C, '-WETH/USDC'),(0xf55B8e9F0c51Ace009f4b41d03321675d4C643b3, '-WETH/ARB'),(0xBFADEA65591235f38809076e14803Ac84AcF3F97, '-weETH/USDT'),(0x0C8C77B7FF4c2aF7F6CEBbe67350A490E3DD6cB3, '-ARB/USDT'),(0x4045720a33193b4Fe66c94DFbc8D37B0b4D9B469, '-weETH/USDC'),(0xdF16AdaF80584b2723F3BA1Eb7a601338Ba18c4e, '-ARB/USDC'),(0xeAbBfca72F8a8bf14C4ac59e69ECB2eB69F0811C, '-WETH/USDC'),(0xbEC491FeF7B4f666b270F9D5E5C3f443cBf20991, '-WETH/USDT'),(0x51197586F6A9e2571868b6ffaef308f3bdfEd3aE, '-wstETH/USDT'),(0xA0F83Fc5885cEBc0420ce7C7b139Adc80c4F4D91, '-wstETH/USDC')),"tokens" (contractAddress, decimals, symbol) AS (VALUES(0x82aF49447D8a07e3bd95BD0d56f35241523fBab1, 18, 'WETH'),(0xaf88d065e77c8cC2239327C5EDb3A432268e5831, 6, 'USDC'),(0x912CE59144191C1204E64559FE8253a0e49E6548, 18, 'ARB'),(0x35751007a407ca6FEFfE80b3cB397736D2cf4dbe, 18, 'weETH'),(0xFd086bC7CD5C481DCC9C85ebE478A1C0b69FCbb9, 6, 'USDT'),(0x5979D7b546E38E414F7E9822514be443A4800529, 18, 'wstETH')),"vault_info" AS (SELECTvl.contract,vl.vault,SPLIT_PART(SPLIT_PART(vl.vault, '-', 2), '/', 1) AS col_symbol,SPLIT_PART(vl.vault, '/', 2) AS debt_symbolFROM vault_list vl),"vault_data" AS (SELECTvi.contract,vi.col_symbol,vi.debt_symbol,tc.decimals AS col_decimals,td.decimals AS debt_decimalsFROM vault_info viJOIN "tokens" tc ON vi.col_symbol = tc.symbolJOIN "tokens" td ON vi.debt_symbol = td.symbol),"_Arbitrum" AS (SELECT *FROM TABLE (DECODE_EVM_EVENT(abi => '{"anonymous":false,"inputs":[{"indexed":false,"internalType":"address","name":"liquidator_","type":"address"},{"indexed":false,"internalType":"uint256","name":"colAmt_","type":"uint256"},{"indexed":false,"internalType":"uint256","name":"debtAmt_","type":"uint256"},{"indexed":false,"internalType":"address","name":"to_","type":"address"}],"name":"LogLiquidate","type":"event"}',input => TABLE(SELECT *FROM arbitrum.logsWHERE 1 = 1AND topic0 = 0x80fd9cc6b1821f4a510e45ffce6852ea3404807b5d3d833ffa85664408afcb66)))),flashloan_data AS (SELECTfl.tx_hash,bytearray_substring(fl.data,2+32+32+32+11,20) AS token,bytearray_to_uint256( bytearray_substring(fl.data,2+32+32+32+32+32,31) ) AS flashloanAmnt