PREVIEW / stock_1hour / 2016-01-08

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-01-08.parquet
  size:    1.0 MB
  rows:    49,114
  symbols: 3,397

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-01-08 04:00:00	AAPL	Stock	24.165	24.3875	24.165	24.385	68140.0
2016-01-08 05:00:00	AAPL	Stock	24.38	24.3825	24.285	24.2875	73120.0
2016-01-08 06:00:00	AAPL	Stock	24.2675	24.2875	24.1625	24.2875	390732.0
2016-01-08 07:00:00	AAPL	Stock	24.2875	24.4225	24.255	24.35	567328.0
2016-01-08 08:00:00	AAPL	Stock	24.355	24.5525	24.225	24.425	2537336.0
2016-01-08 09:00:00	AAPL	Stock	24.425	24.7775	24.335	24.7712	49775232.0
2016-01-08 10:00:00	AAPL	Stock	24.77	24.775	24.3275	24.4088	39429460.0
2016-01-08 11:00:00	AAPL	Stock	24.41	24.4875	24.19	24.485	35947136.0
2016-01-08 12:00:00	AAPL	Stock	24.4825	24.7275	24.455	24.6212	36109268.0
2016-01-08 13:00:00	AAPL	Stock	24.62	24.7375	24.56	24.6225	21604916.0
2016-01-08 14:00:00	AAPL	Stock	24.623	24.6403	24.355	24.41	24034772.0
2016-01-08 15:00:00	AAPL	Stock	24.4075	24.4975	24.225	24.245	36880956.0
2016-01-08 16:00:00	AAPL	Stock	24.24	24.2625	24.2375	24.24	14579484.0
2016-01-08 17:00:00	AAPL	Stock	24.2475	24.2675	24.235	24.25	175880.0
2016-01-08 18:00:00	AAPL	Stock	24.265	24.295	24.25	24.2575	72500.0
2016-01-08 19:00:00	AAPL	Stock	24.265	24.2675	24.25	24.2525	59256.0
2016-01-08 05:00:00	MSFT	Stock	52.9	52.9	52.77	52.77	1410.0
2016-01-08 06:00:00	MSFT	Stock	52.56	52.56	52.51	52.51	1475.0
2016-01-08 07:00:00	MSFT	Stock	52.52	52.65	52.52	52.62	29559.0
2016-01-08 08:00:00	MSFT	Stock	52.65	53.1	52.55	52.72	157062.0
2016-01-08 09:00:00	MSFT	Stock	52.78	52.97	52.17	52.96	7919343.0
2016-01-08 10:00:00	MSFT	Stock	52.96	53.105	52.42	52.5	6702789.0
2016-01-08 11:00:00	MSFT	Stock	52.5	52.95	52.15	52.92	5165199.0
2016-01-08 12:00:00	MSFT	Stock	52.92	53.22	52.81	53.079	4370439.0
2016-01-08 13:00:00	MSFT	Stock	53.07	53.28	52.875	52.97	5686148.0
2016-01-08 14:00:00	MSFT	Stock	52.98	53.05	52.73	52.83	5203903.0
2016-01-08 15:00:00	MSFT	Stock	52.82	52.91	52.25	52.33	7902704.0
2016-01-08 16:00:00	MSFT	Stock	52.33	52.722	52.23	52.39	3216237.0
2016-01-08 17:00:00	MSFT	Stock	52.37	52.39	52.23	52.33	12855.0
2016-01-08 18:00:00	MSFT	Stock	52.23	52.38	52.23	52.38	559.0
2016-01-08 19:00:00	MSFT	Stock	52.33	52.38	52.23	52.26	5344.0
2016-01-08 04:00:00	NVDA	Stock	0.7818	0.7818	0.7818	0.7818	38160.0
2016-01-08 07:00:00	NVDA	Stock	0.7708	0.771	0.7618	0.7618	30800.0
2016-01-08 08:00:00	NVDA	Stock	0.7708	0.7748	0.7675	0.77	292280.0
2016-01-08 09:00:00	NVDA	Stock	0.7702	0.7702	0.757	0.76	41482520.0
2016-01-08 10:00:00	NVDA	Stock	0.76	0.764	0.7572	0.7596	32612960.0
2016-01-08 11:00:00	NVDA	Stock	0.7598	0.7614	0.7495	0.757	38896880.0
2016-01-08 12:00:00	NVDA	Stock	0.7572	0.7618	0.7525	0.7545	35000520.0
2016-01-08 13:00:00	NVDA	Stock	0.7544	0.7575	0.7528	0.7558	35825960.0
2016-01-08 14:00:00	NVDA	Stock	0.7556	0.758	0.7526	0.7538	39200200.0
2016-01-08 15:00:00	NVDA	Stock	0.7538	0.755	0.7391	0.7408	139637280.0
2016-01-08 16:00:00	NVDA	Stock	0.7408	0.7517	0.7383	0.7383	24058480.0
2016-01-08 17:00:00	NVDA	Stock	0.7385	0.7385	0.7385	0.7385	20000.0
2016-01-08 18:00:00	NVDA	Stock	0.74	0.74	0.7393	0.74	46000.0
2016-01-08 19:00:00	NVDA	Stock	0.74	0.74	0.7395	0.7395	12000.0
2016-01-08 04:00:00	AMZN	Stock	30.8525	30.925	30.8525	30.8865	21060.0
2016-01-08 05:00:00	AMZN	Stock	30.803	30.803	30.725	30.725	10000.0
2016-01-08 06:00:00	AMZN	Stock	30.7155	30.75	30.61	30.61	33660.0
2016-01-08 07:00:00	AMZN	Stock	30.65	30.9795	30.65	30.897	270900.0
2016-01-08 08:00:00	AMZN	Stock	30.8495	31.1375	30.7	30.976	1043420.0

> showing 50 of 49,114 rows — these rows as CSV

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