PREVIEW / stock_30min / 2012-05-18

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-18.parquet
  size:    1.4 MB
  rows:    77,401
  symbols: 3,514

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-05-18 04:00:00	AAPL	Stock	18.9404	18.9404	18.85	18.8875	33768.0
2012-05-18 04:30:00	AAPL	Stock	18.8857	18.8857	18.8618	18.8618	70952.0
2012-05-18 05:00:00	AAPL	Stock	18.8632	18.8679	18.8571	18.8571	64932.0
2012-05-18 05:30:00	AAPL	Stock	18.8571	18.9429	18.8571	18.9321	174440.0
2012-05-18 06:00:00	AAPL	Stock	18.9321	18.9643	18.9321	18.9643	76300.0
2012-05-18 06:30:00	AAPL	Stock	18.9754	18.9821	18.9643	18.9821	110908.0
2012-05-18 07:00:00	AAPL	Stock	19.0	19.0518	18.9929	19.025	603764.0
2012-05-18 07:30:00	AAPL	Stock	19.0179	19.0821	19.0089	19.0536	722232.0
2012-05-18 08:00:00	AAPL	Stock	19.0396	19.1036	19.0021	19.0857	2130100.0
2012-05-18 08:30:00	AAPL	Stock	19.0893	19.0896	19.0146	19.0286	1403500.0
2012-05-18 09:00:00	AAPL	Stock	19.0321	19.0736	19.0071	19.0736	2685004.0
2012-05-18 09:30:00	AAPL	Stock	19.0696	19.1389	18.8807	19.0843	103567240.0
2012-05-18 10:00:00	AAPL	Stock	19.0829	19.4007	19.0714	19.3857	110074916.0
2012-05-18 10:30:00	AAPL	Stock	19.3811	19.4075	19.2768	19.3232	59874248.0
2012-05-18 11:00:00	AAPL	Stock	19.3222	19.3611	18.99	19.2071	43965236.0
2012-05-18 11:30:00	AAPL	Stock	19.2064	19.2386	18.6493	19.0904	68377624.0
2012-05-18 12:00:00	AAPL	Stock	19.0935	19.2321	19.0893	19.2114	40592412.0
2012-05-18 12:30:00	AAPL	Stock	19.2112	19.2993	19.2071	19.2339	30799384.0
2012-05-18 13:00:00	AAPL	Stock	19.2339	19.235	19.1111	19.1132	26192432.0
2012-05-18 13:30:00	AAPL	Stock	19.1146	19.1339	19.0223	19.0486	30704128.0
2012-05-18 14:00:00	AAPL	Stock	19.0486	19.1014	19.0261	19.0721	26757500.0
2012-05-18 14:30:00	AAPL	Stock	19.0714	19.0757	19.0	19.0296	24783668.0
2012-05-18 15:00:00	AAPL	Stock	19.0289	19.0804	18.9643	18.9707	41532764.0
2012-05-18 15:30:00	AAPL	Stock	18.9734	18.9857	18.9279	18.9375	65633596.0
2012-05-18 16:00:00	AAPL	Stock	18.9339	19.1999	18.925	18.9361	13787648.0
2012-05-18 16:30:00	AAPL	Stock	18.9357	19.0567	18.9286	18.9329	422632.0
2012-05-18 17:00:00	AAPL	Stock	18.9357	18.998	18.925	18.9275	907452.0
2012-05-18 17:30:00	AAPL	Stock	18.9275	18.9411	18.9275	18.9393	126728.0
2012-05-18 18:00:00	AAPL	Stock	18.9411	18.9521	18.9307	18.9307	250628.0
2012-05-18 18:30:00	AAPL	Stock	18.9304	18.9457	18.9036	18.9111	290192.0
2012-05-18 19:00:00	AAPL	Stock	18.9032	18.9032	18.8679	18.8929	351204.0
2012-05-18 19:30:00	AAPL	Stock	18.8929	18.9093	18.8925	18.8929	132664.0
2012-05-18 06:30:00	MSFT	Stock	29.99	29.99	29.99	29.99	1000.0
2012-05-18 07:00:00	MSFT	Stock	29.76	29.94	29.76	29.93	1228.0
2012-05-18 08:00:00	MSFT	Stock	29.89	29.97	29.8	29.86	23927.0
2012-05-18 08:30:00	MSFT	Stock	29.86	29.86	29.83	29.83	5906.0
2012-05-18 09:00:00	MSFT	Stock	29.81	29.85	29.72	29.76	139530.0
2012-05-18 09:30:00	MSFT	Stock	29.77	29.81	29.3	29.32	14396595.0
2012-05-18 10:00:00	MSFT	Stock	29.32	29.49	29.27	29.39	3387986.0
2012-05-18 10:30:00	MSFT	Stock	29.39	29.63	29.34	29.582	3498306.0
2012-05-18 11:00:00	MSFT	Stock	29.585	29.61	29.41	29.42	2847966.0
2012-05-18 11:30:00	MSFT	Stock	29.43	29.46	29.19	29.35	4395230.0
2012-05-18 12:00:00	MSFT	Stock	29.34	29.55	29.34	29.51	2515716.0
2012-05-18 12:30:00	MSFT	Stock	29.51	29.61	29.47	29.48	1908268.0
2012-05-18 13:00:00	MSFT	Stock	29.485	29.52	29.41	29.47	1670607.0
2012-05-18 13:30:00	MSFT	Stock	29.46	29.48	29.34	29.365	2610890.0
2012-05-18 14:00:00	MSFT	Stock	29.37	29.45	29.35	29.397	1860793.0
2012-05-18 14:30:00	MSFT	Stock	29.39	29.405	29.26	29.35	2957363.0
2012-05-18 15:00:00	MSFT	Stock	29.35	29.42	29.27	29.3	3587319.0
2012-05-18 15:30:00	MSFT	Stock	29.309	29.33	29.17	29.27	6356734.0

> showing 50 of 77,401 rows — these rows as CSV

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