Query editor
WITH pair_flows AS (SELECTblock_date,token_pair,SUM(token_bought_amount) AS bought,SUM(token_sold_amount) AS soldFROM dex.tradesWHERE blockchain = 'mantle'GROUP BY block_date, token_pair)SELECTa.token_pair AS pair_a,b.token_pair AS pair_b,CORR(a.bought - a.sold, b.bought - b.sold) AS flow_correlationFROM pair_flows aJOIN pair_flows bON a.block_date = b.block_dateWHERE a.token_pair <> b.token_pairGROUP BY a.token_pair, b.token_pairORDER BY flow_correlation DESC