Query editor
WITH trades AS (SELECT block_time,tx_hash,tx_from,amount_usdFROM dex.tradesWHERE 1=1AND blockchain = 'hyperevm'AND project = 'prjx'AND amount_usd > 0)SELECT DATE_TRUNC('month', block_time) AS "month",AVG(amount_usd) AS avg_tradeFROM tradesGROUP BY 1ORDER BY "month" DESC