Query editor
WITH hourly_volume AS (SELECTDATE_TRUNC('hour', block_time) AS time,SUM(CAST(amount_usd AS DOUBLE)) AS aggregate_usd_volumeFROMdex."trades"WHEREblock_time > DATE_TRUNC('hour', NOW()) - INTERVAL '5' yearAND block_time < DATE_TRUNC('hour', NOW())GROUP BYDATE_TRUNC('hour', block_time))SELECTtime,aggregate_usd_volumeFROMhourly_volume