PREVIEW / stock_5min / 2017-10-23

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-10-23.parquet
  size:    5.4 MB
  rows:    344,951
  symbols: 2,926

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-23 04:25:00	AAPL	Stock	39.0625	39.0625	39.0625	39.0625	2800.0
2017-10-23 04:30:00	AAPL	Stock	39.1	39.1	39.1	39.1	572.0
2017-10-23 04:40:00	AAPL	Stock	39.1625	39.1625	39.1625	39.1625	552.0
2017-10-23 05:00:00	AAPL	Stock	39.1	39.1	39.1	39.1	1924.0
2017-10-23 05:10:00	AAPL	Stock	39.1425	39.1425	39.1425	39.1425	400.0
2017-10-23 05:15:00	AAPL	Stock	39.1	39.1	39.1	39.1	400.0
2017-10-23 05:20:00	AAPL	Stock	39.1	39.1	39.1	39.1	800.0
2017-10-23 05:45:00	AAPL	Stock	39.15	39.15	39.15	39.15	2380.0
2017-10-23 05:55:00	AAPL	Stock	39.115	39.115	39.115	39.115	400.0
2017-10-23 06:00:00	AAPL	Stock	39.115	39.115	39.115	39.115	800.0
2017-10-23 06:05:00	AAPL	Stock	39.115	39.15	39.115	39.15	2400.0
2017-10-23 06:30:00	AAPL	Stock	39.15	39.15	39.15	39.15	768.0
2017-10-23 06:45:00	AAPL	Stock	39.15	39.2	39.15	39.2	11876.0
2017-10-23 06:55:00	AAPL	Stock	39.15	39.15	39.15	39.15	6000.0
2017-10-23 07:00:00	AAPL	Stock	39.1375	39.1375	39.1375	39.1375	600.0
2017-10-23 07:05:00	AAPL	Stock	39.15	39.15	39.15	39.15	796.0
2017-10-23 07:15:00	AAPL	Stock	39.1625	39.1625	39.1375	39.1375	4720.0
2017-10-23 07:20:00	AAPL	Stock	39.105	39.105	39.105	39.105	1256.0
2017-10-23 07:25:00	AAPL	Stock	39.15	39.15	39.15	39.15	1280.0
2017-10-23 07:30:00	AAPL	Stock	39.1475	39.1475	39.1375	39.1375	3600.0
2017-10-23 07:45:00	AAPL	Stock	39.1375	39.1375	39.135	39.135	800.0
2017-10-23 07:50:00	AAPL	Stock	39.135	39.135	39.125	39.125	7560.0
2017-10-23 07:55:00	AAPL	Stock	39.125	39.125	39.1225	39.1225	2660.0
2017-10-23 08:00:00	AAPL	Stock	39.15	39.15	39.1025	39.115	35076.0
2017-10-23 08:05:00	AAPL	Stock	39.125	39.125	39.115	39.115	3596.0
2017-10-23 08:10:00	AAPL	Stock	39.12	39.12	39.12	39.12	1600.0
2017-10-23 08:15:00	AAPL	Stock	39.1325	39.15	39.1325	39.1325	1600.0
2017-10-23 08:20:00	AAPL	Stock	39.1325	39.1325	39.1325	39.1325	1428.0
2017-10-23 08:25:00	AAPL	Stock	39.14	39.1725	39.14	39.1725	13160.0
2017-10-23 08:30:00	AAPL	Stock	39.175	39.2	39.175	39.1775	5840.0
2017-10-23 08:35:00	AAPL	Stock	39.1875	39.205	39.1825	39.2	31648.0
2017-10-23 08:40:00	AAPL	Stock	39.2025	39.2025	39.2025	39.2025	400.0
2017-10-23 08:45:00	AAPL	Stock	39.195	39.2025	39.195	39.2025	1732.0
2017-10-23 08:50:00	AAPL	Stock	39.2	39.2225	39.2	39.2075	8036.0
2017-10-23 08:55:00	AAPL	Stock	39.2075	39.2225	39.2075	39.2225	5992.0
2017-10-23 09:00:00	AAPL	Stock	39.23	39.23	39.22	39.2275	8020.0
2017-10-23 09:05:00	AAPL	Stock	39.2275	39.275	39.2275	39.275	46352.0
2017-10-23 09:10:00	AAPL	Stock	39.2625	39.2625	39.2375	39.25	10432.0
2017-10-23 09:15:00	AAPL	Stock	39.25	39.2575	39.2275	39.25	23864.0
2017-10-23 09:20:00	AAPL	Stock	39.25	39.25	39.0625	39.24	427888.0
2017-10-23 09:25:00	AAPL	Stock	39.25	39.25	39.2225	39.225	57236.0
2017-10-23 09:30:00	AAPL	Stock	39.2225	39.2275	39.075	39.195	2836760.0
2017-10-23 09:35:00	AAPL	Stock	39.2	39.2625	39.15	39.2075	1372508.0
2017-10-23 09:40:00	AAPL	Stock	39.21	39.2475	39.181	39.1972	1099372.0
2017-10-23 09:45:00	AAPL	Stock	39.2	39.2625	39.2	39.2325	1271712.0
2017-10-23 09:50:00	AAPL	Stock	39.2325	39.235	39.1725	39.2275	1135316.0
2017-10-23 09:55:00	AAPL	Stock	39.23	39.2375	39.1975	39.2125	573864.0
2017-10-23 10:00:00	AAPL	Stock	39.215	39.215	39.162	39.1625	801688.0
2017-10-23 10:05:00	AAPL	Stock	39.165	39.1675	39.0925	39.1125	1326864.0
2017-10-23 10:10:00	AAPL	Stock	39.1125	39.1462	39.035	39.0675	1435128.0

> showing 50 of 344,951 rows — these rows as CSV

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