PREVIEW / stock_5min / 2017-06-26

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-06-26.parquet
  size:    5.4 MB
  rows:    358,370
  symbols: 3,029

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-06-26 05:00:00	AAPL	Stock	36.6925	36.6925	36.6925	36.6925	1888.0
2017-06-26 05:25:00	AAPL	Stock	36.6925	36.6925	36.6925	36.6925	2000.0
2017-06-26 06:10:00	AAPL	Stock	36.65	36.65	36.65	36.65	5600.0
2017-06-26 06:15:00	AAPL	Stock	36.68	36.68	36.68	36.68	400.0
2017-06-26 06:40:00	AAPL	Stock	36.675	36.675	36.675	36.675	1600.0
2017-06-26 06:55:00	AAPL	Stock	36.65	36.6525	36.65	36.6525	1616.0
2017-06-26 07:00:00	AAPL	Stock	36.6725	36.68	36.665	36.68	44552.0
2017-06-26 07:10:00	AAPL	Stock	36.675	36.68	36.675	36.68	43104.0
2017-06-26 07:15:00	AAPL	Stock	36.6875	36.6875	36.6875	36.6875	1288.0
2017-06-26 07:20:00	AAPL	Stock	36.6875	36.6875	36.675	36.675	17000.0
2017-06-26 07:25:00	AAPL	Stock	36.675	36.6875	36.675	36.6825	4732.0
2017-06-26 07:30:00	AAPL	Stock	36.6875	36.6875	36.6875	36.6875	2400.0
2017-06-26 07:35:00	AAPL	Stock	36.6875	36.695	36.6875	36.695	3500.0
2017-06-26 07:40:00	AAPL	Stock	36.7075	36.75	36.7075	36.75	22824.0
2017-06-26 07:45:00	AAPL	Stock	36.75	36.7625	36.75	36.75	8492.0
2017-06-26 07:50:00	AAPL	Stock	36.755	36.785	36.755	36.785	2964.0
2017-06-26 07:55:00	AAPL	Stock	36.765	36.765	36.7625	36.7625	2000.0
2017-06-26 08:00:00	AAPL	Stock	36.755	36.7725	36.665	36.7725	111068.0
2017-06-26 08:05:00	AAPL	Stock	36.7725	36.8125	36.7725	36.8075	31084.0
2017-06-26 08:10:00	AAPL	Stock	36.8075	36.8075	36.76	36.76	47152.0
2017-06-26 08:15:00	AAPL	Stock	36.7625	36.785	36.7625	36.785	34248.0
2017-06-26 08:20:00	AAPL	Stock	36.785	36.7925	36.785	36.7925	11756.0
2017-06-26 08:25:00	AAPL	Stock	36.7925	36.7925	36.7775	36.79	14800.0
2017-06-26 08:30:00	AAPL	Stock	36.775	36.7875	36.765	36.785	14992.0
2017-06-26 08:35:00	AAPL	Stock	36.7825	36.7825	36.77	36.775	17680.0
2017-06-26 08:40:00	AAPL	Stock	36.78	36.7875	36.7625	36.7875	37252.0
2017-06-26 08:50:00	AAPL	Stock	36.7975	36.8025	36.7875	36.8025	6840.0
2017-06-26 08:55:00	AAPL	Stock	36.7925	36.8075	36.7925	36.8075	14148.0
2017-06-26 09:00:00	AAPL	Stock	36.8075	36.8075	36.7825	36.7825	12244.0
2017-06-26 09:05:00	AAPL	Stock	36.8	36.8025	36.7975	36.8	14796.0
2017-06-26 09:10:00	AAPL	Stock	36.8025	36.81	36.8	36.8075	18316.0
2017-06-26 09:15:00	AAPL	Stock	36.8075	36.81	36.8	36.8075	37736.0
2017-06-26 09:20:00	AAPL	Stock	36.8025	36.81	36.79	36.81	8356.0
2017-06-26 09:25:00	AAPL	Stock	36.81	36.825	36.775	36.7975	55104.0
2017-06-26 09:30:00	AAPL	Stock	36.7925	37.0425	36.7925	37.02	4812820.0
2017-06-26 09:35:00	AAPL	Stock	37.0225	37.0525	36.9392	37.005	3220280.0
2017-06-26 09:40:00	AAPL	Stock	37.0035	37.07	36.995	37.0425	2853556.0
2017-06-26 09:45:00	AAPL	Stock	37.045	37.0625	37.015	37.0175	1539812.0
2017-06-26 09:50:00	AAPL	Stock	37.0175	37.03	36.9625	37.0	1669824.0
2017-06-26 09:55:00	AAPL	Stock	36.9975	37.0225	36.9775	36.99	1016656.0
2017-06-26 10:00:00	AAPL	Stock	36.9925	37.0	36.9375	36.945	1496352.0
2017-06-26 10:05:00	AAPL	Stock	36.9425	36.9595	36.82	36.845	1836660.0
2017-06-26 10:10:00	AAPL	Stock	36.845	36.8525	36.785	36.835	1822504.0
2017-06-26 10:15:00	AAPL	Stock	36.8308	36.8525	36.775	36.8525	1662660.0
2017-06-26 10:20:00	AAPL	Stock	36.85	36.9225	36.7928	36.845	1211468.0
2017-06-26 10:25:00	AAPL	Stock	36.8425	36.8975	36.8412	36.875	1232840.0
2017-06-26 10:30:00	AAPL	Stock	36.8728	36.8845	36.78	36.795	978960.0
2017-06-26 10:35:00	AAPL	Stock	36.795	36.795	36.645	36.679	2484024.0
2017-06-26 10:40:00	AAPL	Stock	36.675	36.7025	36.6225	36.6625	2141096.0
2017-06-26 10:45:00	AAPL	Stock	36.665	36.6955	36.615	36.6178	1395452.0

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

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