PREVIEW / stock_5min / 2017-11-14

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-11-14.parquet
  size:    5.6 MB
  rows:    362,229
  symbols: 2,952

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-11-14 04:00:00	AAPL	Stock	43.545	43.545	43.545	43.545	492.0
2017-11-14 05:15:00	AAPL	Stock	43.45	43.45	43.45	43.45	1188.0
2017-11-14 05:45:00	AAPL	Stock	43.45	43.45	43.45	43.45	1800.0
2017-11-14 06:20:00	AAPL	Stock	43.4725	43.4725	43.4725	43.4725	1644.0
2017-11-14 06:30:00	AAPL	Stock	43.45	43.45	43.45	43.45	600.0
2017-11-14 06:35:00	AAPL	Stock	43.45	43.45	43.45	43.45	400.0
2017-11-14 06:40:00	AAPL	Stock	43.45	43.45	43.45	43.45	1000.0
2017-11-14 06:55:00	AAPL	Stock	43.47	43.47	43.47	43.47	2740.0
2017-11-14 07:00:00	AAPL	Stock	43.47	43.5	43.4575	43.4575	18272.0
2017-11-14 07:10:00	AAPL	Stock	43.4625	43.485	43.4625	43.485	4800.0
2017-11-14 07:15:00	AAPL	Stock	43.455	43.455	43.455	43.455	3200.0
2017-11-14 07:20:00	AAPL	Stock	43.4625	43.4625	43.4625	43.4625	400.0
2017-11-14 07:25:00	AAPL	Stock	43.4525	43.4525	43.45	43.45	24444.0
2017-11-14 07:30:00	AAPL	Stock	43.4375	43.4375	43.425	43.435	4240.0
2017-11-14 07:35:00	AAPL	Stock	43.4375	43.4425	43.435	43.435	2600.0
2017-11-14 07:40:00	AAPL	Stock	43.4475	43.4625	43.4475	43.45	1600.0
2017-11-14 07:50:00	AAPL	Stock	43.4525	43.4525	43.4525	43.4525	444.0
2017-11-14 07:55:00	AAPL	Stock	43.4625	43.4625	43.4625	43.4625	3200.0
2017-11-14 08:00:00	AAPL	Stock	43.475	43.475	43.4125	43.4625	9916.0
2017-11-14 08:05:00	AAPL	Stock	43.4375	43.4375	43.4375	43.4375	400.0
2017-11-14 08:10:00	AAPL	Stock	43.4375	43.44	43.425	43.425	5592.0
2017-11-14 08:15:00	AAPL	Stock	43.4275	43.4275	43.425	43.4275	6692.0
2017-11-14 08:20:00	AAPL	Stock	43.425	43.435	43.425	43.43	10296.0
2017-11-14 08:25:00	AAPL	Stock	43.43	43.4375	43.4	43.4375	30688.0
2017-11-14 08:30:00	AAPL	Stock	43.4375	43.4375	43.42	43.42	18196.0
2017-11-14 08:35:00	AAPL	Stock	43.425	43.425	43.425	43.425	20800.0
2017-11-14 08:40:00	AAPL	Stock	43.4375	43.45	43.3975	43.4	23220.0
2017-11-14 08:45:00	AAPL	Stock	43.4	43.4075	43.3875	43.3875	12764.0
2017-11-14 08:50:00	AAPL	Stock	43.39	43.39	43.3525	43.375	17312.0
2017-11-14 08:55:00	AAPL	Stock	43.385	43.3875	43.37	43.375	29452.0
2017-11-14 09:00:00	AAPL	Stock	43.3825	43.4	43.375	43.38	13724.0
2017-11-14 09:05:00	AAPL	Stock	43.3825	43.3825	43.3625	43.3625	32080.0
2017-11-14 09:10:00	AAPL	Stock	43.375	43.42	43.3625	43.375	43368.0
2017-11-14 09:15:00	AAPL	Stock	43.375	43.375	43.375	43.375	17916.0
2017-11-14 09:20:00	AAPL	Stock	43.375	43.375	43.35	43.3525	12824.0
2017-11-14 09:25:00	AAPL	Stock	43.36	43.3725	43.2525	43.2525	77912.0
2017-11-14 09:30:00	AAPL	Stock	43.26	43.37	43.2175	43.2775	3778728.0
2017-11-14 09:35:00	AAPL	Stock	43.28	43.2975	43.1325	43.155	2791096.0
2017-11-14 09:40:00	AAPL	Stock	43.145	43.27	43.145	43.2375	2200568.0
2017-11-14 09:45:00	AAPL	Stock	43.24	43.27	43.1925	43.2225	1224816.0
2017-11-14 09:50:00	AAPL	Stock	43.2175	43.2675	43.2075	43.235	1222676.0
2017-11-14 09:55:00	AAPL	Stock	43.2358	43.2525	43.165	43.1875	1588908.0
2017-11-14 10:00:00	AAPL	Stock	43.19	43.205	43.0325	43.04	3165408.0
2017-11-14 10:05:00	AAPL	Stock	43.045	43.115	43.0275	43.1052	1766416.0
2017-11-14 10:10:00	AAPL	Stock	43.105	43.1475	43.0775	43.135	1230788.0
2017-11-14 10:15:00	AAPL	Stock	43.1375	43.2125	43.1375	43.1802	1091908.0
2017-11-14 10:20:00	AAPL	Stock	43.1825	43.19	43.0975	43.1175	1029220.0
2017-11-14 10:25:00	AAPL	Stock	43.119	43.1825	43.1002	43.1525	1217476.0
2017-11-14 10:30:00	AAPL	Stock	43.155	43.165	43.1	43.1425	1199004.0
2017-11-14 10:35:00	AAPL	Stock	43.1425	43.3	43.1225	43.2988	1836300.0

> showing 50 of 362,229 rows — these rows as CSV

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