SELECT

EVENT_TYPE,

COALESCE(DECODED_ARGS:"amount"::FLOAT, 0) / 1e9 AS amount_sol

FROM solana.core.ez_events_decoded

WHERE PROGRAM_ID = 'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA'

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

SELECT

EVENT_TYPE,

COUNT(*) AS num_events,

SUM(amount_sol) AS total_amount

FROM tvl_events

GROUP BY EVENT_TYPE;