Query editor
SELECTtoken_pair,DATE_TRUNC('day', block_time) AS day,SUM(token_bought_amount) AS total_bought,SUM(token_sold_amount) AS total_sold,CASEWHEN SUM(token_bought_amount) > SUM(token_sold_amount) THEN 'net_buy'ELSE 'net_sell'END AS directionFROM dex.tradesWHERE blockchain = 'mantle'AND block_time >= NOW() - INTERVAL '30' dayGROUP BY token_pair, DATE_TRUNC('day', block_time)ORDER BY DATE_TRUNC('day', block_time), token_pair