PREVIEW / stock_1hour / 2016-12-22

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-22.parquet
  size:    1.0 MB
  rows:    47,883
  symbols: 3,164

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
2016-12-22 04:00:00	AAPL	Stock	29.0	29.0875	29.0	29.01	8304.0
2016-12-22 05:00:00	AAPL	Stock	29.025	29.09	29.01	29.0875	18920.0
2016-12-22 06:00:00	AAPL	Stock	29.1	29.1225	29.08	29.105	16184.0
2016-12-22 07:00:00	AAPL	Stock	29.1225	29.17	29.115	29.1625	21272.0
2016-12-22 08:00:00	AAPL	Stock	29.1225	29.265	29.115	29.2125	153028.0
2016-12-22 09:00:00	AAPL	Stock	29.215	29.235	28.965	29.065	17092048.0
2016-12-22 10:00:00	AAPL	Stock	29.0575	29.125	29.0525	29.0595	12201064.0
2016-12-22 11:00:00	AAPL	Stock	29.055	29.0875	28.91	28.935	12560484.0
2016-12-22 12:00:00	AAPL	Stock	28.935	28.9975	28.93	28.95	7331564.0
2016-12-22 13:00:00	AAPL	Stock	28.95	29.0575	28.9475	29.0325	6441240.0
2016-12-22 14:00:00	AAPL	Stock	29.0325	29.0575	28.98	29.0028	6567856.0
2016-12-22 15:00:00	AAPL	Stock	29.0035	29.0725	28.9175	29.0725	20414488.0
2016-12-22 16:00:00	AAPL	Stock	29.075	29.075	29.0125	29.0725	11897712.0
2016-12-22 17:00:00	AAPL	Stock	29.055	29.0725	29.055	29.055	29140.0
2016-12-22 18:00:00	AAPL	Stock	29.0525	29.06	29.0	29.02	68328.0
2016-12-22 19:00:00	AAPL	Stock	29.0125	29.035	28.9875	29.0	29044.0
2016-12-22 05:00:00	MSFT	Stock	63.72	63.84	63.72	63.84	1193.0
2016-12-22 06:00:00	MSFT	Stock	63.72	63.72	63.6	63.6	828.0
2016-12-22 07:00:00	MSFT	Stock	63.63	63.76	63.63	63.75	4205.0
2016-12-22 08:00:00	MSFT	Stock	63.7	63.95	63.7	63.94	43410.0
2016-12-22 09:00:00	MSFT	Stock	63.95	64.1	63.535	63.688	3831556.0
2016-12-22 10:00:00	MSFT	Stock	63.68	63.94	63.63	63.78	3074557.0
2016-12-22 11:00:00	MSFT	Stock	63.79	63.81	63.41	63.49	2554458.0
2016-12-22 12:00:00	MSFT	Stock	63.48	63.61	63.47	63.52	1581211.0
2016-12-22 13:00:00	MSFT	Stock	63.51	63.72	63.49	63.67	1815698.0
2016-12-22 14:00:00	MSFT	Stock	63.66	63.76	63.56	63.585	1534190.0
2016-12-22 15:00:00	MSFT	Stock	63.585	63.59	63.405	63.55	3250476.0
2016-12-22 16:00:00	MSFT	Stock	63.55	63.57	63.5	63.55	2964748.0
2016-12-22 17:00:00	MSFT	Stock	63.55	63.55	63.52	63.52	1400.0
2016-12-22 18:00:00	MSFT	Stock	63.55	63.55	63.55	63.55	100.0
2016-12-22 19:00:00	MSFT	Stock	63.5	63.6	63.5	63.6	615.0
2016-12-22 04:00:00	NVDA	Stock	2.6623	2.6623	2.6623	2.6623	35800.0
2016-12-22 07:00:00	NVDA	Stock	2.66	2.66	2.6528	2.655	93000.0
2016-12-22 08:00:00	NVDA	Stock	2.6613	2.672	2.6562	2.6698	1444000.0
2016-12-22 09:00:00	NVDA	Stock	2.669	2.7048	2.6675	2.7019	118483920.0
2016-12-22 10:00:00	NVDA	Stock	2.702	2.712	2.6892	2.7075	115316360.0
2016-12-22 11:00:00	NVDA	Stock	2.7072	2.7218	2.69	2.6973	104965960.0
2016-12-22 12:00:00	NVDA	Stock	2.6973	2.705	2.676	2.676	86860360.0
2016-12-22 13:00:00	NVDA	Stock	2.6762	2.6895	2.6705	2.6725	88912360.0
2016-12-22 14:00:00	NVDA	Stock	2.6728	2.6798	2.6632	2.6773	76025400.0
2016-12-22 15:00:00	NVDA	Stock	2.6775	2.6809	2.6653	2.6778	81730280.0
2016-12-22 16:00:00	NVDA	Stock	2.6778	2.682	2.6725	2.6725	10395160.0
2016-12-22 17:00:00	NVDA	Stock	2.6775	2.6795	2.6755	2.6775	139480.0
2016-12-22 18:00:00	NVDA	Stock	2.6775	2.6775	2.675	2.675	149920.0
2016-12-22 19:00:00	NVDA	Stock	2.675	2.6788	2.675	2.675	152040.0
2016-12-22 06:00:00	AMZN	Stock	38.378	38.378	38.378	38.378	4000.0
2016-12-22 08:00:00	AMZN	Stock	38.491	38.55	38.475	38.5	94800.0
2016-12-22 09:00:00	AMZN	Stock	38.45	38.5295	38.3135	38.4548	6231980.0
2016-12-22 10:00:00	AMZN	Stock	38.4545	38.5605	38.28	38.2985	7351000.0
2016-12-22 11:00:00	AMZN	Stock	38.2985	38.337	38.209	38.267	7366920.0

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

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