Query editor
with all_evms as (select * from dune.dune.result_arbitrum_token_pair_volume --https://dune.com/queries/3568001union allselect * from dune.dune.result_base_token_pair_volume -- https://dune.com/queries/3572300union allselect * from dune.dune.result_bnb_token_pair_volume -- https://dune.com/queries/3572306union allselect * from dune.dune.result_celo_token_pair_volume -- https://dune.com/queries/3572308union allselect * from dune.dune.result_ethereum_token_pair_volume -- https://dune.com/queries/3572311union allselect * from dune.dune.result_fantom_token_pair_volume -- https://dune.com/queries/3572312union allselect * from dune.dune.result_gnosis_token_pair_volume -- https://dune.com/queries/3572314union allselect * from dune.dune.result_optimism_token_pair_volume -- https://dune.com/queries/3572315union allselect * from dune.dune.result_polygon_token_pair_volume2 -- https://dune.com/queries/3575395union allselect * from dune.dune.result_scroll_token_pair_volume -- https://dune.com/queries/3572319union allselect * from dune.dune.result_zk_sync_token_pair_volume -- https://dune.com/queries/3572321), evm_t as (WITH unnested AS (SELECTt.chain, t.token_pair, t.projects, t.token_a_address, t.token_b_address, t.one_day_volume, t.seven_day_volume, t.thirty_day_volume, t.all_time_volume, t.usd_liquidity, t.seven_day_volume_liquidity_ratio, u.pool_id AS unnested_pool_idFROM all_evms tCROSS JOIN UNNEST(t.pool_ids) AS u(pool_id) -- Unnest the array)SELECT chain, token_pair, projects, array_agg(cast(unnested_pool_id as varchar)) as pool_ids -- convert varbinary to text, cast(token_a_address as varchar) as token_a_address, cast(token_b_address as varchar) as token_b_address, one_day_volume, seven_day_volume, thirty_day_volume, all_time_volume, usd_liquidity, seven_day_volume_liquidity_ratioFROMunnestedGROUP BY 1,2,3, 5,6,7,8,9,10,11,12)select * from evm_tunion allselect * from dune.dune.result_solana_dex_pair_stats -- https://dune.com/queries/3572096-- where (chain = 'ethereum' and pool_id = 0xCBCdF9626bC03E24f779434178A73a0B4bad62eD) -- https://app.uniswap.org/explore/pools/ethereum/0xCBCdF9626bC03E24f779434178A73a0B4bad62eD-- or (chain = 'optimism' and pool_id = 0x68F5C0A2DE713a54991E01858Fd27a3832401849) -- https://app.uniswap.org/explore/pools/optimism/0x68F5C0A2DE713a54991E01858Fd27a3832401849-- or (chain = 'base' and pool_id = 0x9E37cb775a047Ae99FC5A24dDED834127c4180cD) -- https://app.uniswap.org/explore/pools/base/0x9E37cb775a047Ae99FC5A24dDED834127c4180cDorder by all_time_volume desc