PREVIEW / stock_1hour / 2014-12-29

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-29.parquet
  size:    1.1 MB
  rows:    49,259
  symbols: 3,555

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
2014-12-29 04:00:00	AAPL	Stock	28.55	28.55	28.4375	28.4875	61100.0
2014-12-29 05:00:00	AAPL	Stock	28.5	28.53	28.4625	28.4875	41264.0
2014-12-29 06:00:00	AAPL	Stock	28.5	28.5	28.4425	28.475	17172.0
2014-12-29 07:00:00	AAPL	Stock	28.4925	28.5	28.4125	28.425	70892.0
2014-12-29 08:00:00	AAPL	Stock	28.4375	28.5	28.415	28.45	407332.0
2014-12-29 09:00:00	AAPL	Stock	28.455	28.685	28.425	28.595	23161708.0
2014-12-29 10:00:00	AAPL	Stock	28.5975	28.6825	28.5275	28.674	17539324.0
2014-12-29 11:00:00	AAPL	Stock	28.6725	28.6925	28.625	28.625	10521600.0
2014-12-29 12:00:00	AAPL	Stock	28.6262	28.6375	28.5875	28.5925	9254872.0
2014-12-29 13:00:00	AAPL	Stock	28.5925	28.62	28.5382	28.5525	8928152.0
2014-12-29 14:00:00	AAPL	Stock	28.5525	28.56	28.4475	28.4538	10556936.0
2014-12-29 15:00:00	AAPL	Stock	28.4538	28.5125	28.4375	28.48	15043368.0
2014-12-29 16:00:00	AAPL	Stock	28.4775	28.5692	28.4775	28.4875	7815584.0
2014-12-29 17:00:00	AAPL	Stock	28.4925	28.6288	28.4775	28.49	194448.0
2014-12-29 18:00:00	AAPL	Stock	28.4775	28.5	28.4775	28.495	71132.0
2014-12-29 19:00:00	AAPL	Stock	28.495	28.5125	28.4925	28.5125	85216.0
2014-12-29 05:00:00	MSFT	Stock	47.84	47.84	47.76	47.76	600.0
2014-12-29 06:00:00	MSFT	Stock	47.7	47.7	47.7	47.7	100.0
2014-12-29 07:00:00	MSFT	Stock	47.7	47.7	47.7	47.7	170.0
2014-12-29 08:00:00	MSFT	Stock	47.69	47.69	47.57	47.62	1800.0
2014-12-29 09:00:00	MSFT	Stock	47.75	47.78	47.41	47.505	2213246.0
2014-12-29 10:00:00	MSFT	Stock	47.52	47.55	47.26	47.45	2565097.0
2014-12-29 11:00:00	MSFT	Stock	47.44	47.57	47.43	47.5	1245568.0
2014-12-29 12:00:00	MSFT	Stock	47.505	47.545	47.43	47.435	1081227.0
2014-12-29 13:00:00	MSFT	Stock	47.435	47.52	47.39	47.425	825178.0
2014-12-29 14:00:00	MSFT	Stock	47.425	47.45	47.39	47.415	871818.0
2014-12-29 15:00:00	MSFT	Stock	47.415	47.48	47.355	47.44	3095528.0
2014-12-29 16:00:00	MSFT	Stock	47.45	47.5	47.448	47.45	1821839.0
2014-12-29 17:00:00	MSFT	Stock	47.467	47.5	47.45	47.5	25466.0
2014-12-29 18:00:00	MSFT	Stock	47.45	47.45	47.45	47.45	13371.0
2014-12-29 19:00:00	MSFT	Stock	47.5	47.5	47.5	47.5	500.0
2014-12-29 09:00:00	NVDA	Stock	0.5138	0.5148	0.5108	0.5122	12853000.0
2014-12-29 10:00:00	NVDA	Stock	0.5122	0.5155	0.5118	0.5154	11852680.0
2014-12-29 11:00:00	NVDA	Stock	0.5152	0.5168	0.515	0.5164	7900560.0
2014-12-29 12:00:00	NVDA	Stock	0.5165	0.5173	0.5159	0.5164	12996600.0
2014-12-29 13:00:00	NVDA	Stock	0.5164	0.5175	0.5162	0.5164	8268640.0
2014-12-29 14:00:00	NVDA	Stock	0.5162	0.5165	0.5148	0.5152	5464240.0
2014-12-29 15:00:00	NVDA	Stock	0.5154	0.5155	0.5138	0.5141	16124640.0
2014-12-29 16:00:00	NVDA	Stock	0.514	0.514	0.514	0.514	5764520.0
2014-12-29 19:00:00	NVDA	Stock	0.5122	0.5122	0.5122	0.5122	4000.0
2014-12-29 08:00:00	AMZN	Stock	15.42	15.4545	15.42	15.425	25600.0
2014-12-29 09:00:00	AMZN	Stock	15.425	15.523	15.329	15.5055	8081500.0
2014-12-29 10:00:00	AMZN	Stock	15.5105	15.6945	15.4925	15.661	13097560.0
2014-12-29 11:00:00	AMZN	Stock	15.6595	15.7135	15.6245	15.685	7585060.0
2014-12-29 12:00:00	AMZN	Stock	15.6855	15.697	15.5795	15.582	5156760.0
2014-12-29 13:00:00	AMZN	Stock	15.5818	15.642	15.551	15.5688	5168160.0
2014-12-29 14:00:00	AMZN	Stock	15.5695	15.6298	15.562	15.6255	5942900.0
2014-12-29 15:00:00	AMZN	Stock	15.629	15.6455	15.543	15.602	9070540.0
2014-12-29 16:00:00	AMZN	Stock	15.602	15.6238	15.5895	15.5895	1726980.0
2014-12-29 17:00:00	AMZN	Stock	15.5895	15.6175	15.5895	15.602	206920.0

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

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