Query editor
WITH popcat_trades AS (SELECTDATE(block_time) AS trade_date,amount_usdFROMdex_solana.tradesWHEREtoken_bought_symbol = 'POPCAT' OR token_sold_symbol = 'POPCAT')SELECTtrade_date,COUNT(*) AS total_trades,SUM(amount_usd) AS total_trade_volume_usdFROMpopcat_tradesGROUP BYtrade_dateORDER BYtrade_date;