PREVIEW / stock_5min / 2018-01-04

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-01-04.parquet
  size:    5.8 MB
  rows:    371,301
  symbols: 2,925

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
2018-01-04 04:00:00	AAPL	Stock	43.1	43.1	43.1	43.1	1392.0
2018-01-04 04:05:00	AAPL	Stock	43.1025	43.1025	43.1025	43.1025	400.0
2018-01-04 04:15:00	AAPL	Stock	43.1	43.1	43.1	43.1	2520.0
2018-01-04 05:15:00	AAPL	Stock	43.15	43.15	43.15	43.15	400.0
2018-01-04 05:20:00	AAPL	Stock	43.15	43.2	43.15	43.2	6108.0
2018-01-04 06:00:00	AAPL	Stock	43.1525	43.1525	43.1525	43.1525	400.0
2018-01-04 06:05:00	AAPL	Stock	43.1525	43.1525	43.1275	43.1275	1880.0
2018-01-04 06:10:00	AAPL	Stock	43.14	43.14	43.125	43.1275	7780.0
2018-01-04 06:15:00	AAPL	Stock	43.1275	43.1275	43.1275	43.1275	1600.0
2018-01-04 06:20:00	AAPL	Stock	43.1525	43.1525	43.1525	43.1525	7800.0
2018-01-04 06:35:00	AAPL	Stock	43.1525	43.1525	43.1525	43.1525	800.0
2018-01-04 06:40:00	AAPL	Stock	43.17	43.17	43.17	43.17	800.0
2018-01-04 06:45:00	AAPL	Stock	43.17	43.17	43.17	43.17	400.0
2018-01-04 07:00:00	AAPL	Stock	43.14	43.155	43.14	43.14	3600.0
2018-01-04 07:10:00	AAPL	Stock	43.14	43.145	43.14	43.145	1400.0
2018-01-04 07:15:00	AAPL	Stock	43.15	43.1725	43.1325	43.1725	11816.0
2018-01-04 07:20:00	AAPL	Stock	43.1425	43.1425	43.1425	43.1425	2400.0
2018-01-04 07:25:00	AAPL	Stock	43.1425	43.1725	43.1425	43.1725	8752.0
2018-01-04 07:30:00	AAPL	Stock	43.1625	43.1725	43.1575	43.1625	14920.0
2018-01-04 07:35:00	AAPL	Stock	43.1725	43.175	43.1725	43.175	2000.0
2018-01-04 07:40:00	AAPL	Stock	43.185	43.1925	43.185	43.1925	2808.0
2018-01-04 07:45:00	AAPL	Stock	43.1925	43.1925	43.1875	43.1875	1400.0
2018-01-04 07:50:00	AAPL	Stock	43.1825	43.185	43.18	43.18	10440.0
2018-01-04 07:55:00	AAPL	Stock	43.18	43.18	43.1525	43.1525	2800.0
2018-01-04 08:00:00	AAPL	Stock	43.17	43.1925	43.14	43.1575	31700.0
2018-01-04 08:05:00	AAPL	Stock	43.1575	43.1725	43.1525	43.1675	16976.0
2018-01-04 08:10:00	AAPL	Stock	43.175	43.1925	43.1688	43.1925	16692.0
2018-01-04 08:15:00	AAPL	Stock	43.19	43.2	43.175	43.175	36992.0
2018-01-04 08:20:00	AAPL	Stock	43.175	43.22	43.1575	43.22	44384.0
2018-01-04 08:25:00	AAPL	Stock	43.2	43.2175	43.195	43.2075	15128.0
2018-01-04 08:30:00	AAPL	Stock	43.2	43.2	43.18	43.195	18200.0
2018-01-04 08:35:00	AAPL	Stock	43.1925	43.2	43.1925	43.2	22984.0
2018-01-04 08:40:00	AAPL	Stock	43.2	43.2125	43.2	43.2	4000.0
2018-01-04 08:45:00	AAPL	Stock	43.2	43.22	43.195	43.22	25260.0
2018-01-04 08:50:00	AAPL	Stock	43.2125	43.2125	43.21	43.2125	11480.0
2018-01-04 08:55:00	AAPL	Stock	43.22	43.22	43.19	43.2	19196.0
2018-01-04 09:00:00	AAPL	Stock	43.2	43.205	43.1925	43.205	23536.0
2018-01-04 09:05:00	AAPL	Stock	43.2175	43.2175	43.205	43.215	5740.0
2018-01-04 09:10:00	AAPL	Stock	43.21	43.21	43.1925	43.1925	9216.0
2018-01-04 09:15:00	AAPL	Stock	43.19	43.1925	43.175	43.185	19948.0
2018-01-04 09:20:00	AAPL	Stock	43.1775	43.1775	43.1475	43.15	14244.0
2018-01-04 09:25:00	AAPL	Stock	43.1525	43.2	43.1525	43.1775	19796.0
2018-01-04 09:30:00	AAPL	Stock	43.135	43.28	43.135	43.1775	3907316.0
2018-01-04 09:35:00	AAPL	Stock	43.1825	43.23	43.13	43.1725	1933960.0
2018-01-04 09:40:00	AAPL	Stock	43.1675	43.175	43.02	43.09	3130160.0
2018-01-04 09:45:00	AAPL	Stock	43.09	43.21	43.0625	43.195	2063332.0
2018-01-04 09:50:00	AAPL	Stock	43.1925	43.285	43.1775	43.2485	2253668.0
2018-01-04 09:55:00	AAPL	Stock	43.25	43.29	43.2025	43.235	1168684.0
2018-01-04 10:00:00	AAPL	Stock	43.235	43.2625	43.165	43.18	950480.0
2018-01-04 10:05:00	AAPL	Stock	43.181	43.2975	43.1775	43.2812	1204280.0

> showing 50 of 371,301 rows — these rows as CSV

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