PREVIEW / stock_1hour / 2012-01-03

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-03.parquet
  size:    961 KB
  rows:    45,759
  symbols: 3,574

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-01-03 04:00:00	AAPL	Stock	14.4571	14.7429	14.4571	14.7429	117012.0
2012-01-03 05:00:00	AAPL	Stock	14.7375	14.7375	14.6786	14.6904	55020.0
2012-01-03 06:00:00	AAPL	Stock	14.6904	14.7143	14.6596	14.6607	143864.0
2012-01-03 07:00:00	AAPL	Stock	14.6782	14.6782	14.6268	14.6293	698852.0
2012-01-03 08:00:00	AAPL	Stock	14.6607	14.6607	14.4643	14.5893	3270512.0
2012-01-03 09:00:00	AAPL	Stock	14.5918	14.7029	14.4643	14.6893	60521916.0
2012-01-03 10:00:00	AAPL	Stock	14.6893	14.7321	14.6507	14.6746	53882248.0
2012-01-03 11:00:00	AAPL	Stock	14.6761	14.6948	14.6693	14.6718	24382008.0
2012-01-03 12:00:00	AAPL	Stock	14.6696	14.6814	14.6271	14.6355	25943064.0
2012-01-03 13:00:00	AAPL	Stock	14.6354	14.675	14.615	14.6718	25497192.0
2012-01-03 14:00:00	AAPL	Stock	14.6732	14.7061	14.6607	14.7047	27054104.0
2012-01-03 15:00:00	AAPL	Stock	14.705	14.7157	14.6657	14.6821	51153984.0
2012-01-03 16:00:00	AAPL	Stock	14.6793	14.73	14.6635	14.6918	20015660.0
2012-01-03 17:00:00	AAPL	Stock	14.6979	14.6982	14.6846	14.6911	191940.0
2012-01-03 18:00:00	AAPL	Stock	14.6886	14.6918	14.6868	14.6907	145292.0
2012-01-03 19:00:00	AAPL	Stock	14.6911	14.6957	14.6911	14.6911	84504.0
2012-01-03 04:00:00	MSFT	Stock	26.06	26.32	26.06	26.32	2277.0
2012-01-03 05:00:00	MSFT	Stock	26.49	26.74	26.48	26.5	1200.0
2012-01-03 06:00:00	MSFT	Stock	26.44	26.44	26.44	26.44	300.0
2012-01-03 07:00:00	MSFT	Stock	26.39	26.41	26.32	26.32	40450.0
2012-01-03 08:00:00	MSFT	Stock	26.32	26.36	25.96	26.35	89271.0
2012-01-03 09:00:00	MSFT	Stock	26.35	26.57	25.96	26.51	6183339.0
2012-01-03 10:00:00	MSFT	Stock	26.51	26.75	26.51	26.732	7815994.0
2012-01-03 11:00:00	MSFT	Stock	26.74	26.91	26.72	26.86	11026839.0
2012-01-03 12:00:00	MSFT	Stock	26.85	26.91	26.8	26.85	6485195.0
2012-01-03 13:00:00	MSFT	Stock	26.85	26.905	26.81	26.895	5822988.0
2012-01-03 14:00:00	MSFT	Stock	26.9	26.95	26.88	26.95	6844019.0
2012-01-03 15:00:00	MSFT	Stock	26.95	26.96	26.75	26.83	16768761.0
2012-01-03 16:00:00	MSFT	Stock	26.82	26.915	26.645	26.85	3142731.0
2012-01-03 17:00:00	MSFT	Stock	26.83	26.85	26.83	26.84	8080.0
2012-01-03 18:00:00	MSFT	Stock	26.77	26.84	26.77	26.78	34604.0
2012-01-03 19:00:00	MSFT	Stock	26.78	26.78	26.78	26.78	2725.0
2012-01-03 04:00:00	NVDA	Stock	0.3525	0.3525	0.3525	0.3525	8000.0
2012-01-03 06:00:00	NVDA	Stock	0.3525	0.3525	0.3525	0.3525	38000.0
2012-01-03 07:00:00	NVDA	Stock	0.353	0.353	0.3525	0.3525	84000.0
2012-01-03 08:00:00	NVDA	Stock	0.35	0.3562	0.35	0.3562	411400.0
2012-01-03 09:00:00	NVDA	Stock	0.356	0.3588	0.355	0.3568	72744760.0
2012-01-03 10:00:00	NVDA	Stock	0.357	0.36	0.3568	0.3585	77246880.0
2012-01-03 11:00:00	NVDA	Stock	0.3585	0.3585	0.3538	0.3545	55216720.0
2012-01-03 12:00:00	NVDA	Stock	0.3545	0.3548	0.3502	0.3513	40128000.0
2012-01-03 13:00:00	NVDA	Stock	0.3513	0.353	0.3508	0.3521	58158120.0
2012-01-03 14:00:00	NVDA	Stock	0.3522	0.3532	0.3513	0.3514	49613880.0
2012-01-03 15:00:00	NVDA	Stock	0.3513	0.3522	0.3505	0.3513	97906880.0
2012-01-03 16:00:00	NVDA	Stock	0.351	0.3596	0.3502	0.351	10537840.0
2012-01-03 17:00:00	NVDA	Stock	0.351	0.3535	0.351	0.3511	256640.0
2012-01-03 18:00:00	NVDA	Stock	0.3535	0.3535	0.3535	0.3535	8000.0
2012-01-03 19:00:00	NVDA	Stock	0.3525	0.3525	0.3525	0.3525	81640.0
2012-01-03 04:00:00	AMZN	Stock	8.694	8.85	8.694	8.85	37000.0
2012-01-03 05:00:00	AMZN	Stock	8.8205	8.85	8.8205	8.85	22000.0
2012-01-03 06:00:00	AMZN	Stock	8.85	8.85	8.85	8.85	19400.0

> showing 50 of 45,759 rows — these rows as CSV

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