-- Identify the MarginFi program

SELECT PROGRAM_ID

FROM solana.core.dim_idls

WHERE IDL:metadata.name::STRING = 'MarginFi_v2'

),

liquidity_vaults AS (

-- Pull each bank’s liquidity vault + associated mint

SELECT

DECODED_INSTRUCTION:parsed.info.liquidity_vault::STRING AS vault_address,

DECODED_INSTRUCTION:parsed.info.mint::STRING AS mint_address

FROM solana.core.fact_decoded_instructions fdi

JOIN marginfi_program mp

ON fdi.PROGRAM_ID = mp.PROGRAM_ID

WHERE fdi.EVENT_TYPE = 'InitializeBank'

),

tvl_per_mint AS (

-- Snapshot balances for those vaults

SELECT

lv.mint_address,

tb.BALANCE AS balance

FROM liquidity_vaults lv

JOIN solana.core.fact_token_balances tb

ON tb.ACCOUNT_ADDRESS = lv.vault_address

mint_address AS mint,

SUM(balance) AS tvl

FROM tvl_per_mint

GROUP BY 1

ORDER BY 2 DESC;