PREVIEW / stock_30min / 2012-12-20

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-12-20.parquet
  size:    1.5 MB
  rows:    77,419
  symbols: 3,498

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-12-20 05:00:00	AAPL	Stock	18.8393	18.8661	18.8393	18.8661	53200.0
2012-12-20 05:30:00	AAPL	Stock	18.875	18.875	18.8661	18.8661	11200.0
2012-12-20 06:00:00	AAPL	Stock	18.8821	18.8821	18.8821	18.8821	2800.0
2012-12-20 06:30:00	AAPL	Stock	18.8914	18.8914	18.8914	18.8914	2800.0
2012-12-20 07:00:00	AAPL	Stock	18.9232	18.9261	18.8893	18.8893	150920.0
2012-12-20 07:30:00	AAPL	Stock	18.8896	18.8896	18.7932	18.8214	399672.0
2012-12-20 08:00:00	AAPL	Stock	18.9107	18.9107	18.7668	18.7964	1006292.0
2012-12-20 08:30:00	AAPL	Stock	18.7886	18.9161	18.7886	18.9121	1504580.0
2012-12-20 09:00:00	AAPL	Stock	18.9139	18.9568	18.8929	18.9268	2293816.0
2012-12-20 09:30:00	AAPL	Stock	18.9325	18.9357	18.6493	18.7136	69687240.0
2012-12-20 10:00:00	AAPL	Stock	18.7107	18.8536	18.6921	18.7179	46904564.0
2012-12-20 10:30:00	AAPL	Stock	18.7193	18.7836	18.6679	18.6879	32399528.0
2012-12-20 11:00:00	AAPL	Stock	18.6871	18.725	18.6104	18.6286	34159804.0
2012-12-20 11:30:00	AAPL	Stock	18.6329	18.6846	18.6004	18.6429	24583720.0
2012-12-20 12:00:00	AAPL	Stock	18.6471	18.6682	18.595	18.6089	22673056.0
2012-12-20 12:30:00	AAPL	Stock	18.6071	18.6339	18.5875	18.6156	17897404.0
2012-12-20 13:00:00	AAPL	Stock	18.6161	18.6275	18.5314	18.5814	33192292.0
2012-12-20 13:30:00	AAPL	Stock	18.5789	18.685	18.56	18.6621	30259460.0
2012-12-20 14:00:00	AAPL	Stock	18.6657	18.7129	18.6121	18.6846	22237572.0
2012-12-20 14:30:00	AAPL	Stock	18.6911	18.7654	18.6793	18.7441	33603668.0
2012-12-20 15:00:00	AAPL	Stock	18.7404	18.7475	18.6143	18.6504	33020232.0
2012-12-20 15:30:00	AAPL	Stock	18.6521	18.725	18.6271	18.6395	37443084.0
2012-12-20 16:00:00	AAPL	Stock	18.6279	18.6894	18.5977	18.625	8281812.0
2012-12-20 16:30:00	AAPL	Stock	18.625	18.6462	18.5921	18.5946	3330572.0
2012-12-20 17:00:00	AAPL	Stock	18.5968	18.6421	18.5946	18.615	1280804.0
2012-12-20 17:30:00	AAPL	Stock	18.6154	18.6332	18.5929	18.5929	386876.0
2012-12-20 18:00:00	AAPL	Stock	18.5929	18.6046	18.5929	18.6046	89012.0
2012-12-20 18:30:00	AAPL	Stock	18.5996	18.6025	18.5964	18.5982	61768.0
2012-12-20 19:00:00	AAPL	Stock	18.5961	18.6036	18.5893	18.5929	256816.0
2012-12-20 19:30:00	AAPL	Stock	18.5939	18.5996	18.5775	18.5775	276920.0
2012-12-20 05:30:00	MSFT	Stock	27.32	27.32	27.32	27.32	100.0
2012-12-20 07:30:00	MSFT	Stock	27.41	27.41	27.41	27.41	100.0
2012-12-20 08:00:00	MSFT	Stock	27.39	27.64	27.32	27.32	6300.0
2012-12-20 08:30:00	MSFT	Stock	27.34	27.4	27.34	27.4	2294.0
2012-12-20 09:00:00	MSFT	Stock	27.39	27.4	27.34	27.38	15366.0
2012-12-20 09:30:00	MSFT	Stock	27.39	27.4	27.15	27.27	5470006.0
2012-12-20 10:00:00	MSFT	Stock	27.27	27.42	27.27	27.31	4010645.0
2012-12-20 10:30:00	MSFT	Stock	27.31	27.48	27.3	27.48	2649463.0
2012-12-20 11:00:00	MSFT	Stock	27.475	27.49	27.4	27.44	2908450.0
2012-12-20 11:30:00	MSFT	Stock	27.44	27.53	27.42	27.45	3368811.0
2012-12-20 12:00:00	MSFT	Stock	27.45	27.47	27.38	27.41	2386060.0
2012-12-20 12:30:00	MSFT	Stock	27.413	27.48	27.36	27.48	2492740.0
2012-12-20 13:00:00	MSFT	Stock	27.475	27.53	27.41	27.53	2706163.0
2012-12-20 13:30:00	MSFT	Stock	27.529	27.66	27.51	27.62	3614693.0
2012-12-20 14:00:00	MSFT	Stock	27.63	27.63	27.53	27.585	2962134.0
2012-12-20 14:30:00	MSFT	Stock	27.59	27.65	27.57	27.634	3526536.0
2012-12-20 15:00:00	MSFT	Stock	27.63	27.65	27.55	27.61	3655100.0
2012-12-20 15:30:00	MSFT	Stock	27.6	27.68	27.6	27.67	5932311.0
2012-12-20 16:00:00	MSFT	Stock	27.67	27.7	27.484	27.7	2972942.0
2012-12-20 16:30:00	MSFT	Stock	27.68	27.7	27.592	27.7	2127913.0

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

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