PREVIEW / stock_30min / 2011-03-30

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-30.parquet
  size:    1.4 MB
  rows:    75,317
  symbols: 3,522

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-03-30 04:00:00	AAPL	Stock	12.6518	12.655	12.6468	12.6468	16800.0
2011-03-30 04:30:00	AAPL	Stock	12.6429	12.6429	12.6214	12.6214	28000.0
2011-03-30 05:00:00	AAPL	Stock	12.625	12.625	12.625	12.625	2800.0
2011-03-30 05:30:00	AAPL	Stock	12.6107	12.6143	12.6096	12.6096	8400.0
2011-03-30 06:00:00	AAPL	Stock	12.6096	12.6096	12.6096	12.6096	2800.0
2011-03-30 06:30:00	AAPL	Stock	12.6196	12.6221	12.6089	12.6089	54936.0
2011-03-30 07:00:00	AAPL	Stock	12.6204	12.6204	12.5929	12.6	455280.0
2011-03-30 07:30:00	AAPL	Stock	12.6	12.6161	12.5607	12.5854	1068032.0
2011-03-30 08:00:00	AAPL	Stock	12.5764	12.5854	12.5171	12.5386	2925132.0
2011-03-30 08:30:00	AAPL	Stock	12.5357	12.56	12.5186	12.52	1223320.0
2011-03-30 09:00:00	AAPL	Stock	12.5211	12.5325	12.4893	12.5254	3807860.0
2011-03-30 09:30:00	AAPL	Stock	12.5254	12.5314	12.4214	12.4739	77108528.0
2011-03-30 10:00:00	AAPL	Stock	12.4739	12.4768	12.4271	12.4279	33974808.0
2011-03-30 10:30:00	AAPL	Stock	12.4279	12.4611	12.4086	12.4539	38835552.0
2011-03-30 11:00:00	AAPL	Stock	12.4521	12.4643	12.435	12.4418	17461584.0
2011-03-30 11:30:00	AAPL	Stock	12.4412	12.4554	12.4386	12.4424	8410500.0
2011-03-30 12:00:00	AAPL	Stock	12.4425	12.4714	12.4421	12.4543	17175256.0
2011-03-30 12:30:00	AAPL	Stock	12.4543	12.4593	12.4429	12.4514	8539748.0
2011-03-30 13:00:00	AAPL	Stock	12.4504	12.4607	12.4443	12.4496	10472532.0
2011-03-30 13:30:00	AAPL	Stock	12.4532	12.4668	12.4418	12.4486	12123272.0
2011-03-30 14:00:00	AAPL	Stock	12.4482	12.4704	12.4479	12.4671	12015948.0
2011-03-30 14:30:00	AAPL	Stock	12.4664	12.4704	12.4486	12.4543	11596844.0
2011-03-30 15:00:00	AAPL	Stock	12.453	12.4839	12.4508	12.4682	22424080.0
2011-03-30 15:30:00	AAPL	Stock	12.4686	12.4854	12.4379	12.4561	37009504.0
2011-03-30 16:00:00	AAPL	Stock	12.4564	12.5343	12.4382	12.45	5797764.0
2011-03-30 16:30:00	AAPL	Stock	12.4504	12.4703	12.45	12.4536	626080.0
2011-03-30 17:00:00	AAPL	Stock	12.4564	12.4564	12.4393	12.44	612304.0
2011-03-30 17:30:00	AAPL	Stock	12.4411	12.4454	12.4393	12.4393	52640.0
2011-03-30 18:00:00	AAPL	Stock	12.4375	12.4511	12.425	12.425	327264.0
2011-03-30 18:30:00	AAPL	Stock	12.4286	12.4286	12.4064	12.4107	180852.0
2011-03-30 19:00:00	AAPL	Stock	12.4179	12.4211	12.4107	12.4211	129500.0
2011-03-30 19:30:00	AAPL	Stock	12.4161	12.4318	12.4143	12.4318	90356.0
2011-03-30 04:00:00	MSFT	Stock	25.62	25.67	25.62	25.67	549.0
2011-03-30 07:00:00	MSFT	Stock	25.6	25.6	25.6	25.6	100.0
2011-03-30 08:00:00	MSFT	Stock	25.63	25.68	25.56	25.6	16990.0
2011-03-30 08:30:00	MSFT	Stock	25.59	25.62	25.59	25.59	24050.0
2011-03-30 09:00:00	MSFT	Stock	25.58	25.61	25.56	25.57	47316.0
2011-03-30 09:30:00	MSFT	Stock	25.57	25.65	25.5	25.65	3738655.0
2011-03-30 10:00:00	MSFT	Stock	25.65	25.65	25.55	25.642	1699484.0
2011-03-30 10:30:00	MSFT	Stock	25.64	25.7	25.64	25.69	3001583.0
2011-03-30 11:00:00	MSFT	Stock	25.69	25.71	25.66	25.662	2097506.0
2011-03-30 11:30:00	MSFT	Stock	25.66	25.71	25.63	25.63	1688913.0
2011-03-30 12:00:00	MSFT	Stock	25.635	25.67	25.62	25.646	3087936.0
2011-03-30 12:30:00	MSFT	Stock	25.645	25.65	25.61	25.63	1827357.0
2011-03-30 13:00:00	MSFT	Stock	25.62	25.69	25.61	25.65	2780326.0
2011-03-30 13:30:00	MSFT	Stock	25.645	25.72	25.64	25.7	1742768.0
2011-03-30 14:00:00	MSFT	Stock	25.69	25.72	25.67	25.696	1719797.0
2011-03-30 14:30:00	MSFT	Stock	25.69	25.71	25.63	25.67	2189537.0
2011-03-30 15:00:00	MSFT	Stock	25.662	25.69	25.64	25.65	3105232.0
2011-03-30 15:30:00	MSFT	Stock	25.65	25.67	25.57	25.58	5188816.0

> showing 50 of 75,317 rows — these rows as CSV

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