Query editor
selectcontract_address,'WFLR' as collateral_type,evt_tx_hash as tx_hash,evt_index as tx_index,evt_block_time as block_time,evt_block_number as block_number,_debtOffsetBySP/1e18 as debt_offset_sp,_debtRedistributed/1e18 as debt_redistributed,_boldGasCompensation/1e18 as bold_gas_compensation,_collGasCompensation/1e18 as collateral_gas_compensation,_collSentToSP/1e18 as collateral_sent_sp,_collRedistributed/1e18 as collateral_distributed,_collSurplus/1e18 as collateral_surplus,_L_ETH,_L_boldDebt,_pricefrom enosys_loans_flare.trovemanager_wflr_evt_liquidationunion allselectcontract_address,'FXRP' as collateral_type,evt_tx_hash as tx_hash,evt_index as tx_index,evt_block_time as block_time,evt_block_number as block_number,_debtOffsetBySP/1e18 as debt_offset_sp,_debtRedistributed/1e18 as debt_redistributed,_boldGasCompensation/1e18 as bold_gas_compensation,_collGasCompensation/1e6 as collateral_gas_compensation,_collSentToSP/1e6 as collateral_sent_sp,_collRedistributed/1e6 as collateral_distributed,_collSurplus/1e6 as collateral_surplus,_L_ETH,_L_boldDebt,_pricefrom enosys_loans_flare.trovemanager_fxrp_evt_liquidationunion allselectcontract_address,'STXRP' as collateral_type,evt_tx_hash as tx_hash,evt_index as tx_index,evt_block_time as block_time,evt_block_number as block_number,_debtOffsetBySP/1e18 as debt_offset_sp,_debtRedistributed/1e18 as debt_redistributed,_boldGasCompensation/1e18 as bold_gas_compensation,_collGasCompensation/1e6 as collateral_gas_compensation,_collSentToSP/1e6 as collateral_sent_sp,_collRedistributed/1e6 as collateral_distributed,_collSurplus/1e6 as collateral_surplus,_L_ETH,_L_boldDebt,_pricefrom enosys_loans_flare.trove_manager_stxrp_evt_liquidation