SELECT
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
WHERE
l.BLOCK_TIMESTAMP = m.BLOCK_TIMESTAMP