PREVIEW / stock_30min / 2011-03-31

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-31.parquet
  size:    1.5 MB
  rows:    76,890
  symbols: 3,535

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-31 04:00:00	AAPL	Stock	12.4643	12.4643	12.4643	12.4643	5600.0
2011-03-31 04:30:00	AAPL	Stock	12.4639	12.4639	12.4639	12.4639	2800.0
2011-03-31 05:00:00	AAPL	Stock	12.4643	12.4643	12.4429	12.4429	11200.0
2011-03-31 05:30:00	AAPL	Stock	12.4607	12.4639	12.4607	12.4639	5600.0
2011-03-31 06:30:00	AAPL	Stock	12.4393	12.4393	12.4314	12.4314	5600.0
2011-03-31 07:00:00	AAPL	Stock	12.4143	12.4279	12.4089	12.4168	74648.0
2011-03-31 07:30:00	AAPL	Stock	12.4143	12.4171	12.4032	12.4132	96796.0
2011-03-31 08:00:00	AAPL	Stock	12.4107	12.4107	12.3632	12.3857	1206100.0
2011-03-31 08:30:00	AAPL	Stock	12.3857	12.3964	12.375	12.3836	537824.0
2011-03-31 09:00:00	AAPL	Stock	12.3821	12.3904	12.3596	12.3675	1058624.0
2011-03-31 09:30:00	AAPL	Stock	12.3675	12.4929	12.3593	12.4532	52038336.0
2011-03-31 10:00:00	AAPL	Stock	12.4532	12.4714	12.4136	12.4482	25673116.0
2011-03-31 10:30:00	AAPL	Stock	12.4479	12.4775	12.4443	12.4689	17713696.0
2011-03-31 11:00:00	AAPL	Stock	12.4689	12.4721	12.4236	12.4329	14689388.0
2011-03-31 11:30:00	AAPL	Stock	12.4343	12.4382	12.4007	12.4221	15169336.0
2011-03-31 12:00:00	AAPL	Stock	12.4211	12.4464	12.4186	12.4425	11226656.0
2011-03-31 12:30:00	AAPL	Stock	12.4425	12.4671	12.4332	12.4561	13979588.0
2011-03-31 13:00:00	AAPL	Stock	12.4568	12.4696	12.4554	12.4607	6158236.0
2011-03-31 13:30:00	AAPL	Stock	12.4621	12.4671	12.4432	12.4432	7092316.0
2011-03-31 14:00:00	AAPL	Stock	12.4432	12.4671	12.4375	12.4402	11029732.0
2011-03-31 14:30:00	AAPL	Stock	12.4404	12.4454	12.4182	12.4375	12969544.0
2011-03-31 15:00:00	AAPL	Stock	12.4375	12.4468	12.4179	12.4404	13041980.0
2011-03-31 15:30:00	AAPL	Stock	12.4404	12.4643	12.4139	12.4491	40498668.0
2011-03-31 16:00:00	AAPL	Stock	12.4494	12.4586	12.4401	12.4446	23022720.0
2011-03-31 16:30:00	AAPL	Stock	12.4554	12.4614	12.4375	12.4589	1339912.0
2011-03-31 17:00:00	AAPL	Stock	12.4589	12.4621	12.4455	12.4604	146580.0
2011-03-31 17:30:00	AAPL	Stock	12.4582	12.4582	12.4429	12.4443	184800.0
2011-03-31 18:00:00	AAPL	Stock	12.4436	12.4536	12.4436	12.4471	21420.0
2011-03-31 18:30:00	AAPL	Stock	12.45	12.45	12.45	12.45	2800.0
2011-03-31 19:00:00	AAPL	Stock	12.4482	12.4589	12.4482	12.4589	33572.0
2011-03-31 19:30:00	AAPL	Stock	12.4468	12.4768	12.4468	12.4571	312872.0
2011-03-31 06:30:00	MSFT	Stock	25.7	25.7	25.7	25.7	800.0
2011-03-31 08:00:00	MSFT	Stock	25.68	25.68	25.67	25.68	3410.0
2011-03-31 08:30:00	MSFT	Stock	25.68	25.68	25.65	25.65	4700.0
2011-03-31 09:00:00	MSFT	Stock	25.64	25.66	25.6	25.66	27569.0
2011-03-31 09:30:00	MSFT	Stock	25.63	25.68	25.51	25.55	2954647.0
2011-03-31 10:00:00	MSFT	Stock	25.54	25.63	25.54	25.582	2828415.0
2011-03-31 10:30:00	MSFT	Stock	25.58	25.59	25.54	25.558	1680947.0
2011-03-31 11:00:00	MSFT	Stock	25.56	25.62	25.54	25.555	3787005.0
2011-03-31 11:30:00	MSFT	Stock	25.553	25.57	25.5	25.5	2917656.0
2011-03-31 12:00:00	MSFT	Stock	25.508	25.51	25.48	25.493	2660433.0
2011-03-31 12:30:00	MSFT	Stock	25.5	25.5	25.465	25.49	2048721.0
2011-03-31 13:00:00	MSFT	Stock	25.485	25.51	25.46	25.465	3201916.0
2011-03-31 13:30:00	MSFT	Stock	25.46	25.47	25.4	25.42	4981609.0
2011-03-31 14:00:00	MSFT	Stock	25.415	25.44	25.36	25.36	3495031.0
2011-03-31 14:30:00	MSFT	Stock	25.368	25.5	25.36	25.49	8759481.0
2011-03-31 15:00:00	MSFT	Stock	25.49	25.55	25.475	25.506	5160054.0
2011-03-31 15:30:00	MSFT	Stock	25.505	25.51	25.35	25.35	11645780.0
2011-03-31 16:00:00	MSFT	Stock	25.35	25.537	25.34	25.358	6393943.0
2011-03-31 16:30:00	MSFT	Stock	25.4	25.51	25.357	25.4	189756.0

> showing 50 of 76,890 rows — these rows as CSV

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