Query editor
withfluid_dexes_lite as (select *from "query_5571121"), manual_pricing as (select *from "query_5169345"), dex_tokens_subset as (selecttoken0 as contract_address, blockchain, symbol0 as symbol, decimals0 as decimalsfrom fluid_dexes_liteunionselecttoken1 as contract_address, blockchain, symbol1 as symbol, decimals1 as decimalsfrom fluid_dexes_lite), dex_tokens as (selectt.contract_address as token, t.blockchain, t.symbol, t.decimals, t.contract_address as price_token, t.blockchain as price_blockchain, t.decimals as price_decimalsfrom dex_tokens_subset as t-- select-- t.contract_address as token-- , t.blockchain-- , t.symbol-- , t.decimals-- , t.contract_address as price_token-- , t.blockchain as price_blockchain-- , t.decimals as price_decimals-- from dex_tokens_subset as t-- left join manual_pricing as mp-- on t.contract_address = mp.token-- and t.blockchain = mp.blockchain-- where t.contract_address <> 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee-- and t.blockchain = 'ethereum'-- and mp.token is null-- union all-- select-- 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee as token-- , chain as blockchain