Query editor
SELECTDATE_TRUNC('day', t.block_time) AS day,SUM(t.output_value) / 1e8 * AVG(p.price) AS volume_usdFROM bitcoin.transactions tLEFT JOIN prices.usd pON p.symbol = 'BTC'AND DATE_TRUNC('minute', p.minute) = DATE_TRUNC('minute', t.block_time)WHERE t.block_time >= CURRENT_DATE - INTERVAL '90' DAYGROUP BY DATE_TRUNC('day', t.block_time)ORDER BY DATE_TRUNC('day', t.block_time) DESC