PREVIEW / stock_30min / 2016-12-21

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-12-21.parquet
  size:    1.6 MB
  rows:    82,170
  symbols: 3,168

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-12-21 06:00:00	AAPL	Stock	29.2175	29.2175	29.2175	29.2175	400.0
2016-12-21 07:00:00	AAPL	Stock	29.2125	29.2175	29.205	29.205	9008.0
2016-12-21 07:30:00	AAPL	Stock	29.2125	29.2125	29.165	29.1775	9716.0
2016-12-21 08:00:00	AAPL	Stock	29.2125	29.215	29.1875	29.2	54172.0
2016-12-21 08:30:00	AAPL	Stock	29.2075	29.2325	29.2075	29.2275	10740.0
2016-12-21 09:00:00	AAPL	Stock	29.225	29.2325	29.2	29.2175	45916.0
2016-12-21 09:30:00	AAPL	Stock	29.2	29.3375	29.195	29.2762	11576620.0
2016-12-21 10:00:00	AAPL	Stock	29.2758	29.2945	29.23	29.2575	5190176.0
2016-12-21 10:30:00	AAPL	Stock	29.2575	29.29	29.205	29.2275	4640988.0
2016-12-21 11:00:00	AAPL	Stock	29.23	29.265	29.2175	29.2588	4200924.0
2016-12-21 11:30:00	AAPL	Stock	29.26	29.2775	29.2275	29.2485	2852624.0
2016-12-21 12:00:00	AAPL	Stock	29.2485	29.29	29.242	29.275	3135244.0
2016-12-21 12:30:00	AAPL	Stock	29.2728	29.2875	29.2525	29.2825	3998612.0
2016-12-21 13:00:00	AAPL	Stock	29.2825	29.31	29.205	29.2675	6679356.0
2016-12-21 13:30:00	AAPL	Stock	29.2685	29.29	29.2575	29.28	2496984.0
2016-12-21 14:00:00	AAPL	Stock	29.2775	29.35	29.2775	29.32	3823912.0
2016-12-21 14:30:00	AAPL	Stock	29.3222	29.325	29.295	29.31	3144084.0
2016-12-21 15:00:00	AAPL	Stock	29.3125	29.3165	29.2625	29.2675	4171644.0
2016-12-21 15:30:00	AAPL	Stock	29.268	29.285	29.2375	29.265	5697988.0
2016-12-21 16:00:00	AAPL	Stock	29.265	29.285	29.255	29.2625	7262932.0
2016-12-21 16:30:00	AAPL	Stock	29.26	29.2675	29.2575	29.2575	12804.0
2016-12-21 17:00:00	AAPL	Stock	29.265	29.265	29.2575	29.26	3436.0
2016-12-21 17:30:00	AAPL	Stock	29.2625	29.2625	29.2625	29.2625	6200.0
2016-12-21 18:00:00	AAPL	Stock	29.255	29.2575	29.255	29.255	6068.0
2016-12-21 18:30:00	AAPL	Stock	29.26	29.26	29.26	29.26	2000.0
2016-12-21 19:00:00	AAPL	Stock	29.255	29.265	29.255	29.265	31164.0
2016-12-21 19:30:00	AAPL	Stock	29.2625	29.265	29.25	29.25	22668.0
2016-12-21 06:00:00	MSFT	Stock	63.2	63.2	63.2	63.2	400.0
2016-12-21 07:30:00	MSFT	Stock	63.49	63.5	63.49	63.5	2300.0
2016-12-21 08:00:00	MSFT	Stock	63.61	63.61	63.3	63.5	3785.0
2016-12-21 08:30:00	MSFT	Stock	63.5	63.5	63.5	63.5	1540.0
2016-12-21 09:00:00	MSFT	Stock	63.44	63.55	63.44	63.55	6466.0
2016-12-21 09:30:00	MSFT	Stock	63.49	63.7	63.21	63.3	2406059.0
2016-12-21 10:00:00	MSFT	Stock	63.3	63.46	63.24	63.4	1614029.0
2016-12-21 10:30:00	MSFT	Stock	63.395	63.54	63.25	63.25	1341903.0
2016-12-21 11:00:00	MSFT	Stock	63.255	63.336	63.12	63.32	1694432.0
2016-12-21 11:30:00	MSFT	Stock	63.32	63.45	63.32	63.42	729856.0
2016-12-21 12:00:00	MSFT	Stock	63.425	63.49	63.41	63.48	653118.0
2016-12-21 12:30:00	MSFT	Stock	63.48	63.54	63.452	63.52	544654.0
2016-12-21 13:00:00	MSFT	Stock	63.51	63.57	63.47	63.5	767978.0
2016-12-21 13:30:00	MSFT	Stock	63.5	63.545	63.47	63.49	512126.0
2016-12-21 14:00:00	MSFT	Stock	63.48	63.51	63.451	63.465	679408.0
2016-12-21 14:30:00	MSFT	Stock	63.465	63.56	63.41	63.555	864034.0
2016-12-21 15:00:00	MSFT	Stock	63.555	63.62	63.54	63.555	839220.0
2016-12-21 15:30:00	MSFT	Stock	63.555	63.57	63.48	63.55	1428740.0
2016-12-21 16:00:00	MSFT	Stock	63.54	63.64	63.54	63.62	1716305.0
2016-12-21 16:30:00	MSFT	Stock	63.5	63.5	63.48	63.48	7600.0
2016-12-21 17:00:00	MSFT	Stock	63.5	63.61	63.5	63.59	4498.0
2016-12-21 17:30:00	MSFT	Stock	63.54	63.54	63.54	63.54	8182.0
2016-12-21 18:30:00	MSFT	Stock	63.55	63.62	63.55	63.57	2529.0

> showing 50 of 82,170 rows — these rows as CSV

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