Query editor
-- raw-- select * from arbitrum.logs-- where tx_hash=0x1dc7f005ad18320aeb7e91e85a43e42e5ca884a734235a0d9349f5534cdffd50-- and topic0=0xf3fa0eaee8f258c23b013654df25d1527f98a5c7ccd5e951dd77caca400ef972-- decodedWITH silos AS (SELECTsilo as silo_address,t.symbol as silo_symbolFROM silo_finance_arbitrum.silorepository_evt_newsilo sleft jointokens.erc20 t on s.asset=t.contract_addressand t.blockchain='arbitrum'),liqs as (SELECTblock_time,contract_address,s.silo_symbol,-- Decode the indexed parameters from topics.bytearray_substring(topic1, 1+12, 20) as asset,bytearray_substring(topic2, 1+12, 20) as user,-- Decode non-indexed parameters from data:bytearray_to_uint256(bytearray_substring(data, 1, 32)) as shareAmountRepaid,bytearray_to_uint256(bytearray_substring(data, 33, 32)) as seizedCollateral,tx_hash,index,CASEWHEN tx_to = 0xa673ddce04554ad794972509c5e821780f92ae67 THEN tx_from -- liquidator helperELSE tx_toEND AS liquidatorFROM arbitrum.logs lleft join silos son l.contract_address = s.silo_addressWHERE l.topic0 = 0xf3fa0eaee8f258c23b013654df25d1527f98a5c7ccd5e951dd77caca400ef972and l.contract_address IN (SELECT silo_address FROM silos)and l.tx_hash=0x1dc7f005ad18320aeb7e91e85a43e42e5ca884a734235a0d9349f5534cdffd50)select * from liqs