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('day', block_time) AS "day",AVG(amount_usd) OVER (PARTITION BY DATE_TRUNC('day', block_time)) AS avg_trade,AVG(amount_usd) OVER (ORDER BY DATE_TRUNC('day', block_time)) AS avg_totalFROM tradesORDER BY "day" DESC