PREVIEW / stock_1hour / 2014-12-05

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-05.parquet
  size:    1.0 MB
  rows:    49,080
  symbols: 3,561

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-05 04:00:00	AAPL	Stock	28.9125	28.95	28.9125	28.9375	15928.0
2014-12-05 05:00:00	AAPL	Stock	28.9275	28.9375	28.925	28.925	5600.0
2014-12-05 06:00:00	AAPL	Stock	28.9375	28.9975	28.9375	28.9975	33852.0
2014-12-05 07:00:00	AAPL	Stock	28.985	28.9975	28.95	28.9825	87800.0
2014-12-05 08:00:00	AAPL	Stock	28.975	29.05	28.8725	28.9648	877172.0
2014-12-05 09:00:00	AAPL	Stock	28.97	29.0152	28.7675	28.93	23524144.0
2014-12-05 10:00:00	AAPL	Stock	28.93	28.93	28.795	28.865	22787932.0
2014-12-05 11:00:00	AAPL	Stock	28.865	28.925	28.8325	28.8925	14835532.0
2014-12-05 12:00:00	AAPL	Stock	28.8925	29.02	28.8825	28.9632	20349288.0
2014-12-05 13:00:00	AAPL	Stock	28.9628	28.9675	28.88	28.9292	10327032.0
2014-12-05 14:00:00	AAPL	Stock	28.93	28.94	28.795	28.8125	11359268.0
2014-12-05 15:00:00	AAPL	Stock	28.8125	28.8575	28.66	28.7475	30999996.0
2014-12-05 16:00:00	AAPL	Stock	28.75	28.9375	28.735	28.745	9365644.0
2014-12-05 17:00:00	AAPL	Stock	28.745	28.75	28.74	28.75	1494456.0
2014-12-05 18:00:00	AAPL	Stock	28.74	28.75	28.7375	28.7375	71856.0
2014-12-05 19:00:00	AAPL	Stock	28.73	28.75	28.725	28.75	42140.0
2014-12-05 08:00:00	MSFT	Stock	48.9	48.99	48.8	48.9	20311.0
2014-12-05 09:00:00	MSFT	Stock	48.86	48.97	48.57	48.58	3310112.0
2014-12-05 10:00:00	MSFT	Stock	48.59	48.755	48.385	48.63	3816010.0
2014-12-05 11:00:00	MSFT	Stock	48.635	48.68	48.57	48.609	1898348.0
2014-12-05 12:00:00	MSFT	Stock	48.607	48.7	48.59	48.635	1236796.0
2014-12-05 13:00:00	MSFT	Stock	48.635	48.64	48.475	48.53	1214706.0
2014-12-05 14:00:00	MSFT	Stock	48.53	48.54	48.45	48.51	2309679.0
2014-12-05 15:00:00	MSFT	Stock	48.5	48.6	48.38	48.41	5521511.0
2014-12-05 16:00:00	MSFT	Stock	48.42	48.65	48.41	48.43	5568996.0
2014-12-05 17:00:00	MSFT	Stock	48.45	48.45	48.42	48.42	610481.0
2014-12-05 18:00:00	MSFT	Stock	48.42	48.42	48.42	48.42	607181.0
2014-12-05 19:00:00	MSFT	Stock	48.44	48.44	48.42	48.42	906.0
2014-12-05 09:00:00	NVDA	Stock	0.524	0.5295	0.5238	0.527	18491040.0
2014-12-05 10:00:00	NVDA	Stock	0.5271	0.5278	0.524	0.5247	19389120.0
2014-12-05 11:00:00	NVDA	Stock	0.5247	0.5279	0.5246	0.5271	13242160.0
2014-12-05 12:00:00	NVDA	Stock	0.527	0.5278	0.5268	0.5274	12669560.0
2014-12-05 13:00:00	NVDA	Stock	0.5274	0.528	0.527	0.5274	11357840.0
2014-12-05 14:00:00	NVDA	Stock	0.5274	0.5278	0.5255	0.526	14778480.0
2014-12-05 15:00:00	NVDA	Stock	0.526	0.5275	0.5258	0.5268	41101600.0
2014-12-05 16:00:00	NVDA	Stock	0.5268	0.5275	0.5267	0.5268	31969360.0
2014-12-05 06:00:00	AMZN	Stock	15.8485	15.8495	15.8485	15.8495	4000.0
2014-12-05 08:00:00	AMZN	Stock	15.828	15.84	15.781	15.825	70200.0
2014-12-05 09:00:00	AMZN	Stock	15.815	15.85	15.616	15.6895	11226140.0
2014-12-05 10:00:00	AMZN	Stock	15.6959	15.6959	15.542	15.559	12146980.0
2014-12-05 11:00:00	AMZN	Stock	15.5565	15.6485	15.55	15.6254	6045980.0
2014-12-05 12:00:00	AMZN	Stock	15.6275	15.653	15.5836	15.612	3100640.0
2014-12-05 13:00:00	AMZN	Stock	15.6125	15.6125	15.55	15.5955	4441180.0
2014-12-05 14:00:00	AMZN	Stock	15.5958	15.648	15.5948	15.6235	5272180.0
2014-12-05 15:00:00	AMZN	Stock	15.629	15.64	15.572	15.6305	15585140.0
2014-12-05 16:00:00	AMZN	Stock	15.6315	15.6334	15.6075	15.6275	2827920.0
2014-12-05 17:00:00	AMZN	Stock	15.625	15.6315	15.625	15.6315	121920.0
2014-12-05 18:00:00	AMZN	Stock	15.625	15.6275	15.625	15.6275	9000.0
2014-12-05 19:00:00	AMZN	Stock	15.6005	15.6315	15.6005	15.6315	4000.0
2014-12-05 04:00:00	GOOGL	Stock	27.125	27.125	27.125	27.125	2000.0

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

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