PREVIEW / stock_30min / 2013-05-09

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-09.parquet
  size:    1.5 MB
  rows:    77,429
  symbols: 3,494

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
2013-05-09 04:00:00	AAPL	Stock	16.5275	16.5275	16.475	16.4821	61460.0
2013-05-09 04:30:00	AAPL	Stock	16.5036	16.5036	16.5036	16.5036	2800.0
2013-05-09 05:30:00	AAPL	Stock	16.4821	16.4821	16.475	16.475	11200.0
2013-05-09 06:00:00	AAPL	Stock	16.4671	16.4675	16.4357	16.4357	63224.0
2013-05-09 06:30:00	AAPL	Stock	16.4432	16.4454	16.4107	16.4429	57428.0
2013-05-09 07:00:00	AAPL	Stock	16.4357	16.5071	16.4357	16.4821	314328.0
2013-05-09 07:30:00	AAPL	Stock	16.4857	16.4861	16.4329	16.4446	513520.0
2013-05-09 08:00:00	AAPL	Stock	16.445	16.4925	16.3857	16.4218	1736840.0
2013-05-09 08:30:00	AAPL	Stock	16.4218	16.4714	16.4179	16.4354	1504328.0
2013-05-09 09:00:00	AAPL	Stock	16.4357	16.4543	16.4107	16.4143	1243564.0
2013-05-09 09:30:00	AAPL	Stock	16.4218	16.5357	16.3429	16.4257	76183632.0
2013-05-09 10:00:00	AAPL	Stock	16.4261	16.4389	16.3721	16.4039	35087500.0
2013-05-09 10:30:00	AAPL	Stock	16.4039	16.4243	16.3839	16.39	29489684.0
2013-05-09 11:00:00	AAPL	Stock	16.3861	16.4164	16.3447	16.4132	28909720.0
2013-05-09 11:30:00	AAPL	Stock	16.4122	16.4643	16.3886	16.4521	23184840.0
2013-05-09 12:00:00	AAPL	Stock	16.454	16.4743	16.4179	16.4282	15861328.0
2013-05-09 12:30:00	AAPL	Stock	16.4273	16.4914	16.4268	16.4736	16585968.0
2013-05-09 13:00:00	AAPL	Stock	16.4761	16.4893	16.4268	16.4475	18195744.0
2013-05-09 13:30:00	AAPL	Stock	16.445	16.4811	16.4429	16.4782	15244964.0
2013-05-09 14:00:00	AAPL	Stock	16.4761	16.4825	16.4343	16.4372	15310036.0
2013-05-09 14:30:00	AAPL	Stock	16.4386	16.4471	16.3529	16.3643	26141444.0
2013-05-09 15:00:00	AAPL	Stock	16.3636	16.39	16.3182	16.3618	28492940.0
2013-05-09 15:30:00	AAPL	Stock	16.3586	16.3857	16.2707	16.3125	40823524.0
2013-05-09 16:00:00	AAPL	Stock	16.3132	16.4091	16.3036	16.3132	6258812.0
2013-05-09 16:30:00	AAPL	Stock	16.3143	16.389	16.2986	16.3132	7225288.0
2013-05-09 17:00:00	AAPL	Stock	16.2975	16.3132	16.275	16.2807	315448.0
2013-05-09 17:30:00	AAPL	Stock	16.285	16.3132	16.285	16.3125	237048.0
2013-05-09 18:00:00	AAPL	Stock	16.2946	16.3	16.2821	16.2911	255808.0
2013-05-09 18:30:00	AAPL	Stock	16.2982	16.2982	16.2857	16.2875	58800.0
2013-05-09 19:00:00	AAPL	Stock	16.2886	16.2993	16.2875	16.29	28000.0
2013-05-09 19:30:00	AAPL	Stock	16.2896	16.2982	16.2861	16.2982	185948.0
2013-05-09 07:00:00	MSFT	Stock	32.91	32.91	32.91	32.91	200.0
2013-05-09 07:30:00	MSFT	Stock	32.87	32.87	32.84	32.85	1700.0
2013-05-09 08:00:00	MSFT	Stock	32.85	32.95	32.7	32.7	17537.0
2013-05-09 08:30:00	MSFT	Stock	32.75	32.99	32.7	32.73	145800.0
2013-05-09 09:00:00	MSFT	Stock	32.72	32.98	32.7	32.9	102895.0
2013-05-09 09:30:00	MSFT	Stock	32.85	32.98	32.62	32.875	6916201.0
2013-05-09 10:00:00	MSFT	Stock	32.875	32.89	32.59	32.62	5704240.0
2013-05-09 10:30:00	MSFT	Stock	32.63	32.79	32.59	32.75	3364128.0
2013-05-09 11:00:00	MSFT	Stock	32.745	32.81	32.72	32.8	2306684.0
2013-05-09 11:30:00	MSFT	Stock	32.8	32.86	32.79	32.845	1508809.0
2013-05-09 12:00:00	MSFT	Stock	32.845	32.89	32.79	32.794	1060825.0
2013-05-09 12:30:00	MSFT	Stock	32.795	32.88	32.79	32.88	1116027.0
2013-05-09 13:00:00	MSFT	Stock	32.876	33.0	32.87	32.94	1832934.0
2013-05-09 13:30:00	MSFT	Stock	32.937	32.995	32.88	32.919	2362987.0
2013-05-09 14:00:00	MSFT	Stock	32.92	32.93	32.86	32.87	1637746.0
2013-05-09 14:30:00	MSFT	Stock	32.88	32.89	32.77	32.771	3103694.0
2013-05-09 15:00:00	MSFT	Stock	32.78	32.81	32.695	32.755	3437745.0
2013-05-09 15:30:00	MSFT	Stock	32.75	32.79	32.6	32.66	6818339.0
2013-05-09 16:00:00	MSFT	Stock	32.66	32.772	32.62	32.66	2183919.0

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

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