PREVIEW / stock_5min / 2016-10-04

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-10-04.parquet
  size:    5.3 MB
  rows:    349,230
  symbols: 3,206

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
2016-10-04 04:05:00	AAPL	Stock	28.1875	28.1875	28.1875	28.1875	400.0
2016-10-04 05:05:00	AAPL	Stock	28.235	28.2375	28.235	28.2375	964.0
2016-10-04 05:10:00	AAPL	Stock	28.2375	28.2375	28.2375	28.2375	2960.0
2016-10-04 06:10:00	AAPL	Stock	28.205	28.205	28.205	28.205	400.0
2016-10-04 06:15:00	AAPL	Stock	28.1875	28.1875	28.1875	28.1875	416.0
2016-10-04 06:35:00	AAPL	Stock	28.175	28.175	28.175	28.175	400.0
2016-10-04 07:10:00	AAPL	Stock	28.155	28.155	28.155	28.155	1880.0
2016-10-04 07:25:00	AAPL	Stock	28.17	28.17	28.15	28.1525	7656.0
2016-10-04 07:30:00	AAPL	Stock	28.1525	28.1525	28.145	28.145	7452.0
2016-10-04 07:40:00	AAPL	Stock	28.13	28.13	28.125	28.13	9492.0
2016-10-04 07:45:00	AAPL	Stock	28.1125	28.13	28.1125	28.13	9144.0
2016-10-04 07:50:00	AAPL	Stock	28.13	28.13	28.13	28.13	3204.0
2016-10-04 07:55:00	AAPL	Stock	28.13	28.13	28.11	28.11	7656.0
2016-10-04 08:00:00	AAPL	Stock	28.1875	28.1875	28.075	28.14	26420.0
2016-10-04 08:05:00	AAPL	Stock	28.13	28.1375	28.13	28.1375	2400.0
2016-10-04 08:10:00	AAPL	Stock	28.1275	28.1275	28.1275	28.1275	1572.0
2016-10-04 08:15:00	AAPL	Stock	28.1325	28.14	28.1275	28.1325	16984.0
2016-10-04 08:20:00	AAPL	Stock	28.1425	28.1425	28.1325	28.1325	2100.0
2016-10-04 08:25:00	AAPL	Stock	28.145	28.1475	28.145	28.1475	21168.0
2016-10-04 08:30:00	AAPL	Stock	28.1475	28.1475	28.1125	28.1125	5040.0
2016-10-04 08:35:00	AAPL	Stock	28.1375	28.1375	28.125	28.125	3600.0
2016-10-04 08:40:00	AAPL	Stock	28.1325	28.15	28.1325	28.15	17400.0
2016-10-04 08:45:00	AAPL	Stock	28.15	28.1525	28.15	28.15	23620.0
2016-10-04 08:50:00	AAPL	Stock	28.16	28.18	28.16	28.175	14460.0
2016-10-04 08:55:00	AAPL	Stock	28.175	28.18	28.175	28.175	8920.0
2016-10-04 09:00:00	AAPL	Stock	28.1775	28.1825	28.175	28.1775	78660.0
2016-10-04 09:05:00	AAPL	Stock	28.185	28.22	28.175	28.2075	50592.0
2016-10-04 09:10:00	AAPL	Stock	28.2175	28.2425	28.2175	28.2375	94104.0
2016-10-04 09:15:00	AAPL	Stock	28.2325	28.2425	28.2075	28.21	24532.0
2016-10-04 09:20:00	AAPL	Stock	28.2125	28.2425	28.2125	28.2425	30784.0
2016-10-04 09:25:00	AAPL	Stock	28.2425	28.275	28.2375	28.2525	159080.0
2016-10-04 09:30:00	AAPL	Stock	28.2525	28.45	28.25	28.365	6616504.0
2016-10-04 09:35:00	AAPL	Stock	28.365	28.465	28.36	28.4525	3571608.0
2016-10-04 09:40:00	AAPL	Stock	28.4525	28.5575	28.4525	28.5258	4857672.0
2016-10-04 09:45:00	AAPL	Stock	28.5275	28.5375	28.4675	28.535	3069584.0
2016-10-04 09:50:00	AAPL	Stock	28.535	28.5775	28.5225	28.535	2671724.0
2016-10-04 09:55:00	AAPL	Stock	28.535	28.575	28.5175	28.5582	2277568.0
2016-10-04 10:00:00	AAPL	Stock	28.5595	28.5625	28.525	28.5438	1447260.0
2016-10-04 10:05:00	AAPL	Stock	28.545	28.5575	28.4875	28.495	2496184.0
2016-10-04 10:10:00	AAPL	Stock	28.4938	28.51	28.4275	28.445	2498616.0
2016-10-04 10:15:00	AAPL	Stock	28.4475	28.465	28.435	28.4625	1428572.0
2016-10-04 10:20:00	AAPL	Stock	28.46	28.52	28.4525	28.5075	1962692.0
2016-10-04 10:25:00	AAPL	Stock	28.5075	28.5582	28.49	28.535	2000524.0
2016-10-04 10:30:00	AAPL	Stock	28.5348	28.5425	28.505	28.5225	1224172.0
2016-10-04 10:35:00	AAPL	Stock	28.5225	28.5425	28.5138	28.5282	1143840.0
2016-10-04 10:40:00	AAPL	Stock	28.5288	28.575	28.5275	28.542	2069176.0
2016-10-04 10:45:00	AAPL	Stock	28.5425	28.57	28.535	28.56	1192832.0
2016-10-04 10:50:00	AAPL	Stock	28.5575	28.575	28.55	28.574	981656.0
2016-10-04 10:55:00	AAPL	Stock	28.575	28.575	28.505	28.51	1454712.0
2016-10-04 11:00:00	AAPL	Stock	28.5125	28.52	28.3625	28.3698	3360644.0

> showing 50 of 349,230 rows — these rows as CSV

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