PREVIEW / stock_5min / 2017-07-10

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-07-10.parquet
  size:    5.3 MB
  rows:    347,197
  symbols: 2,990

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-10 04:00:00	AAPL	Stock	36.2075	36.2075	36.2075	36.2075	400.0
2017-07-10 04:15:00	AAPL	Stock	36.1375	36.1375	36.1375	36.1375	400.0
2017-07-10 05:00:00	AAPL	Stock	36.1475	36.1475	36.1475	36.1475	432.0
2017-07-10 06:05:00	AAPL	Stock	36.155	36.155	36.15	36.15	3492.0
2017-07-10 06:40:00	AAPL	Stock	36.21	36.21	36.21	36.21	612.0
2017-07-10 07:00:00	AAPL	Stock	36.21	36.2375	36.21	36.2375	5984.0
2017-07-10 07:10:00	AAPL	Stock	36.2	36.2475	36.2	36.2375	8396.0
2017-07-10 07:20:00	AAPL	Stock	36.2	36.21	36.18	36.18	5180.0
2017-07-10 07:25:00	AAPL	Stock	36.175	36.1775	36.16	36.175	7360.0
2017-07-10 07:30:00	AAPL	Stock	36.16	36.1625	36.15	36.15	4840.0
2017-07-10 07:35:00	AAPL	Stock	36.15	36.175	36.15	36.175	2800.0
2017-07-10 08:00:00	AAPL	Stock	36.1625	36.215	36.0	36.1525	35008.0
2017-07-10 08:05:00	AAPL	Stock	36.1525	36.1525	36.125	36.13	37308.0
2017-07-10 08:10:00	AAPL	Stock	36.1375	36.1625	36.1375	36.15	14468.0
2017-07-10 08:15:00	AAPL	Stock	36.1475	36.1525	36.1375	36.1375	7000.0
2017-07-10 08:20:00	AAPL	Stock	36.1625	36.1625	36.1575	36.1625	22936.0
2017-07-10 08:25:00	AAPL	Stock	36.1425	36.1525	36.1375	36.14	11832.0
2017-07-10 08:30:00	AAPL	Stock	36.12	36.1375	36.1125	36.1375	22400.0
2017-07-10 08:35:00	AAPL	Stock	36.125	36.1375	36.125	36.125	6796.0
2017-07-10 08:40:00	AAPL	Stock	36.125	36.125	36.12	36.12	16756.0
2017-07-10 08:45:00	AAPL	Stock	36.12	36.12	36.075	36.075	31536.0
2017-07-10 08:50:00	AAPL	Stock	36.075	36.075	36.075	36.075	4000.0
2017-07-10 08:55:00	AAPL	Stock	36.08	36.08	36.075	36.075	7768.0
2017-07-10 09:00:00	AAPL	Stock	36.0775	36.0775	36.0125	36.0125	45540.0
2017-07-10 09:05:00	AAPL	Stock	36.0125	36.03	36.0125	36.02	11648.0
2017-07-10 09:10:00	AAPL	Stock	36.02	36.03	36.015	36.03	10128.0
2017-07-10 09:15:00	AAPL	Stock	36.0375	36.0375	36.015	36.015	6696.0
2017-07-10 09:20:00	AAPL	Stock	36.01	36.025	36.01	36.02	23828.0
2017-07-10 09:25:00	AAPL	Stock	36.025	36.0625	36.025	36.045	307076.0
2017-07-10 09:30:00	AAPL	Stock	36.0275	36.065	35.965	36.0162	2739824.0
2017-07-10 09:35:00	AAPL	Stock	36.0175	36.1325	36.01	36.05	1874204.0
2017-07-10 09:40:00	AAPL	Stock	36.0505	36.07	35.9875	36.045	1227488.0
2017-07-10 09:45:00	AAPL	Stock	36.0425	36.05	35.985	36.0075	1270864.0
2017-07-10 09:50:00	AAPL	Stock	36.0075	36.0175	35.8425	35.875	1763684.0
2017-07-10 09:55:00	AAPL	Stock	35.8725	35.91	35.8425	35.87	1251316.0
2017-07-10 10:00:00	AAPL	Stock	35.8675	35.9675	35.8575	35.9675	1338124.0
2017-07-10 10:05:00	AAPL	Stock	35.9665	35.9775	35.9275	35.9725	971140.0
2017-07-10 10:10:00	AAPL	Stock	35.9725	35.99	35.9475	35.95	1138492.0
2017-07-10 10:15:00	AAPL	Stock	35.95	35.96	35.895	35.955	1033012.0
2017-07-10 10:20:00	AAPL	Stock	35.955	35.9725	35.9375	35.97	565292.0
2017-07-10 10:25:00	AAPL	Stock	35.97	35.99	35.9475	35.9535	629360.0
2017-07-10 10:30:00	AAPL	Stock	35.95	35.9865	35.945	35.97	626436.0
2017-07-10 10:35:00	AAPL	Stock	35.9675	35.9725	35.92	35.965	994508.0
2017-07-10 10:40:00	AAPL	Stock	35.9665	36.04	35.9612	36.039	675768.0
2017-07-10 10:45:00	AAPL	Stock	36.0375	36.1	36.0175	36.0962	1093608.0
2017-07-10 10:50:00	AAPL	Stock	36.0962	36.1525	36.09	36.148	982300.0
2017-07-10 10:55:00	AAPL	Stock	36.1475	36.225	36.1375	36.21	1371012.0
2017-07-10 11:00:00	AAPL	Stock	36.2075	36.2325	36.175	36.19	775012.0
2017-07-10 11:05:00	AAPL	Stock	36.19	36.2475	36.1875	36.24	822792.0
2017-07-10 11:10:00	AAPL	Stock	36.2412	36.2425	36.2075	36.24	666876.0

> showing 50 of 347,197 rows — these rows as CSV

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