PREVIEW / stock_5min / 2017-12-26

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-12-26.parquet
  size:    5.4 MB
  rows:    349,530
  symbols: 2,889

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-12-26 04:00:00	AAPL	Stock	43.625	43.625	43.155	43.155	9800.0
2017-12-26 04:10:00	AAPL	Stock	43.1	43.125	43.1	43.125	7964.0
2017-12-26 04:15:00	AAPL	Stock	43.125	43.125	43.125	43.125	560.0
2017-12-26 04:30:00	AAPL	Stock	43.185	43.185	43.175	43.175	800.0
2017-12-26 04:35:00	AAPL	Stock	43.175	43.175	43.125	43.125	1600.0
2017-12-26 04:45:00	AAPL	Stock	43.05	43.05	43.0	43.0	3732.0
2017-12-26 04:50:00	AAPL	Stock	43.0	43.0	43.0	43.0	800.0
2017-12-26 04:55:00	AAPL	Stock	43.0	43.0	42.9375	42.9375	3600.0
2017-12-26 05:00:00	AAPL	Stock	42.9375	42.9375	42.9375	42.9375	988.0
2017-12-26 05:20:00	AAPL	Stock	42.9375	42.9375	42.9375	42.9375	400.0
2017-12-26 05:25:00	AAPL	Stock	42.9425	42.9425	42.9375	42.9375	1200.0
2017-12-26 05:50:00	AAPL	Stock	43.0275	43.0275	43.0275	43.0275	1800.0
2017-12-26 06:00:00	AAPL	Stock	43.005	43.005	43.005	43.005	400.0
2017-12-26 06:05:00	AAPL	Stock	43.025	43.0575	43.025	43.0575	2800.0
2017-12-26 06:10:00	AAPL	Stock	43.025	43.025	43.015	43.015	3200.0
2017-12-26 06:15:00	AAPL	Stock	43.025	43.05	43.0	43.0	7080.0
2017-12-26 06:20:00	AAPL	Stock	43.04	43.04	43.0	43.0	5884.0
2017-12-26 06:25:00	AAPL	Stock	43.0025	43.0025	42.9925	42.9925	1600.0
2017-12-26 06:30:00	AAPL	Stock	42.9975	43.0	42.94	42.94	5208.0
2017-12-26 06:35:00	AAPL	Stock	42.94	42.94	42.94	42.94	2800.0
2017-12-26 06:40:00	AAPL	Stock	42.92	42.925	42.92	42.925	2600.0
2017-12-26 06:45:00	AAPL	Stock	42.9025	42.9025	42.8725	42.8725	23880.0
2017-12-26 06:50:00	AAPL	Stock	42.84	42.84	42.6875	42.6875	35620.0
2017-12-26 06:55:00	AAPL	Stock	42.7675	42.7975	42.75	42.7975	39636.0
2017-12-26 07:00:00	AAPL	Stock	42.895	42.925	42.835	42.9075	65516.0
2017-12-26 07:05:00	AAPL	Stock	42.9	42.905	42.8475	42.85	97016.0
2017-12-26 07:10:00	AAPL	Stock	42.8375	42.845	42.785	42.785	82016.0
2017-12-26 07:15:00	AAPL	Stock	42.7875	42.795	42.7125	42.745	112284.0
2017-12-26 07:20:00	AAPL	Stock	42.725	42.7475	42.7	42.725	32048.0
2017-12-26 07:25:00	AAPL	Stock	42.7075	42.7075	42.5875	42.6375	75336.0
2017-12-26 07:30:00	AAPL	Stock	42.605	42.635	42.4375	42.4725	239508.0
2017-12-26 07:35:00	AAPL	Stock	42.4725	42.5	42.44	42.495	113628.0
2017-12-26 07:40:00	AAPL	Stock	42.5	42.535	42.4625	42.525	122356.0
2017-12-26 07:45:00	AAPL	Stock	42.5225	42.6175	42.5225	42.6125	57376.0
2017-12-26 07:50:00	AAPL	Stock	42.61	42.61	42.5525	42.5625	35400.0
2017-12-26 07:55:00	AAPL	Stock	42.54	42.5625	42.5	42.5625	130472.0
2017-12-26 08:00:00	AAPL	Stock	42.575	42.9	42.4525	42.5625	274600.0
2017-12-26 08:05:00	AAPL	Stock	42.575	42.6025	42.5625	42.6	112008.0
2017-12-26 08:10:00	AAPL	Stock	42.5925	42.6	42.5625	42.5875	96040.0
2017-12-26 08:15:00	AAPL	Stock	42.5875	42.6	42.5275	42.6	83628.0
2017-12-26 08:20:00	AAPL	Stock	42.575	42.64	42.575	42.6075	147604.0
2017-12-26 08:25:00	AAPL	Stock	42.62	42.65	42.6125	42.65	48908.0
2017-12-26 08:30:00	AAPL	Stock	42.65	42.6975	42.625	42.6975	59036.0
2017-12-26 08:35:00	AAPL	Stock	42.675	42.735	42.65	42.7125	74740.0
2017-12-26 08:40:00	AAPL	Stock	42.7175	42.735	42.65	42.6575	141344.0
2017-12-26 08:45:00	AAPL	Stock	42.6725	42.69	42.6525	42.6625	43400.0
2017-12-26 08:50:00	AAPL	Stock	42.665	42.69	42.6325	42.6525	83172.0
2017-12-26 08:55:00	AAPL	Stock	42.655	42.6875	42.6375	42.68	75684.0
2017-12-26 09:00:00	AAPL	Stock	42.6725	42.6825	42.6025	42.6125	136840.0
2017-12-26 09:05:00	AAPL	Stock	42.605	42.6225	42.5375	42.5375	254972.0

> showing 50 of 349,530 rows — these rows as CSV

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