Query editor
with view_tokens as (select * from query_4715378),token_prices AS (SELECTdate_trunc('hour', minute) AS dt,a.mtoken_contract_address AS mtoken_contract,a.underlying_token_address AS underlying_contract,a.symbol,a.mtoken,a.decimals AS decimals,mtoken_decimals,b.price AS priceFROM view_tokens aINNER JOIN prices.usd b ON a.underlying_token_address = b.contract_addressWHERE b.blockchain = 'optimism' and b.minute >= date '2024-09-01'UNION ALL-- wrsETH (ok coverage, might need forward fill)selecthour as dt,0x181bA797ccF779D8aB339721ED6ee827E758668e as mtoken_contract,contract_address as underlying_contract,'wrsETH' as symbol,'mwrsETH' as mtoken,18 as decimals,8 as mtoken_decimals,median_price as pricefrom dex.priceswhere contract_address=0x87eEE96D50Fb761AD85B1c982d28A042169d61b1and blockchain='optimism'UNION ALL-- VELOselecthour as dt,0x21d851585840942B0eF9f20d842C00C5f3735eaF as mtoken_contract,contract_address as underlying_contract,'VELO' as symbol,'mVELO' as mtoken,18 as decimals,8 as mtoken_decimals,median_price as pricefrom dex.priceswhere contract_address=0x3c8B650257cFb5f272f799F5e2b4e65093a11a05and blockchain='optimism'),exchange_rates_1 AS (SELECT dt, mtoken, mtoken_contract_address, mtoken_decimals, underlying_token_address, symbol, decimals, exchange_rateFROM (SELECT call_block_time AS dt, contract_address, output_0 / POWER(10, 28) as exchange_rateFROM moonwell_optimism.moonwell_op_call_exchangeRateStoredUNION ALLSELECT call_block_time AS dt, contract_address, output_0 / POWER(10, 16) as exchange_rateFROM moonwell_optimism.moonwell_usdt_call_exchangeRateStoredUNION ALL