Skip to content

Instantly share code, notes, and snippets.

@sekrystal

sekrystal/collateral.sql

Created March 30, 2023 14:48
Show Gist options
  • Save sekrystal/166bfd03c4c156c275d0bf1bd37ecc68 to your computer and use it in GitHub Desktop.
Save sekrystal/166bfd03c4c156c275d0bf1bd37ecc68 to your computer and use it in GitHub Desktop.
Download ZIP
Insolvent Position Analysis
Raw
collateral.sql
select
SUM(liquidatedCollateralAmount) as amountSeized,
collateralAsset
from
aave_v2_ethereum.LendingPool_evt_LiquidationCall
where
user = from_hex('0x227cAa7eF6D955A92F483dB2BD01172997A1a623')
and evt_block_number <= 13522070 and evt_block_number >= 13520838
group by collateralAsset
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment