PREVIEW / stock_30min / 2012-07-11

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-11.parquet
  size:    1.4 MB
  rows:    72,992
  symbols: 3,466

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-07-11 04:00:00	AAPL	Stock	21.7536	21.7536	21.7536	21.7536	2800.0
2012-07-11 04:30:00	AAPL	Stock	21.785	21.7854	21.785	21.7854	5600.0
2012-07-11 05:00:00	AAPL	Stock	21.8214	21.8214	21.8214	21.8214	2800.0
2012-07-11 06:00:00	AAPL	Stock	21.7946	21.7946	21.7911	21.7911	16380.0
2012-07-11 06:30:00	AAPL	Stock	21.7946	21.7946	21.7946	21.7946	11200.0
2012-07-11 07:00:00	AAPL	Stock	21.7893	21.8179	21.7407	21.7464	424452.0
2012-07-11 07:30:00	AAPL	Stock	21.7464	21.7589	21.6918	21.7093	635656.0
2012-07-11 08:00:00	AAPL	Stock	21.7082	21.7418	21.6429	21.6793	1608432.0
2012-07-11 08:30:00	AAPL	Stock	21.6839	21.7064	21.6629	21.6629	970200.0
2012-07-11 09:00:00	AAPL	Stock	21.6675	21.7036	21.6464	21.6489	1124704.0
2012-07-11 09:30:00	AAPL	Stock	21.6471	21.7021	21.5179	21.63	64257536.0
2012-07-11 10:00:00	AAPL	Stock	21.631	21.6904	21.5893	21.6107	32199440.0
2012-07-11 10:30:00	AAPL	Stock	21.6098	21.6195	21.4893	21.5036	24681776.0
2012-07-11 11:00:00	AAPL	Stock	21.5036	21.5714	21.4857	21.5296	21701316.0
2012-07-11 11:30:00	AAPL	Stock	21.53	21.5857	21.5296	21.5568	13227732.0
2012-07-11 12:00:00	AAPL	Stock	21.5593	21.5768	21.5118	21.5346	11779124.0
2012-07-11 12:30:00	AAPL	Stock	21.5311	21.6396	21.5243	21.6354	14441952.0
2012-07-11 13:00:00	AAPL	Stock	21.6364	21.6364	21.5357	21.5629	12769232.0
2012-07-11 13:30:00	AAPL	Stock	21.5625	21.6189	21.5379	21.5923	11118856.0
2012-07-11 14:00:00	AAPL	Stock	21.5907	21.6175	21.3586	21.3943	50975456.0
2012-07-11 14:30:00	AAPL	Stock	21.3936	21.3964	21.3293	21.3618	47755064.0
2012-07-11 15:00:00	AAPL	Stock	21.3664	21.4982	21.3621	21.45	37497992.0
2012-07-11 15:30:00	AAPL	Stock	21.4514	21.6307	21.4046	21.5868	52861928.0
2012-07-11 16:00:00	AAPL	Stock	21.5825	21.5961	21.5137	21.5893	61638640.0
2012-07-11 16:30:00	AAPL	Stock	21.5811	21.6018	21.4445	21.5982	538496.0
2012-07-11 17:00:00	AAPL	Stock	21.5009	21.6	21.4939	21.5996	461944.0
2012-07-11 17:30:00	AAPL	Stock	21.6	21.6554	21.6	21.6329	481516.0
2012-07-11 18:00:00	AAPL	Stock	21.6346	21.6346	21.6196	21.6196	59920.0
2012-07-11 18:30:00	AAPL	Stock	21.6243	21.6329	21.6196	21.6321	94388.0
2012-07-11 19:00:00	AAPL	Stock	21.6304	21.6329	21.6257	21.6329	95060.0
2012-07-11 19:30:00	AAPL	Stock	21.6329	21.6425	21.625	21.6386	286608.0
2012-07-11 08:00:00	MSFT	Stock	29.89	29.89	29.8	29.8	2492.0
2012-07-11 08:30:00	MSFT	Stock	29.8	29.8	29.8	29.8	991.0
2012-07-11 09:00:00	MSFT	Stock	29.81	29.82	29.65	29.71	11513.0
2012-07-11 09:30:00	MSFT	Stock	29.71	29.735	29.39	29.4	3994009.0
2012-07-11 10:00:00	MSFT	Stock	29.4	29.62	29.39	29.435	2638056.0
2012-07-11 10:30:00	MSFT	Stock	29.44	29.46	29.35	29.37	2077305.0
2012-07-11 11:00:00	MSFT	Stock	29.36	29.45	29.35	29.385	1620712.0
2012-07-11 11:30:00	MSFT	Stock	29.39	29.45	29.36	29.44	1771634.0
2012-07-11 12:00:00	MSFT	Stock	29.43	29.48	29.4	29.411	1146048.0
2012-07-11 12:30:00	MSFT	Stock	29.42	29.43	29.34	29.35	1744209.0
2012-07-11 13:00:00	MSFT	Stock	29.345	29.36	29.24	29.275	1953804.0
2012-07-11 13:30:00	MSFT	Stock	29.27	29.372	29.26	29.37	1670681.0
2012-07-11 14:00:00	MSFT	Stock	29.38	29.39	29.13	29.16	3701729.0
2012-07-11 14:30:00	MSFT	Stock	29.185	29.2	29.105	29.168	2137824.0
2012-07-11 15:00:00	MSFT	Stock	29.16	29.26	29.16	29.2	2882170.0
2012-07-11 15:30:00	MSFT	Stock	29.19	29.39	29.18	29.29	8190940.0
2012-07-11 16:00:00	MSFT	Stock	29.29	29.505	29.29	29.3	3351839.0
2012-07-11 16:30:00	MSFT	Stock	29.3	29.74	29.21	29.74	105933.0
2012-07-11 17:00:00	MSFT	Stock	29.263	29.3	29.261	29.3	65863.0

> showing 50 of 72,992 rows — these rows as CSV

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