SELECT

sender_id,

SUM(amount_usd) AS total_deposited

FROM

near.defi.ez_lending

WHERE

symbol IN ('USDT', 'USDt', 'DAI', 'FRAX', 'USDT.e', 'USDC.e', 'USN')

AND actions IN ('deposit', 'deposit_to_reserve')

GROUP BY

sender_id

),

BorrowerVolumes AS (

SELECT

sender_id,

SUM(amount_usd) AS total_borrowed

FROM

near.defi.ez_lending

WHERE

symbol IN ('USDT', 'USDt', 'DAI', 'FRAX', 'USDT.e', 'USDC.e', 'USN')

AND actions IN ('borrow')

AND amount_usd IS NOT NULL

GROUP BY

sender_id

),

TopDepositors AS (

SELECT

sender_id,

SUM(total_deposited) AS total_deposited

FROM

DepositorVolumes

GROUP BY

sender_id

),

TopBorrowers AS (

SELECT