PREVIEW / stock_1min / 2017-11-20

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-11-20.parquet
  size:    14.8 MB
  rows:    1,067,591
  symbols: 2,437

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-11-20 04:46:00	AAPL	Stock	42.475	42.475	42.475	42.475	1948.0
2017-11-20 05:43:00	AAPL	Stock	42.475	42.475	42.475	42.475	400.0
2017-11-20 06:06:00	AAPL	Stock	42.5	42.5	42.5	42.5	400.0
2017-11-20 06:36:00	AAPL	Stock	42.5	42.5275	42.5	42.5275	2000.0
2017-11-20 06:48:00	AAPL	Stock	42.5275	42.535	42.5275	42.535	4000.0
2017-11-20 06:50:00	AAPL	Stock	42.5475	42.5475	42.5475	42.5475	1600.0
2017-11-20 06:56:00	AAPL	Stock	42.5275	42.5275	42.525	42.525	2820.0
2017-11-20 07:00:00	AAPL	Stock	42.5075	42.5875	42.5	42.5375	10448.0
2017-11-20 07:02:00	AAPL	Stock	42.525	42.525	42.525	42.525	2000.0
2017-11-20 07:03:00	AAPL	Stock	42.525	42.525	42.525	42.525	4000.0
2017-11-20 07:06:00	AAPL	Stock	42.54	42.54	42.54	42.54	2000.0
2017-11-20 07:13:00	AAPL	Stock	42.525	42.525	42.525	42.525	2600.0
2017-11-20 07:18:00	AAPL	Stock	42.525	42.525	42.525	42.525	1600.0
2017-11-20 07:25:00	AAPL	Stock	42.535	42.535	42.535	42.535	800.0
2017-11-20 07:27:00	AAPL	Stock	42.5025	42.5025	42.5025	42.5025	400.0
2017-11-20 07:37:00	AAPL	Stock	42.5325	42.5325	42.5325	42.5325	1600.0
2017-11-20 07:39:00	AAPL	Stock	42.535	42.535	42.535	42.535	3024.0
2017-11-20 07:40:00	AAPL	Stock	42.5375	42.56	42.5375	42.56	3996.0
2017-11-20 07:51:00	AAPL	Stock	42.55	42.55	42.55	42.55	2800.0
2017-11-20 07:54:00	AAPL	Stock	42.55	42.55	42.55	42.55	3204.0
2017-11-20 08:00:00	AAPL	Stock	42.555	42.5625	42.535	42.535	17024.0
2017-11-20 08:01:00	AAPL	Stock	42.5475	42.5475	42.5475	42.5475	2152.0
2017-11-20 08:03:00	AAPL	Stock	42.555	42.555	42.5375	42.5375	7200.0
2017-11-20 08:04:00	AAPL	Stock	42.535	42.535	42.535	42.535	3724.0
2017-11-20 08:07:00	AAPL	Stock	42.535	42.535	42.535	42.535	400.0
2017-11-20 08:09:00	AAPL	Stock	42.515	42.515	42.515	42.515	796.0
2017-11-20 08:10:00	AAPL	Stock	42.535	42.535	42.535	42.535	676.0
2017-11-20 08:11:00	AAPL	Stock	42.535	42.5375	42.535	42.5375	5280.0
2017-11-20 08:14:00	AAPL	Stock	42.5525	42.5625	42.5525	42.5625	1232.0
2017-11-20 08:15:00	AAPL	Stock	42.555	42.555	42.555	42.555	400.0
2017-11-20 08:16:00	AAPL	Stock	42.555	42.5575	42.555	42.5575	2400.0
2017-11-20 08:17:00	AAPL	Stock	42.5625	42.5625	42.5625	42.5625	2000.0
2017-11-20 08:18:00	AAPL	Stock	42.5675	42.5825	42.555	42.5825	17840.0
2017-11-20 08:20:00	AAPL	Stock	42.5875	42.5875	42.585	42.5875	6744.0
2017-11-20 08:21:00	AAPL	Stock	42.5925	42.595	42.5925	42.595	3592.0
2017-11-20 08:22:00	AAPL	Stock	42.5925	42.5925	42.5925	42.5925	400.0
2017-11-20 08:23:00	AAPL	Stock	42.59	42.5925	42.59	42.5925	800.0
2017-11-20 08:24:00	AAPL	Stock	42.5975	42.605	42.595	42.605	4160.0
2017-11-20 08:25:00	AAPL	Stock	42.6075	42.6125	42.6075	42.6125	6132.0
2017-11-20 08:27:00	AAPL	Stock	42.615	42.615	42.615	42.615	400.0
2017-11-20 08:28:00	AAPL	Stock	42.6175	42.62	42.6175	42.62	2800.0
2017-11-20 08:29:00	AAPL	Stock	42.6225	42.625	42.6225	42.625	5200.0
2017-11-20 08:30:00	AAPL	Stock	42.625	42.6425	42.625	42.6425	9636.0
2017-11-20 08:31:00	AAPL	Stock	42.6475	42.65	42.6425	42.65	3312.0
2017-11-20 08:32:00	AAPL	Stock	42.6425	42.66	42.6425	42.66	7216.0
2017-11-20 08:33:00	AAPL	Stock	42.65	42.65	42.65	42.65	620.0
2017-11-20 08:35:00	AAPL	Stock	42.635	42.645	42.635	42.645	3200.0
2017-11-20 08:36:00	AAPL	Stock	42.645	42.645	42.63	42.63	2800.0
2017-11-20 08:38:00	AAPL	Stock	42.635	42.635	42.635	42.635	4600.0
2017-11-20 08:39:00	AAPL	Stock	42.645	42.645	42.6375	42.6375	1596.0

> showing 50 of 1,067,591 rows — these rows as CSV

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