Insolvent Position Analysis

lq.sql

select
  evt_block_number,
  collateralAsset,
  debtAsset,
  debtToCover,
  liquidatedCollateralAmount,
  liquidator
from
  aave_v2_ethereum.LendingPool_evt_LiquidationCall
where
  user = from_hex('0x227cAa7eF6D955A92F483dB2BD01172997A1a623')
order by
  evt_block_number desc;