PREVIEW / stock_30min / 2011-06-23

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-23.parquet
  size:    1.4 MB
  rows:    75,629
  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
2011-06-23 04:00:00	AAPL	Stock	11.4846	11.4846	11.4846	11.4846	2800.0
2011-06-23 06:00:00	AAPL	Stock	11.4654	11.4654	11.4554	11.4554	16800.0
2011-06-23 06:30:00	AAPL	Stock	11.4543	11.4543	11.4421	11.4421	26264.0
2011-06-23 07:00:00	AAPL	Stock	11.4461	11.4821	11.4386	11.4643	135912.0
2011-06-23 07:30:00	AAPL	Stock	11.4536	11.4643	11.4404	11.4596	223636.0
2011-06-23 08:00:00	AAPL	Stock	11.4643	11.4643	11.4146	11.4146	1043420.0
2011-06-23 08:30:00	AAPL	Stock	11.4064	11.4186	11.3571	11.3818	2146228.0
2011-06-23 09:00:00	AAPL	Stock	11.3818	11.3914	11.3625	11.3907	1488004.0
2011-06-23 09:30:00	AAPL	Stock	11.3918	11.4914	11.3614	11.48	72156532.0
2011-06-23 10:00:00	AAPL	Stock	11.48	11.6057	11.4643	11.5686	69829396.0
2011-06-23 10:30:00	AAPL	Stock	11.5654	11.5893	11.4821	11.5357	37782836.0
2011-06-23 11:00:00	AAPL	Stock	11.5364	11.5911	11.52	11.5854	28493080.0
2011-06-23 11:30:00	AAPL	Stock	11.5843	11.6071	11.5578	11.6025	21734552.0
2011-06-23 12:00:00	AAPL	Stock	11.6021	11.6629	11.6018	11.6169	37494268.0
2011-06-23 12:30:00	AAPL	Stock	11.6179	11.6868	11.6136	11.6864	22283912.0
2011-06-23 13:00:00	AAPL	Stock	11.6864	11.7318	11.6821	11.7043	36524096.0
2011-06-23 13:30:00	AAPL	Stock	11.7032	11.7318	11.6607	11.6937	31675168.0
2011-06-23 14:00:00	AAPL	Stock	11.6939	11.6939	11.62	11.6507	28680064.0
2011-06-23 14:30:00	AAPL	Stock	11.6507	11.74	11.635	11.7387	29447768.0
2011-06-23 15:00:00	AAPL	Stock	11.7396	11.7639	11.6868	11.7407	51195424.0
2011-06-23 15:30:00	AAPL	Stock	11.7414	11.8461	11.7164	11.83	64537228.0
2011-06-23 16:00:00	AAPL	Stock	11.8349	11.8411	11.5435	11.8296	16183664.0
2011-06-23 16:30:00	AAPL	Stock	11.7957	11.8146	11.7415	11.8018	309568.0
2011-06-23 17:00:00	AAPL	Stock	11.8032	11.8196	11.8032	11.8143	295792.0
2011-06-23 17:30:00	AAPL	Stock	11.8161	11.8218	11.8143	11.8193	179368.0
2011-06-23 18:00:00	AAPL	Stock	11.8211	11.8536	11.8211	11.8464	636944.0
2011-06-23 18:30:00	AAPL	Stock	11.85	11.8575	11.8454	11.8454	288764.0
2011-06-23 19:00:00	AAPL	Stock	11.8464	11.8518	11.8393	11.8457	126896.0
2011-06-23 19:30:00	AAPL	Stock	11.8479	11.8529	11.8439	11.85	162204.0
2011-06-23 07:00:00	MSFT	Stock	24.5	24.5	24.5	24.5	400.0
2011-06-23 08:00:00	MSFT	Stock	24.5	24.56	24.5	24.56	12453.0
2011-06-23 08:30:00	MSFT	Stock	24.56	24.56	24.43	24.49	28551.0
2011-06-23 09:00:00	MSFT	Stock	24.49	24.53	24.4	24.45	68896.0
2011-06-23 09:30:00	MSFT	Stock	24.43	24.5	24.36	24.4	6000555.0
2011-06-23 10:00:00	MSFT	Stock	24.4	24.4	24.26	24.295	5453954.0
2011-06-23 10:30:00	MSFT	Stock	24.293	24.33	24.2	24.249	5739885.0
2011-06-23 11:00:00	MSFT	Stock	24.245	24.28	24.21	24.275	3580570.0
2011-06-23 11:30:00	MSFT	Stock	24.27	24.31	24.26	24.305	2850221.0
2011-06-23 12:00:00	MSFT	Stock	24.302	24.34	24.27	24.275	4434161.0
2011-06-23 12:30:00	MSFT	Stock	24.271	24.34	24.26	24.335	2086154.0
2011-06-23 13:00:00	MSFT	Stock	24.34	24.44	24.31	24.42	2931371.0
2011-06-23 13:30:00	MSFT	Stock	24.42	24.46	24.29	24.34	2986823.0
2011-06-23 14:00:00	MSFT	Stock	24.34	24.35	24.27	24.305	2498047.0
2011-06-23 14:30:00	MSFT	Stock	24.31	24.52	24.27	24.52	3466288.0
2011-06-23 15:00:00	MSFT	Stock	24.49	24.62	24.42	24.49	5933873.0
2011-06-23 15:30:00	MSFT	Stock	24.488	24.65	24.43	24.64	7911375.0
2011-06-23 16:00:00	MSFT	Stock	24.63	24.64	24.3	24.63	2990932.0
2011-06-23 16:30:00	MSFT	Stock	24.46	24.51	24.45	24.51	61200.0
2011-06-23 17:00:00	MSFT	Stock	24.51	24.51	24.51	24.51	700.0
2011-06-23 17:30:00	MSFT	Stock	24.55	24.55	24.55	24.55	1000.0

> showing 50 of 75,629 rows — these rows as CSV

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