PREVIEW / stock_1min / 2017-01-09

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-01-09.parquet
  size:    14.5 MB
  rows:    1,057,582
  symbols: 2,576

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-01-09 04:03:00	AAPL	Stock	29.5	29.5	29.5	29.5	5080.0
2017-01-09 04:24:00	AAPL	Stock	29.43	29.43	29.43	29.43	596.0
2017-01-09 05:02:00	AAPL	Stock	29.45	29.45	29.45	29.45	3392.0
2017-01-09 05:30:00	AAPL	Stock	29.45	29.45	29.45	29.45	1192.0
2017-01-09 05:39:00	AAPL	Stock	29.4375	29.4375	29.4375	29.4375	1080.0
2017-01-09 05:48:00	AAPL	Stock	29.4475	29.4475	29.4375	29.4375	2000.0
2017-01-09 05:52:00	AAPL	Stock	29.4475	29.4475	29.4475	29.4475	2400.0
2017-01-09 05:53:00	AAPL	Stock	29.46	29.4725	29.46	29.4725	2000.0
2017-01-09 05:55:00	AAPL	Stock	29.4475	29.4475	29.4475	29.4475	400.0
2017-01-09 06:31:00	AAPL	Stock	29.415	29.4275	29.395	29.395	4000.0
2017-01-09 06:32:00	AAPL	Stock	29.405	29.405	29.405	29.405	4084.0
2017-01-09 06:38:00	AAPL	Stock	29.385	29.385	29.38	29.38	1808.0
2017-01-09 06:42:00	AAPL	Stock	29.3775	29.3775	29.3775	29.3775	400.0
2017-01-09 06:46:00	AAPL	Stock	29.3975	29.405	29.3975	29.405	4760.0
2017-01-09 06:49:00	AAPL	Stock	29.405	29.405	29.405	29.405	1136.0
2017-01-09 06:53:00	AAPL	Stock	29.405	29.405	29.405	29.405	2640.0
2017-01-09 07:01:00	AAPL	Stock	29.4375	29.4475	29.4375	29.4475	1600.0
2017-01-09 07:07:00	AAPL	Stock	29.46	29.46	29.455	29.455	1968.0
2017-01-09 07:11:00	AAPL	Stock	29.45	29.45	29.45	29.45	2000.0
2017-01-09 07:12:00	AAPL	Stock	29.45	29.45	29.45	29.45	1360.0
2017-01-09 07:23:00	AAPL	Stock	29.45	29.45	29.45	29.45	640.0
2017-01-09 07:29:00	AAPL	Stock	29.46	29.4725	29.46	29.4725	7600.0
2017-01-09 07:31:00	AAPL	Stock	29.47	29.5	29.47	29.5	20236.0
2017-01-09 07:32:00	AAPL	Stock	29.5225	29.525	29.5125	29.525	8492.0
2017-01-09 07:33:00	AAPL	Stock	29.5225	29.525	29.5225	29.525	800.0
2017-01-09 07:34:00	AAPL	Stock	29.525	29.525	29.525	29.525	2000.0
2017-01-09 07:35:00	AAPL	Stock	29.525	29.5375	29.525	29.5375	5200.0
2017-01-09 07:36:00	AAPL	Stock	29.5375	29.5425	29.5375	29.54	12088.0
2017-01-09 07:37:00	AAPL	Stock	29.525	29.525	29.525	29.525	400.0
2017-01-09 07:42:00	AAPL	Stock	29.5175	29.5175	29.5175	29.5175	2000.0
2017-01-09 07:43:00	AAPL	Stock	29.52	29.525	29.52	29.525	800.0
2017-01-09 07:45:00	AAPL	Stock	29.52	29.52	29.52	29.52	6600.0
2017-01-09 07:46:00	AAPL	Stock	29.505	29.505	29.505	29.505	1200.0
2017-01-09 07:51:00	AAPL	Stock	29.5025	29.5025	29.5	29.5	2012.0
2017-01-09 07:54:00	AAPL	Stock	29.505	29.505	29.505	29.505	800.0
2017-01-09 07:56:00	AAPL	Stock	29.52	29.525	29.52	29.525	15200.0
2017-01-09 07:59:00	AAPL	Stock	29.535	29.535	29.525	29.525	4000.0
2017-01-09 08:00:00	AAPL	Stock	29.52	29.5425	29.5025	29.5275	26716.0
2017-01-09 08:01:00	AAPL	Stock	29.5275	29.5275	29.5275	29.5275	1600.0
2017-01-09 08:02:00	AAPL	Stock	29.515	29.525	29.515	29.525	2400.0
2017-01-09 08:03:00	AAPL	Stock	29.54	29.54	29.54	29.54	6400.0
2017-01-09 08:04:00	AAPL	Stock	29.52	29.52	29.52	29.52	3080.0
2017-01-09 08:05:00	AAPL	Stock	29.5175	29.5175	29.51	29.51	3960.0
2017-01-09 08:06:00	AAPL	Stock	29.5275	29.5375	29.525	29.525	4000.0
2017-01-09 08:07:00	AAPL	Stock	29.525	29.5275	29.525	29.5275	5200.0
2017-01-09 08:09:00	AAPL	Stock	29.525	29.525	29.525	29.525	2040.0
2017-01-09 08:10:00	AAPL	Stock	29.5275	29.5275	29.5275	29.5275	400.0
2017-01-09 08:11:00	AAPL	Stock	29.5375	29.545	29.5375	29.545	5868.0
2017-01-09 08:12:00	AAPL	Stock	29.545	29.545	29.545	29.545	800.0
2017-01-09 08:14:00	AAPL	Stock	29.545	29.545	29.525	29.525	21492.0

> showing 50 of 1,057,582 rows — these rows as CSV

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