PREVIEW / stock_1min / 2017-06-05

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-06-05.parquet
  size:    14.1 MB
  rows:    1,026,286
  symbols: 2,520

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-06-05 04:00:00	AAPL	Stock	38.6	38.6	38.5075	38.5075	24400.0
2017-06-05 04:04:00	AAPL	Stock	38.525	38.525	38.525	38.525	4000.0
2017-06-05 04:05:00	AAPL	Stock	38.515	38.515	38.515	38.515	4296.0
2017-06-05 04:07:00	AAPL	Stock	38.5175	38.5175	38.4875	38.4875	10204.0
2017-06-05 04:08:00	AAPL	Stock	38.505	38.505	38.495	38.495	2400.0
2017-06-05 04:11:00	AAPL	Stock	38.5	38.5	38.5	38.5	1604.0
2017-06-05 04:13:00	AAPL	Stock	38.5	38.5	38.5	38.5	4000.0
2017-06-05 04:24:00	AAPL	Stock	38.55	38.55	38.55	38.55	1600.0
2017-06-05 04:26:00	AAPL	Stock	38.5875	38.6	38.5875	38.6	7600.0
2017-06-05 04:29:00	AAPL	Stock	38.5	38.5125	38.5	38.5	3528.0
2017-06-05 04:30:00	AAPL	Stock	38.575	38.575	38.575	38.575	920.0
2017-06-05 04:48:00	AAPL	Stock	38.5	38.5025	38.465	38.465	6168.0
2017-06-05 05:36:00	AAPL	Stock	38.5675	38.5675	38.5675	38.5675	1124.0
2017-06-05 05:50:00	AAPL	Stock	38.545	38.545	38.545	38.545	1600.0
2017-06-05 06:10:00	AAPL	Stock	38.5275	38.5275	38.5275	38.5275	544.0
2017-06-05 06:12:00	AAPL	Stock	38.5275	38.5275	38.525	38.525	1056.0
2017-06-05 06:19:00	AAPL	Stock	38.5075	38.5075	38.465	38.465	12752.0
2017-06-05 06:21:00	AAPL	Stock	38.4675	38.4675	38.4675	38.4675	800.0
2017-06-05 06:24:00	AAPL	Stock	38.475	38.475	38.47	38.47	4000.0
2017-06-05 06:26:00	AAPL	Stock	38.4975	38.5	38.49	38.49	3508.0
2017-06-05 06:27:00	AAPL	Stock	38.4875	38.4875	38.4875	38.4875	2560.0
2017-06-05 06:28:00	AAPL	Stock	38.4975	38.5	38.4975	38.5	3168.0
2017-06-05 06:40:00	AAPL	Stock	38.525	38.525	38.525	38.525	800.0
2017-06-05 06:49:00	AAPL	Stock	38.54	38.54	38.535	38.535	2416.0
2017-06-05 06:52:00	AAPL	Stock	38.525	38.525	38.525	38.525	400.0
2017-06-05 06:53:00	AAPL	Stock	38.535	38.535	38.535	38.535	400.0
2017-06-05 06:55:00	AAPL	Stock	38.525	38.525	38.5125	38.5125	2400.0
2017-06-05 06:57:00	AAPL	Stock	38.525	38.525	38.525	38.525	792.0
2017-06-05 07:01:00	AAPL	Stock	38.535	38.54	38.53	38.53	3404.0
2017-06-05 07:02:00	AAPL	Stock	38.545	38.545	38.545	38.545	2000.0
2017-06-05 07:03:00	AAPL	Stock	38.5375	38.5375	38.5375	38.5375	3960.0
2017-06-05 07:04:00	AAPL	Stock	38.54	38.54	38.535	38.535	9700.0
2017-06-05 07:05:00	AAPL	Stock	38.5375	38.5375	38.525	38.5275	8400.0
2017-06-05 07:06:00	AAPL	Stock	38.54	38.545	38.54	38.54	3600.0
2017-06-05 07:08:00	AAPL	Stock	38.545	38.55	38.545	38.55	1200.0
2017-06-05 07:09:00	AAPL	Stock	38.55	38.575	38.55	38.575	5308.0
2017-06-05 07:10:00	AAPL	Stock	38.5725	38.575	38.5725	38.575	3680.0
2017-06-05 07:11:00	AAPL	Stock	38.5675	38.5675	38.5625	38.5675	2168.0
2017-06-05 07:14:00	AAPL	Stock	38.5425	38.5425	38.525	38.525	24784.0
2017-06-05 07:15:00	AAPL	Stock	38.5275	38.5275	38.525	38.525	28764.0
2017-06-05 07:16:00	AAPL	Stock	38.5225	38.525	38.5225	38.525	2600.0
2017-06-05 07:17:00	AAPL	Stock	38.525	38.525	38.525	38.525	1600.0
2017-06-05 07:18:00	AAPL	Stock	38.51	38.525	38.51	38.525	4708.0
2017-06-05 07:20:00	AAPL	Stock	38.5325	38.5325	38.5325	38.5325	800.0
2017-06-05 07:21:00	AAPL	Stock	38.5375	38.5375	38.535	38.535	4036.0
2017-06-05 07:22:00	AAPL	Stock	38.55	38.55	38.55	38.55	400.0
2017-06-05 07:24:00	AAPL	Stock	38.55	38.55	38.55	38.55	900.0
2017-06-05 07:26:00	AAPL	Stock	38.5375	38.5425	38.5375	38.5425	3600.0
2017-06-05 07:31:00	AAPL	Stock	38.545	38.5475	38.545	38.5475	3880.0
2017-06-05 07:36:00	AAPL	Stock	38.555	38.555	38.555	38.555	2000.0

> showing 50 of 1,026,286 rows — these rows as CSV

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