PREVIEW / stock_5min / 2017-10-05

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-10-05.parquet
  size:    5.4 MB
  rows:    352,370
  symbols: 2,963

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-10-05 04:35:00	AAPL	Stock	38.41	38.41	38.41	38.41	400.0
2017-10-05 05:15:00	AAPL	Stock	38.375	38.375	38.375	38.375	2296.0
2017-10-05 06:10:00	AAPL	Stock	38.35	38.35	38.35	38.35	2000.0
2017-10-05 06:20:00	AAPL	Stock	38.375	38.375	38.375	38.375	1224.0
2017-10-05 06:45:00	AAPL	Stock	38.375	38.375	38.375	38.375	400.0
2017-10-05 07:00:00	AAPL	Stock	38.395	38.4175	38.395	38.4175	2400.0
2017-10-05 07:05:00	AAPL	Stock	38.415	38.415	38.415	38.415	1888.0
2017-10-05 07:10:00	AAPL	Stock	38.39	38.395	38.39	38.395	848.0
2017-10-05 07:15:00	AAPL	Stock	38.3925	38.3925	38.3925	38.3925	400.0
2017-10-05 07:20:00	AAPL	Stock	38.4175	38.4175	38.4175	38.4175	572.0
2017-10-05 07:25:00	AAPL	Stock	38.3925	38.3925	38.3925	38.3925	400.0
2017-10-05 07:35:00	AAPL	Stock	38.4225	38.425	38.4225	38.425	1080.0
2017-10-05 07:45:00	AAPL	Stock	38.43	38.43	38.43	38.43	400.0
2017-10-05 07:50:00	AAPL	Stock	38.435	38.435	38.435	38.435	1488.0
2017-10-05 07:55:00	AAPL	Stock	38.4475	38.45	38.4475	38.45	2408.0
2017-10-05 08:00:00	AAPL	Stock	38.45	38.4875	38.42	38.4875	41012.0
2017-10-05 08:05:00	AAPL	Stock	38.475	38.4925	38.475	38.4875	4800.0
2017-10-05 08:10:00	AAPL	Stock	38.475	38.55	38.475	38.5475	55560.0
2017-10-05 08:15:00	AAPL	Stock	38.53	38.545	38.525	38.525	12172.0
2017-10-05 08:20:00	AAPL	Stock	38.53	38.56	38.525	38.555	13864.0
2017-10-05 08:25:00	AAPL	Stock	38.555	38.5575	38.5375	38.5475	7200.0
2017-10-05 08:30:00	AAPL	Stock	38.54	38.55	38.53	38.5475	8960.0
2017-10-05 08:35:00	AAPL	Stock	38.53	38.5375	38.515	38.525	15100.0
2017-10-05 08:40:00	AAPL	Stock	38.51	38.5125	38.5025	38.505	9960.0
2017-10-05 08:45:00	AAPL	Stock	38.53	38.5375	38.525	38.5375	37452.0
2017-10-05 08:50:00	AAPL	Stock	38.5475	38.5675	38.5475	38.565	69180.0
2017-10-05 08:55:00	AAPL	Stock	38.565	38.565	38.5475	38.5475	800.0
2017-10-05 09:00:00	AAPL	Stock	38.56	38.56	38.55	38.5575	14200.0
2017-10-05 09:05:00	AAPL	Stock	38.55	38.55	38.545	38.5475	3288.0
2017-10-05 09:10:00	AAPL	Stock	38.545	38.545	38.51	38.52	27436.0
2017-10-05 09:15:00	AAPL	Stock	38.5125	38.525	38.5125	38.525	9096.0
2017-10-05 09:20:00	AAPL	Stock	38.5375	38.545	38.5375	38.545	4400.0
2017-10-05 09:25:00	AAPL	Stock	38.545	38.55	38.525	38.5275	24208.0
2017-10-05 09:30:00	AAPL	Stock	38.545	38.7225	38.5125	38.7125	3707020.0
2017-10-05 09:35:00	AAPL	Stock	38.715	38.7475	38.6728	38.7075	2435504.0
2017-10-05 09:40:00	AAPL	Stock	38.705	38.785	38.69	38.7438	2786692.0
2017-10-05 09:45:00	AAPL	Stock	38.7475	38.8405	38.73	38.805	2309080.0
2017-10-05 09:50:00	AAPL	Stock	38.805	38.8375	38.79	38.8275	1759180.0
2017-10-05 09:55:00	AAPL	Stock	38.825	38.835	38.725	38.7475	1866936.0
2017-10-05 10:00:00	AAPL	Stock	38.7475	38.8045	38.7375	38.7662	1860384.0
2017-10-05 10:05:00	AAPL	Stock	38.7675	38.83	38.765	38.795	1370052.0
2017-10-05 10:10:00	AAPL	Stock	38.7925	38.8112	38.7875	38.8088	844092.0
2017-10-05 10:15:00	AAPL	Stock	38.81	38.8175	38.7625	38.8025	1126392.0
2017-10-05 10:20:00	AAPL	Stock	38.8025	38.83	38.7862	38.7928	837696.0
2017-10-05 10:25:00	AAPL	Stock	38.7925	38.81	38.7375	38.75	1198460.0
2017-10-05 10:30:00	AAPL	Stock	38.7518	38.765	38.69	38.7125	1329008.0
2017-10-05 10:35:00	AAPL	Stock	38.7125	38.78	38.71	38.7625	912408.0
2017-10-05 10:40:00	AAPL	Stock	38.7575	38.765	38.7125	38.725	935000.0
2017-10-05 10:45:00	AAPL	Stock	38.7225	38.725	38.6675	38.695	948544.0
2017-10-05 10:50:00	AAPL	Stock	38.695	38.7175	38.655	38.6853	1038260.0

> showing 50 of 352,370 rows — these rows as CSV

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