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)SELECTlta.chain,v.vault_name,lp.symbol as loan_symbol,lta.newTotalAssets / pow(10, lp.decimals) as total_assets,lta.newTotalAssets * lp.price / pow(10, lp.decimals) as total_assets_usd,lta.contract_address as vault_address,lta.evt_block_time as last_update,v.creation_dateFROM 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.chainLEFT JOIN query_6408240 ssON lta.contract_address = ss.contract_address AND lta.chain = ss.chainLEFT JOIN query_6408201 saON lta.contract_address = sa.contract_address AND lta.chain = sa.chainLEFT JOIN query_6408189 rsON lta.contract_address = rs.contract_address AND lta.chain = rs.chainLEFT JOIN query_6408144 raON lta.contract_address = ra.contract_address AND lta.chain = ra.chainORDER BY total_assets_usd DESC