PREVIEW / stock_30min / 2014-07-23

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-23.parquet
  size:    1.5 MB
  rows:    81,176
  symbols: 3,559

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
2014-07-23 04:00:00	AAPL	Stock	23.585	23.6225	23.5775	23.6	13236.0
2014-07-23 04:30:00	AAPL	Stock	23.625	23.625	23.5975	23.6075	4000.0
2014-07-23 05:00:00	AAPL	Stock	23.59	23.6	23.5825	23.5825	4360.0
2014-07-23 05:30:00	AAPL	Stock	23.5875	23.6	23.5775	23.6	22120.0
2014-07-23 06:00:00	AAPL	Stock	23.5875	23.5875	23.555	23.575	29788.0
2014-07-23 06:30:00	AAPL	Stock	23.57	23.575	23.545	23.5625	47072.0
2014-07-23 07:00:00	AAPL	Stock	23.5625	23.7875	23.53	23.7875	828200.0
2014-07-23 07:30:00	AAPL	Stock	23.79	23.9675	23.775	23.845	1048672.0
2014-07-23 08:00:00	AAPL	Stock	23.8475	23.97	23.53	23.7175	2356580.0
2014-07-23 08:30:00	AAPL	Stock	23.72	23.83	23.6825	23.775	2648740.0
2014-07-23 09:00:00	AAPL	Stock	23.775	23.8525	23.755	23.85	1693632.0
2014-07-23 09:30:00	AAPL	Stock	23.855	24.07	23.7925	24.0475	62797816.0
2014-07-23 10:00:00	AAPL	Stock	24.0425	24.3425	24.0425	24.2928	50922624.0
2014-07-23 10:30:00	AAPL	Stock	24.2938	24.47	24.28	24.4175	45638764.0
2014-07-23 11:00:00	AAPL	Stock	24.4152	24.4275	24.315	24.355	29466516.0
2014-07-23 11:30:00	AAPL	Stock	24.3562	24.4262	24.3075	24.3425	22793264.0
2014-07-23 12:00:00	AAPL	Stock	24.345	24.42	24.325	24.385	15938932.0
2014-07-23 12:30:00	AAPL	Stock	24.385	24.4075	24.3325	24.3875	12216076.0
2014-07-23 13:00:00	AAPL	Stock	24.3873	24.3912	24.2913	24.335	10806172.0
2014-07-23 13:30:00	AAPL	Stock	24.3328	24.4125	24.305	24.4055	12094392.0
2014-07-23 14:00:00	AAPL	Stock	24.405	24.42	24.38	24.4	9623728.0
2014-07-23 14:30:00	AAPL	Stock	24.4	24.405	24.3425	24.3675	7857704.0
2014-07-23 15:00:00	AAPL	Stock	24.3662	24.405	24.3525	24.3812	10747932.0
2014-07-23 15:30:00	AAPL	Stock	24.38	24.39	24.2825	24.2975	23837468.0
2014-07-23 16:00:00	AAPL	Stock	24.2975	24.3482	24.2375	24.2475	17059304.0
2014-07-23 16:30:00	AAPL	Stock	24.25	24.2975	24.2375	24.285	280736.0
2014-07-23 17:00:00	AAPL	Stock	24.2825	24.2975	24.2525	24.28	317484.0
2014-07-23 17:30:00	AAPL	Stock	24.2775	24.2825	24.2625	24.2625	115424.0
2014-07-23 18:00:00	AAPL	Stock	24.2725	24.3	24.2575	24.285	229112.0
2014-07-23 18:30:00	AAPL	Stock	24.285	24.29	24.2675	24.285	40872.0
2014-07-23 19:00:00	AAPL	Stock	24.2875	24.2925	24.27	24.27	87692.0
2014-07-23 19:30:00	AAPL	Stock	24.27	24.2925	24.27	24.2925	121580.0
2014-07-23 04:00:00	MSFT	Stock	45.5	45.59	45.5	45.59	1100.0
2014-07-23 04:30:00	MSFT	Stock	45.56	45.56	45.07	45.07	3900.0
2014-07-23 05:00:00	MSFT	Stock	45.55	45.55	45.55	45.55	500.0
2014-07-23 05:30:00	MSFT	Stock	45.55	45.55	45.31	45.31	800.0
2014-07-23 06:00:00	MSFT	Stock	45.35	45.62	45.32	45.51	14172.0
2014-07-23 06:30:00	MSFT	Stock	45.51	45.51	45.42	45.43	1400.0
2014-07-23 07:00:00	MSFT	Stock	45.55	45.9	45.55	45.81	65115.0
2014-07-23 07:30:00	MSFT	Stock	45.84	45.95	45.65	45.88	192611.0
2014-07-23 08:00:00	MSFT	Stock	45.88	45.9	45.39	45.46	308212.0
2014-07-23 08:30:00	MSFT	Stock	45.48	45.58	45.41	45.57	125149.0
2014-07-23 09:00:00	MSFT	Stock	45.56	45.69	45.42	45.48	219944.0
2014-07-23 09:30:00	MSFT	Stock	45.45	45.46	44.62	44.74	12213211.0
2014-07-23 10:00:00	MSFT	Stock	44.75	45.19	44.725	45.18	6557212.0
2014-07-23 10:30:00	MSFT	Stock	45.18	45.43	45.08	45.265	5171278.0
2014-07-23 11:00:00	MSFT	Stock	45.262	45.34	45.23	45.257	2972754.0
2014-07-23 11:30:00	MSFT	Stock	45.255	45.4	45.14	45.17	3263938.0
2014-07-23 12:00:00	MSFT	Stock	45.18	45.31	44.965	45.0	2681813.0
2014-07-23 12:30:00	MSFT	Stock	45.001	45.165	44.99	45.09	1706131.0

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

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