Query editor
WITH blue_market AS (SELECTid,from_hex(json_value(marketParams, 'lax $.loanToken')) as loan_token,from_hex(json_value(marketParams, 'lax $.collateralToken')) as collateral_token,from_hex(json_value(marketParams, 'lax $.oracle')) as oracle_address,from_hex(json_value(marketParams, 'lax $.irm')) as irm_address,cast(json_value(marketParams, 'lax $.lltv') as double) / pow(10, 18) as lltv,chain as blockchainFROM morpho_blue_multichain.MorphoBlue_evt_CreateMarketWHERE chain = 'base'),last_prices AS (SELECTcontract_address,symbol,decimals,price,blockchainFROMdune.morpho.result_morpho_api_pricesWHEREblacklist = false),supply_interactions AS (SELECTshares as shares_amount,assets / pow(10, lpl.decimals) as supply_amount,assets * lpl.price / pow(10, lpl.decimals) AS supply_amount_usd,evt_block_time as time,s.id,onBehalf as usr,lpl.symbol as loan_symbol,lpc.symbol as collateral_symbol,lltv,chain as blockchain,evt_tx_hash as hashFROMmorpho_blue_multichain.MorphoBlue_evt_Supply sJOIN blue_market markets ON markets.id = s.idAND s.chain = markets.blockchainJOIN last_prices lpl ON lpl.contract_address = markets.loan_tokenand lpl.blockchain = markets.blockchainJOIN last_prices lpc ON lpc.contract_address = markets.collateral_tokenAND lpc.blockchain = markets.blockchainWHERE s.chain = 'base'UNION ALLSELECT- shares as shares_amount,- assets / pow(10, lpl.decimals) as supply_amount,- assets * lpl.price / pow(10, lpl.decimals) AS supply_amount_usd,evt_block_time as time,w.id,onBehalf as usr,lpl.symbol as loan_symbol,lpc.symbol as collateral_symbol,lltv,chain as blockchain,