SELECT dt, price, amount
FROM coinbase_btcusd

SELECT count() as tx
FROM coinbase_btcusd

SELECT
  min(dt) min_date,
  max(dt) max_date
FROM coinbase_btcusd

SELECT
	toYear(dt) year,
  count() as tx,
  min(price) min_price,
  max(price) max_price,
  sum(amount) volume
FROM coinbase_btcusd
GROUP BY year
ORDER BY year

SELECT
    toStartOfDay(dt) AS t,
    max(price) AS high,
    min(price) AS low,
    argMin(price, unixtime) AS open,
    argMax(price, unixtime) AS close,
    sum(amount) AS volume
FROM coinbase_btcusd
WHERE dt BETWEEN toDateTime('2018-01-01 00:00:00') AND toDateTime('2018-01-31 23:59:59')
GROUP BY t
ORDER BY t