Query editor
WITH dex_base AS (SELECTblockchain,block_time,tx_from,token_bought_symbol,token_sold_symbol,CAST(token_bought_address AS VARCHAR) AS token_bought_address,CAST(token_sold_address AS VARCHAR) AS token_sold_address,token_bought_amount,token_sold_amount,amount_usdFROM dex.tradesWHERE amount_usd > 0AND block_time >= CURRENT_TIMESTAMP - INTERVAL '8' dayAND tx_from IS NOT NULLAND token_bought_symbol IS NOT NULLAND token_sold_symbol IS NOT NULLAND token_bought_address IS NOT NULLAND token_sold_address IS NOT NULLAND blockchain IN ('ethereum','base','arbitrum','optimism','avalanche_c')),sol_dex_base AS (SELECTblockchain,block_time,trader_id AS tx_from,token_bought_symbol,token_sold_symbol,token_bought_mint_address AS token_bought_address,token_sold_mint_address AS token_sold_address,token_bought_amount,token_sold_amount,amount_usdFROM dex_solana.tradesWHERE amount_usd > 0AND block_time >= CURRENT_TIMESTAMP - INTERVAL '8' dayAND trader_id IS NOT NULLAND token_bought_symbol IS NOT NULLAND token_sold_symbol IS NOT NULLAND token_bought_mint_address IS NOT NULLAND token_sold_mint_address IS NOT NULL),asset_activity AS (SELECT *FROM (SELECT*,ROW_NUMBER() OVER (ORDER BY volume_usd_24h_pct_chg_7d DESC, volume_usd_7d DESC) AS og_rank_7dFROM (SELECT*,