Query editor
-- based ON https://dune.com/queries/4481333WITH all_tokens AS (SELECTsymbol_name, contract_address, decimals, price_decimals, chain, CASE WHEN chain = 'avalanche' THEN 'avalanche_c' ELSE chain END AS blockchain, "version"FROM query_4420483WHERE-- "version" = 2-- ANDsymbol_name NOT LIKE '%deprecated%')-- VERSION 1, distinct_v1_tokens AS (SELECTDISTINCT'arbitrum' AS blockchain, tokenIn AS token_addressFROM gmx_arbitrum.Vault_evt_SwapUNIONSELECTDISTINCT'arbitrum' AS blockchain, tokenOut AS token_addressFROM gmx_arbitrum.Vault_evt_SwapUNIONSELECTDISTINCT'avalanche_c' AS blockchain, tokenIn AS token_addressFROM gmx_avalanche_c.Vault_evt_SwapUNIONSELECTDISTINCT'avalanche_c' AS blockchain, tokenOut AS token_addressFROM gmx_avalanche_c.Vault_evt_Swap), daily_prices_v1 AS (SELECTDATE_TRUNC('day', pr.minute) AS block_date, att.symbol_name, AVG(pr.price) AS avg_priceFROM prices.usd AS prINNER JOIN distinct_v1_tokens AS t2ON pr.blockchain = t2.blockchainAND pr.contract_address = t2.token_addressINNER JOIN all_tokens AS att