PREVIEW / stock_1hour / 2013-07-09

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-09.parquet
  size:    1002 KB
  rows:    46,581
  symbols: 3,519

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-09 04:00:00	AAPL	Stock	14.8564	14.8564	14.8432	14.85	20356.0
2013-07-09 05:00:00	AAPL	Stock	14.8482	14.8482	14.8482	14.8482	2800.0
2013-07-09 06:00:00	AAPL	Stock	14.8257	14.8286	14.8146	14.8146	45276.0
2013-07-09 07:00:00	AAPL	Stock	14.8164	14.8282	14.7793	14.7964	172872.0
2013-07-09 08:00:00	AAPL	Stock	14.7975	14.8571	14.7818	14.8389	780220.0
2013-07-09 09:00:00	AAPL	Stock	14.8414	14.8679	14.6564	14.8089	66513552.0
2013-07-09 10:00:00	AAPL	Stock	14.8096	14.8893	14.79	14.8654	59610376.0
2013-07-09 11:00:00	AAPL	Stock	14.8675	15.0125	14.8457	14.9682	53400340.0
2013-07-09 12:00:00	AAPL	Stock	14.9668	15.0112	14.9515	14.9643	20886628.0
2013-07-09 13:00:00	AAPL	Stock	14.9711	14.995	14.9311	14.9761	19395096.0
2013-07-09 14:00:00	AAPL	Stock	14.9768	15.1143	14.9715	15.0796	51237424.0
2013-07-09 15:00:00	AAPL	Stock	15.0796	15.125	15.0464	15.0757	48650364.0
2013-07-09 16:00:00	AAPL	Stock	15.0757	15.0841	14.8359	15.0793	25686584.0
2013-07-09 17:00:00	AAPL	Stock	15.0793	15.085	15.0757	15.0804	81536.0
2013-07-09 18:00:00	AAPL	Stock	15.08	15.0814	15.075	15.075	30324.0
2013-07-09 19:00:00	AAPL	Stock	15.0786	15.0893	15.0786	15.0807	90524.0
2013-07-09 07:00:00	MSFT	Stock	34.45	34.45	34.45	34.45	640.0
2013-07-09 08:00:00	MSFT	Stock	34.21	34.47	34.21	34.47	8615.0
2013-07-09 09:00:00	MSFT	Stock	34.47	34.6	34.21	34.25	3344162.0
2013-07-09 10:00:00	MSFT	Stock	34.24	34.41	34.14	34.365	4614904.0
2013-07-09 11:00:00	MSFT	Stock	34.365	34.46	34.285	34.39	3363565.0
2013-07-09 12:00:00	MSFT	Stock	34.385	34.46	34.37	34.45	1475047.0
2013-07-09 13:00:00	MSFT	Stock	34.455	34.46	34.31	34.349	1458805.0
2013-07-09 14:00:00	MSFT	Stock	34.345	34.41	34.32	34.395	2095946.0
2013-07-09 15:00:00	MSFT	Stock	34.395	34.54	34.3	34.37	5699411.0
2013-07-09 16:00:00	MSFT	Stock	34.35	34.447	34.248	34.35	2168926.0
2013-07-09 17:00:00	MSFT	Stock	34.439	34.439	34.248	34.35	310397.0
2013-07-09 18:00:00	MSFT	Stock	34.35	34.35	34.35	34.35	490.0
2013-07-09 19:00:00	MSFT	Stock	34.3	34.36	34.29	34.36	1917.0
2013-07-09 08:00:00	NVDA	Stock	0.354	0.3545	0.354	0.3545	9520.0
2013-07-09 09:00:00	NVDA	Stock	0.3553	0.3568	0.354	0.3565	15517440.0
2013-07-09 10:00:00	NVDA	Stock	0.3562	0.3574	0.3553	0.3565	28395320.0
2013-07-09 11:00:00	NVDA	Stock	0.3568	0.3575	0.356	0.3562	15890680.0
2013-07-09 12:00:00	NVDA	Stock	0.3562	0.357	0.3555	0.3568	11200040.0
2013-07-09 13:00:00	NVDA	Stock	0.3569	0.358	0.3565	0.3572	25018520.0
2013-07-09 14:00:00	NVDA	Stock	0.3572	0.3582	0.3562	0.3564	14910360.0
2013-07-09 15:00:00	NVDA	Stock	0.3562	0.357	0.3555	0.356	38404200.0
2013-07-09 16:00:00	NVDA	Stock	0.356	0.356	0.356	0.356	458600.0
2013-07-09 04:00:00	AMZN	Stock	14.6	14.6	14.6	14.6	2000.0
2013-07-09 05:00:00	AMZN	Stock	14.6	14.6	14.6	14.6	2000.0
2013-07-09 06:00:00	AMZN	Stock	14.5685	14.5685	14.5685	14.5685	2000.0
2013-07-09 07:00:00	AMZN	Stock	14.57	14.57	14.549	14.549	26500.0
2013-07-09 08:00:00	AMZN	Stock	14.576	14.594	14.51	14.59	416840.0
2013-07-09 09:00:00	AMZN	Stock	14.585	14.598	14.43	14.444	11940700.0
2013-07-09 10:00:00	AMZN	Stock	14.43	14.498	14.4005	14.4885	10389060.0
2013-07-09 11:00:00	AMZN	Stock	14.491	14.54	14.481	14.5075	5103060.0
2013-07-09 12:00:00	AMZN	Stock	14.508	14.57	14.501	14.5675	4577940.0
2013-07-09 13:00:00	AMZN	Stock	14.5685	14.595	14.5255	14.5856	5393020.0
2013-07-09 14:00:00	AMZN	Stock	14.5865	14.5935	14.5565	14.5855	5108880.0
2013-07-09 15:00:00	AMZN	Stock	14.5835	14.6285	14.5735	14.5755	8344140.0

> showing 50 of 46,581 rows — these rows as CSV

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