PREVIEW / stock_30min / 2013-11-01

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-11-01.parquet
  size:    1.6 MB
  rows:    82,313
  symbols: 3,531

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
2013-11-01 04:00:00	AAPL	Stock	18.6786	18.6786	18.6786	18.6786	2800.0
2013-11-01 05:30:00	AAPL	Stock	18.6786	18.6875	18.6786	18.6875	9744.0
2013-11-01 06:30:00	AAPL	Stock	18.6786	18.6786	18.5714	18.5893	263704.0
2013-11-01 07:00:00	AAPL	Stock	18.6071	18.7357	18.6071	18.7357	205800.0
2013-11-01 07:30:00	AAPL	Stock	18.7446	18.7486	18.7264	18.7454	108976.0
2013-11-01 08:00:00	AAPL	Stock	18.7411	18.7493	18.6554	18.7286	686196.0
2013-11-01 08:30:00	AAPL	Stock	18.7321	18.7321	18.7146	18.7232	275100.0
2013-11-01 09:00:00	AAPL	Stock	18.7239	18.7411	18.6679	18.7161	793828.0
2013-11-01 09:30:00	AAPL	Stock	18.715	18.7429	18.6436	18.7007	35206304.0
2013-11-01 10:00:00	AAPL	Stock	18.7029	18.725	18.6232	18.6461	23437288.0
2013-11-01 10:30:00	AAPL	Stock	18.6454	18.6943	18.6268	18.6364	13733468.0
2013-11-01 11:00:00	AAPL	Stock	18.6382	18.6429	18.5232	18.5393	28676732.0
2013-11-01 11:30:00	AAPL	Stock	18.5429	18.5632	18.5146	18.5207	12881960.0
2013-11-01 12:00:00	AAPL	Stock	18.5204	18.5714	18.5189	18.5675	14126644.0
2013-11-01 12:30:00	AAPL	Stock	18.5675	18.5846	18.5282	18.5369	8671040.0
2013-11-01 13:00:00	AAPL	Stock	18.5325	18.55	18.4246	18.4254	22572564.0
2013-11-01 13:30:00	AAPL	Stock	18.4257	18.5032	18.4229	18.4954	18541124.0
2013-11-01 14:00:00	AAPL	Stock	18.4939	18.5225	18.4539	18.4761	15164436.0
2013-11-01 14:30:00	AAPL	Stock	18.4751	18.4907	18.4404	18.4804	12459356.0
2013-11-01 15:00:00	AAPL	Stock	18.4806	18.5589	18.4804	18.5571	17503108.0
2013-11-01 15:30:00	AAPL	Stock	18.5571	18.5875	18.5511	18.5693	32595332.0
2013-11-01 16:00:00	AAPL	Stock	18.5729	18.5921	18.565	18.5707	10435432.0
2013-11-01 16:30:00	AAPL	Stock	18.5711	18.5736	18.5622	18.5729	1099140.0
2013-11-01 17:00:00	AAPL	Stock	18.5725	18.5796	18.5714	18.5743	485184.0
2013-11-01 17:30:00	AAPL	Stock	18.5757	18.5782	18.5579	18.5636	197036.0
2013-11-01 18:00:00	AAPL	Stock	18.5729	18.575	18.5443	18.575	312004.0
2013-11-01 18:30:00	AAPL	Stock	18.5768	18.5804	18.5714	18.5793	70336.0
2013-11-01 19:00:00	AAPL	Stock	18.5725	18.5725	18.5671	18.5696	64624.0
2013-11-01 19:30:00	AAPL	Stock	18.5654	18.5714	18.5375	18.5429	119224.0
2013-11-01 04:00:00	MSFT	Stock	35.39	35.39	35.39	35.39	100.0
2013-11-01 06:00:00	MSFT	Stock	35.5	35.5	35.5	35.5	1000.0
2013-11-01 07:00:00	MSFT	Stock	35.5	35.5	35.5	35.5	1000.0
2013-11-01 08:00:00	MSFT	Stock	35.45	35.51	35.4	35.51	4500.0
2013-11-01 08:30:00	MSFT	Stock	35.55	35.56	35.52	35.55	3700.0
2013-11-01 09:00:00	MSFT	Stock	35.55	35.69	35.35	35.64	45782.0
2013-11-01 09:30:00	MSFT	Stock	35.67	35.69	35.53	35.635	3995639.0
2013-11-01 10:00:00	MSFT	Stock	35.64	35.66	35.51	35.575	3037261.0
2013-11-01 10:30:00	MSFT	Stock	35.58	35.62	35.542	35.543	3101712.0
2013-11-01 11:00:00	MSFT	Stock	35.545	35.57	35.42	35.46	3378410.0
2013-11-01 11:30:00	MSFT	Stock	35.45	35.52	35.39	35.41	3033184.0
2013-11-01 12:00:00	MSFT	Stock	35.405	35.54	35.395	35.5	2340560.0
2013-11-01 12:30:00	MSFT	Stock	35.495	35.525	35.451	35.485	2258510.0
2013-11-01 13:00:00	MSFT	Stock	35.485	35.49	35.4	35.45	3306658.0
2013-11-01 13:30:00	MSFT	Stock	35.45	35.56	35.44	35.53	1788774.0
2013-11-01 14:00:00	MSFT	Stock	35.54	35.57	35.52	35.535	1006505.0
2013-11-01 14:30:00	MSFT	Stock	35.54	35.54	35.5	35.51	1890432.0
2013-11-01 15:00:00	MSFT	Stock	35.51	35.56	35.5	35.551	2036354.0
2013-11-01 15:30:00	MSFT	Stock	35.555	35.6	35.49	35.51	5890711.0
2013-11-01 16:00:00	MSFT	Stock	35.51	35.545	35.44	35.517	2597730.0
2013-11-01 16:30:00	MSFT	Stock	35.51	35.58	35.47	35.47	125900.0

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

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