Query editor
WITH all_uniswap_trades AS (SELECTblock_time,token_bought_address,token_bought_symbol,token_sold_address,token_sold_symbol,amount_usdFROM uniswap_v2_ethereum.tradesWHERE block_date = CURRENT_DATE - INTERVAL '1' DAYUNION ALLSELECTblock_time,token_bought_address,token_bought_symbol,token_sold_address,token_sold_symbol,amount_usdFROM uniswap_v3_ethereum.tradesWHERE block_date = CURRENT_DATE - INTERVAL '1' DAY),token_volumes AS (SELECTdate_trunc('hour', block_time) as hour,token_bought_address as token_address,token_bought_symbol as token_symbol,SUM(amount_usd) as volume_usdFROM all_uniswap_tradesGROUP BY date_trunc('hour', block_time), token_bought_address, token_bought_symbolUNION ALLSELECTdate_trunc('hour', block_time) as hour,token_sold_address as token_address,token_sold_symbol as token_symbol,SUM(amount_usd) as volume_usdFROM all_uniswap_tradesGROUP BY date_trunc('hour', block_time), token_sold_address, token_sold_symbol)SELECThour,token_address,token_symbol,SUM(volume_usd) as total_volume_usdFROM token_volumesGROUP BY hour, token_address, token_symbolORDER BY hour DESC, total_volume_usd DESC