PREVIEW / stock_30min / 2014-08-28

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-28.parquet
  size:    1.5 MB
  rows:    81,104
  symbols: 3,583

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-08-28 04:00:00	AAPL	Stock	25.5875	25.5875	25.48	25.5	5200.0
2014-08-28 04:30:00	AAPL	Stock	25.5	25.5	25.5	25.5	3116.0
2014-08-28 05:00:00	AAPL	Stock	25.5	25.5	25.5	25.5	3020.0
2014-08-28 05:30:00	AAPL	Stock	25.5075	25.5075	25.4375	25.45	8120.0
2014-08-28 06:00:00	AAPL	Stock	25.45	25.45	25.375	25.3825	67180.0
2014-08-28 06:30:00	AAPL	Stock	25.3825	25.4275	25.375	25.415	22384.0
2014-08-28 07:00:00	AAPL	Stock	25.41	25.4725	25.41	25.45	115972.0
2014-08-28 07:30:00	AAPL	Stock	25.45	25.4525	25.4375	25.4375	45816.0
2014-08-28 08:00:00	AAPL	Stock	25.4375	25.5325	25.375	25.4125	616428.0
2014-08-28 08:30:00	AAPL	Stock	25.42	25.435	25.4075	25.425	217880.0
2014-08-28 09:00:00	AAPL	Stock	25.4225	25.5325	25.33	25.3875	6242188.0
2014-08-28 09:30:00	AAPL	Stock	25.3975	25.635	25.39	25.603	35391072.0
2014-08-28 10:00:00	AAPL	Stock	25.6075	25.625	25.51	25.525	19256424.0
2014-08-28 10:30:00	AAPL	Stock	25.5238	25.625	25.5225	25.5912	13876312.0
2014-08-28 11:00:00	AAPL	Stock	25.5925	25.615	25.5625	25.5912	10280308.0
2014-08-28 11:30:00	AAPL	Stock	25.595	25.64	25.5865	25.605	11011532.0
2014-08-28 12:00:00	AAPL	Stock	25.6048	25.695	25.5925	25.66	15304024.0
2014-08-28 12:30:00	AAPL	Stock	25.6575	25.6675	25.5925	25.6072	8374168.0
2014-08-28 13:00:00	AAPL	Stock	25.6075	25.6175	25.5675	25.5875	7356208.0
2014-08-28 13:30:00	AAPL	Stock	25.5888	25.6338	25.585	25.6053	5442044.0
2014-08-28 14:00:00	AAPL	Stock	25.605	25.62	25.585	25.605	4577704.0
2014-08-28 14:30:00	AAPL	Stock	25.6062	25.6275	25.565	25.57	6459068.0
2014-08-28 15:00:00	AAPL	Stock	25.57	25.5975	25.54	25.5875	7063144.0
2014-08-28 15:30:00	AAPL	Stock	25.5875	25.63	25.545	25.5625	18385796.0
2014-08-28 16:00:00	AAPL	Stock	25.5625	25.5905	25.5225	25.5625	27207388.0
2014-08-28 16:30:00	AAPL	Stock	25.5675	25.603	25.5675	25.603	104380.0
2014-08-28 17:00:00	AAPL	Stock	25.575	25.5925	25.5625	25.585	1858032.0
2014-08-28 17:30:00	AAPL	Stock	25.5875	25.59	25.575	25.575	39256.0
2014-08-28 18:00:00	AAPL	Stock	25.5775	25.585	25.575	25.585	45448.0
2014-08-28 18:30:00	AAPL	Stock	25.5875	25.6075	25.5625	25.6075	65316.0
2014-08-28 19:00:00	AAPL	Stock	25.6075	25.6175	25.6025	25.6125	116424.0
2014-08-28 19:30:00	AAPL	Stock	25.595	25.605	25.595	25.595	85112.0
2014-08-28 05:30:00	MSFT	Stock	44.7	44.7	44.62	44.62	400.0
2014-08-28 06:00:00	MSFT	Stock	44.6	44.6	44.6	44.6	1150.0
2014-08-28 07:00:00	MSFT	Stock	44.79	44.79	44.79	44.79	100.0
2014-08-28 08:00:00	MSFT	Stock	44.73	44.73	44.71	44.71	1700.0
2014-08-28 08:30:00	MSFT	Stock	44.67	44.72	44.67	44.7	3109.0
2014-08-28 09:00:00	MSFT	Stock	44.71	44.74	44.67	44.74	14935.0
2014-08-28 09:30:00	MSFT	Stock	44.74	44.85	44.64	44.69	2693025.0
2014-08-28 10:00:00	MSFT	Stock	44.69	44.75	44.61	44.705	1457923.0
2014-08-28 10:30:00	MSFT	Stock	44.71	44.76	44.64	44.715	1132235.0
2014-08-28 11:00:00	MSFT	Stock	44.72	44.74	44.66	44.71	724230.0
2014-08-28 11:30:00	MSFT	Stock	44.72	44.8	44.71	44.735	769995.0
2014-08-28 12:00:00	MSFT	Stock	44.74	44.87	44.73	44.843	907532.0
2014-08-28 12:30:00	MSFT	Stock	44.85	44.91	44.85	44.875	593494.0
2014-08-28 13:00:00	MSFT	Stock	44.87	44.875	44.825	44.847	589515.0
2014-08-28 13:30:00	MSFT	Stock	44.845	44.88	44.81	44.87	425366.0
2014-08-28 14:00:00	MSFT	Stock	44.865	44.87	44.78	44.845	587798.0
2014-08-28 14:30:00	MSFT	Stock	44.845	44.85	44.78	44.805	953875.0
2014-08-28 15:00:00	MSFT	Stock	44.81	44.87	44.79	44.865	1379653.0

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

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