PREVIEW / stock_30min / 2013-09-24

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-24.parquet
  size:    1.6 MB
  rows:    80,874
  symbols: 3,511

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-09-24 04:00:00	AAPL	Stock	17.6421	17.6786	17.6357	17.6429	117236.0
2013-09-24 04:30:00	AAPL	Stock	17.6432	17.6432	17.6071	17.64	41160.0
2013-09-24 05:00:00	AAPL	Stock	17.6286	17.6286	17.605	17.6196	224000.0
2013-09-24 05:30:00	AAPL	Stock	17.6068	17.6068	17.5811	17.5811	58100.0
2013-09-24 06:00:00	AAPL	Stock	17.5857	17.675	17.5536	17.6429	287392.0
2013-09-24 06:30:00	AAPL	Stock	17.6143	17.6661	17.6143	17.6164	200368.0
2013-09-24 07:00:00	AAPL	Stock	17.6179	17.6607	17.6161	17.6361	859460.0
2013-09-24 07:30:00	AAPL	Stock	17.6429	17.6429	17.5964	17.5964	541632.0
2013-09-24 08:00:00	AAPL	Stock	17.6039	17.6607	17.5243	17.6121	2952992.0
2013-09-24 08:30:00	AAPL	Stock	17.6089	17.6679	17.6004	17.6654	3123960.0
2013-09-24 09:00:00	AAPL	Stock	17.6668	17.7025	17.6593	17.6707	4185944.0
2013-09-24 09:30:00	AAPL	Stock	17.6743	17.6954	17.5286	17.5286	90005328.0
2013-09-24 10:00:00	AAPL	Stock	17.5318	17.5714	17.4221	17.5704	49496440.0
2013-09-24 10:30:00	AAPL	Stock	17.5692	17.6039	17.5432	17.5871	31533824.0
2013-09-24 11:00:00	AAPL	Stock	17.585	17.6036	17.5221	17.5361	19871236.0
2013-09-24 11:30:00	AAPL	Stock	17.5404	17.5982	17.528	17.5637	14422044.0
2013-09-24 12:00:00	AAPL	Stock	17.5678	17.5714	17.4761	17.5031	18578168.0
2013-09-24 12:30:00	AAPL	Stock	17.5029	17.5754	17.5	17.5389	15244376.0
2013-09-24 13:00:00	AAPL	Stock	17.5407	17.5521	17.5054	17.5471	9147684.0
2013-09-24 13:30:00	AAPL	Stock	17.5507	17.5536	17.5043	17.5325	11502512.0
2013-09-24 14:00:00	AAPL	Stock	17.5393	17.5481	17.4839	17.5043	13677916.0
2013-09-24 14:30:00	AAPL	Stock	17.5032	17.5332	17.4755	17.5136	11240348.0
2013-09-24 15:00:00	AAPL	Stock	17.5136	17.5411	17.5011	17.5107	14332276.0
2013-09-24 15:30:00	AAPL	Stock	17.5111	17.5204	17.4443	17.475	35336168.0
2013-09-24 16:00:00	AAPL	Stock	17.4679	17.5494	17.46	17.4732	11986240.0
2013-09-24 16:30:00	AAPL	Stock	17.4679	17.5563	17.4679	17.47	327152.0
2013-09-24 17:00:00	AAPL	Stock	17.4696	17.4768	17.4643	17.4768	237664.0
2013-09-24 17:30:00	AAPL	Stock	17.48	17.4857	17.4679	17.4857	462784.0
2013-09-24 18:00:00	AAPL	Stock	17.4857	17.4957	17.4679	17.4929	126784.0
2013-09-24 18:30:00	AAPL	Stock	17.4868	17.4946	17.4771	17.4771	124796.0
2013-09-24 19:00:00	AAPL	Stock	17.4736	17.4814	17.4618	17.4707	1560244.0
2013-09-24 19:30:00	AAPL	Stock	17.4643	17.4793	17.4643	17.4768	122164.0
2013-09-24 04:00:00	MSFT	Stock	32.76	32.76	32.76	32.76	100.0
2013-09-24 07:00:00	MSFT	Stock	32.74	32.8	32.5	32.72	7070.0
2013-09-24 08:00:00	MSFT	Stock	32.6	32.6	32.6	32.6	411.0
2013-09-24 08:30:00	MSFT	Stock	32.61	32.64	32.61	32.63	640.0
2013-09-24 09:00:00	MSFT	Stock	32.65	32.81	32.65	32.71	25118.0
2013-09-24 09:30:00	MSFT	Stock	32.72	32.87	32.33	32.33	4647483.0
2013-09-24 10:00:00	MSFT	Stock	32.333	32.4	32.15	32.365	5747203.0
2013-09-24 10:30:00	MSFT	Stock	32.38	32.5	32.29	32.43	3543217.0
2013-09-24 11:00:00	MSFT	Stock	32.43	32.48	32.38	32.4	1740437.0
2013-09-24 11:30:00	MSFT	Stock	32.4	32.54	32.38	32.465	2191905.0
2013-09-24 12:00:00	MSFT	Stock	32.46	32.51	32.43	32.49	1466328.0
2013-09-24 12:30:00	MSFT	Stock	32.495	32.54	32.47	32.52	1348464.0
2013-09-24 13:00:00	MSFT	Stock	32.52	32.6	32.5	32.58	1178128.0
2013-09-24 13:30:00	MSFT	Stock	32.58	32.65	32.52	32.52	1653249.0
2013-09-24 14:00:00	MSFT	Stock	32.525	32.53	32.44	32.44	1561001.0
2013-09-24 14:30:00	MSFT	Stock	32.44	32.51	32.44	32.49	1608329.0
2013-09-24 15:00:00	MSFT	Stock	32.485	32.53	32.45	32.45	1835317.0
2013-09-24 15:30:00	MSFT	Stock	32.46	32.46	32.36	32.46	5026976.0

> showing 50 of 80,874 rows — these rows as CSV

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