PREVIEW / stock_5min / 2017-10-27

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-10-27.parquet
  size:    5.5 MB
  rows:    357,517
  symbols: 2,930

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-27 04:20:00	AAPL	Stock	39.5325	39.5325	39.53	39.53	1892.0
2017-10-27 04:40:00	AAPL	Stock	39.505	39.505	39.505	39.505	400.0
2017-10-27 05:10:00	AAPL	Stock	39.55	39.585	39.55	39.585	34076.0
2017-10-27 05:15:00	AAPL	Stock	39.59	39.59	39.5875	39.5875	2000.0
2017-10-27 05:30:00	AAPL	Stock	39.5975	39.5975	39.595	39.595	1600.0
2017-10-27 05:35:00	AAPL	Stock	39.5975	39.6	39.595	39.595	8540.0
2017-10-27 05:40:00	AAPL	Stock	39.5925	39.6	39.5925	39.6	9692.0
2017-10-27 05:50:00	AAPL	Stock	39.6	39.6	39.6	39.6	800.0
2017-10-27 06:00:00	AAPL	Stock	39.6225	39.6225	39.6225	39.6225	3968.0
2017-10-27 06:05:00	AAPL	Stock	39.6725	39.6725	39.6025	39.625	1768.0
2017-10-27 06:10:00	AAPL	Stock	39.6725	39.6775	39.6725	39.6775	4428.0
2017-10-27 06:20:00	AAPL	Stock	39.67	39.67	39.67	39.67	400.0
2017-10-27 06:35:00	AAPL	Stock	39.64	39.64	39.64	39.64	400.0
2017-10-27 06:40:00	AAPL	Stock	39.64	39.64	39.64	39.64	6400.0
2017-10-27 06:45:00	AAPL	Stock	39.66	39.66	39.625	39.625	10112.0
2017-10-27 06:50:00	AAPL	Stock	39.6375	39.6625	39.6375	39.6625	3720.0
2017-10-27 06:55:00	AAPL	Stock	39.6725	39.7125	39.6725	39.7125	73136.0
2017-10-27 07:00:00	AAPL	Stock	39.6875	39.725	39.6875	39.7125	56276.0
2017-10-27 07:05:00	AAPL	Stock	39.6875	39.6975	39.6625	39.6975	16948.0
2017-10-27 07:10:00	AAPL	Stock	39.675	39.68	39.6625	39.6625	6400.0
2017-10-27 07:15:00	AAPL	Stock	39.6525	39.675	39.6525	39.6625	9008.0
2017-10-27 07:20:00	AAPL	Stock	39.6625	39.675	39.6625	39.675	2700.0
2017-10-27 07:25:00	AAPL	Stock	39.6625	39.6875	39.6625	39.665	12980.0
2017-10-27 07:30:00	AAPL	Stock	39.67	39.67	39.65	39.65	3200.0
2017-10-27 07:35:00	AAPL	Stock	39.6475	39.7375	39.6475	39.725	85060.0
2017-10-27 07:40:00	AAPL	Stock	39.7	39.75	39.6875	39.7425	54560.0
2017-10-27 07:45:00	AAPL	Stock	39.7425	39.8075	39.7425	39.8075	17768.0
2017-10-27 07:50:00	AAPL	Stock	39.735	39.8125	39.735	39.81	50196.0
2017-10-27 07:55:00	AAPL	Stock	39.775	39.775	39.75	39.7675	12908.0
2017-10-27 08:00:00	AAPL	Stock	39.75	39.8075	39.535	39.77	262636.0
2017-10-27 08:05:00	AAPL	Stock	39.77	39.7875	39.77	39.77	18712.0
2017-10-27 08:10:00	AAPL	Stock	39.795	39.81	39.775	39.8075	66920.0
2017-10-27 08:15:00	AAPL	Stock	39.8075	39.85	39.7925	39.845	42092.0
2017-10-27 08:20:00	AAPL	Stock	39.83	39.8875	39.825	39.855	78504.0
2017-10-27 08:25:00	AAPL	Stock	39.8725	39.985	39.855	39.985	86632.0
2017-10-27 08:30:00	AAPL	Stock	39.895	39.95	39.89	39.9475	101196.0
2017-10-27 08:35:00	AAPL	Stock	39.94	39.945	39.83	39.8875	51676.0
2017-10-27 08:40:00	AAPL	Stock	39.8875	39.925	39.875	39.92	32900.0
2017-10-27 08:45:00	AAPL	Stock	39.9025	39.945	39.9	39.9225	62880.0
2017-10-27 08:50:00	AAPL	Stock	39.9375	39.9475	39.9225	39.9275	37424.0
2017-10-27 08:55:00	AAPL	Stock	39.925	39.93	39.8775	39.8775	93668.0
2017-10-27 09:00:00	AAPL	Stock	39.8775	39.9125	39.8525	39.9125	118404.0
2017-10-27 09:05:00	AAPL	Stock	39.9175	40.0	39.9175	39.99	213032.0
2017-10-27 09:10:00	AAPL	Stock	39.9975	40.0375	39.965	39.965	280892.0
2017-10-27 09:15:00	AAPL	Stock	39.9575	40.0	39.95	39.965	176876.0
2017-10-27 09:20:00	AAPL	Stock	39.965	39.9875	39.9625	39.975	61644.0
2017-10-27 09:25:00	AAPL	Stock	39.9675	39.975	39.8075	39.82	394432.0
2017-10-27 09:30:00	AAPL	Stock	39.825	39.875	39.725	39.7825	6016432.0
2017-10-27 09:35:00	AAPL	Stock	39.775	39.795	39.7025	39.7355	2448044.0
2017-10-27 09:40:00	AAPL	Stock	39.735	39.845	39.675	39.835	3957904.0

> showing 50 of 357,517 rows — these rows as CSV

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