Query editor
WITH popcat_trades AS (SELECTblock_time,amount_usdFROM dex_solana.tradesWHEREtoken_bought_symbol = 'POPCAT' OR token_sold_symbol = 'POPCAT')SELECTHOUR(block_time) AS trade_hour,COUNT(*) AS total_trades,SUM(amount_usd) AS total_trade_volume_usdFROM popcat_tradesGROUP BY1ORDER BYtotal_trades DESC