PREVIEW / stock_5min / 2017-09-07

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-09-07.parquet
  size:    5.4 MB
  rows:    354,184
  symbols: 2,978

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-09-07 04:40:00	AAPL	Stock	40.5	40.5	40.5	40.5	592.0
2017-09-07 05:00:00	AAPL	Stock	40.5	40.5	40.5	40.5	840.0
2017-09-07 05:05:00	AAPL	Stock	40.5	40.5	40.4875	40.5	13752.0
2017-09-07 05:10:00	AAPL	Stock	40.5	40.5	40.5	40.5	6804.0
2017-09-07 05:20:00	AAPL	Stock	40.5	40.5	40.5	40.5	2000.0
2017-09-07 05:25:00	AAPL	Stock	40.4875	40.4875	40.4875	40.4875	400.0
2017-09-07 05:30:00	AAPL	Stock	40.4875	40.4875	40.4875	40.4875	1040.0
2017-09-07 05:35:00	AAPL	Stock	40.4875	40.4875	40.4875	40.4875	800.0
2017-09-07 05:40:00	AAPL	Stock	40.55	40.55	40.55	40.55	3600.0
2017-09-07 05:50:00	AAPL	Stock	40.5	40.5	40.5	40.5	3400.0
2017-09-07 05:55:00	AAPL	Stock	40.5	40.5	40.5	40.5	3200.0
2017-09-07 06:05:00	AAPL	Stock	40.515	40.515	40.515	40.515	1732.0
2017-09-07 06:20:00	AAPL	Stock	40.5325	40.5375	40.5325	40.5375	7200.0
2017-09-07 06:25:00	AAPL	Stock	40.5475	40.55	40.5475	40.55	1748.0
2017-09-07 06:50:00	AAPL	Stock	40.55	40.56	40.55	40.55	6324.0
2017-09-07 06:55:00	AAPL	Stock	40.56	40.56	40.56	40.56	1200.0
2017-09-07 07:05:00	AAPL	Stock	40.5325	40.535	40.5325	40.535	1200.0
2017-09-07 07:10:00	AAPL	Stock	40.535	40.5425	40.5325	40.535	10400.0
2017-09-07 07:15:00	AAPL	Stock	40.535	40.535	40.5325	40.5325	5156.0
2017-09-07 07:20:00	AAPL	Stock	40.52	40.5325	40.52	40.52	3940.0
2017-09-07 07:25:00	AAPL	Stock	40.515	40.515	40.5075	40.5125	7400.0
2017-09-07 07:30:00	AAPL	Stock	40.5	40.5	40.5	40.5	400.0
2017-09-07 07:40:00	AAPL	Stock	40.5	40.5	40.5	40.5	3344.0
2017-09-07 07:45:00	AAPL	Stock	40.5	40.5	40.5	40.5	4868.0
2017-09-07 07:50:00	AAPL	Stock	40.515	40.515	40.4975	40.5125	5068.0
2017-09-07 07:55:00	AAPL	Stock	40.4875	40.4875	40.4875	40.4875	400.0
2017-09-07 08:00:00	AAPL	Stock	40.5125	40.535	40.475	40.475	83984.0
2017-09-07 08:05:00	AAPL	Stock	40.48	40.4875	40.45	40.45	34200.0
2017-09-07 08:10:00	AAPL	Stock	40.45	40.45	40.45	40.45	800.0
2017-09-07 08:15:00	AAPL	Stock	40.4525	40.4725	40.4525	40.4525	5996.0
2017-09-07 08:20:00	AAPL	Stock	40.4625	40.4625	40.45	40.45	1600.0
2017-09-07 08:25:00	AAPL	Stock	40.44	40.47	40.4375	40.47	12800.0
2017-09-07 08:30:00	AAPL	Stock	40.465	40.4875	40.44	40.4875	11560.0
2017-09-07 08:35:00	AAPL	Stock	40.4475	40.4525	40.4475	40.4525	4800.0
2017-09-07 08:40:00	AAPL	Stock	40.465	40.4725	40.45	40.4725	9364.0
2017-09-07 08:45:00	AAPL	Stock	40.45	40.475	40.45	40.47	6588.0
2017-09-07 08:50:00	AAPL	Stock	40.475	40.5	40.475	40.5	11648.0
2017-09-07 08:55:00	AAPL	Stock	40.5	40.525	40.5	40.5125	21096.0
2017-09-07 09:00:00	AAPL	Stock	40.5125	40.5325	40.5125	40.5325	8084.0
2017-09-07 09:05:00	AAPL	Stock	40.5275	40.5325	40.52	40.5325	8488.0
2017-09-07 09:10:00	AAPL	Stock	40.5325	40.535	40.525	40.53	13408.0
2017-09-07 09:15:00	AAPL	Stock	40.5275	40.5375	40.5275	40.5375	14524.0
2017-09-07 09:20:00	AAPL	Stock	40.5375	40.5375	40.52	40.5375	5060.0
2017-09-07 09:25:00	AAPL	Stock	40.545	40.545	40.515	40.515	9776.0
2017-09-07 09:30:00	AAPL	Stock	40.525	40.56	40.455	40.4802	2692124.0
2017-09-07 09:35:00	AAPL	Stock	40.4825	40.495	40.4425	40.47	1263964.0
2017-09-07 09:40:00	AAPL	Stock	40.4712	40.4725	40.3975	40.4	1449896.0
2017-09-07 09:45:00	AAPL	Stock	40.4	40.455	40.39	40.405	1401192.0
2017-09-07 09:50:00	AAPL	Stock	40.4025	40.435	40.38	40.3988	1008932.0
2017-09-07 09:55:00	AAPL	Stock	40.3975	40.4175	40.3462	40.3725	1273832.0

> showing 50 of 354,184 rows — these rows as CSV

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