PREVIEW / stock_5min / 2017-11-29

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-11-29.parquet
  size:    5.7 MB
  rows:    371,162
  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-29 05:40:00	AAPL	Stock	43.185	43.185	43.125	43.125	2372.0
2017-11-29 06:10:00	AAPL	Stock	43.1875	43.1875	43.1875	43.1875	400.0
2017-11-29 06:15:00	AAPL	Stock	43.2075	43.2075	43.2025	43.2025	2448.0
2017-11-29 07:00:00	AAPL	Stock	43.27	43.3	43.27	43.3	2700.0
2017-11-29 07:05:00	AAPL	Stock	43.325	43.3375	43.3125	43.325	6320.0
2017-11-29 07:10:00	AAPL	Stock	43.335	43.335	43.3125	43.3125	1200.0
2017-11-29 07:15:00	AAPL	Stock	43.3	43.3125	43.3	43.3075	11352.0
2017-11-29 07:20:00	AAPL	Stock	43.3125	43.3325	43.3	43.3325	2156.0
2017-11-29 07:30:00	AAPL	Stock	43.3	43.3	43.3	43.3	1600.0
2017-11-29 07:35:00	AAPL	Stock	43.3	43.3	43.275	43.295	14004.0
2017-11-29 07:45:00	AAPL	Stock	43.2975	43.2975	43.2875	43.2875	6000.0
2017-11-29 07:50:00	AAPL	Stock	43.2875	43.2875	43.275	43.275	3896.0
2017-11-29 08:00:00	AAPL	Stock	43.335	43.335	43.2525	43.2725	11620.0
2017-11-29 08:05:00	AAPL	Stock	43.2725	43.2925	43.2725	43.2925	10792.0
2017-11-29 08:10:00	AAPL	Stock	43.275	43.275	43.255	43.2575	6500.0
2017-11-29 08:15:00	AAPL	Stock	43.2675	43.3	43.2675	43.3	21484.0
2017-11-29 08:20:00	AAPL	Stock	43.2975	43.2975	43.28	43.295	2572.0
2017-11-29 08:25:00	AAPL	Stock	43.2775	43.2775	43.275	43.275	10196.0
2017-11-29 08:30:00	AAPL	Stock	43.255	43.255	43.23	43.23	19844.0
2017-11-29 08:35:00	AAPL	Stock	43.2275	43.25	43.215	43.22	11148.0
2017-11-29 08:40:00	AAPL	Stock	43.2175	43.225	43.2125	43.225	35496.0
2017-11-29 08:45:00	AAPL	Stock	43.21	43.21	43.1775	43.1775	14032.0
2017-11-29 08:50:00	AAPL	Stock	43.1875	43.2075	43.1875	43.19	13808.0
2017-11-29 08:55:00	AAPL	Stock	43.2025	43.2225	43.2	43.2225	4476.0
2017-11-29 09:00:00	AAPL	Stock	43.2325	43.2375	43.21	43.21	17320.0
2017-11-29 09:05:00	AAPL	Stock	43.22	43.22	43.1875	43.1875	15200.0
2017-11-29 09:10:00	AAPL	Stock	43.19	43.2125	43.19	43.2125	17600.0
2017-11-29 09:15:00	AAPL	Stock	43.2	43.2	43.1875	43.1875	18580.0
2017-11-29 09:20:00	AAPL	Stock	43.2	43.2	43.19	43.2	6496.0
2017-11-29 09:25:00	AAPL	Stock	43.19	43.19	43.135	43.1375	43212.0
2017-11-29 09:30:00	AAPL	Stock	43.1575	43.23	43.0625	43.1	3732204.0
2017-11-29 09:35:00	AAPL	Stock	43.105	43.1775	42.985	43.025	2415380.0
2017-11-29 09:40:00	AAPL	Stock	43.0225	43.16	43.0162	43.155	1987232.0
2017-11-29 09:45:00	AAPL	Stock	43.1525	43.16	42.985	43.0125	1603632.0
2017-11-29 09:50:00	AAPL	Stock	43.01	43.0375	42.96	43.0225	2104272.0
2017-11-29 09:55:00	AAPL	Stock	43.0225	43.06	42.92	42.9505	2618596.0
2017-11-29 10:00:00	AAPL	Stock	42.95	42.9575	42.775	42.8025	2370488.0
2017-11-29 10:05:00	AAPL	Stock	42.805	42.91	42.8025	42.8335	1761220.0
2017-11-29 10:10:00	AAPL	Stock	42.835	42.925	42.7175	42.7375	2363068.0
2017-11-29 10:15:00	AAPL	Stock	42.74	42.7425	42.35	42.365	5470244.0
2017-11-29 10:20:00	AAPL	Stock	42.37	42.545	42.295	42.3275	5427648.0
2017-11-29 10:25:00	AAPL	Stock	42.33	42.485	42.2325	42.485	3216032.0
2017-11-29 10:30:00	AAPL	Stock	42.4875	42.4975	42.3975	42.435	2759220.0
2017-11-29 10:35:00	AAPL	Stock	42.44	42.5875	42.4052	42.5078	2842564.0
2017-11-29 10:40:00	AAPL	Stock	42.51	42.53	42.4125	42.4775	2001028.0
2017-11-29 10:45:00	AAPL	Stock	42.48	42.485	42.365	42.4275	1367116.0
2017-11-29 10:50:00	AAPL	Stock	42.425	42.45	42.2875	42.3188	1956692.0
2017-11-29 10:55:00	AAPL	Stock	42.3225	42.3975	42.1825	42.2	4372224.0
2017-11-29 11:00:00	AAPL	Stock	42.2012	42.2575	42.1275	42.254	2523504.0
2017-11-29 11:05:00	AAPL	Stock	42.255	42.305	42.23	42.248	2455564.0

> showing 50 of 371,162 rows — these rows as CSV

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