DEPOSITOR AS "Depositor Address",

sum(

case

when Amount_USD is not null then Amount_USD

else Amount * Price

end

) AS Volume,

Count(*) AS "Despoits Count"

from

base.defi.ez_lending_deposits A

inner join base.price.ez_hourly_token_prices B on B.TOKEN_ADDRESS = A.TOKEN_ADDRESS

and HOUR = date_trunc('hour', BLOCK_TIMESTAMP)

where

PLATFORM = 'Seamless'

group by

1 order by 2 desc limit 100