PREVIEW / stock_5min / 2017-04-07

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-04-07.parquet
  size:    5.3 MB
  rows:    353,627
  symbols: 3,030

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-04-07 04:00:00	AAPL	Stock	35.8775	35.8775	35.825	35.825	5248.0
2017-04-07 04:30:00	AAPL	Stock	35.87	35.87	35.87	35.87	420.0
2017-04-07 05:45:00	AAPL	Stock	35.87	35.87	35.87	35.87	400.0
2017-04-07 06:00:00	AAPL	Stock	35.8525	35.8525	35.8525	35.8525	536.0
2017-04-07 06:40:00	AAPL	Stock	35.87	35.875	35.87	35.875	5264.0
2017-04-07 07:00:00	AAPL	Stock	35.875	35.8875	35.875	35.8875	1600.0
2017-04-07 07:05:00	AAPL	Stock	35.87	35.87	35.87	35.87	800.0
2017-04-07 07:25:00	AAPL	Stock	35.9125	35.925	35.9125	35.925	4300.0
2017-04-07 07:30:00	AAPL	Stock	35.95	35.95	35.935	35.9375	5940.0
2017-04-07 07:35:00	AAPL	Stock	35.9125	35.9125	35.9125	35.9125	2000.0
2017-04-07 07:45:00	AAPL	Stock	35.8975	35.8975	35.88	35.88	4000.0
2017-04-07 07:50:00	AAPL	Stock	35.88	35.88	35.88	35.88	1600.0
2017-04-07 07:55:00	AAPL	Stock	35.9	35.9	35.9	35.9	3700.0
2017-04-07 08:00:00	AAPL	Stock	35.8875	35.935	35.8525	35.895	15160.0
2017-04-07 08:05:00	AAPL	Stock	35.895	35.895	35.895	35.895	1600.0
2017-04-07 08:10:00	AAPL	Stock	35.8925	35.8925	35.8925	35.8925	1200.0
2017-04-07 08:15:00	AAPL	Stock	35.8875	35.8875	35.875	35.8775	12460.0
2017-04-07 08:20:00	AAPL	Stock	35.8775	35.8875	35.8775	35.8875	10452.0
2017-04-07 08:25:00	AAPL	Stock	35.895	35.895	35.895	35.895	400.0
2017-04-07 08:30:00	AAPL	Stock	35.89	35.89	35.805	35.8125	79908.0
2017-04-07 08:35:00	AAPL	Stock	35.8275	35.8625	35.8275	35.8575	8668.0
2017-04-07 08:40:00	AAPL	Stock	35.8575	35.8575	35.83	35.835	7636.0
2017-04-07 08:45:00	AAPL	Stock	35.8375	35.8625	35.8375	35.8375	13408.0
2017-04-07 08:50:00	AAPL	Stock	35.8375	35.8725	35.8375	35.8725	2000.0
2017-04-07 08:55:00	AAPL	Stock	35.8525	35.875	35.8525	35.8525	13564.0
2017-04-07 09:00:00	AAPL	Stock	35.8525	35.8725	35.8525	35.8625	1468.0
2017-04-07 09:05:00	AAPL	Stock	35.875	35.8925	35.875	35.8925	5296.0
2017-04-07 09:10:00	AAPL	Stock	35.8925	35.91	35.8925	35.8975	14832.0
2017-04-07 09:15:00	AAPL	Stock	35.9075	35.92	35.9	35.9175	10400.0
2017-04-07 09:20:00	AAPL	Stock	35.9175	35.93	35.9175	35.93	9748.0
2017-04-07 09:25:00	AAPL	Stock	35.9225	35.9425	35.9225	35.925	12084.0
2017-04-07 09:30:00	AAPL	Stock	35.9325	36.0162	35.9175	35.9672	2969984.0
2017-04-07 09:35:00	AAPL	Stock	35.9675	36.045	35.955	35.995	2097912.0
2017-04-07 09:40:00	AAPL	Stock	35.9955	36.0308	35.95	35.9775	1572076.0
2017-04-07 09:45:00	AAPL	Stock	35.9725	36.01	35.9525	35.9588	915684.0
2017-04-07 09:50:00	AAPL	Stock	35.9575	35.9875	35.8475	35.8525	2012556.0
2017-04-07 09:55:00	AAPL	Stock	35.8525	35.915	35.8475	35.8575	1445208.0
2017-04-07 10:00:00	AAPL	Stock	35.8625	35.9225	35.8175	35.905	1543236.0
2017-04-07 10:05:00	AAPL	Stock	35.905	35.9225	35.87	35.915	812476.0
2017-04-07 10:10:00	AAPL	Stock	35.9165	35.975	35.9125	35.9475	1263380.0
2017-04-07 10:15:00	AAPL	Stock	35.95	35.9575	35.9125	35.9325	532452.0
2017-04-07 10:20:00	AAPL	Stock	35.9275	35.935	35.89	35.9252	700492.0
2017-04-07 10:25:00	AAPL	Stock	35.9275	35.9675	35.9275	35.9628	523304.0
2017-04-07 10:30:00	AAPL	Stock	35.9638	35.985	35.95	35.985	547716.0
2017-04-07 10:35:00	AAPL	Stock	35.985	36.025	35.9675	36.0025	1145180.0
2017-04-07 10:40:00	AAPL	Stock	36.005	36.015	35.9825	35.985	502760.0
2017-04-07 10:45:00	AAPL	Stock	35.985	36.005	35.9725	35.9925	691532.0
2017-04-07 10:50:00	AAPL	Stock	35.99	35.995	35.9425	35.961	524016.0
2017-04-07 10:55:00	AAPL	Stock	35.9625	35.97	35.9375	35.9622	524724.0
2017-04-07 11:00:00	AAPL	Stock	35.96	35.9675	35.93	35.9475	532012.0

> showing 50 of 353,627 rows — these rows as CSV

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