PREVIEW / stock_30min / 2011-04-29

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-29.parquet
  size:    1.4 MB
  rows:    74,641
  symbols: 3,563

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
2011-04-29 06:00:00	AAPL	Stock	12.3929	12.3929	12.3929	12.3929	2800.0
2011-04-29 06:30:00	AAPL	Stock	12.3886	12.3886	12.3718	12.3718	5600.0
2011-04-29 07:00:00	AAPL	Stock	12.385	12.4096	12.385	12.4096	32900.0
2011-04-29 07:30:00	AAPL	Stock	12.4236	12.4286	12.4129	12.4214	262080.0
2011-04-29 08:00:00	AAPL	Stock	12.4157	12.4282	12.4107	12.4143	350448.0
2011-04-29 08:30:00	AAPL	Stock	12.4186	12.425	12.3925	12.3925	204148.0
2011-04-29 09:00:00	AAPL	Stock	12.3893	12.4068	12.3632	12.3879	655424.0
2011-04-29 09:30:00	AAPL	Stock	12.3979	12.5357	12.3809	12.4914	77012600.0
2011-04-29 10:00:00	AAPL	Stock	12.4904	12.5307	12.4793	12.5257	33826128.0
2011-04-29 10:30:00	AAPL	Stock	12.5254	12.5254	12.4886	12.5011	18265884.0
2011-04-29 11:00:00	AAPL	Stock	12.5011	12.5107	12.4861	12.4882	14087500.0
2011-04-29 11:30:00	AAPL	Stock	12.4893	12.5232	12.4789	12.5137	21506324.0
2011-04-29 12:00:00	AAPL	Stock	12.5146	12.5357	12.5132	12.5286	19761084.0
2011-04-29 12:30:00	AAPL	Stock	12.5304	12.5661	12.5293	12.5495	25173624.0
2011-04-29 13:00:00	AAPL	Stock	12.55	12.5893	12.5489	12.5859	22991192.0
2011-04-29 13:30:00	AAPL	Stock	12.5857	12.6411	12.5851	12.595	37018184.0
2011-04-29 14:00:00	AAPL	Stock	12.5954	12.6161	12.5811	12.5932	24577000.0
2011-04-29 14:30:00	AAPL	Stock	12.5932	12.6382	12.5929	12.6078	30702420.0
2011-04-29 15:00:00	AAPL	Stock	12.6075	12.6214	12.5914	12.5964	30164904.0
2011-04-29 15:30:00	AAPL	Stock	12.5975	12.6268	12.4675	12.4675	193543840.0
2011-04-29 16:00:00	AAPL	Stock	12.4675	12.5114	12.4366	12.4971	255638852.0
2011-04-29 16:30:00	AAPL	Stock	12.4982	12.6097	12.4367	12.4371	9388512.0
2011-04-29 17:00:00	AAPL	Stock	12.5	12.5036	12.4371	12.5036	171169236.0
2011-04-29 17:30:00	AAPL	Stock	12.5046	12.5068	12.4368	12.4968	976752.0
2011-04-29 18:00:00	AAPL	Stock	12.5018	12.5046	12.4964	12.4979	362488.0
2011-04-29 18:30:00	AAPL	Stock	12.4971	12.5011	12.4964	12.4968	215096.0
2011-04-29 19:00:00	AAPL	Stock	12.4979	12.5007	12.4911	12.4989	132440.0
2011-04-29 19:30:00	AAPL	Stock	12.4982	12.4996	12.4893	12.4893	244272.0
2011-04-29 05:30:00	MSFT	Stock	26.36	26.36	26.3	26.3	2500.0
2011-04-29 06:30:00	MSFT	Stock	26.39	26.4	26.38	26.38	12150.0
2011-04-29 07:00:00	MSFT	Stock	26.31	26.35	26.23	26.23	51050.0
2011-04-29 07:30:00	MSFT	Stock	26.25	26.55	26.25	26.5	111435.0
2011-04-29 08:00:00	MSFT	Stock	26.5	26.55	26.35	26.49	234890.0
2011-04-29 08:30:00	MSFT	Stock	26.49	26.49	26.42	26.49	253556.0
2011-04-29 09:00:00	MSFT	Stock	26.49	26.56	26.46	26.55	420080.0
2011-04-29 09:30:00	MSFT	Stock	26.55	26.64	25.88	25.9	24344030.0
2011-04-29 10:00:00	MSFT	Stock	25.88	25.99	25.5	25.549	24682218.0
2011-04-29 10:30:00	MSFT	Stock	25.55	25.71	25.48	25.63	13650338.0
2011-04-29 11:00:00	MSFT	Stock	25.62	25.7	25.56	25.57	11280372.0
2011-04-29 11:30:00	MSFT	Stock	25.571	25.71	25.53	25.623	8585155.0
2011-04-29 12:00:00	MSFT	Stock	25.62	25.77	25.6	25.7	9060027.0
2011-04-29 12:30:00	MSFT	Stock	25.7	25.72	25.58	25.61	5889817.0
2011-04-29 13:00:00	MSFT	Stock	25.605	25.64	25.52	25.541	6632651.0
2011-04-29 13:30:00	MSFT	Stock	25.55	25.59	25.41	25.44	9727317.0
2011-04-29 14:00:00	MSFT	Stock	25.44	25.63	25.36	25.605	13530858.0
2011-04-29 14:30:00	MSFT	Stock	25.603	25.69	25.56	25.602	7216201.0
2011-04-29 15:00:00	MSFT	Stock	25.61	25.65	25.51	25.552	8347587.0
2011-04-29 15:30:00	MSFT	Stock	25.55	26.03	25.505	26.02	51312998.0
2011-04-29 16:00:00	MSFT	Stock	26.02	26.72	25.743	25.95	66567198.0
2011-04-29 16:30:00	MSFT	Stock	25.95	26.02	25.565	25.97	3063063.0

> showing 50 of 74,641 rows — these rows as CSV

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