PREVIEW / stock_30min / 2012-05-23

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-23.parquet
  size:    1.4 MB
  rows:    76,754
  symbols: 3,533

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-23 04:00:00	AAPL	Stock	19.7929	19.8304	19.7571	19.7571	32200.0
2012-05-23 04:30:00	AAPL	Stock	19.7504	19.7504	19.75	19.75	6300.0
2012-05-23 05:00:00	AAPL	Stock	19.8036	19.8036	19.7504	19.7504	16800.0
2012-05-23 05:30:00	AAPL	Stock	19.75	19.75	19.75	19.75	2800.0
2012-05-23 06:00:00	AAPL	Stock	19.7404	19.75	19.7257	19.7429	19460.0
2012-05-23 06:30:00	AAPL	Stock	19.7375	19.7375	19.7375	19.7375	16800.0
2012-05-23 07:00:00	AAPL	Stock	19.7429	19.7946	19.7429	19.7714	130480.0
2012-05-23 07:30:00	AAPL	Stock	19.7696	19.8357	19.7614	19.8286	409052.0
2012-05-23 08:00:00	AAPL	Stock	19.8282	19.8414	19.7218	19.7693	1064336.0
2012-05-23 08:30:00	AAPL	Stock	19.7768	19.8929	19.7464	19.8711	1204168.0
2012-05-23 09:00:00	AAPL	Stock	19.8711	19.9464	19.8443	19.9086	2966012.0
2012-05-23 09:30:00	AAPL	Stock	19.9089	20.0493	19.7582	19.9611	85769040.0
2012-05-23 10:00:00	AAPL	Stock	19.9604	20.0089	19.8286	19.9446	49209384.0
2012-05-23 10:30:00	AAPL	Stock	19.9436	19.9532	19.8214	19.875	33497184.0
2012-05-23 11:00:00	AAPL	Stock	19.8754	20.0068	19.8571	19.9425	27813408.0
2012-05-23 11:30:00	AAPL	Stock	19.9461	19.9886	19.7857	19.8489	36982736.0
2012-05-23 12:00:00	AAPL	Stock	19.8478	19.885	19.7886	19.8446	21254492.0
2012-05-23 12:30:00	AAPL	Stock	19.8471	19.9352	19.8375	19.8871	19307652.0
2012-05-23 13:00:00	AAPL	Stock	19.8864	19.9982	19.8729	19.9939	19692260.0
2012-05-23 13:30:00	AAPL	Stock	19.9902	20.0911	19.9761	20.0771	35078428.0
2012-05-23 14:00:00	AAPL	Stock	20.0761	20.1193	19.9643	20.005	35253792.0
2012-05-23 14:30:00	AAPL	Stock	20.005	20.1543	19.9843	20.1416	32190200.0
2012-05-23 15:00:00	AAPL	Stock	20.14	20.3886	20.1018	20.2964	54434576.0
2012-05-23 15:30:00	AAPL	Stock	20.2964	20.4571	20.2871	20.3682	98914620.0
2012-05-23 16:00:00	AAPL	Stock	20.3682	20.4018	19.9642	20.3982	15052576.0
2012-05-23 16:30:00	AAPL	Stock	20.4007	20.4246	20.2816	20.4214	793996.0
2012-05-23 17:00:00	AAPL	Stock	20.4218	20.4571	20.3771	20.4571	1033592.0
2012-05-23 17:30:00	AAPL	Stock	20.4554	20.4879	20.4554	20.4821	886956.0
2012-05-23 18:00:00	AAPL	Stock	20.4789	20.4857	20.4375	20.4482	500836.0
2012-05-23 18:30:00	AAPL	Stock	20.4457	20.4636	20.4386	20.4525	490644.0
2012-05-23 19:00:00	AAPL	Stock	20.4604	20.4643	20.4464	20.4582	142128.0
2012-05-23 19:30:00	AAPL	Stock	20.4571	20.4571	20.4107	20.4161	389200.0
2012-05-23 20:00:00	AAPL	Stock	20.4	20.4	20.4	20.4	9100.0
2012-05-23 07:00:00	MSFT	Stock	29.51	29.51	29.5	29.5	500.0
2012-05-23 07:30:00	MSFT	Stock	29.63	29.63	29.63	29.63	100.0
2012-05-23 08:00:00	MSFT	Stock	29.63	29.65	29.53	29.53	3282.0
2012-05-23 08:30:00	MSFT	Stock	29.57	29.59	29.56	29.56	7318.0
2012-05-23 09:00:00	MSFT	Stock	29.64	29.64	29.28	29.4	383309.0
2012-05-23 09:30:00	MSFT	Stock	29.34	29.4	28.66	28.872	12776286.0
2012-05-23 10:00:00	MSFT	Stock	28.88	29.0	28.75	28.888	6873839.0
2012-05-23 10:30:00	MSFT	Stock	28.89	28.93	28.76	28.844	4304731.0
2012-05-23 11:00:00	MSFT	Stock	28.848	28.905	28.79	28.8	2832379.0
2012-05-23 11:30:00	MSFT	Stock	28.805	28.83	28.72	28.785	2807753.0
2012-05-23 12:00:00	MSFT	Stock	28.785	28.79	28.64	28.695	3585666.0
2012-05-23 12:30:00	MSFT	Stock	28.695	28.82	28.69	28.79	1914989.0
2012-05-23 13:00:00	MSFT	Stock	28.795	28.85	28.78	28.845	1365729.0
2012-05-23 13:30:00	MSFT	Stock	28.85	28.95	28.83	28.938	3000845.0
2012-05-23 14:00:00	MSFT	Stock	28.93	28.94	28.79	28.8	3164764.0
2012-05-23 14:30:00	MSFT	Stock	28.81	29.0	28.79	28.98	3086744.0
2012-05-23 15:00:00	MSFT	Stock	28.98	29.15	28.922	29.07	3954183.0

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

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