SELECT

symbol,

price

FROM

gnosis.price.ez_prices_hourly

),

borrow_data AS (

SELECT

tx_hash,

borrower,

token_symbol,

amount,

(amount * pd.price) AS amount_usd

FROM

gnosis.defi.ez_lending_borrows b

JOIN

price_data pd ON b.token_symbol = pd.symbol

SELECT

SUM(amount_usd) AS total_amount_usd

FROM

borrow_data;