with prices AS (

select

SYMBOL,

PRICE,

rank() over (

partition by SYMBOL

order by

HOUR desc

) AS rank

from

base.price.ez_prices_hourly

where

TOKEN_ADDRESS in (

select

DISTINCT TOKEN_ADDRESS

from

base.defi.ez_lending_borrows

) qualify rank = 1

),

main AS (

select

SYMBOL,

sum(AMT) AS "Active Borrowed Amount"

from

(

select

TOKEN_SYMBOL AS SYMBOL,

sum(AMOUNT) AS AMT

from

base.defi.ez_lending_borrows

where

PLATFORM = 'Seamless'

group by

1

union