PREVIEW / stock_30min / 2013-07-29

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-29.parquet
  size:    1.5 MB
  rows:    79,055
  symbols: 3,504

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-07-29 04:00:00	AAPL	Stock	15.7661	15.7661	15.75	15.75	11200.0
2013-07-29 05:30:00	AAPL	Stock	15.7571	15.7571	15.7571	15.7571	2800.0
2013-07-29 06:30:00	AAPL	Stock	15.75	15.75	15.75	15.75	2800.0
2013-07-29 07:00:00	AAPL	Stock	15.7571	15.7679	15.7457	15.7679	52360.0
2013-07-29 07:30:00	AAPL	Stock	15.7321	15.7321	15.7136	15.7289	81284.0
2013-07-29 08:00:00	AAPL	Stock	15.7429	15.7843	15.7143	15.7429	148848.0
2013-07-29 08:30:00	AAPL	Stock	15.7443	15.7443	15.7179	15.7268	188888.0
2013-07-29 09:00:00	AAPL	Stock	15.7221	15.7729	15.7168	15.7257	751128.0
2013-07-29 09:30:00	AAPL	Stock	15.7429	16.0264	15.7214	16.0032	64712368.0
2013-07-29 10:00:00	AAPL	Stock	16.0051	16.0279	15.9575	16.0	24717364.0
2013-07-29 10:30:00	AAPL	Stock	16.0029	16.0032	15.9529	15.9891	13504400.0
2013-07-29 11:00:00	AAPL	Stock	15.9907	16.0054	15.9579	15.9636	12357912.0
2013-07-29 11:30:00	AAPL	Stock	15.9632	15.985	15.9364	15.9661	11569236.0
2013-07-29 12:00:00	AAPL	Stock	15.9679	15.9964	15.9579	15.9746	8804768.0
2013-07-29 12:30:00	AAPL	Stock	15.9761	16.0021	15.9643	16.0011	6774376.0
2013-07-29 13:00:00	AAPL	Stock	16.0007	16.0154	15.9704	15.9707	7889084.0
2013-07-29 13:30:00	AAPL	Stock	15.9718	15.9911	15.95	15.9879	9353764.0
2013-07-29 14:00:00	AAPL	Stock	15.9864	16.0407	15.9864	16.0264	14821044.0
2013-07-29 14:30:00	AAPL	Stock	16.0232	16.0536	16.0211	16.0445	12164880.0
2013-07-29 15:00:00	AAPL	Stock	16.0432	16.0668	16.0154	16.0643	13108340.0
2013-07-29 15:30:00	AAPL	Stock	16.0643	16.0711	15.9839	15.9925	33089084.0
2013-07-29 16:00:00	AAPL	Stock	15.9925	16.0399	15.9693	16.0118	9790116.0
2013-07-29 16:30:00	AAPL	Stock	16.0114	16.0651	15.9925	16.0321	901292.0
2013-07-29 17:00:00	AAPL	Stock	16.0221	16.0221	16.0143	16.0214	43960.0
2013-07-29 17:30:00	AAPL	Stock	16.0214	16.0268	15.7496	16.0107	56560.0
2013-07-29 18:00:00	AAPL	Stock	16.0146	16.0211	16.0107	16.0107	35168.0
2013-07-29 18:30:00	AAPL	Stock	16.0186	16.0211	16.0179	16.0179	51800.0
2013-07-29 19:00:00	AAPL	Stock	16.0282	16.0304	16.0196	16.0296	132552.0
2013-07-29 19:30:00	AAPL	Stock	16.03	16.0329	16.0204	16.0329	136304.0
2013-07-29 04:00:00	MSFT	Stock	31.56	31.56	31.56	31.56	100.0
2013-07-29 04:30:00	MSFT	Stock	31.56	31.56	31.56	31.56	100.0
2013-07-29 05:00:00	MSFT	Stock	31.56	31.56	31.56	31.56	100.0
2013-07-29 06:00:00	MSFT	Stock	31.51	31.51	31.49	31.49	1600.0
2013-07-29 07:00:00	MSFT	Stock	31.44	31.46	31.4	31.46	3937.0
2013-07-29 07:30:00	MSFT	Stock	31.42	31.46	31.41	31.46	800.0
2013-07-29 08:00:00	MSFT	Stock	31.46	31.51	31.41	31.41	3509.0
2013-07-29 08:30:00	MSFT	Stock	31.43	31.5	31.43	31.46	4277.0
2013-07-29 09:00:00	MSFT	Stock	31.44	31.46	31.4	31.4	12160.0
2013-07-29 09:30:00	MSFT	Stock	31.43	31.6	31.43	31.57	3585198.0
2013-07-29 10:00:00	MSFT	Stock	31.56	31.59	31.45	31.495	2675431.0
2013-07-29 10:30:00	MSFT	Stock	31.493	31.59	31.47	31.56	2231737.0
2013-07-29 11:00:00	MSFT	Stock	31.55	31.58	31.43	31.43	2639458.0
2013-07-29 11:30:00	MSFT	Stock	31.435	31.48	31.41	31.44	1513947.0
2013-07-29 12:00:00	MSFT	Stock	31.445	31.5	31.4	31.49	1448972.0
2013-07-29 12:30:00	MSFT	Stock	31.495	31.5	31.46	31.49	1364853.0
2013-07-29 13:00:00	MSFT	Stock	31.495	31.54	31.46	31.52	1791998.0
2013-07-29 13:30:00	MSFT	Stock	31.515	31.55	31.475	31.536	1704185.0
2013-07-29 14:00:00	MSFT	Stock	31.535	31.6	31.53	31.57	921688.0
2013-07-29 14:30:00	MSFT	Stock	31.575	31.59	31.53	31.54	1337511.0
2013-07-29 15:00:00	MSFT	Stock	31.535	31.55	31.49	31.545	1122828.0

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

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