PREVIEW / stock_5min / 2018-01-03

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-01-03.parquet
  size:    5.9 MB
  rows:    374,497
  symbols: 2,903

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-03 04:05:00	AAPL	Stock	43.165	43.165	43.165	43.165	436.0
2018-01-03 04:25:00	AAPL	Stock	43.165	43.165	43.165	43.165	2444.0
2018-01-03 05:05:00	AAPL	Stock	43.165	43.165	43.165	43.165	400.0
2018-01-03 06:25:00	AAPL	Stock	43.1975	43.1975	43.1875	43.1875	3008.0
2018-01-03 06:30:00	AAPL	Stock	43.1875	43.1875	43.1875	43.1875	17600.0
2018-01-03 06:35:00	AAPL	Stock	43.1875	43.1875	43.1875	43.1875	400.0
2018-01-03 07:00:00	AAPL	Stock	43.1875	43.1875	43.1275	43.15	8308.0
2018-01-03 07:05:00	AAPL	Stock	43.15	43.15	43.13	43.13	1000.0
2018-01-03 07:10:00	AAPL	Stock	43.145	43.145	43.1425	43.1425	2000.0
2018-01-03 07:15:00	AAPL	Stock	43.15	43.15	43.1325	43.1425	14780.0
2018-01-03 07:20:00	AAPL	Stock	43.13	43.13	43.125	43.125	29468.0
2018-01-03 07:25:00	AAPL	Stock	43.1375	43.145	43.125	43.1275	7536.0
2018-01-03 07:30:00	AAPL	Stock	43.1275	43.1275	43.125	43.125	2800.0
2018-01-03 07:35:00	AAPL	Stock	43.13	43.145	43.1275	43.145	13772.0
2018-01-03 07:40:00	AAPL	Stock	43.14	43.15	43.14	43.14	5684.0
2018-01-03 07:45:00	AAPL	Stock	43.14	43.14	43.1275	43.13	2892.0
2018-01-03 07:50:00	AAPL	Stock	43.1375	43.14	43.1275	43.14	5456.0
2018-01-03 07:55:00	AAPL	Stock	43.1375	43.1375	43.1375	43.1375	416.0
2018-01-03 08:00:00	AAPL	Stock	43.1375	43.1625	43.1075	43.1375	24044.0
2018-01-03 08:05:00	AAPL	Stock	43.1375	43.1375	43.105	43.105	46956.0
2018-01-03 08:10:00	AAPL	Stock	43.125	43.1375	43.125	43.1375	12080.0
2018-01-03 08:15:00	AAPL	Stock	43.1375	43.1475	43.125	43.14	13828.0
2018-01-03 08:20:00	AAPL	Stock	43.1425	43.145	43.125	43.125	10568.0
2018-01-03 08:25:00	AAPL	Stock	43.115	43.1375	43.115	43.1375	1752.0
2018-01-03 08:30:00	AAPL	Stock	43.1325	43.1375	43.1275	43.1275	12684.0
2018-01-03 08:35:00	AAPL	Stock	43.1275	43.1375	43.1175	43.1175	17732.0
2018-01-03 08:40:00	AAPL	Stock	43.125	43.145	43.1125	43.145	36400.0
2018-01-03 08:45:00	AAPL	Stock	43.145	43.15	43.125	43.1375	6716.0
2018-01-03 08:50:00	AAPL	Stock	43.115	43.12	43.115	43.12	11524.0
2018-01-03 08:55:00	AAPL	Stock	43.1175	43.135	43.1175	43.125	9316.0
2018-01-03 09:00:00	AAPL	Stock	43.1375	43.1625	43.1375	43.1625	22952.0
2018-01-03 09:05:00	AAPL	Stock	43.17	43.185	43.1625	43.1725	22220.0
2018-01-03 09:10:00	AAPL	Stock	43.1725	43.175	43.1575	43.1575	21816.0
2018-01-03 09:15:00	AAPL	Stock	43.1575	43.1675	43.1575	43.1575	11768.0
2018-01-03 09:20:00	AAPL	Stock	43.1575	43.1675	43.15	43.15	25348.0
2018-01-03 09:25:00	AAPL	Stock	43.16	43.1625	43.1175	43.13	47904.0
2018-01-03 09:30:00	AAPL	Stock	43.13	43.325	43.045	43.28	4710264.0
2018-01-03 09:35:00	AAPL	Stock	43.2725	43.3375	43.2575	43.28	2536836.0
2018-01-03 09:40:00	AAPL	Stock	43.2775	43.33	43.2625	43.3	2508532.0
2018-01-03 09:45:00	AAPL	Stock	43.3	43.31	43.205	43.2762	1771552.0
2018-01-03 09:50:00	AAPL	Stock	43.275	43.3575	43.2325	43.3275	1867016.0
2018-01-03 09:55:00	AAPL	Stock	43.3275	43.475	43.3225	43.4662	2432520.0
2018-01-03 10:00:00	AAPL	Stock	43.4725	43.56	43.44	43.56	2454856.0
2018-01-03 10:05:00	AAPL	Stock	43.56	43.6025	43.5275	43.545	2153588.0
2018-01-03 10:10:00	AAPL	Stock	43.5475	43.575	43.51	43.5188	1622584.0
2018-01-03 10:15:00	AAPL	Stock	43.5175	43.5225	43.475	43.487	1606552.0
2018-01-03 10:20:00	AAPL	Stock	43.4875	43.4888	43.4525	43.485	895280.0
2018-01-03 10:25:00	AAPL	Stock	43.4825	43.5175	43.445	43.5075	1333908.0
2018-01-03 10:30:00	AAPL	Stock	43.51	43.5225	43.475	43.49	1160212.0
2018-01-03 10:35:00	AAPL	Stock	43.4875	43.61	43.485	43.61	1490624.0

> showing 50 of 374,497 rows — these rows as CSV

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