PREVIEW / stock_5min / 2017-11-20

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-11-20.parquet
  size:    5.6 MB
  rows:    360,693
  symbols: 2,936

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:45:00	AAPL	Stock	42.475	42.475	42.475	42.475	1948.0
2017-11-20 05:40:00	AAPL	Stock	42.475	42.475	42.475	42.475	400.0
2017-11-20 06:05:00	AAPL	Stock	42.5	42.5	42.5	42.5	400.0
2017-11-20 06:35:00	AAPL	Stock	42.5	42.5275	42.5	42.5275	2000.0
2017-11-20 06:45: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:55: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.525	16448.0
2017-11-20 07:05:00	AAPL	Stock	42.54	42.54	42.54	42.54	2000.0
2017-11-20 07:10:00	AAPL	Stock	42.525	42.525	42.525	42.525	2600.0
2017-11-20 07:15: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.5025	42.5025	1200.0
2017-11-20 07:35:00	AAPL	Stock	42.5325	42.535	42.5325	42.535	4624.0
2017-11-20 07:40:00	AAPL	Stock	42.5375	42.56	42.5375	42.56	3996.0
2017-11-20 07:50:00	AAPL	Stock	42.55	42.55	42.55	42.55	6004.0
2017-11-20 08:00:00	AAPL	Stock	42.555	42.5625	42.535	42.535	30100.0
2017-11-20 08:05:00	AAPL	Stock	42.535	42.535	42.515	42.515	1196.0
2017-11-20 08:10:00	AAPL	Stock	42.535	42.5625	42.535	42.5625	7188.0
2017-11-20 08:15:00	AAPL	Stock	42.555	42.5825	42.555	42.5825	22640.0
2017-11-20 08:20:00	AAPL	Stock	42.5875	42.605	42.585	42.605	15696.0
2017-11-20 08:25:00	AAPL	Stock	42.6075	42.625	42.6075	42.625	14532.0
2017-11-20 08:30:00	AAPL	Stock	42.625	42.66	42.625	42.65	20784.0
2017-11-20 08:35:00	AAPL	Stock	42.635	42.645	42.63	42.6375	12196.0
2017-11-20 08:40:00	AAPL	Stock	42.64	42.64	42.6275	42.63	11776.0
2017-11-20 08:45:00	AAPL	Stock	42.6375	42.64	42.6375	42.64	800.0
2017-11-20 08:50:00	AAPL	Stock	42.63	42.6375	42.63	42.6375	800.0
2017-11-20 08:55:00	AAPL	Stock	42.645	42.645	42.635	42.635	13440.0
2017-11-20 09:00:00	AAPL	Stock	42.6425	42.675	42.635	42.66	29116.0
2017-11-20 09:05:00	AAPL	Stock	42.66	42.66	42.6325	42.6325	1792.0
2017-11-20 09:10:00	AAPL	Stock	42.6375	42.6375	42.625	42.6275	5544.0
2017-11-20 09:15:00	AAPL	Stock	42.6375	42.6375	42.625	42.625	3956.0
2017-11-20 09:20:00	AAPL	Stock	42.625	42.6275	42.6	42.6275	18412.0
2017-11-20 09:25:00	AAPL	Stock	42.6375	42.645	42.57	42.5825	84980.0
2017-11-20 09:30:00	AAPL	Stock	42.5725	42.6	42.4275	42.485	3284544.0
2017-11-20 09:35:00	AAPL	Stock	42.4875	42.625	42.4725	42.62	1466168.0
2017-11-20 09:40:00	AAPL	Stock	42.6225	42.64	42.45	42.6038	1407748.0
2017-11-20 09:45:00	AAPL	Stock	42.605	42.6175	42.57	42.5725	764112.0
2017-11-20 09:50:00	AAPL	Stock	42.575	42.58	42.485	42.5102	1089492.0
2017-11-20 09:55:00	AAPL	Stock	42.515	42.5725	42.51	42.5425	1036052.0
2017-11-20 10:00:00	AAPL	Stock	42.5375	42.59	42.5375	42.5675	1009248.0
2017-11-20 10:05:00	AAPL	Stock	42.5688	42.585	42.5325	42.56	781552.0
2017-11-20 10:10:00	AAPL	Stock	42.56	42.5712	42.53	42.5525	901348.0
2017-11-20 10:15:00	AAPL	Stock	42.55	42.5625	42.5325	42.5442	587736.0
2017-11-20 10:20:00	AAPL	Stock	42.5462	42.5538	42.505	42.5065	1313360.0
2017-11-20 10:25:00	AAPL	Stock	42.5075	42.5075	42.434	42.434	1132932.0
2017-11-20 10:30:00	AAPL	Stock	42.4325	42.505	42.4325	42.4965	982552.0
2017-11-20 10:35:00	AAPL	Stock	42.495	42.53	42.4825	42.49	722132.0
2017-11-20 10:40:00	AAPL	Stock	42.49	42.5025	42.4775	42.4848	487252.0
2017-11-20 10:45:00	AAPL	Stock	42.485	42.5175	42.4775	42.4963	552764.0
2017-11-20 10:50:00	AAPL	Stock	42.4975	42.5525	42.4925	42.53	772504.0

> showing 50 of 360,693 rows — these rows as CSV

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