PREVIEW / stock_5min / 2017-06-29

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-06-29.parquet
  size:    5.5 MB
  rows:    358,848
  symbols: 3,019

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-06-29 04:15:00	AAPL	Stock	36.4475	36.45	36.41	36.41	7064.0
2017-06-29 04:20:00	AAPL	Stock	36.41	36.41	36.41	36.41	800.0
2017-06-29 04:30:00	AAPL	Stock	36.41	36.41	36.4075	36.4075	2800.0
2017-06-29 04:40:00	AAPL	Stock	36.385	36.385	36.385	36.385	1200.0
2017-06-29 05:20:00	AAPL	Stock	36.375	36.3825	36.3725	36.3825	5820.0
2017-06-29 05:25:00	AAPL	Stock	36.3925	36.3925	36.3925	36.3925	1004.0
2017-06-29 05:30:00	AAPL	Stock	36.3925	36.3925	36.3925	36.3925	400.0
2017-06-29 05:35:00	AAPL	Stock	36.3925	36.3925	36.3925	36.3925	400.0
2017-06-29 05:40:00	AAPL	Stock	36.3825	36.3825	36.36	36.36	5160.0
2017-06-29 05:45:00	AAPL	Stock	36.36	36.36	36.3475	36.3475	1920.0
2017-06-29 06:05:00	AAPL	Stock	36.3525	36.3525	36.3475	36.3475	1600.0
2017-06-29 06:10:00	AAPL	Stock	36.3375	36.3375	36.335	36.335	2000.0
2017-06-29 06:15:00	AAPL	Stock	36.335	36.335	36.3225	36.33	13200.0
2017-06-29 06:20:00	AAPL	Stock	36.315	36.315	36.315	36.315	3220.0
2017-06-29 06:25:00	AAPL	Stock	36.33	36.33	36.33	36.33	400.0
2017-06-29 06:30:00	AAPL	Stock	36.33	36.33	36.33	36.33	2000.0
2017-06-29 06:35:00	AAPL	Stock	36.3275	36.3275	36.31	36.31	5980.0
2017-06-29 06:45:00	AAPL	Stock	36.325	36.325	36.325	36.325	1980.0
2017-06-29 06:55:00	AAPL	Stock	36.325	36.325	36.3225	36.3225	4000.0
2017-06-29 07:00:00	AAPL	Stock	36.325	36.375	36.325	36.375	8448.0
2017-06-29 07:10:00	AAPL	Stock	36.3725	36.4025	36.3725	36.4025	17364.0
2017-06-29 07:15:00	AAPL	Stock	36.375	36.4025	36.375	36.4025	7608.0
2017-06-29 07:20:00	AAPL	Stock	36.4025	36.4025	36.4025	36.4025	6240.0
2017-06-29 07:25:00	AAPL	Stock	36.4	36.4025	36.3875	36.4025	9848.0
2017-06-29 07:30:00	AAPL	Stock	36.4125	36.415	36.4125	36.4125	3436.0
2017-06-29 07:35:00	AAPL	Stock	36.4125	36.435	36.4125	36.435	4328.0
2017-06-29 07:40:00	AAPL	Stock	36.425	36.425	36.4025	36.4025	7820.0
2017-06-29 07:45:00	AAPL	Stock	36.415	36.415	36.4	36.4	11792.0
2017-06-29 07:50:00	AAPL	Stock	36.4	36.4	36.4	36.4	2800.0
2017-06-29 08:00:00	AAPL	Stock	36.4	36.4	36.3175	36.35	90592.0
2017-06-29 08:05:00	AAPL	Stock	36.3675	36.3675	36.3375	36.3375	9136.0
2017-06-29 08:10:00	AAPL	Stock	36.34	36.34	36.3175	36.3175	8572.0
2017-06-29 08:15:00	AAPL	Stock	36.345	36.345	36.3	36.3375	44824.0
2017-06-29 08:20:00	AAPL	Stock	36.3175	36.3175	36.2775	36.2875	29360.0
2017-06-29 08:25:00	AAPL	Stock	36.295	36.31	36.2825	36.2825	22844.0
2017-06-29 08:30:00	AAPL	Stock	36.3225	36.3225	36.2525	36.2525	42192.0
2017-06-29 08:35:00	AAPL	Stock	36.2575	36.2625	36.2125	36.2125	54524.0
2017-06-29 08:40:00	AAPL	Stock	36.215	36.25	36.215	36.25	63308.0
2017-06-29 08:45:00	AAPL	Stock	36.25	36.25	36.225	36.225	17844.0
2017-06-29 08:50:00	AAPL	Stock	36.22	36.225	36.2075	36.225	30828.0
2017-06-29 08:55:00	AAPL	Stock	36.2125	36.2375	36.2125	36.2125	36460.0
2017-06-29 09:00:00	AAPL	Stock	36.2125	36.2225	36.1925	36.195	77296.0
2017-06-29 09:05:00	AAPL	Stock	36.195	36.21	36.1925	36.21	61808.0
2017-06-29 09:10:00	AAPL	Stock	36.205	36.235	36.1975	36.225	36368.0
2017-06-29 09:15:00	AAPL	Stock	36.2125	36.2175	36.2	36.2175	16172.0
2017-06-29 09:20:00	AAPL	Stock	36.2175	36.225	36.205	36.225	31000.0
2017-06-29 09:25:00	AAPL	Stock	36.2125	36.225	36.155	36.1925	107424.0
2017-06-29 09:30:00	AAPL	Stock	36.1875	36.2825	36.1525	36.1725	3688552.0
2017-06-29 09:35:00	AAPL	Stock	36.1775	36.2325	36.1075	36.2172	2819228.0
2017-06-29 09:40:00	AAPL	Stock	36.2175	36.275	36.0875	36.0875	2205928.0

> showing 50 of 358,848 rows — these rows as CSV

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