PREVIEW / stock_30min / 2012-11-07

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-07.parquet
  size:    1.4 MB
  rows:    76,690
  symbols: 3,471

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-11-07 04:00:00	AAPL	Stock	20.8214	20.8214	20.7857	20.7857	11200.0
2012-11-07 06:00:00	AAPL	Stock	20.8036	20.8036	20.7179	20.7214	107380.0
2012-11-07 06:30:00	AAPL	Stock	20.7214	20.75	20.7214	20.75	29680.0
2012-11-07 07:00:00	AAPL	Stock	20.7479	20.7479	20.5821	20.6179	471772.0
2012-11-07 07:30:00	AAPL	Stock	20.6143	20.6179	20.5836	20.6071	520856.0
2012-11-07 08:00:00	AAPL	Stock	20.6071	20.6854	20.4411	20.4839	3548104.0
2012-11-07 08:30:00	AAPL	Stock	20.4836	20.5296	20.4643	20.4818	1370824.0
2012-11-07 09:00:00	AAPL	Stock	20.4814	20.5336	20.4557	20.49	1884204.0
2012-11-07 09:30:00	AAPL	Stock	20.4979	20.5193	20.2625	20.3289	113331708.0
2012-11-07 10:00:00	AAPL	Stock	20.3314	20.3714	20.1714	20.265	70645008.0
2012-11-07 10:30:00	AAPL	Stock	20.2629	20.2786	20.0361	20.0393	68467868.0
2012-11-07 11:00:00	AAPL	Stock	20.038	20.1246	19.9421	19.9536	73396932.0
2012-11-07 11:30:00	AAPL	Stock	19.9536	20.1536	19.8586	20.1108	75533080.0
2012-11-07 12:00:00	AAPL	Stock	20.11	20.205	20.0536	20.1439	47975200.0
2012-11-07 12:30:00	AAPL	Stock	20.1357	20.1529	19.9511	19.9621	40442024.0
2012-11-07 13:00:00	AAPL	Stock	19.9684	20.1032	19.9311	20.0647	36687252.0
2012-11-07 13:30:00	AAPL	Stock	20.0568	20.1414	19.9686	19.9729	32031608.0
2012-11-07 14:00:00	AAPL	Stock	19.9758	20.0514	19.9068	19.9493	32187512.0
2012-11-07 14:30:00	AAPL	Stock	19.9479	20.0529	19.8482	20.0361	50938300.0
2012-11-07 15:00:00	AAPL	Stock	20.0436	20.1036	19.9214	20.0518	42486360.0
2012-11-07 15:30:00	AAPL	Stock	20.0468	20.0882	19.9271	19.9311	65283120.0
2012-11-07 16:00:00	AAPL	Stock	19.9332	20.1186	19.9242	20.0179	12041736.0
2012-11-07 16:30:00	AAPL	Stock	20.0179	20.0482	19.9771	19.9821	416192.0
2012-11-07 17:00:00	AAPL	Stock	19.9925	19.9975	19.9414	19.9821	465724.0
2012-11-07 17:30:00	AAPL	Stock	19.9889	19.9921	19.9546	19.9546	254044.0
2012-11-07 18:00:00	AAPL	Stock	19.9536	19.9929	19.9536	19.9929	207172.0
2012-11-07 18:30:00	AAPL	Stock	19.9946	20.0	19.9821	19.9821	214844.0
2012-11-07 19:00:00	AAPL	Stock	19.9761	19.9864	19.9607	19.9607	145964.0
2012-11-07 19:30:00	AAPL	Stock	19.9575	20.0	19.9554	20.0	161532.0
2012-11-07 07:00:00	MSFT	Stock	29.71	29.71	29.64	29.64	1100.0
2012-11-07 07:30:00	MSFT	Stock	29.7	29.7	29.5	29.55	1440.0
2012-11-07 08:00:00	MSFT	Stock	29.58	29.69	29.5	29.5	24830.0
2012-11-07 08:30:00	MSFT	Stock	29.49	29.52	29.4	29.5	41346.0
2012-11-07 09:00:00	MSFT	Stock	29.47	29.54	29.47	29.54	9786.0
2012-11-07 09:30:00	MSFT	Stock	29.56	29.825	29.34	29.68	6236775.0
2012-11-07 10:00:00	MSFT	Stock	29.685	29.7	29.39	29.46	3887844.0
2012-11-07 10:30:00	MSFT	Stock	29.45	29.46	29.21	29.21	3734461.0
2012-11-07 11:00:00	MSFT	Stock	29.21	29.38	29.21	29.262	4364306.0
2012-11-07 11:30:00	MSFT	Stock	29.263	29.27	29.12	29.165	4127929.0
2012-11-07 12:00:00	MSFT	Stock	29.152	29.2	29.05	29.105	3094405.0
2012-11-07 12:30:00	MSFT	Stock	29.1	29.17	29.07	29.095	2720108.0
2012-11-07 13:00:00	MSFT	Stock	29.095	29.21	29.06	29.185	3694392.0
2012-11-07 13:30:00	MSFT	Stock	29.185	29.24	29.15	29.165	2223191.0
2012-11-07 14:00:00	MSFT	Stock	29.17	29.23	29.16	29.19	2157148.0
2012-11-07 14:30:00	MSFT	Stock	29.19	29.265	29.12	29.252	2235294.0
2012-11-07 15:00:00	MSFT	Stock	29.255	29.29	29.15	29.265	3219924.0
2012-11-07 15:30:00	MSFT	Stock	29.262	29.27	29.06	29.073	8809614.0
2012-11-07 16:00:00	MSFT	Stock	29.08	29.276	29.0	29.064	5995361.0
2012-11-07 16:30:00	MSFT	Stock	29.12	29.13	29.1	29.13	1500.0
2012-11-07 17:00:00	MSFT	Stock	29.13	29.17	29.08	29.1	6570.0

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

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