Query editor
WITHvault_list (contract, vault) AS (VALUES -- ETH, USDC, ARB, weETH, USDT, ARB, wstETH(0xeabbfca72f8a8bf14c4ac59e69ecb2eb69f0811c, '-WETH/USDC'),(0x1c2bb46f36561bc4f05a94bd50916496aa501078, '-weETH/USDC'),(0x1982cc7b1570c2503282d0a0b41f69b3b28fdcc3, '-cbBTC/WETH'),(0x4045720a33193b4fe66c94dfbc8d37b0b4d9b469, '-cbBTC/USDC'),(0x82b27fa821419f5689381b565a8b0786aa2548de, '-cbBTC/WETH')--,--(0xdF16AdaF80584b2723F3BA1Eb7a601338Ba18c4e, '-cbETH/USDC 70%'),--(0xeAbBfca72F8a8bf14C4ac59e69ECB2eB69F0811C, '-cbBTC/USDC 80%'),--(0xbEC491FeF7B4f666b270F9D5E5C3f443cBf20991, '-cbBTC/EURC 70%'),--(0x51197586F6A9e2571868b6ffaef308f3bdfEd3aE, '-cbBTC/EURC 80%'),--(0xA0F83Fc5885cEBc0420ce7C7b139Adc80c4F4D91, '-WETH/EURC'),--(0xA0F83Fc5885cEBc0420ce7C7b139Adc80c4F4D91, '-weETH/EURC'),--(0xA0F83Fc5885cEBc0420ce7C7b139Adc80c4F4D91, '-wstETH/EURC'),--(0xA0F83Fc5885cEBc0420ce7C7b139Adc80c4F4D91, '-cbBTC/WETH'),--(0xA0F83Fc5885cEBc0420ce7C7b139Adc80c4F4D91, '-WETH/cbBTC'),--(0xA0F83Fc5885cEBc0420ce7C7b139Adc80c4F4D91, '-weETH/cbBTC'),--(0xA0F83Fc5885cEBc0420ce7C7b139Adc80c4F4D91, '-wstETH/cbBTC')),"tokens" (contractAddress, decimals, symbol) AS (VALUES(0x4200000000000000000000000000000000000006, 18, 'WETH'),(0xcbB7C0000aB88B473b1f5aFd9ef808440eed33Bf, 8, 'cbBTC'),(0x04C0599Ae5A44757c0af6F9eC3b93da8976c150A, 18, 'weETH'),(0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913, 6, 'USDC')),"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),"_Base" 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 base.logsWHERE 1 = 1AND topic0 = 0x80fd9cc6b1821f4a510e45ffce6852ea3404807b5d3d833ffa85664408afcb66)))),