PREVIEW / stock_1min / 2017-07-27

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-07-27.parquet
  size:    14.7 MB
  rows:    1,055,493
  symbols: 2,480

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2017-07-27 04:00:00	AAPL	Stock	38.4975	38.5025	38.4975	38.5025	2800.0
2017-07-27 04:37:00	AAPL	Stock	38.5125	38.5125	38.5125	38.5125	768.0
2017-07-27 04:38:00	AAPL	Stock	38.5125	38.5125	38.5125	38.5125	2616.0
2017-07-27 04:42:00	AAPL	Stock	38.5025	38.5025	38.5025	38.5025	768.0
2017-07-27 04:46:00	AAPL	Stock	38.5025	38.5025	38.5025	38.5025	1956.0
2017-07-27 04:55:00	AAPL	Stock	38.5025	38.5025	38.5025	38.5025	480.0
2017-07-27 04:56:00	AAPL	Stock	38.5025	38.5025	38.5025	38.5025	400.0
2017-07-27 04:59:00	AAPL	Stock	38.55	38.55	38.55	38.55	7772.0
2017-07-27 05:18:00	AAPL	Stock	38.555	38.555	38.555	38.555	456.0
2017-07-27 05:40:00	AAPL	Stock	38.55	38.55	38.55	38.55	624.0
2017-07-27 05:59:00	AAPL	Stock	38.5375	38.5375	38.5375	38.5375	400.0
2017-07-27 06:00:00	AAPL	Stock	38.5125	38.5125	38.5125	38.5125	400.0
2017-07-27 06:04:00	AAPL	Stock	38.5	38.5	38.5	38.5	1996.0
2017-07-27 06:18:00	AAPL	Stock	38.5	38.5	38.5	38.5	400.0
2017-07-27 06:23:00	AAPL	Stock	38.53	38.53	38.53	38.53	552.0
2017-07-27 06:33:00	AAPL	Stock	38.5025	38.5025	38.5025	38.5025	400.0
2017-07-27 06:39:00	AAPL	Stock	38.525	38.525	38.525	38.525	5172.0
2017-07-27 06:43:00	AAPL	Stock	38.5325	38.535	38.5325	38.535	5680.0
2017-07-27 06:52:00	AAPL	Stock	38.535	38.535	38.535	38.535	1908.0
2017-07-27 07:04:00	AAPL	Stock	38.505	38.505	38.5	38.5	2524.0
2017-07-27 07:10:00	AAPL	Stock	38.5	38.5	38.5	38.5	1724.0
2017-07-27 07:12:00	AAPL	Stock	38.5	38.5	38.5	38.5	6492.0
2017-07-27 07:13:00	AAPL	Stock	38.485	38.485	38.485	38.485	520.0
2017-07-27 07:14:00	AAPL	Stock	38.5	38.5	38.485	38.485	7628.0
2017-07-27 07:16:00	AAPL	Stock	38.4975	38.4975	38.4975	38.4975	400.0
2017-07-27 07:19:00	AAPL	Stock	38.5025	38.5025	38.5	38.5	8000.0
2017-07-27 07:20:00	AAPL	Stock	38.5	38.5	38.5	38.5	6116.0
2017-07-27 07:22:00	AAPL	Stock	38.5125	38.5125	38.5125	38.5125	400.0
2017-07-27 07:25:00	AAPL	Stock	38.5125	38.5125	38.5025	38.5025	3640.0
2017-07-27 07:30:00	AAPL	Stock	38.5125	38.5125	38.5125	38.5125	1000.0
2017-07-27 07:36:00	AAPL	Stock	38.5125	38.5125	38.5125	38.5125	800.0
2017-07-27 07:40:00	AAPL	Stock	38.5	38.5025	38.4975	38.4975	5360.0
2017-07-27 07:41:00	AAPL	Stock	38.4975	38.4975	38.4975	38.4975	892.0
2017-07-27 07:46:00	AAPL	Stock	38.4975	38.4975	38.4975	38.4975	1988.0
2017-07-27 07:47:00	AAPL	Stock	38.5	38.5	38.5	38.5	4000.0
2017-07-27 07:48:00	AAPL	Stock	38.5	38.5	38.5	38.5	2400.0
2017-07-27 07:52:00	AAPL	Stock	38.5125	38.5125	38.5125	38.5125	3708.0
2017-07-27 07:53:00	AAPL	Stock	38.5125	38.5125	38.5025	38.5025	3760.0
2017-07-27 07:54:00	AAPL	Stock	38.505	38.5075	38.505	38.5075	800.0
2017-07-27 07:55:00	AAPL	Stock	38.515	38.515	38.515	38.515	1200.0
2017-07-27 07:56:00	AAPL	Stock	38.53	38.53	38.53	38.53	760.0
2017-07-27 07:57:00	AAPL	Stock	38.505	38.505	38.5025	38.5025	3964.0
2017-07-27 08:00:00	AAPL	Stock	38.5125	38.53	38.5	38.53	40688.0
2017-07-27 08:01:00	AAPL	Stock	38.53	38.53	38.505	38.505	10400.0
2017-07-27 08:02:00	AAPL	Stock	38.5025	38.505	38.5	38.5	4428.0
2017-07-27 08:04:00	AAPL	Stock	38.505	38.51	38.505	38.51	6200.0
2017-07-27 08:05:00	AAPL	Stock	38.505	38.505	38.5	38.5	4432.0
2017-07-27 08:06:00	AAPL	Stock	38.51	38.5125	38.51	38.51	3176.0
2017-07-27 08:08:00	AAPL	Stock	38.505	38.505	38.505	38.505	400.0
2017-07-27 08:09:00	AAPL	Stock	38.515	38.5175	38.505	38.505	9712.0

> showing 50 of 1,055,493 rows — these rows as CSV

> unlock the full archive -- $79 one-time