SELECT

collateral_token_symbol AS "Collateral Token Symbol",

tx_hash,

amount,

block_timestamp::date AS liquidation_date

FROM

gnosis.defi.ez_lending_liquidations

),

price_data AS (

SELECT

symbol,

price

FROM

gnosis.price.ez_prices_hourly

SELECT

SUM(ld.amount * pd.price) AS "Total Liquidated USD"

FROM

liquidation_data ld

JOIN

price_data pd ON ld."Collateral Token Symbol" = pd.symbol;