PREVIEW / stock_1hour / 2014-07-16

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-16.parquet
  size:    1.0 MB
  rows:    49,237
  symbols: 3,568

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-07-16 04:00:00	AAPL	Stock	24.345	24.345	24.2	24.2475	54932.0
2014-07-16 05:00:00	AAPL	Stock	24.2475	24.315	24.2475	24.315	17560.0
2014-07-16 06:00:00	AAPL	Stock	24.3375	24.395	24.31	24.375	203416.0
2014-07-16 07:00:00	AAPL	Stock	24.3675	24.4975	24.3075	24.4075	802440.0
2014-07-16 08:00:00	AAPL	Stock	24.4125	24.49	24.3	24.3375	2847552.0
2014-07-16 09:00:00	AAPL	Stock	24.3375	24.3675	24.065	24.0925	46337380.0
2014-07-16 10:00:00	AAPL	Stock	24.0925	24.14	24.0175	24.0375	31766904.0
2014-07-16 11:00:00	AAPL	Stock	24.0375	24.125	24.0375	24.0902	18892920.0
2014-07-16 12:00:00	AAPL	Stock	24.09	24.125	24.055	24.0575	12189936.0
2014-07-16 13:00:00	AAPL	Stock	24.055	24.0725	23.98	24.005	14237756.0
2014-07-16 14:00:00	AAPL	Stock	24.0075	24.045	23.9675	23.9675	13032032.0
2014-07-16 15:00:00	AAPL	Stock	23.9675	24.0025	23.685	23.695	42678320.0
2014-07-16 16:00:00	AAPL	Stock	23.695	24.086	23.685	23.775	8977556.0
2014-07-16 17:00:00	AAPL	Stock	23.77	23.77	23.695	23.7525	323652.0
2014-07-16 18:00:00	AAPL	Stock	23.7525	23.755	23.695	23.74	338876.0
2014-07-16 19:00:00	AAPL	Stock	23.745	23.745	23.695	23.695	203684.0
2014-07-16 07:00:00	MSFT	Stock	42.61	42.71	42.6	42.7	6945.0
2014-07-16 08:00:00	MSFT	Stock	42.67	42.72	42.6	42.66	32171.0
2014-07-16 09:00:00	MSFT	Stock	42.66	42.98	42.47	42.98	5640759.0
2014-07-16 10:00:00	MSFT	Stock	42.98	43.13	42.92	42.99	8082298.0
2014-07-16 11:00:00	MSFT	Stock	42.99	43.46	42.93	43.435	6335070.0
2014-07-16 12:00:00	MSFT	Stock	43.43	43.935	43.43	43.905	8436895.0
2014-07-16 13:00:00	MSFT	Stock	43.9	43.99	43.835	43.865	5129448.0
2014-07-16 14:00:00	MSFT	Stock	43.865	44.06	43.845	43.944	7726018.0
2014-07-16 15:00:00	MSFT	Stock	43.94	44.31	43.94	44.07	15389678.0
2014-07-16 16:00:00	MSFT	Stock	44.08	44.08	43.068	44.03	4190249.0
2014-07-16 17:00:00	MSFT	Stock	44.04	44.08	43.98	44.02	64547.0
2014-07-16 18:00:00	MSFT	Stock	44.02	44.02	43.98	44.0	2682.0
2014-07-16 19:00:00	MSFT	Stock	43.99	44.0	43.97	43.99	2800.0
2014-07-16 09:00:00	NVDA	Stock	0.487	0.49	0.4852	0.4865	25243280.0
2014-07-16 10:00:00	NVDA	Stock	0.4868	0.4875	0.483	0.483	68018880.0
2014-07-16 11:00:00	NVDA	Stock	0.483	0.4843	0.481	0.4838	46478960.0
2014-07-16 12:00:00	NVDA	Stock	0.4839	0.4864	0.4835	0.4855	25043040.0
2014-07-16 13:00:00	NVDA	Stock	0.4854	0.4858	0.4845	0.485	11126640.0
2014-07-16 14:00:00	NVDA	Stock	0.485	0.487	0.4847	0.4858	28317960.0
2014-07-16 15:00:00	NVDA	Stock	0.4858	0.487	0.4838	0.4838	78613000.0
2014-07-16 16:00:00	NVDA	Stock	0.4838	0.4838	0.4838	0.4838	10215160.0
2014-07-16 07:00:00	AMZN	Stock	17.7405	17.8	17.7405	17.8	22400.0
2014-07-16 08:00:00	AMZN	Stock	17.7875	17.8325	17.7705	17.818	286220.0
2014-07-16 09:00:00	AMZN	Stock	17.8335	17.966	17.65	17.895	14499960.0
2014-07-16 10:00:00	AMZN	Stock	17.8905	17.96	17.8465	17.936	12775320.0
2014-07-16 11:00:00	AMZN	Stock	17.936	17.9521	17.7175	17.8	9616700.0
2014-07-16 12:00:00	AMZN	Stock	17.7958	17.846	17.776	17.803	4303140.0
2014-07-16 13:00:00	AMZN	Stock	17.8035	17.83	17.7875	17.8025	3372340.0
2014-07-16 14:00:00	AMZN	Stock	17.799	17.819	17.781	17.7984	3648720.0
2014-07-16 15:00:00	AMZN	Stock	17.793	17.9555	17.7845	17.795	9300920.0
2014-07-16 16:00:00	AMZN	Stock	17.795	17.8935	17.729	17.795	4371140.0
2014-07-16 17:00:00	AMZN	Stock	17.775	17.795	17.775	17.775	156000.0
2014-07-16 18:00:00	AMZN	Stock	17.775	17.795	17.7515	17.7945	14380.0
2014-07-16 19:00:00	AMZN	Stock	17.7555	17.774	17.744	17.744	17040.0

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

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