PREVIEW / stock_30min / 2016-12-27

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-12-27.parquet
  size:    1.6 MB
  rows:    81,554
  symbols: 3,165

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-27 05:00:00	AAPL	Stock	29.1375	29.1375	29.1375	29.1375	400.0
2016-12-27 06:30:00	AAPL	Stock	29.1725	29.1725	29.1725	29.1725	864.0
2016-12-27 07:00:00	AAPL	Stock	29.225	29.23	29.225	29.225	8960.0
2016-12-27 07:30:00	AAPL	Stock	29.205	29.2225	29.185	29.185	21000.0
2016-12-27 08:00:00	AAPL	Stock	29.225	29.225	29.1775	29.1875	18464.0
2016-12-27 08:30:00	AAPL	Stock	29.1875	29.1875	29.1625	29.1775	38200.0
2016-12-27 09:00:00	AAPL	Stock	29.17	29.19	29.13	29.13	53692.0
2016-12-27 09:30:00	AAPL	Stock	29.1425	29.445	29.1225	29.4438	17768812.0
2016-12-27 10:00:00	AAPL	Stock	29.4438	29.45	29.365	29.4125	6347148.0
2016-12-27 10:30:00	AAPL	Stock	29.41	29.4225	29.3675	29.4075	4353148.0
2016-12-27 11:00:00	AAPL	Stock	29.4062	29.42	29.385	29.419	3585648.0
2016-12-27 11:30:00	AAPL	Stock	29.4175	29.4375	29.3875	29.4	3288364.0
2016-12-27 12:00:00	AAPL	Stock	29.4025	29.4025	29.347	29.3575	2808940.0
2016-12-27 12:30:00	AAPL	Stock	29.36	29.3875	29.335	29.3725	2592644.0
2016-12-27 13:00:00	AAPL	Stock	29.3725	29.4075	29.3675	29.4	2464788.0
2016-12-27 13:30:00	AAPL	Stock	29.4	29.4025	29.365	29.3825	2459116.0
2016-12-27 14:00:00	AAPL	Stock	29.38	29.3975	29.3675	29.3825	2335840.0
2016-12-27 14:30:00	AAPL	Stock	29.3825	29.3825	29.35	29.3525	2468492.0
2016-12-27 15:00:00	AAPL	Stock	29.3535	29.3688	29.35	29.365	2603968.0
2016-12-27 15:30:00	AAPL	Stock	29.365	29.3675	29.3	29.3125	7217624.0
2016-12-27 16:00:00	AAPL	Stock	29.315	29.325	29.305	29.315	6131776.0
2016-12-27 16:30:00	AAPL	Stock	29.3175	29.3175	29.3125	29.3125	11216.0
2016-12-27 17:00:00	AAPL	Stock	29.3125	29.345	29.3125	29.325	28540.0
2016-12-27 17:30:00	AAPL	Stock	29.325	29.325	29.3125	29.325	24444.0
2016-12-27 18:00:00	AAPL	Stock	29.325	29.325	29.3125	29.32	5860.0
2016-12-27 18:30:00	AAPL	Stock	29.3425	29.345	29.325	29.325	12772.0
2016-12-27 19:00:00	AAPL	Stock	29.325	29.3425	29.325	29.3425	4616.0
2016-12-27 19:30:00	AAPL	Stock	29.3425	29.3425	29.315	29.315	14400.0
2016-12-27 06:30:00	MSFT	Stock	63.45	63.45	63.45	63.45	100.0
2016-12-27 08:00:00	MSFT	Stock	63.22	63.22	63.22	63.22	100.0
2016-12-27 08:30:00	MSFT	Stock	63.38	63.4	63.38	63.4	1120.0
2016-12-27 09:30:00	MSFT	Stock	63.21	64.07	63.21	63.93	2347647.0
2016-12-27 10:00:00	MSFT	Stock	63.93	63.97	63.74	63.79	941925.0
2016-12-27 10:30:00	MSFT	Stock	63.786	63.81	63.64	63.65	597894.0
2016-12-27 11:00:00	MSFT	Stock	63.65	63.74	63.63	63.635	642611.0
2016-12-27 11:30:00	MSFT	Stock	63.634	63.68	63.48	63.48	601947.0
2016-12-27 12:00:00	MSFT	Stock	63.48	63.506	63.35	63.366	498849.0
2016-12-27 12:30:00	MSFT	Stock	63.365	63.45	63.32	63.4	434695.0
2016-12-27 13:00:00	MSFT	Stock	63.405	63.465	63.4	63.455	367089.0
2016-12-27 13:30:00	MSFT	Stock	63.455	63.48	63.38	63.404	424030.0
2016-12-27 14:00:00	MSFT	Stock	63.4	63.42	63.31	63.37	457489.0
2016-12-27 14:30:00	MSFT	Stock	63.37	63.41	63.31	63.314	348258.0
2016-12-27 15:00:00	MSFT	Stock	63.315	63.37	63.28	63.325	481794.0
2016-12-27 15:30:00	MSFT	Stock	63.325	63.34	63.23	63.27	1441278.0
2016-12-27 16:00:00	MSFT	Stock	63.28	63.28	63.19	63.28	1260977.0
2016-12-27 16:30:00	MSFT	Stock	63.22	63.28	63.22	63.28	158525.0
2016-12-27 17:00:00	MSFT	Stock	63.28	63.28	63.28	63.28	471.0
2016-12-27 17:30:00	MSFT	Stock	63.22	63.22	63.22	63.22	1000.0
2016-12-27 18:00:00	MSFT	Stock	63.28	63.28	63.28	63.28	12000.0
2016-12-27 18:30:00	MSFT	Stock	63.22	63.22	63.22	63.22	378.0

> showing 50 of 81,554 rows — these rows as CSV

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