PREVIEW / stock_30min / 2011-06-22

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-22.parquet
  size:    1.4 MB
  rows:    74,238
  symbols: 3,541

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-06-22 06:00:00	AAPL	Stock	11.5939	11.5939	11.5939	11.5939	2800.0
2011-06-22 06:30:00	AAPL	Stock	11.6054	11.6054	11.5821	11.5821	30800.0
2011-06-22 07:00:00	AAPL	Stock	11.5825	11.5825	11.5521	11.5521	206136.0
2011-06-22 07:30:00	AAPL	Stock	11.5607	11.6007	11.5554	11.6007	380576.0
2011-06-22 08:00:00	AAPL	Stock	11.5968	11.6146	11.5836	11.6011	641200.0
2011-06-22 08:30:00	AAPL	Stock	11.6	11.6036	11.5689	11.5796	490364.0
2011-06-22 09:00:00	AAPL	Stock	11.58	11.6161	11.5729	11.6107	898688.0
2011-06-22 09:30:00	AAPL	Stock	11.6121	11.7464	11.5768	11.721	76430480.0
2011-06-22 10:00:00	AAPL	Stock	11.7211	11.7229	11.6793	11.6875	35934052.0
2011-06-22 10:30:00	AAPL	Stock	11.6907	11.7082	11.6607	11.6766	29377572.0
2011-06-22 11:00:00	AAPL	Stock	11.6742	11.6957	11.6525	11.6561	25671520.0
2011-06-22 11:30:00	AAPL	Stock	11.6561	11.6607	11.5821	11.5857	27014568.0
2011-06-22 12:00:00	AAPL	Stock	11.585	11.6321	11.5818	11.6264	24397128.0
2011-06-22 12:30:00	AAPL	Stock	11.6255	11.6907	11.6079	11.6671	24507784.0
2011-06-22 13:00:00	AAPL	Stock	11.6689	11.6707	11.6375	11.6414	14537516.0
2011-06-22 13:30:00	AAPL	Stock	11.6404	11.6739	11.6396	11.6675	11118296.0
2011-06-22 14:00:00	AAPL	Stock	11.6671	11.6696	11.6357	11.6506	14467572.0
2011-06-22 14:30:00	AAPL	Stock	11.6529	11.6679	11.5986	11.6143	20802768.0
2011-06-22 15:00:00	AAPL	Stock	11.6143	11.6346	11.5936	11.6011	17481044.0
2011-06-22 15:30:00	AAPL	Stock	11.6029	11.6054	11.5136	11.5214	53145092.0
2011-06-22 16:00:00	AAPL	Stock	11.5239	11.6465	11.5107	11.515	8089676.0
2011-06-22 16:30:00	AAPL	Stock	11.5143	11.6023	11.5132	11.5175	118580.0
2011-06-22 17:00:00	AAPL	Stock	11.5161	11.5161	11.51	11.5121	149268.0
2011-06-22 17:30:00	AAPL	Stock	11.515	11.5189	11.5118	11.5189	78400.0
2011-06-22 18:00:00	AAPL	Stock	11.5107	11.5218	11.5107	11.5107	188384.0
2011-06-22 18:30:00	AAPL	Stock	11.5089	11.5118	11.4911	11.5011	179480.0
2011-06-22 19:00:00	AAPL	Stock	11.5011	11.5011	11.4839	11.4839	65016.0
2011-06-22 19:30:00	AAPL	Stock	11.4893	11.4979	11.4786	11.4814	196336.0
2011-06-22 07:30:00	MSFT	Stock	24.71	24.71	24.71	24.71	500.0
2011-06-22 08:00:00	MSFT	Stock	24.71	24.74	24.66	24.66	3304.0
2011-06-22 08:30:00	MSFT	Stock	24.66	24.67	24.65	24.67	3189.0
2011-06-22 09:00:00	MSFT	Stock	24.68	24.68	24.61	24.62	9770.0
2011-06-22 09:30:00	MSFT	Stock	24.6	24.81	24.59	24.76	4331797.0
2011-06-22 10:00:00	MSFT	Stock	24.766	24.79	24.68	24.739	4260806.0
2011-06-22 10:30:00	MSFT	Stock	24.73	24.77	24.72	24.75	1972183.0
2011-06-22 11:00:00	MSFT	Stock	24.747	24.78	24.72	24.72	3063795.0
2011-06-22 11:30:00	MSFT	Stock	24.73	24.76	24.66	24.722	4385490.0
2011-06-22 12:00:00	MSFT	Stock	24.72	24.76	24.71	24.735	1505004.0
2011-06-22 12:30:00	MSFT	Stock	24.74	24.78	24.7	24.78	2070800.0
2011-06-22 13:00:00	MSFT	Stock	24.77	24.78	24.74	24.75	1262132.0
2011-06-22 13:30:00	MSFT	Stock	24.755	24.76	24.72	24.75	1365364.0
2011-06-22 14:00:00	MSFT	Stock	24.76	24.77	24.71	24.74	2821264.0
2011-06-22 14:30:00	MSFT	Stock	24.735	24.78	24.71	24.74	3415851.0
2011-06-22 15:00:00	MSFT	Stock	24.74	24.78	24.715	24.735	2486024.0
2011-06-22 15:30:00	MSFT	Stock	24.739	24.74	24.63	24.65	7626587.0
2011-06-22 16:00:00	MSFT	Stock	24.64	24.731	24.63	24.66	1998510.0
2011-06-22 16:30:00	MSFT	Stock	24.713	24.713	24.62	24.62	3850.0
2011-06-22 17:00:00	MSFT	Stock	24.61	24.61	24.55	24.55	7786.0
2011-06-22 17:30:00	MSFT	Stock	24.6	24.63	24.6	24.63	2977.0
2011-06-22 18:00:00	MSFT	Stock	24.63	24.65	24.63	24.63	3823.0

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

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