PREVIEW / stock_5min / 2017-10-31

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-10-31.parquet
  size:    5.6 MB
  rows:    359,518
  symbols: 2,945

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-31 04:00:00	AAPL	Stock	41.75	41.75	41.75	41.75	1276.0
2017-10-31 04:10:00	AAPL	Stock	41.76	41.76	41.75	41.75	1480.0
2017-10-31 04:20:00	AAPL	Stock	41.77	41.77	41.77	41.77	516.0
2017-10-31 05:25:00	AAPL	Stock	41.8125	41.8125	41.8125	41.8125	1984.0
2017-10-31 05:50:00	AAPL	Stock	41.8625	41.8625	41.8625	41.8625	400.0
2017-10-31 05:55:00	AAPL	Stock	41.8625	41.8625	41.8625	41.8625	1200.0
2017-10-31 06:00:00	AAPL	Stock	41.87	41.87	41.8625	41.87	1760.0
2017-10-31 06:05:00	AAPL	Stock	41.85	41.85	41.845	41.845	800.0
2017-10-31 06:10:00	AAPL	Stock	41.875	41.875	41.875	41.875	1188.0
2017-10-31 06:15:00	AAPL	Stock	41.875	41.875	41.8525	41.8525	800.0
2017-10-31 06:25:00	AAPL	Stock	41.925	41.925	41.9	41.9	3600.0
2017-10-31 06:30:00	AAPL	Stock	41.885	41.885	41.885	41.885	400.0
2017-10-31 06:35:00	AAPL	Stock	41.9	41.92	41.9	41.92	4000.0
2017-10-31 06:40:00	AAPL	Stock	41.875	41.875	41.85	41.85	3196.0
2017-10-31 06:50:00	AAPL	Stock	41.825	41.8275	41.8	41.8	5740.0
2017-10-31 06:55:00	AAPL	Stock	41.775	41.7775	41.775	41.7775	4232.0
2017-10-31 07:00:00	AAPL	Stock	41.775	41.8675	41.775	41.8375	38784.0
2017-10-31 07:05:00	AAPL	Stock	41.8375	41.8675	41.8375	41.8675	8720.0
2017-10-31 07:10:00	AAPL	Stock	41.85	41.85	41.7875	41.825	27320.0
2017-10-31 07:15:00	AAPL	Stock	41.805	41.85	41.805	41.85	21000.0
2017-10-31 07:20:00	AAPL	Stock	41.85	41.85	41.8325	41.835	23660.0
2017-10-31 07:25:00	AAPL	Stock	41.8375	41.8375	41.825	41.8375	28776.0
2017-10-31 07:30:00	AAPL	Stock	41.8625	41.87	41.8425	41.87	6560.0
2017-10-31 07:35:00	AAPL	Stock	41.87	41.885	41.865	41.88	27872.0
2017-10-31 07:40:00	AAPL	Stock	41.885	41.92	41.875	41.895	61576.0
2017-10-31 07:45:00	AAPL	Stock	41.875	41.895	41.875	41.895	5192.0
2017-10-31 07:50:00	AAPL	Stock	41.895	41.9025	41.89	41.9025	13104.0
2017-10-31 07:55:00	AAPL	Stock	41.905	41.9175	41.905	41.9175	23900.0
2017-10-31 08:00:00	AAPL	Stock	41.865	41.925	41.8375	41.92	165316.0
2017-10-31 08:05:00	AAPL	Stock	41.9175	41.9475	41.77	41.945	88248.0
2017-10-31 08:10:00	AAPL	Stock	41.9375	41.9475	41.9375	41.9475	21856.0
2017-10-31 08:15:00	AAPL	Stock	41.9475	41.9475	41.9425	41.9475	33880.0
2017-10-31 08:20:00	AAPL	Stock	41.9475	42.0175	41.9475	42.0	151796.0
2017-10-31 08:25:00	AAPL	Stock	42.0	42.0	41.95	41.9725	47264.0
2017-10-31 08:30:00	AAPL	Stock	41.9625	41.9725	41.96	41.9725	25716.0
2017-10-31 08:35:00	AAPL	Stock	41.9725	41.9975	41.9625	41.9975	46952.0
2017-10-31 08:40:00	AAPL	Stock	42.0	42.05	42.0	42.0475	204488.0
2017-10-31 08:45:00	AAPL	Stock	42.0475	42.0925	42.0475	42.0525	150984.0
2017-10-31 08:50:00	AAPL	Stock	42.055	42.075	42.0375	42.0625	41248.0
2017-10-31 08:55:00	AAPL	Stock	42.0625	42.0725	42.025	42.0375	53156.0
2017-10-31 09:00:00	AAPL	Stock	42.0225	42.05	42.0	42.005	130148.0
2017-10-31 09:05:00	AAPL	Stock	42.005	42.02	41.975	42.0	110300.0
2017-10-31 09:10:00	AAPL	Stock	42.0025	42.0025	41.9875	41.99	34668.0
2017-10-31 09:15:00	AAPL	Stock	41.985	42.0675	41.985	42.0675	203460.0
2017-10-31 09:20:00	AAPL	Stock	42.065	42.0725	42.0225	42.055	134188.0
2017-10-31 09:25:00	AAPL	Stock	42.0525	42.0725	41.965	41.99	203540.0
2017-10-31 09:30:00	AAPL	Stock	41.975	42.1725	41.8775	41.9075	8797328.0
2017-10-31 09:35:00	AAPL	Stock	41.9058	41.955	41.8525	41.9275	3747844.0
2017-10-31 09:40:00	AAPL	Stock	41.925	41.9482	41.89	41.9125	1846760.0
2017-10-31 09:45:00	AAPL	Stock	41.9125	41.9425	41.875	41.8875	2422268.0

> showing 50 of 359,518 rows — these rows as CSV

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