SELECT

EVENT_TYPE,

COALESCE(DECODED_ARGS:"amount"::FLOAT, 0) / 1e9 AS amount_sol -- ADJUST for 9 decimals

FROM solana.core.ez_events_decoded

WHERE PROGRAM_ID = 'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA'

AND EVENT_TYPE IN ('lendingAccountDeposit', 'lendingAccountWithdraw')

SELECT

SUM(

CASE

WHEN EVENT_TYPE = 'lendingAccountDeposit' THEN amount_sol

WHEN EVENT_TYPE = 'lendingAccountWithdraw' THEN -amount_sol

ELSE 0

END

) AS total_tvl_sol

FROM tvl_events;