PREVIEW / stock_30min / 2013-05-29

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-29.parquet
  size:    1.5 MB
  rows:    79,847
  symbols: 3,510

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-29 05:00:00	AAPL	Stock	15.7239	15.7239	15.7239	15.7239	2800.0
2013-05-29 06:00:00	AAPL	Stock	15.7239	15.7239	15.7229	15.7229	16800.0
2013-05-29 06:30:00	AAPL	Stock	15.7118	15.7118	15.7118	15.7118	2800.0
2013-05-29 07:00:00	AAPL	Stock	15.6793	15.6896	15.6504	15.6668	315476.0
2013-05-29 07:30:00	AAPL	Stock	15.6625	15.6786	15.6243	15.6261	337736.0
2013-05-29 08:00:00	AAPL	Stock	15.6379	15.7321	15.5964	15.6889	1503404.0
2013-05-29 08:30:00	AAPL	Stock	15.6889	15.7018	15.6679	15.6889	764400.0
2013-05-29 09:00:00	AAPL	Stock	15.6957	15.7321	15.6939	15.7146	919968.0
2013-05-29 09:30:00	AAPL	Stock	15.7143	15.915	15.6929	15.8943	59854536.0
2013-05-29 10:00:00	AAPL	Stock	15.8943	15.9404	15.8664	15.8886	41683320.0
2013-05-29 10:30:00	AAPL	Stock	15.8886	15.8982	15.7914	15.8451	24569132.0
2013-05-29 11:00:00	AAPL	Stock	15.8411	15.8668	15.8044	15.8221	23769872.0
2013-05-29 11:30:00	AAPL	Stock	15.8225	15.8518	15.8071	15.8379	15053080.0
2013-05-29 12:00:00	AAPL	Stock	15.8446	15.8571	15.7964	15.8311	13073060.0
2013-05-29 12:30:00	AAPL	Stock	15.8311	15.8536	15.8164	15.8511	8242416.0
2013-05-29 13:00:00	AAPL	Stock	15.8511	15.9004	15.8293	15.8993	15762264.0
2013-05-29 13:30:00	AAPL	Stock	15.8996	15.9286	15.8821	15.9089	16960468.0
2013-05-29 14:00:00	AAPL	Stock	15.9132	15.9754	15.9004	15.9561	22141672.0
2013-05-29 14:30:00	AAPL	Stock	15.9557	15.9821	15.9286	15.9286	17042452.0
2013-05-29 15:00:00	AAPL	Stock	15.9286	15.9774	15.9057	15.9732	16413712.0
2013-05-29 15:30:00	AAPL	Stock	15.9732	15.9786	15.8896	15.8921	31416728.0
2013-05-29 16:00:00	AAPL	Stock	15.8925	15.9179	15.8822	15.893	16598960.0
2013-05-29 16:30:00	AAPL	Stock	15.9104	15.9701	15.8874	15.9107	620452.0
2013-05-29 17:00:00	AAPL	Stock	15.9107	15.9107	15.8911	15.9018	96516.0
2013-05-29 17:30:00	AAPL	Stock	15.8911	15.9068	15.8839	15.8918	354956.0
2013-05-29 18:00:00	AAPL	Stock	15.8929	15.8982	15.8929	15.8982	8400.0
2013-05-29 18:30:00	AAPL	Stock	15.8893	15.8893	15.8818	15.8857	66696.0
2013-05-29 19:00:00	AAPL	Stock	15.8893	15.8929	15.8821	15.8929	67592.0
2013-05-29 19:30:00	AAPL	Stock	15.8921	15.8929	15.88	15.88	72212.0
2013-05-29 06:00:00	MSFT	Stock	34.9	34.9	34.9	34.9	100.0
2013-05-29 07:00:00	MSFT	Stock	34.75	34.75	34.75	34.75	400.0
2013-05-29 07:30:00	MSFT	Stock	34.8	34.85	34.78	34.78	1500.0
2013-05-29 08:00:00	MSFT	Stock	34.83	34.9	34.76	34.78	22982.0
2013-05-29 08:30:00	MSFT	Stock	34.78	34.8	34.77	34.8	18014.0
2013-05-29 09:00:00	MSFT	Stock	35.01	35.01	34.72	34.73	142131.0
2013-05-29 09:30:00	MSFT	Stock	34.74	35.02	34.62	34.95	6266640.0
2013-05-29 10:00:00	MSFT	Stock	34.95	35.01	34.865	34.87	3986817.0
2013-05-29 10:30:00	MSFT	Stock	34.879	34.88	34.63	34.645	2581961.0
2013-05-29 11:00:00	MSFT	Stock	34.64	34.665	34.57	34.635	2183347.0
2013-05-29 11:30:00	MSFT	Stock	34.63	34.72	34.6	34.71	1426337.0
2013-05-29 12:00:00	MSFT	Stock	34.709	34.76	34.66	34.685	1106226.0
2013-05-29 12:30:00	MSFT	Stock	34.685	34.695	34.59	34.59	1244759.0
2013-05-29 13:00:00	MSFT	Stock	34.596	34.75	34.585	34.75	1442277.0
2013-05-29 13:30:00	MSFT	Stock	34.75	34.89	34.71	34.85	1631437.0
2013-05-29 14:00:00	MSFT	Stock	34.85	34.97	34.82	34.925	1936979.0
2013-05-29 14:30:00	MSFT	Stock	34.925	34.93	34.85	34.86	1882663.0
2013-05-29 15:00:00	MSFT	Stock	34.85	34.95	34.84	34.94	1555209.0
2013-05-29 15:30:00	MSFT	Stock	34.94	34.98	34.86	34.89	4881967.0
2013-05-29 16:00:00	MSFT	Stock	34.88	34.961	34.64	34.884	2164456.0
2013-05-29 16:30:00	MSFT	Stock	34.88	34.929	34.88	34.88	12152.0

> showing 50 of 79,847 rows — these rows as CSV

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