Query editor
WITH trades AS (SELECT tx_hash,tx_from AS trader,amount_usdFROM dex.tradesWHERE 1=1AND blockchain = 'hyperevm'AND project = 'prjx'AND amount_usd > 0),trade_distribution AS (SELECT CASE WHEN amount_usd < 50 THEN '< $50'WHEN amount_usd < 500 THEN '$50 – $500'WHEN amount_usd < 5000 THEN '$500 – $5k'WHEN amount_usd < 50000 THEN '$5k – $50k'WHEN amount_usd < 500000 THEN '$50k – $500k'ELSE '$500k+' END AS size_range,CAST(COUNT(*) AS DOUBLE) AS trade_count,COUNT(DISTINCT trader) AS unique_traders,SUM(amount_usd) AS total_volume,AVG(amount_usd) AS avg_sizeFROM tradesGROUP BY 1)SELECT size_range,trade_count,unique_traders,avg_size,total_volume,(total_volume / SUM(total_volume) OVER ()) AS volume_share,(trade_count / SUM(trade_count) OVER ()) AS count_shareFROM trade_distributionORDER BY total_volume DESC