Query editor
with view_tokens as (select * from query_4631885),token_prices AS (SELECTdate_trunc('hour', minute) AS dt,a.vtoken_contract_address AS vtoken_contract,a.underlying_token_address AS contract_address,a.symbol,a.vtoken,a.decimals AS decimals,vtoken_decimals AS vtoken_decimals,b.price AS priceFROM view_tokens aINNER JOIN prices.usd b ON a.underlying_token_address = b.contract_addressWHERE b.blockchain = 'scroll' and b.minute >= date '2024-06-01'),exchange_rates_1 AS (SELECT dt, vtoken, vtoken_contract_address, vtoken_decimals, underlying_token_address, symbol, decimals, exchange_rateFROM (SELECTcall_block_time AS dt, contract_address, output_0 / POWER(10, 18) as exchange_rateFROM rho_scroll.rether_call_exchangeRateStoredUNION ALLSELECT call_block_time AS dt, contract_address, output_0 / POWER(10, 18) AS exchange_rateFROM rho_scroll.rsolvbtc_call_exchangeRateStoredUNION ALLSELECT call_block_time AS dt, contract_address, output_0 / POWER(10, 18) AS exchange_rateFROM rho_scroll.rstone_call_exchangeRateStoredUNION ALLSELECT call_block_time AS dt, contract_address, output_0 / POWER(10, 18) AS exchange_rateFROM rho_scroll.rusdc_call_exchangeRateStoredUNION ALLSELECT call_block_time AS dt, contract_address, output_0 / POWER(10, 18) AS exchange_rateFROM rho_scroll.rusdt_call_exchangeRateStoredUNION ALLSELECT call_block_time AS dt, contract_address, output_0 / POWER(10, 18) AS exchange_rateFROM rho_scroll.rweeth_call_exchangeRateStoredUNION ALLSELECT call_block_time AS dt, contract_address, output_0 / POWER(10, 18) AS exchange_rateFROM rho_scroll.rwsteth_call_exchangeRateStoredUNION ALLSELECT call_block_time AS dt, contract_address, output_0 / POWER(10, 18) AS exchange_rateFROM rho_makets_scroll.rwrseth_call_exchangeRateStoredUNION ALLSELECT call_block_time AS dt, contract_address, output_0 / POWER(10, 18) AS exchange_rateFROM rho_markets_scroll.rSCR_call_exchangeRateStored) aLEFT JOIN view_tokens b ON a.contract_address = b.vtoken_contract_address),-- -- exchange_rates_max AS (-- -- SELECT MAX(dt) AS dt, vtoken_contract_address-- -- FROM exchange_rates_1-- -- GROUP BY vtoken_contract_address-- -- ),-- -- exchange_rates AS (