l.BLOCK_NUMBER,

l.BLOCK_TIMESTAMP AS Liquidation_Timestamp,

l.LIQUIDATION_AMOUNT_USD,

m.SUPPLY_APY,

m.BORROW_APY,

m.RESERVES_USD,

m.BORROWS_USD,

m.SUPPLY_USD,

m.UNDERLYING_SYMBOL AS Market_Asset_Symbol,

m.TOKEN_PRICE

FROM

ethereum.compound.ez_liquidations AS l

JOIN

ethereum.compound.ez_market_stats AS m

ON

l.BLOCK_NUMBER = m.BLOCK_NUMBER

l.BLOCK_TIMESTAMP = m.BLOCK_TIMESTAMP