SELECT time_bucket('1 day', time) AS day,
  first(price, time) AS open,
  last(price, time) AS close,
  max(price) AS high,
  min(price) AS low,
  sum(volume) AS volume
FROM prices
WHERE asset_code = 'TIMS'
  AND time > NOW() - interval '30d'
GROUP BY day
ORDER BY day ASC;

SELECT price,price[-1] FROM cost

SELECT (H-(avg(H))) FROM 'Seven'

panic: table name already provided: invalid message

sender, _ := QDBConnectILP(ctx)
	defer sender.Close()
   
    // For each of these results, push!
	for _, agg := range aggBar.Results {
		err := sender.Table("aggs").
			Symbol("ticker", aggBar.Ticker).
			StringColumn("timespan", timespan).
			Int64Column("multiplier", int64(multiplier)).
			Float64Column("timestamp", agg.T).
			Float64Column("open", agg.O).
			Float64Column("high", agg.H).
			Float64Column("low", agg.L).
			Float64Column("close", agg.C).
			Float64Column("volume", agg.V).
			Float64Column("vw", agg.Vw).
			Float64Column("n", float64(agg.N)).
			At(ctx, time.Now().UnixNano())
		CheckErr(err)
	}

	// Make sure that the messages are sent over the network.
	err = sender.Flush(ctx)
	CheckErr(err)