PREVIEW / stock_5min / 2017-07-31

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-07-31.parquet
  size:    5.3 MB
  rows:    346,847
  symbols: 2,991

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-07-31 04:00:00	AAPL	Stock	37.4375	37.4375	37.4375	37.4375	400.0
2017-07-31 04:15:00	AAPL	Stock	37.465	37.465	37.465	37.465	524.0
2017-07-31 05:05:00	AAPL	Stock	37.55	37.55	37.55	37.55	6592.0
2017-07-31 05:25:00	AAPL	Stock	37.5625	37.5625	37.5625	37.5625	400.0
2017-07-31 05:50:00	AAPL	Stock	37.5575	37.5575	37.5575	37.5575	400.0
2017-07-31 05:55:00	AAPL	Stock	37.51	37.51	37.51	37.51	400.0
2017-07-31 06:05:00	AAPL	Stock	37.5125	37.5125	37.5125	37.5125	516.0
2017-07-31 06:15:00	AAPL	Stock	37.5325	37.5325	37.5325	37.5325	1200.0
2017-07-31 06:20:00	AAPL	Stock	37.525	37.525	37.525	37.525	1200.0
2017-07-31 06:30:00	AAPL	Stock	37.5375	37.55	37.5125	37.5125	4800.0
2017-07-31 06:45:00	AAPL	Stock	37.5125	37.5125	37.5125	37.5125	1908.0
2017-07-31 06:50:00	AAPL	Stock	37.5025	37.5025	37.5	37.5	3172.0
2017-07-31 07:00:00	AAPL	Stock	37.5	37.5	37.5	37.5	5500.0
2017-07-31 07:05:00	AAPL	Stock	37.5125	37.52	37.5025	37.5175	6632.0
2017-07-31 07:10:00	AAPL	Stock	37.515	37.515	37.515	37.515	2400.0
2017-07-31 07:15:00	AAPL	Stock	37.5125	37.52	37.5125	37.52	8364.0
2017-07-31 07:20:00	AAPL	Stock	37.52	37.525	37.52	37.525	8644.0
2017-07-31 07:25:00	AAPL	Stock	37.5225	37.5225	37.5225	37.5225	1200.0
2017-07-31 07:30:00	AAPL	Stock	37.5225	37.5225	37.51	37.5175	2000.0
2017-07-31 07:35:00	AAPL	Stock	37.5125	37.5225	37.5075	37.5075	5600.0
2017-07-31 07:40:00	AAPL	Stock	37.5075	37.5075	37.5075	37.5075	2000.0
2017-07-31 07:45:00	AAPL	Stock	37.5	37.5	37.5	37.5	5012.0
2017-07-31 07:50:00	AAPL	Stock	37.5125	37.5125	37.505	37.5125	7432.0
2017-07-31 07:55:00	AAPL	Stock	37.5075	37.5225	37.5	37.5	15136.0
2017-07-31 08:00:00	AAPL	Stock	37.4775	37.525	37.4775	37.495	41256.0
2017-07-31 08:05:00	AAPL	Stock	37.4875	37.49	37.475	37.475	25968.0
2017-07-31 08:10:00	AAPL	Stock	37.4875	37.4975	37.4875	37.49	15080.0
2017-07-31 08:15:00	AAPL	Stock	37.4975	37.4975	37.4875	37.49	27804.0
2017-07-31 08:20:00	AAPL	Stock	37.49	37.49	37.49	37.49	7200.0
2017-07-31 08:25:00	AAPL	Stock	37.49	37.5	37.49	37.5	24556.0
2017-07-31 08:30:00	AAPL	Stock	37.495	37.495	37.4875	37.49	7280.0
2017-07-31 08:35:00	AAPL	Stock	37.4875	37.495	37.4875	37.495	16524.0
2017-07-31 08:40:00	AAPL	Stock	37.4875	37.495	37.4875	37.495	11936.0
2017-07-31 08:45:00	AAPL	Stock	37.495	37.495	37.4875	37.4925	5088.0
2017-07-31 08:50:00	AAPL	Stock	37.495	37.495	37.4925	37.4925	1784.0
2017-07-31 08:55:00	AAPL	Stock	37.4875	37.4875	37.455	37.455	39872.0
2017-07-31 09:00:00	AAPL	Stock	37.455	37.4875	37.455	37.4875	10236.0
2017-07-31 09:05:00	AAPL	Stock	37.4875	37.4875	37.475	37.485	2876.0
2017-07-31 09:10:00	AAPL	Stock	37.485	37.4875	37.4525	37.475	8568.0
2017-07-31 09:15:00	AAPL	Stock	37.4725	37.475	37.4725	37.4725	16688.0
2017-07-31 09:20:00	AAPL	Stock	37.475	37.475	37.45	37.47	4752.0
2017-07-31 09:25:00	AAPL	Stock	37.45	37.49	37.45	37.4825	25960.0
2017-07-31 09:30:00	AAPL	Stock	37.475	37.5	37.3875	37.4675	3004520.0
2017-07-31 09:35:00	AAPL	Stock	37.4625	37.5825	37.43	37.562	2412848.0
2017-07-31 09:40:00	AAPL	Stock	37.5625	37.5725	37.49	37.55	1472984.0
2017-07-31 09:45:00	AAPL	Stock	37.5488	37.55	37.4875	37.5108	1200312.0
2017-07-31 09:50:00	AAPL	Stock	37.5075	37.53	37.305	37.3362	2049772.0
2017-07-31 09:55:00	AAPL	Stock	37.335	37.4325	37.3325	37.3475	1381432.0
2017-07-31 10:00:00	AAPL	Stock	37.3475	37.365	37.2025	37.2575	1783800.0
2017-07-31 10:05:00	AAPL	Stock	37.2625	37.285	37.2	37.2578	1099108.0

> showing 50 of 346,847 rows — these rows as CSV

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