PREVIEW / stock_5min / 2017-09-05

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-09-05.parquet
  size:    5.5 MB
  rows:    359,729
  symbols: 2,992

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-09-05 04:00:00	AAPL	Stock	41.0	41.0	40.9375	40.95	20064.0
2017-09-05 04:05:00	AAPL	Stock	40.9825	40.9825	40.9825	40.9825	800.0
2017-09-05 04:15:00	AAPL	Stock	40.97	40.995	40.97	40.995	10584.0
2017-09-05 04:25:00	AAPL	Stock	40.9975	41.0	40.9975	41.0	3588.0
2017-09-05 04:30:00	AAPL	Stock	41.01	41.01	41.01	41.01	3996.0
2017-09-05 04:50:00	AAPL	Stock	41.0	41.0	41.0	41.0	13940.0
2017-09-05 05:00:00	AAPL	Stock	40.9825	40.9825	40.9825	40.9825	400.0
2017-09-05 05:25:00	AAPL	Stock	40.9975	41.0	40.9975	41.0	7180.0
2017-09-05 05:35:00	AAPL	Stock	41.02	41.02	41.02	41.02	400.0
2017-09-05 06:05:00	AAPL	Stock	40.955	40.955	40.935	40.9375	3068.0
2017-09-05 06:15:00	AAPL	Stock	40.94	40.94	40.9375	40.9375	1760.0
2017-09-05 06:20:00	AAPL	Stock	40.9375	40.9375	40.9225	40.9225	2564.0
2017-09-05 06:25:00	AAPL	Stock	40.9125	40.9125	40.9125	40.9125	7912.0
2017-09-05 06:35:00	AAPL	Stock	40.8925	40.8925	40.8925	40.8925	2704.0
2017-09-05 07:00:00	AAPL	Stock	40.8925	40.92	40.8925	40.92	1996.0
2017-09-05 07:05:00	AAPL	Stock	40.9	40.91	40.9	40.91	6008.0
2017-09-05 07:10:00	AAPL	Stock	40.91	40.915	40.9025	40.9125	5000.0
2017-09-05 07:15:00	AAPL	Stock	40.925	40.95	40.9075	40.9075	9156.0
2017-09-05 07:20:00	AAPL	Stock	40.955	40.955	40.925	40.955	4000.0
2017-09-05 07:25:00	AAPL	Stock	40.945	40.945	40.945	40.945	1000.0
2017-09-05 07:30:00	AAPL	Stock	40.96	40.9625	40.9375	40.9375	2800.0
2017-09-05 07:35:00	AAPL	Stock	40.9375	40.96	40.9375	40.9375	4720.0
2017-09-05 07:40:00	AAPL	Stock	40.96	40.96	40.9375	40.95	8360.0
2017-09-05 07:45:00	AAPL	Stock	40.95	40.95	40.95	40.95	1200.0
2017-09-05 07:50:00	AAPL	Stock	40.95	40.95	40.95	40.95	1000.0
2017-09-05 07:55:00	AAPL	Stock	40.9475	40.9475	40.9475	40.9475	2800.0
2017-09-05 08:00:00	AAPL	Stock	40.9375	41.0975	40.8875	40.8925	166808.0
2017-09-05 08:05:00	AAPL	Stock	40.9	40.9	40.875	40.875	34552.0
2017-09-05 08:10:00	AAPL	Stock	40.875	40.875	40.83	40.8375	57748.0
2017-09-05 08:15:00	AAPL	Stock	40.8375	40.84	40.8375	40.8375	7732.0
2017-09-05 08:20:00	AAPL	Stock	40.835	40.85	40.7875	40.7875	32128.0
2017-09-05 08:25:00	AAPL	Stock	40.8	40.8125	40.79	40.8	41576.0
2017-09-05 08:30:00	AAPL	Stock	40.8075	40.8325	40.8075	40.8325	27180.0
2017-09-05 08:35:00	AAPL	Stock	40.8325	40.8325	40.81	40.825	10392.0
2017-09-05 08:40:00	AAPL	Stock	40.8375	40.8475	40.81	40.825	26816.0
2017-09-05 08:45:00	AAPL	Stock	40.825	40.9375	40.825	40.8575	30424.0
2017-09-05 08:50:00	AAPL	Stock	40.85	40.86	40.8375	40.85	17460.0
2017-09-05 08:55:00	AAPL	Stock	40.8375	40.855	40.8275	40.855	16956.0
2017-09-05 09:00:00	AAPL	Stock	40.8625	40.8625	40.84	40.8425	4580.0
2017-09-05 09:05:00	AAPL	Stock	40.83	40.8625	40.83	40.8425	12444.0
2017-09-05 09:10:00	AAPL	Stock	40.8425	40.855	40.8375	40.8425	17212.0
2017-09-05 09:15:00	AAPL	Stock	40.865	40.875	40.85	40.875	10708.0
2017-09-05 09:20:00	AAPL	Stock	40.8725	40.8825	40.8525	40.8525	15196.0
2017-09-05 09:25:00	AAPL	Stock	40.8625	40.9675	40.8575	40.9675	54304.0
2017-09-05 09:30:00	AAPL	Stock	40.92	41.0625	40.8775	40.9775	4863292.0
2017-09-05 09:35:00	AAPL	Stock	40.9725	41.0	40.8988	40.8988	2089260.0
2017-09-05 09:40:00	AAPL	Stock	40.9	40.95	40.8442	40.9425	1773508.0
2017-09-05 09:45:00	AAPL	Stock	40.9425	41.025	40.905	40.9775	1849284.0
2017-09-05 09:50:00	AAPL	Stock	40.9775	41.025	40.955	40.9738	1058284.0
2017-09-05 09:55:00	AAPL	Stock	40.9775	41.0475	40.965	41.0125	1487120.0

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

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