PREVIEW / stock_30min / 2012-11-26

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-26.parquet
  size:    1.4 MB
  rows:    76,002
  symbols: 3,497

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
2012-11-26 04:00:00	AAPL	Stock	20.4643	20.4996	20.4579	20.4996	49000.0
2012-11-26 04:30:00	AAPL	Stock	20.4993	20.535	20.4821	20.4821	99428.0
2012-11-26 05:00:00	AAPL	Stock	20.4768	20.4946	20.4768	20.4946	11200.0
2012-11-26 05:30:00	AAPL	Stock	20.475	20.5143	20.4554	20.5143	42952.0
2012-11-26 06:00:00	AAPL	Stock	20.4979	20.5143	20.4821	20.5	49140.0
2012-11-26 06:30:00	AAPL	Stock	20.4911	20.4929	20.4607	20.4643	51632.0
2012-11-26 07:00:00	AAPL	Stock	20.4643	20.4786	20.4307	20.45	398468.0
2012-11-26 07:30:00	AAPL	Stock	20.455	20.4696	20.3779	20.4286	1131004.0
2012-11-26 08:00:00	AAPL	Stock	20.4521	20.4811	20.4196	20.45	1865052.0
2012-11-26 08:30:00	AAPL	Stock	20.4482	20.4643	20.4332	20.4607	1834756.0
2012-11-26 09:00:00	AAPL	Stock	20.4596	20.5786	20.4596	20.5661	6213900.0
2012-11-26 09:30:00	AAPL	Stock	20.5679	20.705	20.4896	20.685	101041304.0
2012-11-26 10:00:00	AAPL	Stock	20.6893	20.6996	20.5896	20.6339	46030404.0
2012-11-26 10:30:00	AAPL	Stock	20.6304	20.7143	20.6071	20.6593	34306860.0
2012-11-26 11:00:00	AAPL	Stock	20.6626	20.6786	20.6161	20.6582	25759468.0
2012-11-26 11:30:00	AAPL	Stock	20.6602	20.8064	20.6538	20.7679	40129628.0
2012-11-26 12:00:00	AAPL	Stock	20.7671	20.8882	20.7607	20.8786	39662224.0
2012-11-26 12:30:00	AAPL	Stock	20.875	21.0307	20.8214	21.004	55358212.0
2012-11-26 13:00:00	AAPL	Stock	21.0029	21.0357	20.9371	20.9507	37143568.0
2012-11-26 13:30:00	AAPL	Stock	20.9504	21.03	20.9443	20.9853	25300968.0
2012-11-26 14:00:00	AAPL	Stock	20.9877	21.01	20.9196	20.9764	26065424.0
2012-11-26 14:30:00	AAPL	Stock	20.9757	21.0671	20.975	21.0493	30191672.0
2012-11-26 15:00:00	AAPL	Stock	21.0471	21.0675	20.9914	21.0107	31989384.0
2012-11-26 15:30:00	AAPL	Stock	21.0093	21.0671	20.9436	21.0454	63312788.0
2012-11-26 16:00:00	AAPL	Stock	21.0454	21.0679	20.6575	21.0529	45258360.0
2012-11-26 16:30:00	AAPL	Stock	21.0532	21.1372	20.5875	21.0464	338436.0
2012-11-26 17:00:00	AAPL	Stock	21.0496	21.0607	21.0482	21.0536	320768.0
2012-11-26 17:30:00	AAPL	Stock	21.0507	21.0507	21.0411	21.0411	267876.0
2012-11-26 18:00:00	AAPL	Stock	21.0393	21.0532	21.0375	21.0464	143948.0
2012-11-26 18:30:00	AAPL	Stock	21.0525	21.0582	21.0482	21.0571	60760.0
2012-11-26 19:00:00	AAPL	Stock	21.0579	21.0686	21.0536	21.0686	392728.0
2012-11-26 19:30:00	AAPL	Stock	21.0679	21.0786	21.0675	21.0779	720692.0
2012-11-26 04:00:00	MSFT	Stock	27.7	27.7	27.7	27.7	600.0
2012-11-26 04:30:00	MSFT	Stock	27.58	27.58	27.58	27.58	200.0
2012-11-26 05:00:00	MSFT	Stock	27.55	27.55	27.55	27.55	150.0
2012-11-26 07:00:00	MSFT	Stock	27.6	27.6	27.59	27.6	1800.0
2012-11-26 07:30:00	MSFT	Stock	27.58	27.58	27.45	27.48	4000.0
2012-11-26 08:00:00	MSFT	Stock	27.55	27.7	27.46	27.55	10075.0
2012-11-26 08:30:00	MSFT	Stock	27.56	27.58	27.52	27.56	6500.0
2012-11-26 09:00:00	MSFT	Stock	27.55	27.58	27.5	27.54	108851.0
2012-11-26 09:30:00	MSFT	Stock	27.54	27.58	27.32	27.36	6441461.0
2012-11-26 10:00:00	MSFT	Stock	27.362	27.38	27.27	27.28	6227991.0
2012-11-26 10:30:00	MSFT	Stock	27.285	27.32	27.25	27.27	4519131.0
2012-11-26 11:00:00	MSFT	Stock	27.28	27.32	27.17	27.223	5615992.0
2012-11-26 11:30:00	MSFT	Stock	27.225	27.307	27.19	27.25	2915892.0
2012-11-26 12:00:00	MSFT	Stock	27.245	27.32	27.23	27.26	2863189.0
2012-11-26 12:30:00	MSFT	Stock	27.26	27.29	27.23	27.23	3065338.0
2012-11-26 13:00:00	MSFT	Stock	27.235	27.28	27.21	27.25	3828358.0
2012-11-26 13:30:00	MSFT	Stock	27.25	27.28	27.22	27.25	2661741.0
2012-11-26 14:00:00	MSFT	Stock	27.255	27.31	27.23	27.25	2611956.0

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

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