PREVIEW / stock_30min / 2011-06-29

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-29.parquet
  size:    1.5 MB
  rows:    76,883
  symbols: 3,550

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-29 04:00:00	AAPL	Stock	12.0	12.0161	12.0	12.0	8400.0
2011-06-29 06:30:00	AAPL	Stock	12.0357	12.0357	12.0357	12.0357	5600.0
2011-06-29 07:00:00	AAPL	Stock	12.0357	12.0536	12.0354	12.0536	210000.0
2011-06-29 07:30:00	AAPL	Stock	12.0429	12.0554	12.0357	12.0357	277452.0
2011-06-29 08:00:00	AAPL	Stock	12.0336	12.0443	12.0179	12.0339	759444.0
2011-06-29 08:30:00	AAPL	Stock	12.0336	12.0571	12.02	12.0546	1143044.0
2011-06-29 09:00:00	AAPL	Stock	12.0532	12.0714	11.9911	12.0021	2876104.0
2011-06-29 09:30:00	AAPL	Stock	12.0014	12.0132	11.8932	11.925	62704656.0
2011-06-29 10:00:00	AAPL	Stock	11.9271	11.9518	11.8854	11.9293	43178016.0
2011-06-29 10:30:00	AAPL	Stock	11.9296	12.0078	11.9161	12.0046	34656188.0
2011-06-29 11:00:00	AAPL	Stock	12.0079	12.0111	11.9325	11.9339	29142148.0
2011-06-29 11:30:00	AAPL	Stock	11.9329	11.9446	11.9193	11.9339	15611624.0
2011-06-29 12:00:00	AAPL	Stock	11.935	11.9543	11.9232	11.9343	11111912.0
2011-06-29 12:30:00	AAPL	Stock	11.9353	11.9429	11.9198	11.9329	8805972.0
2011-06-29 13:00:00	AAPL	Stock	11.93	11.9375	11.9154	11.9293	13180636.0
2011-06-29 13:30:00	AAPL	Stock	11.9296	11.9557	11.925	11.9393	12803224.0
2011-06-29 14:00:00	AAPL	Stock	11.9407	11.9464	11.8571	11.8732	28318388.0
2011-06-29 14:30:00	AAPL	Stock	11.8736	11.8989	11.8529	11.8912	24311084.0
2011-06-29 15:00:00	AAPL	Stock	11.8929	11.9375	11.8786	11.925	21848596.0
2011-06-29 15:30:00	AAPL	Stock	11.9243	11.9371	11.9136	11.93	28983724.0
2011-06-29 16:00:00	AAPL	Stock	11.93	11.9514	11.9095	11.9324	6993364.0
2011-06-29 16:30:00	AAPL	Stock	11.9314	11.9357	11.9267	11.935	134624.0
2011-06-29 17:00:00	AAPL	Stock	11.9357	11.9486	11.9306	11.9375	141176.0
2011-06-29 17:30:00	AAPL	Stock	11.9375	11.9393	11.9357	11.9393	22820.0
2011-06-29 18:00:00	AAPL	Stock	11.93	11.93	11.93	11.93	27132.0
2011-06-29 18:30:00	AAPL	Stock	11.9354	11.9354	11.9307	11.9354	28504.0
2011-06-29 19:30:00	AAPL	Stock	11.9332	11.9336	11.9286	11.9321	143920.0
2011-06-29 06:30:00	MSFT	Stock	25.86	25.86	25.86	25.86	500.0
2011-06-29 07:00:00	MSFT	Stock	25.89	25.89	25.79	25.86	8872.0
2011-06-29 07:30:00	MSFT	Stock	25.87	25.87	25.8	25.8	10840.0
2011-06-29 08:00:00	MSFT	Stock	25.83	25.84	25.7	25.71	94315.0
2011-06-29 08:30:00	MSFT	Stock	25.74	25.84	25.74	25.8	26281.0
2011-06-29 09:00:00	MSFT	Stock	25.83	25.83	25.65	25.72	97087.0
2011-06-29 09:30:00	MSFT	Stock	25.69	25.7	25.4	25.46	8019667.0
2011-06-29 10:00:00	MSFT	Stock	25.455	25.53	25.36	25.49	4124584.0
2011-06-29 10:30:00	MSFT	Stock	25.49	25.65	25.48	25.645	3741639.0
2011-06-29 11:00:00	MSFT	Stock	25.65	25.7	25.61	25.61	3161734.0
2011-06-29 11:30:00	MSFT	Stock	25.62	25.68	25.585	25.68	2150589.0
2011-06-29 12:00:00	MSFT	Stock	25.68	25.7	25.57	25.57	3453110.0
2011-06-29 12:30:00	MSFT	Stock	25.57	25.63	25.56	25.58	2664651.0
2011-06-29 13:00:00	MSFT	Stock	25.58	25.62	25.55	25.581	2620315.0
2011-06-29 13:30:00	MSFT	Stock	25.585	25.62	25.54	25.56	3643932.0
2011-06-29 14:00:00	MSFT	Stock	25.56	25.62	25.55	25.62	4234181.0
2011-06-29 14:30:00	MSFT	Stock	25.615	25.65	25.57	25.62	3525306.0
2011-06-29 15:00:00	MSFT	Stock	25.619	25.69	25.57	25.67	4248562.0
2011-06-29 15:30:00	MSFT	Stock	25.679	25.7	25.59	25.62	9512837.0
2011-06-29 16:00:00	MSFT	Stock	25.63	25.851	25.57	25.851	9726193.0
2011-06-29 16:30:00	MSFT	Stock	25.67	25.69	25.61	25.66	48412.0
2011-06-29 17:00:00	MSFT	Stock	25.65	25.71	25.602	25.65	7277.0
2011-06-29 17:30:00	MSFT	Stock	25.65	25.65	25.62	25.62	4925.0

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

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