PREVIEW / stock_5min / 2019-08-27

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-08-27.parquet
  size:    5.7 MB
  rows:    358,338
  symbols: 2,575

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
2019-08-27 04:00:00	AAPL	Stock	51.47	51.47	51.4275	51.4275	1200.0
2019-08-27 04:10:00	AAPL	Stock	51.4925	51.4925	51.4925	51.4925	400.0
2019-08-27 04:20:00	AAPL	Stock	51.5	51.5	51.5	51.5	1200.0
2019-08-27 05:00:00	AAPL	Stock	51.495	51.625	51.495	51.625	4236.0
2019-08-27 05:10:00	AAPL	Stock	51.5925	51.5925	51.5925	51.5925	6380.0
2019-08-27 05:25:00	AAPL	Stock	51.5625	51.5625	51.5125	51.5125	4276.0
2019-08-27 05:30:00	AAPL	Stock	51.5825	51.5825	51.5825	51.5825	2600.0
2019-08-27 05:35:00	AAPL	Stock	51.6025	51.6725	51.6025	51.6725	1944.0
2019-08-27 06:00:00	AAPL	Stock	51.6225	51.6225	51.6225	51.6225	400.0
2019-08-27 06:05:00	AAPL	Stock	51.66	51.6725	51.66	51.6725	3316.0
2019-08-27 06:10:00	AAPL	Stock	51.6975	51.7225	51.6975	51.7225	2000.0
2019-08-27 06:35:00	AAPL	Stock	51.71	51.71	51.71	51.71	824.0
2019-08-27 07:00:00	AAPL	Stock	51.715	51.725	51.6375	51.7125	7888.0
2019-08-27 07:05:00	AAPL	Stock	51.75	51.8375	51.75	51.82	11016.0
2019-08-27 07:10:00	AAPL	Stock	51.8175	51.8175	51.8175	51.8175	400.0
2019-08-27 07:15:00	AAPL	Stock	51.79	51.8175	51.79	51.8175	1600.0
2019-08-27 07:20:00	AAPL	Stock	51.8	51.8	51.77	51.8	11592.0
2019-08-27 07:25:00	AAPL	Stock	51.7875	51.815	51.7625	51.775	9324.0
2019-08-27 07:30:00	AAPL	Stock	51.7825	51.7825	51.75	51.75	2952.0
2019-08-27 07:35:00	AAPL	Stock	51.7625	51.795	51.7625	51.775	2900.0
2019-08-27 07:45:00	AAPL	Stock	51.7725	51.7725	51.7425	51.75	33760.0
2019-08-27 07:50:00	AAPL	Stock	51.75	51.7625	51.75	51.7625	1284.0
2019-08-27 07:55:00	AAPL	Stock	51.775	51.775	51.775	51.775	8100.0
2019-08-27 08:00:00	AAPL	Stock	51.7325	51.8275	51.6525	51.7627	109624.0
2019-08-27 08:05:00	AAPL	Stock	51.7925	51.835	51.7775	51.8	7720.0
2019-08-27 08:10:00	AAPL	Stock	51.8125	51.825	51.8	51.8125	2800.0
2019-08-27 08:15:00	AAPL	Stock	51.8025	51.81	51.75	51.81	12268.0
2019-08-27 08:20:00	AAPL	Stock	51.775	51.86	51.775	51.86	34768.0
2019-08-27 08:25:00	AAPL	Stock	51.8525	51.9725	51.8525	51.9375	47992.0
2019-08-27 08:30:00	AAPL	Stock	51.955	51.96	51.89	51.92	40472.0
2019-08-27 08:35:00	AAPL	Stock	51.92	51.9425	51.875	51.9	27180.0
2019-08-27 08:40:00	AAPL	Stock	51.9	51.935	51.9	51.935	28100.0
2019-08-27 08:45:00	AAPL	Stock	51.935	51.9375	51.9025	51.93	43172.0
2019-08-27 08:50:00	AAPL	Stock	51.9125	51.9625	51.9075	51.95	25724.0
2019-08-27 08:55:00	AAPL	Stock	51.9325	51.9875	51.93	51.9625	36956.0
2019-08-27 09:00:00	AAPL	Stock	51.9625	51.9725	51.91	51.925	29632.0
2019-08-27 09:05:00	AAPL	Stock	51.9375	51.9875	51.925	51.985	39820.0
2019-08-27 09:10:00	AAPL	Stock	51.975	51.975	51.9225	51.9375	19076.0
2019-08-27 09:15:00	AAPL	Stock	51.935	51.95	51.935	51.95	24572.0
2019-08-27 09:20:00	AAPL	Stock	51.9475	51.95	51.925	51.9475	59984.0
2019-08-27 09:25:00	AAPL	Stock	51.9475	51.9875	51.9225	51.9725	60292.0
2019-08-27 09:30:00	AAPL	Stock	51.9775	52.1375	51.8775	51.9	3868776.0
2019-08-27 09:35:00	AAPL	Stock	51.905	52.0	51.82	51.82	2025416.0
2019-08-27 09:40:00	AAPL	Stock	51.825	51.8948	51.675	51.755	1990292.0
2019-08-27 09:45:00	AAPL	Stock	51.7625	51.9	51.7025	51.798	1301880.0
2019-08-27 09:50:00	AAPL	Stock	51.805	51.832	51.6675	51.7375	1439412.0
2019-08-27 09:55:00	AAPL	Stock	51.735	51.795	51.7075	51.7325	715364.0
2019-08-27 10:00:00	AAPL	Stock	51.7312	51.795	51.675	51.709	906148.0
2019-08-27 10:05:00	AAPL	Stock	51.715	51.7712	51.67	51.6775	754576.0
2019-08-27 10:10:00	AAPL	Stock	51.6775	51.695	51.6125	51.6458	1368220.0

> showing 50 of 358,338 rows — these rows as CSV

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