PREVIEW / stock_1hour / 2013-06-27

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-27.parquet
  size:    1015 KB
  rows:    47,841
  symbols: 3,527

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-06-27 05:00:00	AAPL	Stock	14.2054	14.2054	14.2	14.2	16800.0
2013-06-27 06:00:00	AAPL	Stock	14.2143	14.2143	14.2143	14.2143	2800.0
2013-06-27 07:00:00	AAPL	Stock	14.2232	14.2429	14.1732	14.2429	292516.0
2013-06-27 08:00:00	AAPL	Stock	14.2321	14.2714	14.1929	14.2493	1261372.0
2013-06-27 09:00:00	AAPL	Stock	14.2493	14.2682	14.1272	14.2514	53670204.0
2013-06-27 10:00:00	AAPL	Stock	14.2514	14.3354	14.2036	14.2425	70773584.0
2013-06-27 11:00:00	AAPL	Stock	14.2464	14.2621	14.1432	14.1779	35817264.0
2013-06-27 12:00:00	AAPL	Stock	14.1781	14.1925	14.1468	14.1679	19609576.0
2013-06-27 13:00:00	AAPL	Stock	14.1688	14.1821	14.0893	14.0993	35758884.0
2013-06-27 14:00:00	AAPL	Stock	14.1004	14.1429	14.0714	14.1062	34475532.0
2013-06-27 15:00:00	AAPL	Stock	14.1071	14.1125	14.055	14.0641	51013872.0
2013-06-27 16:00:00	AAPL	Stock	14.0636	14.2281	14.0414	14.0464	27619928.0
2013-06-27 17:00:00	AAPL	Stock	14.0496	14.0539	14.0286	14.0357	584276.0
2013-06-27 18:00:00	AAPL	Stock	14.055	14.06	14.0536	14.06	87276.0
2013-06-27 19:00:00	AAPL	Stock	14.05	14.0536	14.0482	14.0536	121100.0
2013-06-27 04:00:00	MSFT	Stock	34.39	34.39	34.36	34.36	500.0
2013-06-27 07:00:00	MSFT	Stock	34.39	34.39	34.39	34.39	200.0
2013-06-27 08:00:00	MSFT	Stock	34.35	34.55	34.35	34.46	9078.0
2013-06-27 09:00:00	MSFT	Stock	34.49	34.78	34.48	34.72	3187134.0
2013-06-27 10:00:00	MSFT	Stock	34.72	34.75	34.6	34.63	4927577.0
2013-06-27 11:00:00	MSFT	Stock	34.63	34.7	34.52	34.69	4298943.0
2013-06-27 12:00:00	MSFT	Stock	34.691	34.7	34.56	34.609	2596795.0
2013-06-27 13:00:00	MSFT	Stock	34.6	34.71	34.57	34.63	2588177.0
2013-06-27 14:00:00	MSFT	Stock	34.62	34.65	34.51	34.59	2043660.0
2013-06-27 15:00:00	MSFT	Stock	34.59	34.63	34.53	34.61	5605513.0
2013-06-27 16:00:00	MSFT	Stock	34.62	34.653	34.3	34.61	3083822.0
2013-06-27 17:00:00	MSFT	Stock	34.61	34.62	34.35	34.51	5150.0
2013-06-27 19:00:00	MSFT	Stock	34.58	34.58	34.51	34.58	500.0
2013-06-27 09:00:00	NVDA	Stock	0.3545	0.355	0.3505	0.3513	62659600.0
2013-06-27 10:00:00	NVDA	Stock	0.3513	0.3528	0.349	0.3499	222597120.0
2013-06-27 11:00:00	NVDA	Stock	0.35	0.3513	0.347	0.3485	150051840.0
2013-06-27 12:00:00	NVDA	Stock	0.3485	0.3502	0.3465	0.3498	107402280.0
2013-06-27 13:00:00	NVDA	Stock	0.3499	0.3542	0.3498	0.3522	57798600.0
2013-06-27 14:00:00	NVDA	Stock	0.3522	0.353	0.3508	0.351	45031520.0
2013-06-27 15:00:00	NVDA	Stock	0.351	0.3518	0.35	0.3505	93269000.0
2013-06-27 16:00:00	NVDA	Stock	0.3502	0.354	0.3495	0.3505	12210560.0
2013-06-27 08:00:00	AMZN	Stock	13.9	13.9525	13.9	13.95	85180.0
2013-06-27 09:00:00	AMZN	Stock	13.956	14.01	13.921	13.968	9348260.0
2013-06-27 10:00:00	AMZN	Stock	13.968	13.979	13.8455	13.909	10038400.0
2013-06-27 11:00:00	AMZN	Stock	13.9055	13.925	13.828	13.8675	3625300.0
2013-06-27 12:00:00	AMZN	Stock	13.867	13.867	13.804	13.812	3596960.0
2013-06-27 13:00:00	AMZN	Stock	13.8105	13.8525	13.7958	13.7958	4588480.0
2013-06-27 14:00:00	AMZN	Stock	13.7985	13.832	13.727	13.7895	7641100.0
2013-06-27 15:00:00	AMZN	Stock	13.7925	13.8843	13.784	13.8795	9264040.0
2013-06-27 16:00:00	AMZN	Stock	13.8775	13.887	13.8625	13.887	1988960.0
2013-06-27 17:00:00	AMZN	Stock	13.885	13.887	13.885	13.887	16680.0
2013-06-27 18:00:00	AMZN	Stock	13.8775	13.8775	13.8725	13.8725	20000.0
2013-06-27 04:00:00	META	Stock	24.09	24.25	24.09	24.25	200.0
2013-06-27 05:00:00	META	Stock	24.22	24.22	24.2	24.2	200.0
2013-06-27 06:00:00	META	Stock	24.22	24.22	24.22	24.22	120.0

> showing 50 of 47,841 rows — these rows as CSV

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