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 '12' hourAND 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 '12' hourAND 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_6h_pct_chg DESC, volume_usd_6h DESC) AS og_rank_6hFROM (SELECT*,