PREVIEW / stock_5min / 2017-01-09

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-01-09.parquet
  size:    5.4 MB
  rows:    356,101
  symbols: 3,127

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:00:00	AAPL	Stock	29.5	29.5	29.5	29.5	5080.0
2017-01-09 04:20:00	AAPL	Stock	29.43	29.43	29.43	29.43	596.0
2017-01-09 05:00: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:35:00	AAPL	Stock	29.4375	29.4375	29.4375	29.4375	1080.0
2017-01-09 05:45:00	AAPL	Stock	29.4475	29.4475	29.4375	29.4375	2000.0
2017-01-09 05:50:00	AAPL	Stock	29.4475	29.4725	29.4475	29.4725	4400.0
2017-01-09 05:55:00	AAPL	Stock	29.4475	29.4475	29.4475	29.4475	400.0
2017-01-09 06:30:00	AAPL	Stock	29.415	29.4275	29.395	29.405	8084.0
2017-01-09 06:35:00	AAPL	Stock	29.385	29.385	29.38	29.38	1808.0
2017-01-09 06:40:00	AAPL	Stock	29.3775	29.3775	29.3775	29.3775	400.0
2017-01-09 06:45:00	AAPL	Stock	29.3975	29.405	29.3975	29.405	5896.0
2017-01-09 06:50:00	AAPL	Stock	29.405	29.405	29.405	29.405	2640.0
2017-01-09 07:00:00	AAPL	Stock	29.4375	29.4475	29.4375	29.4475	1600.0
2017-01-09 07:05:00	AAPL	Stock	29.46	29.46	29.455	29.455	1968.0
2017-01-09 07:10:00	AAPL	Stock	29.45	29.45	29.45	29.45	3360.0
2017-01-09 07:20:00	AAPL	Stock	29.45	29.45	29.45	29.45	640.0
2017-01-09 07:25:00	AAPL	Stock	29.46	29.4725	29.46	29.4725	7600.0
2017-01-09 07:30:00	AAPL	Stock	29.47	29.525	29.47	29.525	31528.0
2017-01-09 07:35:00	AAPL	Stock	29.525	29.5425	29.525	29.525	17688.0
2017-01-09 07:40:00	AAPL	Stock	29.5175	29.525	29.5175	29.525	2800.0
2017-01-09 07:45:00	AAPL	Stock	29.52	29.52	29.505	29.505	7800.0
2017-01-09 07:50:00	AAPL	Stock	29.5025	29.505	29.5	29.505	2812.0
2017-01-09 07:55:00	AAPL	Stock	29.52	29.535	29.52	29.525	19200.0
2017-01-09 08:00:00	AAPL	Stock	29.52	29.5425	29.5025	29.52	40196.0
2017-01-09 08:05:00	AAPL	Stock	29.5175	29.5375	29.51	29.525	15200.0
2017-01-09 08:10:00	AAPL	Stock	29.5275	29.545	29.525	29.525	28560.0
2017-01-09 08:15:00	AAPL	Stock	29.525	29.5375	29.525	29.5375	15776.0
2017-01-09 08:20:00	AAPL	Stock	29.5375	29.5475	29.5275	29.5275	37440.0
2017-01-09 08:25:00	AAPL	Stock	29.54	29.54	29.525	29.53	8240.0
2017-01-09 08:30:00	AAPL	Stock	29.5375	29.55	29.5325	29.5475	34556.0
2017-01-09 08:35:00	AAPL	Stock	29.5475	29.5475	29.5425	29.5425	1000.0
2017-01-09 08:40:00	AAPL	Stock	29.5425	29.555	29.535	29.55	55332.0
2017-01-09 08:45:00	AAPL	Stock	29.5375	29.5675	29.525	29.5675	49872.0
2017-01-09 08:50:00	AAPL	Stock	29.5325	29.55	29.525	29.5275	66632.0
2017-01-09 08:55:00	AAPL	Stock	29.5275	29.5375	29.5275	29.5275	3616.0
2017-01-09 09:00:00	AAPL	Stock	29.5275	29.5375	29.5275	29.5375	4400.0
2017-01-09 09:05:00	AAPL	Stock	29.5375	29.5375	29.4875	29.4875	31160.0
2017-01-09 09:10:00	AAPL	Stock	29.4875	29.49	29.4875	29.49	3600.0
2017-01-09 09:15:00	AAPL	Stock	29.4925	29.4975	29.4875	29.4875	10264.0
2017-01-09 09:20:00	AAPL	Stock	29.485	29.56	29.4725	29.54	99788.0
2017-01-09 09:25:00	AAPL	Stock	29.5475	29.5825	29.4875	29.4875	394864.0
2017-01-09 09:30:00	AAPL	Stock	29.485	29.625	29.485	29.6075	8866428.0
2017-01-09 09:35:00	AAPL	Stock	29.6075	29.745	29.5875	29.735	6321040.0
2017-01-09 09:40:00	AAPL	Stock	29.7362	29.74	29.695	29.73	3434344.0
2017-01-09 09:45:00	AAPL	Stock	29.7312	29.7975	29.7225	29.775	6153912.0
2017-01-09 09:50:00	AAPL	Stock	29.7752	29.825	29.7575	29.7875	4236760.0
2017-01-09 09:55:00	AAPL	Stock	29.786	29.8225	29.745	29.7625	2887788.0
2017-01-09 10:00:00	AAPL	Stock	29.7625	29.8225	29.7598	29.7675	2176916.0
2017-01-09 10:05:00	AAPL	Stock	29.7675	29.77	29.7125	29.7175	1759192.0

> showing 50 of 356,101 rows — these rows as CSV

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