PREVIEW / stock_5min / 2017-02-03

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-02-03.parquet
  size:    5.4 MB
  rows:    348,453
  symbols: 3,120

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-02-03 05:20:00	AAPL	Stock	32.01	32.01	32.01	32.01	400.0
2017-02-03 06:20:00	AAPL	Stock	32.07	32.07	32.07	32.07	400.0
2017-02-03 06:30:00	AAPL	Stock	32.0875	32.0875	32.0875	32.0875	2400.0
2017-02-03 06:35:00	AAPL	Stock	32.0875	32.0875	32.0875	32.0875	400.0
2017-02-03 06:40:00	AAPL	Stock	32.0875	32.0875	32.0875	32.0875	1880.0
2017-02-03 06:45:00	AAPL	Stock	32.0875	32.0875	32.0875	32.0875	800.0
2017-02-03 07:00:00	AAPL	Stock	32.0875	32.0875	32.0875	32.0875	1600.0
2017-02-03 07:05:00	AAPL	Stock	32.1	32.1025	32.1	32.1025	3308.0
2017-02-03 07:10:00	AAPL	Stock	32.1	32.105	32.1	32.1	5000.0
2017-02-03 07:20:00	AAPL	Stock	32.1075	32.1075	32.1075	32.1075	1360.0
2017-02-03 07:30:00	AAPL	Stock	32.1225	32.1225	32.1	32.1075	2204.0
2017-02-03 07:35:00	AAPL	Stock	32.1075	32.1075	32.1	32.1	1200.0
2017-02-03 07:40:00	AAPL	Stock	32.1	32.1	32.1	32.1	400.0
2017-02-03 07:50:00	AAPL	Stock	32.1175	32.12	32.1175	32.12	8500.0
2017-02-03 08:00:00	AAPL	Stock	32.1175	32.13	32.0625	32.0625	114604.0
2017-02-03 08:05:00	AAPL	Stock	32.0625	32.07	32.03	32.0325	97416.0
2017-02-03 08:10:00	AAPL	Stock	32.05	32.05	32.04	32.04	2000.0
2017-02-03 08:15:00	AAPL	Stock	32.05	32.05	32.05	32.05	3104.0
2017-02-03 08:20:00	AAPL	Stock	32.06	32.075	32.05	32.075	13480.0
2017-02-03 08:25:00	AAPL	Stock	32.0775	32.0775	32.07	32.075	3800.0
2017-02-03 08:30:00	AAPL	Stock	32.07	32.1375	32.07	32.1375	32880.0
2017-02-03 08:35:00	AAPL	Stock	32.1325	32.15	32.1125	32.1175	37964.0
2017-02-03 08:40:00	AAPL	Stock	32.1225	32.13	32.1125	32.13	4400.0
2017-02-03 08:45:00	AAPL	Stock	32.125	32.1375	32.1175	32.1375	17048.0
2017-02-03 08:50:00	AAPL	Stock	32.1475	32.17	32.14	32.1625	32772.0
2017-02-03 08:55:00	AAPL	Stock	32.15	32.15	32.1375	32.1375	10240.0
2017-02-03 09:00:00	AAPL	Stock	32.1375	32.1425	32.1125	32.115	36476.0
2017-02-03 09:05:00	AAPL	Stock	32.12	32.125	32.1125	32.1225	40404.0
2017-02-03 09:10:00	AAPL	Stock	32.125	32.135	32.125	32.1325	7936.0
2017-02-03 09:15:00	AAPL	Stock	32.125	32.125	32.095	32.095	60232.0
2017-02-03 09:20:00	AAPL	Stock	32.095	32.11	32.095	32.11	24260.0
2017-02-03 09:25:00	AAPL	Stock	32.1075	32.1075	32.075	32.105	116272.0
2017-02-03 09:30:00	AAPL	Stock	32.0775	32.2	32.0775	32.13	6134696.0
2017-02-03 09:35:00	AAPL	Stock	32.1325	32.185	32.11	32.1275	1913752.0
2017-02-03 09:40:00	AAPL	Stock	32.1275	32.15	32.04	32.0737	1921436.0
2017-02-03 09:45:00	AAPL	Stock	32.075	32.2025	32.0725	32.199	1994340.0
2017-02-03 09:50:00	AAPL	Stock	32.2	32.235	32.1925	32.2275	1708740.0
2017-02-03 09:55:00	AAPL	Stock	32.23	32.279	32.2288	32.2537	1973664.0
2017-02-03 10:00:00	AAPL	Stock	32.255	32.2775	32.225	32.2275	2215984.0
2017-02-03 10:05:00	AAPL	Stock	32.2275	32.255	32.2125	32.2375	1548228.0
2017-02-03 10:10:00	AAPL	Stock	32.24	32.2625	32.2025	32.2605	1295496.0
2017-02-03 10:15:00	AAPL	Stock	32.26	32.27	32.2262	32.26	1126484.0
2017-02-03 10:20:00	AAPL	Stock	32.2625	32.2625	32.2275	32.2425	970400.0
2017-02-03 10:25:00	AAPL	Stock	32.2425	32.2975	32.2425	32.2575	1533232.0
2017-02-03 10:30:00	AAPL	Stock	32.2575	32.27	32.2225	32.2225	1005008.0
2017-02-03 10:35:00	AAPL	Stock	32.221	32.24	32.215	32.2218	794664.0
2017-02-03 10:40:00	AAPL	Stock	32.22	32.2325	32.19	32.195	930060.0
2017-02-03 10:45:00	AAPL	Stock	32.195	32.2125	32.175	32.2125	1059504.0
2017-02-03 10:50:00	AAPL	Stock	32.21	32.2125	32.1685	32.1798	741712.0
2017-02-03 10:55:00	AAPL	Stock	32.18	32.1975	32.1738	32.1775	594052.0

> showing 50 of 348,453 rows — these rows as CSV

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