PREVIEW / stock_30min / 2014-05-20

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-20.parquet
  size:    1.6 MB
  rows:    83,021
  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
2014-05-20 04:00:00	AAPL	Stock	21.6071	21.6071	21.6071	21.6071	2800.0
2014-05-20 05:00:00	AAPL	Stock	21.5996	21.6007	21.5996	21.6007	5600.0
2014-05-20 05:30:00	AAPL	Stock	21.6271	21.6296	21.6271	21.6296	11200.0
2014-05-20 06:00:00	AAPL	Stock	21.6507	21.6604	21.6507	21.6554	81200.0
2014-05-20 06:30:00	AAPL	Stock	21.6311	21.6561	21.6161	21.6561	28000.0
2014-05-20 07:00:00	AAPL	Stock	21.6482	21.6625	21.6218	21.6336	183120.0
2014-05-20 07:30:00	AAPL	Stock	21.6286	21.6286	21.6061	21.6061	129276.0
2014-05-20 08:00:00	AAPL	Stock	21.6036	21.6554	21.5718	21.5882	240968.0
2014-05-20 08:30:00	AAPL	Stock	21.5804	21.5986	21.56	21.5982	257012.0
2014-05-20 09:00:00	AAPL	Stock	21.5989	21.6018	21.5754	21.5893	274848.0
2014-05-20 09:30:00	AAPL	Stock	21.5896	21.6393	21.5361	21.5821	33795720.0
2014-05-20 10:00:00	AAPL	Stock	21.5843	21.65	21.5611	21.5864	27595932.0
2014-05-20 10:30:00	AAPL	Stock	21.5886	21.6429	21.5843	21.6343	15062460.0
2014-05-20 11:00:00	AAPL	Stock	21.6332	21.6371	21.5718	21.5874	9175292.0
2014-05-20 11:30:00	AAPL	Stock	21.5861	21.6571	21.5818	21.6468	8101716.0
2014-05-20 12:00:00	AAPL	Stock	21.6536	21.6536	21.5639	21.5789	9457308.0
2014-05-20 12:30:00	AAPL	Stock	21.5796	21.6025	21.5682	21.5871	4781448.0
2014-05-20 13:00:00	AAPL	Stock	21.5893	21.5911	21.515	21.5154	12826688.0
2014-05-20 13:30:00	AAPL	Stock	21.5157	21.5182	21.4546	21.4661	13813940.0
2014-05-20 14:00:00	AAPL	Stock	21.4661	21.54	21.4661	21.5261	9554580.0
2014-05-20 14:30:00	AAPL	Stock	21.5214	21.5264	21.4682	21.5036	7589428.0
2014-05-20 15:00:00	AAPL	Stock	21.5032	21.5671	21.4914	21.56	9740612.0
2014-05-20 15:30:00	AAPL	Stock	21.5604	21.6071	21.5604	21.5932	21225876.0
2014-05-20 16:00:00	AAPL	Stock	21.5911	21.5968	21.5761	21.5857	9533888.0
2014-05-20 16:30:00	AAPL	Stock	21.5854	21.5893	21.5839	21.5839	124852.0
2014-05-20 17:00:00	AAPL	Stock	21.5811	21.5911	21.5768	21.5768	389984.0
2014-05-20 17:30:00	AAPL	Stock	21.5911	21.5918	21.5804	21.5804	883736.0
2014-05-20 18:00:00	AAPL	Stock	21.585	21.5854	21.5539	21.5607	275324.0
2014-05-20 18:30:00	AAPL	Stock	21.5571	21.5911	21.5439	21.5454	255612.0
2014-05-20 19:00:00	AAPL	Stock	21.5443	21.5446	21.5357	21.5357	100324.0
2014-05-20 19:30:00	AAPL	Stock	21.5375	21.5454	21.5243	21.5375	143472.0
2014-05-20 04:30:00	MSFT	Stock	39.65	39.65	39.65	39.65	500.0
2014-05-20 05:30:00	MSFT	Stock	39.65	39.65	39.65	39.65	500.0
2014-05-20 07:30:00	MSFT	Stock	39.61	39.61	39.6	39.6	1300.0
2014-05-20 08:00:00	MSFT	Stock	39.74	39.74	39.59	39.62	4800.0
2014-05-20 08:30:00	MSFT	Stock	39.6	39.65	39.6	39.65	2650.0
2014-05-20 09:00:00	MSFT	Stock	39.63	39.8	39.61	39.77	8092.0
2014-05-20 09:30:00	MSFT	Stock	39.68	39.94	39.52	39.6	2269200.0
2014-05-20 10:00:00	MSFT	Stock	39.6	39.69	39.58	39.61	1071888.0
2014-05-20 10:30:00	MSFT	Stock	39.6	39.68	39.6	39.68	856559.0
2014-05-20 11:00:00	MSFT	Stock	39.68	39.7	39.65	39.66	955714.0
2014-05-20 11:30:00	MSFT	Stock	39.67	39.74	39.622	39.72	1132427.0
2014-05-20 12:00:00	MSFT	Stock	39.72	39.73	39.53	39.558	1253461.0
2014-05-20 12:30:00	MSFT	Stock	39.56	39.63	39.52	39.61	717924.0
2014-05-20 13:00:00	MSFT	Stock	39.6	39.61	39.48	39.58	1457963.0
2014-05-20 13:30:00	MSFT	Stock	39.58	39.625	39.46	39.548	1609395.0
2014-05-20 14:00:00	MSFT	Stock	39.54	39.75	39.54	39.69	1416945.0
2014-05-20 14:30:00	MSFT	Stock	39.68	39.71	39.6	39.65	887995.0
2014-05-20 15:00:00	MSFT	Stock	39.645	39.75	39.62	39.7	1544062.0
2014-05-20 15:30:00	MSFT	Stock	39.705	39.8	39.67	39.69	3205309.0

> showing 50 of 83,021 rows — these rows as CSV

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