PREVIEW / stock_30min / 2011-06-17

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-17.parquet
  size:    1.5 MB
  rows:    77,304
  symbols: 3,578

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-17 06:00:00	AAPL	Stock	11.65	11.65	11.65	11.65	2800.0
2011-06-17 06:30:00	AAPL	Stock	11.6982	11.7057	11.685	11.695	100800.0
2011-06-17 07:00:00	AAPL	Stock	11.6946	11.7143	11.6946	11.7089	244888.0
2011-06-17 07:30:00	AAPL	Stock	11.7121	11.7379	11.7107	11.7321	264572.0
2011-06-17 08:00:00	AAPL	Stock	11.73	11.73	11.7004	11.7054	1004220.0
2011-06-17 08:30:00	AAPL	Stock	11.7071	11.7107	11.6879	11.7096	524104.0
2011-06-17 09:00:00	AAPL	Stock	11.7107	11.7582	11.6964	11.755	2637936.0
2011-06-17 09:30:00	AAPL	Stock	11.7496	11.7589	11.577	11.5786	71136436.0
2011-06-17 10:00:00	AAPL	Stock	11.5791	11.6106	11.445	11.4821	77742560.0
2011-06-17 10:30:00	AAPL	Stock	11.4821	11.5639	11.4468	11.5221	50648976.0
2011-06-17 11:00:00	AAPL	Stock	11.5214	11.555	11.4911	11.54	33357072.0
2011-06-17 11:30:00	AAPL	Stock	11.5421	11.5443	11.51	11.5236	21414120.0
2011-06-17 12:00:00	AAPL	Stock	11.5236	11.5479	11.4721	11.4982	24989132.0
2011-06-17 12:30:00	AAPL	Stock	11.4986	11.5085	11.4493	11.4575	27654788.0
2011-06-17 13:00:00	AAPL	Stock	11.4579	11.4768	11.4286	11.4721	32764900.0
2011-06-17 13:30:00	AAPL	Stock	11.4736	11.4975	11.4525	11.4679	21242200.0
2011-06-17 14:00:00	AAPL	Stock	11.4682	11.4907	11.4529	11.4821	19271392.0
2011-06-17 14:30:00	AAPL	Stock	11.4821	11.485	11.4464	11.4686	21632688.0
2011-06-17 15:00:00	AAPL	Stock	11.4707	11.4771	11.4057	11.4521	46233460.0
2011-06-17 15:30:00	AAPL	Stock	11.4518	11.4568	11.4214	11.4396	61609352.0
2011-06-17 16:00:00	AAPL	Stock	11.4368	11.4946	11.4264	11.4321	40508776.0
2011-06-17 16:30:00	AAPL	Stock	11.4304	11.4552	11.4254	11.4286	6199872.0
2011-06-17 17:00:00	AAPL	Stock	11.4289	11.4314	11.4243	11.4286	166208.0
2011-06-17 17:30:00	AAPL	Stock	11.4275	11.4321	11.4232	11.4321	132580.0
2011-06-17 18:00:00	AAPL	Stock	11.4336	11.4429	11.4296	11.4429	239708.0
2011-06-17 18:30:00	AAPL	Stock	11.4393	11.4429	11.4296	11.4393	57316.0
2011-06-17 19:00:00	AAPL	Stock	11.4325	11.4332	11.4218	11.4221	93240.0
2011-06-17 19:30:00	AAPL	Stock	11.4221	11.4321	11.4221	11.4321	107520.0
2011-06-17 04:00:00	MSFT	Stock	23.96	23.96	23.96	23.96	500.0
2011-06-17 06:00:00	MSFT	Stock	24.05	24.05	24.05	24.05	100.0
2011-06-17 06:30:00	MSFT	Stock	24.05	24.1	24.05	24.1	900.0
2011-06-17 07:00:00	MSFT	Stock	24.14	24.15	24.06	24.09	4600.0
2011-06-17 07:30:00	MSFT	Stock	24.13	24.15	24.13	24.15	550.0
2011-06-17 08:00:00	MSFT	Stock	24.14	24.14	24.08	24.11	17221.0
2011-06-17 08:30:00	MSFT	Stock	24.11	24.15	24.11	24.13	17600.0
2011-06-17 09:00:00	MSFT	Stock	24.12	24.26	24.1	24.25	248053.0
2011-06-17 09:30:00	MSFT	Stock	24.25	24.3	24.16	24.25	5437075.0
2011-06-17 10:00:00	MSFT	Stock	24.25	24.28	24.16	24.26	3794242.0
2011-06-17 10:30:00	MSFT	Stock	24.26	24.28	24.07	24.07	4205213.0
2011-06-17 11:00:00	MSFT	Stock	24.07	24.11	23.98	24.09	2580055.0
2011-06-17 11:30:00	MSFT	Stock	24.1	24.11	24.04	24.04	2236797.0
2011-06-17 12:00:00	MSFT	Stock	24.04	24.1	24.04	24.09	2687544.0
2011-06-17 12:30:00	MSFT	Stock	24.08	24.18	24.08	24.11	3073810.0
2011-06-17 13:00:00	MSFT	Stock	24.115	24.17	24.08	24.17	2511377.0
2011-06-17 13:30:00	MSFT	Stock	24.17	24.2	24.122	24.135	3570682.0
2011-06-17 14:00:00	MSFT	Stock	24.135	24.27	24.13	24.26	3611481.0
2011-06-17 14:30:00	MSFT	Stock	24.265	24.27	24.19	24.21	3118175.0
2011-06-17 15:00:00	MSFT	Stock	24.21	24.25	24.07	24.17	5537127.0
2011-06-17 15:30:00	MSFT	Stock	24.17	24.29	24.145	24.26	13927547.0
2011-06-17 16:00:00	MSFT	Stock	24.26	24.28	24.177	24.25	9744706.0

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

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