SELECT

-- BLOCK_TIMESTAMP::date AS date,

SYMBOL,

SUM(AMOUNT) AS amount,

SUM(AMOUNT_USD) AS usd_amount

-- SUM(usd_amount) OVER(ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_usd

FROM

ethereum.sushi.ez_lending

WHERE

ACTION='Deposit'

AND SYMBOL IN (

'DAI',

'USDT',

'USDC',

'sUSD',

'TUSD',

'UST',

'FEI'

)

GROUP BY symbol

), borrowed AS (

SELECT

-- BLOCK_TIMESTAMP::date AS date,

SYMBOL,

SUM(AMOUNT) AS amount,

SUM(AMOUNT_USD) AS usd_amount

-- SUM(usd_amount) OVER(ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_usd

FROM

ethereum.sushi.ez_borrowing

WHERE

ACTION='Borrow'

AND SYMBOL IN (

'DAI',

'USDT',

'USDC',