Query editor
WITH ranked_data AS (SELECT*,ROW_NUMBER() OVER (PARTITION BY contract_address, chainORDER BY evt_block_number DESC) AS rnFROM morpho_v2_multichain.vaultv2_evt_accrueinterest),latest_total_assets AS (SELECT chain,contract_address,evt_block_time,evt_block_number,evt_block_date,newTotalAssetsFROM ranked_dataWHERE rn = 1AND contract_address IN (CAST(X'54210d3f1a066413891af9e17210e787d5c6e3f4' AS varbinary), CAST(X'e2221aa07ec3266da87763e2b1e28d07a8a4e53b' AS varbinary))),last_prices AS (SELECTcontract_address,symbol,decimals,price,blockchainFROMdune.morpho.result_morpho_api_prices_extended)SELECTSUM(lta.newTotalAssets / pow(10, lp.decimals)) as total_assetsFROM latest_total_assets ltaJOIN dune.morpho.result_unique_vaults_v_2 vON lta.contract_address = v.vault_address AND lta.chain = v.chainLEFT JOIN last_prices lpON v.loan_asset = lp.contract_address AND lp.blockchain = v.chain