PREVIEW / stock_5min / 2017-07-14

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-07-14.parquet
  size:    5.1 MB
  rows:    338,305
  symbols: 3,003

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-07-14 04:00:00	AAPL	Stock	36.8625	36.8625	36.75	36.775	10876.0
2017-07-14 04:05:00	AAPL	Stock	36.78	36.78	36.75	36.75	4800.0
2017-07-14 05:00:00	AAPL	Stock	36.7275	36.7275	36.7275	36.7275	1600.0
2017-07-14 05:05:00	AAPL	Stock	36.7	36.745	36.7	36.745	5896.0
2017-07-14 05:30:00	AAPL	Stock	36.745	36.745	36.745	36.745	400.0
2017-07-14 05:35:00	AAPL	Stock	36.7	36.7	36.7	36.7	2540.0
2017-07-14 05:40:00	AAPL	Stock	36.7	36.7	36.7	36.7	8000.0
2017-07-14 05:45:00	AAPL	Stock	36.725	36.725	36.725	36.725	400.0
2017-07-14 05:55:00	AAPL	Stock	36.7425	36.7425	36.7425	36.7425	680.0
2017-07-14 06:00:00	AAPL	Stock	36.725	36.735	36.725	36.735	15840.0
2017-07-14 06:10:00	AAPL	Stock	36.735	36.735	36.735	36.735	2400.0
2017-07-14 06:25:00	AAPL	Stock	36.7475	36.7475	36.7475	36.7475	412.0
2017-07-14 06:30:00	AAPL	Stock	36.7275	36.73	36.7275	36.73	2000.0
2017-07-14 06:35:00	AAPL	Stock	36.735	36.735	36.73	36.73	8400.0
2017-07-14 06:40:00	AAPL	Stock	36.7475	36.775	36.735	36.775	17800.0
2017-07-14 06:45:00	AAPL	Stock	36.7725	36.7725	36.7725	36.7725	2000.0
2017-07-14 06:55:00	AAPL	Stock	36.7825	36.7825	36.765	36.765	4400.0
2017-07-14 07:00:00	AAPL	Stock	36.7825	36.7825	36.7825	36.7825	2400.0
2017-07-14 07:05:00	AAPL	Stock	36.7825	36.795	36.7825	36.795	23156.0
2017-07-14 07:20:00	AAPL	Stock	36.8	36.8	36.8	36.8	2400.0
2017-07-14 07:30:00	AAPL	Stock	36.81	36.825	36.81	36.8125	11200.0
2017-07-14 07:35:00	AAPL	Stock	36.8125	36.825	36.8125	36.8125	1200.0
2017-07-14 07:40:00	AAPL	Stock	36.82	36.825	36.81	36.81	16592.0
2017-07-14 07:45:00	AAPL	Stock	36.8125	36.8125	36.8125	36.8125	400.0
2017-07-14 07:50:00	AAPL	Stock	36.8125	36.8125	36.8125	36.8125	1200.0
2017-07-14 07:55:00	AAPL	Stock	36.82	36.8225	36.82	36.8225	4896.0
2017-07-14 08:00:00	AAPL	Stock	36.805	37.025	36.7825	36.835	59388.0
2017-07-14 08:05:00	AAPL	Stock	36.8325	36.8675	36.8325	36.855	27748.0
2017-07-14 08:10:00	AAPL	Stock	36.86	36.86	36.83	36.8375	28088.0
2017-07-14 08:15:00	AAPL	Stock	36.8325	36.8375	36.8125	36.815	40352.0
2017-07-14 08:20:00	AAPL	Stock	36.8175	36.8275	36.815	36.8275	35400.0
2017-07-14 08:25:00	AAPL	Stock	36.8375	36.8675	36.8375	36.8625	34288.0
2017-07-14 08:30:00	AAPL	Stock	36.8625	36.95	36.8625	36.9275	113844.0
2017-07-14 08:35:00	AAPL	Stock	36.9275	36.9275	36.8825	36.915	77372.0
2017-07-14 08:40:00	AAPL	Stock	36.9125	36.93	36.9125	36.93	26320.0
2017-07-14 08:45:00	AAPL	Stock	36.9325	36.9425	36.925	36.925	29200.0
2017-07-14 08:50:00	AAPL	Stock	36.94	36.95	36.9325	36.95	34500.0
2017-07-14 08:55:00	AAPL	Stock	36.95	36.97	36.94	36.97	47028.0
2017-07-14 09:00:00	AAPL	Stock	36.97	37.0	36.965	36.99	71576.0
2017-07-14 09:05:00	AAPL	Stock	36.9825	37.01	36.975	36.975	94412.0
2017-07-14 09:10:00	AAPL	Stock	36.975	36.975	36.925	36.95	22940.0
2017-07-14 09:15:00	AAPL	Stock	36.9625	36.965	36.9625	36.965	3236.0
2017-07-14 09:20:00	AAPL	Stock	36.9525	36.9725	36.9375	36.9375	11372.0
2017-07-14 09:25:00	AAPL	Stock	36.95	37.01	36.95	36.995	105456.0
2017-07-14 09:30:00	AAPL	Stock	36.9875	37.0218	36.845	36.895	3665960.0
2017-07-14 09:35:00	AAPL	Stock	36.895	36.9525	36.87	36.9325	1338860.0
2017-07-14 09:40:00	AAPL	Stock	36.9325	37.0125	36.91	36.985	1304616.0
2017-07-14 09:45:00	AAPL	Stock	36.9875	37.025	36.9628	36.975	1122328.0
2017-07-14 09:50:00	AAPL	Stock	36.9735	36.9775	36.87	36.885	1608476.0
2017-07-14 09:55:00	AAPL	Stock	36.8825	36.9025	36.8362	36.865	1201392.0

> showing 50 of 338,305 rows — these rows as CSV

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