PREVIEW / stock_5min / 2016-08-01

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-08-01.parquet
  size:    5.4 MB
  rows:    355,874
  symbols: 3,270

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-08-01 04:00:00	AAPL	Stock	26.1	26.125	26.1	26.125	2800.0
2016-08-01 04:50:00	AAPL	Stock	26.13	26.13	26.13	26.13	3920.0
2016-08-01 05:35:00	AAPL	Stock	26.1325	26.1325	26.1325	26.1325	400.0
2016-08-01 05:45:00	AAPL	Stock	26.155	26.155	26.155	26.155	400.0
2016-08-01 05:50:00	AAPL	Stock	26.155	26.155	26.1475	26.1475	4120.0
2016-08-01 06:00:00	AAPL	Stock	26.1475	26.1475	26.1475	26.1475	11280.0
2016-08-01 06:10:00	AAPL	Stock	26.13	26.13	26.13	26.13	1600.0
2016-08-01 06:25:00	AAPL	Stock	26.125	26.125	26.125	26.125	800.0
2016-08-01 06:30:00	AAPL	Stock	26.1375	26.1375	26.1375	26.1375	3600.0
2016-08-01 06:35:00	AAPL	Stock	26.1425	26.1425	26.125	26.125	13600.0
2016-08-01 06:45:00	AAPL	Stock	26.125	26.125	26.125	26.125	2104.0
2016-08-01 06:55:00	AAPL	Stock	26.125	26.125	26.125	26.125	1864.0
2016-08-01 07:00:00	AAPL	Stock	26.125	26.15	26.125	26.15	15600.0
2016-08-01 07:05:00	AAPL	Stock	26.16	26.1625	26.1575	26.1625	19200.0
2016-08-01 07:10:00	AAPL	Stock	26.1625	26.1725	26.1625	26.1725	4800.0
2016-08-01 07:15:00	AAPL	Stock	26.1575	26.1575	26.1525	26.1525	2400.0
2016-08-01 07:20:00	AAPL	Stock	26.15	26.1575	26.15	26.1525	7320.0
2016-08-01 07:25:00	AAPL	Stock	26.15	26.15	26.15	26.15	8800.0
2016-08-01 07:30:00	AAPL	Stock	26.155	26.245	26.155	26.225	19128.0
2016-08-01 08:00:00	AAPL	Stock	26.1625	26.2225	26.1275	26.2175	126168.0
2016-08-01 08:05:00	AAPL	Stock	26.2175	26.2225	26.2125	26.2125	59752.0
2016-08-01 08:10:00	AAPL	Stock	26.2	26.2	26.1875	26.1875	14240.0
2016-08-01 08:15:00	AAPL	Stock	26.2	26.2075	26.18	26.19	26920.0
2016-08-01 08:20:00	AAPL	Stock	26.1775	26.1975	26.175	26.1975	5600.0
2016-08-01 08:25:00	AAPL	Stock	26.1975	26.2075	26.19	26.205	29820.0
2016-08-01 08:30:00	AAPL	Stock	26.2075	26.21	26.2	26.2075	38092.0
2016-08-01 08:35:00	AAPL	Stock	26.2075	26.21	26.1875	26.1875	43000.0
2016-08-01 08:40:00	AAPL	Stock	26.175	26.1875	26.175	26.1825	8380.0
2016-08-01 08:45:00	AAPL	Stock	26.1875	26.1875	26.175	26.175	17020.0
2016-08-01 08:50:00	AAPL	Stock	26.175	26.1775	26.1675	26.1675	26200.0
2016-08-01 08:55:00	AAPL	Stock	26.175	26.175	26.155	26.1575	34972.0
2016-08-01 09:00:00	AAPL	Stock	26.16	26.165	26.15	26.165	51728.0
2016-08-01 09:05:00	AAPL	Stock	26.165	26.165	26.145	26.1575	26932.0
2016-08-01 09:10:00	AAPL	Stock	26.1625	26.17	26.15	26.15	44300.0
2016-08-01 09:15:00	AAPL	Stock	26.1525	26.1675	26.15	26.16	12600.0
2016-08-01 09:20:00	AAPL	Stock	26.165	26.17	26.1625	26.1625	31112.0
2016-08-01 09:25:00	AAPL	Stock	26.17	26.1725	26.1025	26.1025	170352.0
2016-08-01 09:30:00	AAPL	Stock	26.105	26.1675	26.1025	26.132	5308688.0
2016-08-01 09:35:00	AAPL	Stock	26.1325	26.2075	26.125	26.2	3738852.0
2016-08-01 09:40:00	AAPL	Stock	26.2025	26.2075	26.165	26.2055	2914200.0
2016-08-01 09:45:00	AAPL	Stock	26.2075	26.25	26.2025	26.24	3899572.0
2016-08-01 09:50:00	AAPL	Stock	26.24	26.2875	26.2375	26.2625	6861264.0
2016-08-01 09:55:00	AAPL	Stock	26.2625	26.2638	26.25	26.2612	1594420.0
2016-08-01 10:00:00	AAPL	Stock	26.26	26.295	26.25	26.2675	2774404.0
2016-08-01 10:05:00	AAPL	Stock	26.2675	26.295	26.26	26.2848	1779764.0
2016-08-01 10:10:00	AAPL	Stock	26.2825	26.2975	26.26	26.2775	1736532.0
2016-08-01 10:15:00	AAPL	Stock	26.2775	26.325	26.275	26.3225	2576576.0
2016-08-01 10:20:00	AAPL	Stock	26.3225	26.325	26.3	26.3175	1345684.0
2016-08-01 10:25:00	AAPL	Stock	26.3175	26.345	26.3125	26.329	1999920.0
2016-08-01 10:30:00	AAPL	Stock	26.3275	26.3375	26.3125	26.3175	1547372.0

> showing 50 of 355,874 rows — these rows as CSV

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