PREVIEW / stock_30min / 2014-11-17

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-11-17.parquet
  size:    1.6 MB
  rows:    85,717
  symbols: 3,567

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-11-17 04:00:00	AAPL	Stock	28.475	28.545	28.4625	28.485	36568.0
2014-11-17 04:30:00	AAPL	Stock	28.5	28.5	28.475	28.49	11728.0
2014-11-17 05:00:00	AAPL	Stock	28.49	28.49	28.4425	28.4425	42984.0
2014-11-17 05:30:00	AAPL	Stock	28.43	28.5	28.43	28.4625	64800.0
2014-11-17 06:00:00	AAPL	Stock	28.465	28.4825	28.4625	28.4825	25432.0
2014-11-17 06:30:00	AAPL	Stock	28.475	28.5	28.475	28.5	30424.0
2014-11-17 07:00:00	AAPL	Stock	28.5	28.535	28.4625	28.53	142112.0
2014-11-17 07:30:00	AAPL	Stock	28.535	28.57	28.5225	28.5375	103620.0
2014-11-17 08:00:00	AAPL	Stock	28.55	28.6475	28.405	28.6325	611312.0
2014-11-17 08:30:00	AAPL	Stock	28.6325	28.67	28.6075	28.655	362512.0
2014-11-17 09:00:00	AAPL	Stock	28.6675	28.6725	28.555	28.575	813912.0
2014-11-17 09:30:00	AAPL	Stock	28.5675	28.7375	28.5	28.6775	30300940.0
2014-11-17 10:00:00	AAPL	Stock	28.68	28.7725	28.5825	28.7048	24538916.0
2014-11-17 10:30:00	AAPL	Stock	28.705	28.7125	28.5625	28.6072	15947888.0
2014-11-17 11:00:00	AAPL	Stock	28.6095	28.6162	28.325	28.4175	22702260.0
2014-11-17 11:30:00	AAPL	Stock	28.4188	28.4525	28.36	28.4362	11245064.0
2014-11-17 12:00:00	AAPL	Stock	28.435	28.51	28.3825	28.49	8219764.0
2014-11-17 12:30:00	AAPL	Stock	28.49	28.6075	28.4625	28.4825	10006476.0
2014-11-17 13:00:00	AAPL	Stock	28.4825	28.5375	28.45	28.525	7867340.0
2014-11-17 13:30:00	AAPL	Stock	28.5225	28.5525	28.45	28.475	6268028.0
2014-11-17 14:00:00	AAPL	Stock	28.475	28.545	28.465	28.5238	5820704.0
2014-11-17 14:30:00	AAPL	Stock	28.5225	28.54	28.51	28.524	4907844.0
2014-11-17 15:00:00	AAPL	Stock	28.525	28.545	28.47	28.475	5869796.0
2014-11-17 15:30:00	AAPL	Stock	28.4732	28.55	28.4725	28.5	13385236.0
2014-11-17 16:00:00	AAPL	Stock	28.4975	28.569	28.46	28.46	6289812.0
2014-11-17 16:30:00	AAPL	Stock	28.4575	28.4975	28.4525	28.4675	147596.0
2014-11-17 17:00:00	AAPL	Stock	28.4625	28.5155	28.46	28.4625	37792.0
2014-11-17 17:30:00	AAPL	Stock	28.47	28.4975	28.4625	28.4975	49296.0
2014-11-17 18:00:00	AAPL	Stock	28.47	28.4975	28.4625	28.4675	35924.0
2014-11-17 18:30:00	AAPL	Stock	28.4625	28.465	28.4525	28.4575	41988.0
2014-11-17 19:00:00	AAPL	Stock	28.45	28.455	28.44	28.4475	30632.0
2014-11-17 19:30:00	AAPL	Stock	28.4525	28.46	28.4325	28.4325	64356.0
2014-11-17 05:30:00	MSFT	Stock	49.49	49.49	49.49	49.49	100.0
2014-11-17 06:00:00	MSFT	Stock	49.31	49.31	49.31	49.31	200.0
2014-11-17 06:30:00	MSFT	Stock	49.44	49.44	49.44	49.44	1500.0
2014-11-17 07:00:00	MSFT	Stock	49.38	49.38	49.38	49.38	650.0
2014-11-17 08:00:00	MSFT	Stock	49.49	49.53	49.38	49.49	2260.0
2014-11-17 08:30:00	MSFT	Stock	49.57	49.58	49.57	49.58	11610.0
2014-11-17 09:00:00	MSFT	Stock	49.53	49.53	49.45	49.46	5969.0
2014-11-17 09:30:00	MSFT	Stock	49.41	49.5	49.14	49.205	2694284.0
2014-11-17 10:00:00	MSFT	Stock	49.2	49.44	49.16	49.43	2262465.0
2014-11-17 10:30:00	MSFT	Stock	49.43	49.45	49.275	49.315	1682545.0
2014-11-17 11:00:00	MSFT	Stock	49.315	49.34	49.243	49.27	1379568.0
2014-11-17 11:30:00	MSFT	Stock	49.26	49.355	49.24	49.33	1503009.0
2014-11-17 12:00:00	MSFT	Stock	49.33	49.44	49.305	49.43	2253546.0
2014-11-17 12:30:00	MSFT	Stock	49.425	49.705	49.42	49.58	2324743.0
2014-11-17 13:00:00	MSFT	Stock	49.58	49.63	49.57	49.585	1260834.0
2014-11-17 13:30:00	MSFT	Stock	49.585	49.61	49.511	49.57	875202.0
2014-11-17 14:00:00	MSFT	Stock	49.575	49.58	49.5	49.51	1408552.0
2014-11-17 14:30:00	MSFT	Stock	49.515	49.56	49.48	49.495	1724377.0

> showing 50 of 85,717 rows — these rows as CSV

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