PREVIEW / stock_1hour / 2014-06-27

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-27.parquet
  size:    1.1 MB
  rows:    49,487
  symbols: 3,574

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-06-27 04:00:00	AAPL	Stock	22.7375	22.74	22.735	22.74	4400.0
2014-06-27 05:00:00	AAPL	Stock	22.7475	22.7475	22.7475	22.7475	12280.0
2014-06-27 06:00:00	AAPL	Stock	22.75	22.78	22.7475	22.7625	22792.0
2014-06-27 07:00:00	AAPL	Stock	22.7575	22.7575	22.7275	22.7575	83212.0
2014-06-27 08:00:00	AAPL	Stock	22.76	22.7725	22.665	22.705	318236.0
2014-06-27 09:00:00	AAPL	Stock	22.705	22.9138	22.6675	22.8925	30779360.0
2014-06-27 10:00:00	AAPL	Stock	22.895	22.95	22.855	22.885	23772352.0
2014-06-27 11:00:00	AAPL	Stock	22.885	22.9225	22.835	22.8858	12412812.0
2014-06-27 12:00:00	AAPL	Stock	22.8858	22.9125	22.84	22.9025	9318560.0
2014-06-27 13:00:00	AAPL	Stock	22.9025	22.91	22.835	22.875	12478868.0
2014-06-27 14:00:00	AAPL	Stock	22.8775	22.905	22.82	22.8332	12269032.0
2014-06-27 15:00:00	AAPL	Stock	22.8325	23.0	22.8325	22.99	33286508.0
2014-06-27 16:00:00	AAPL	Stock	22.9875	23.011	22.8455	22.9775	81292844.0
2014-06-27 17:00:00	AAPL	Stock	22.9775	22.9995	22.891	22.98	16062524.0
2014-06-27 18:00:00	AAPL	Stock	22.9825	22.995	22.975	22.9775	216592.0
2014-06-27 19:00:00	AAPL	Stock	22.9775	22.985	22.975	22.985	78984.0
2014-06-27 09:00:00	MSFT	Stock	41.68	41.93	41.51	41.82	2918065.0
2014-06-27 10:00:00	MSFT	Stock	41.82	41.89	41.64	41.745	2808745.0
2014-06-27 11:00:00	MSFT	Stock	41.75	41.78	41.64	41.705	1674255.0
2014-06-27 12:00:00	MSFT	Stock	41.705	41.72	41.525	41.62	1359405.0
2014-06-27 13:00:00	MSFT	Stock	41.61	41.74	41.51	41.72	1755391.0
2014-06-27 14:00:00	MSFT	Stock	41.72	41.98	41.71	41.918	2724973.0
2014-06-27 15:00:00	MSFT	Stock	41.91	42.29	41.91	42.24	8184538.0
2014-06-27 16:00:00	MSFT	Stock	42.25	42.28	41.918	42.25	40293394.0
2014-06-27 17:00:00	MSFT	Stock	42.2	42.258	42.2	42.22	8206405.0
2014-06-27 18:00:00	MSFT	Stock	42.22	42.25	42.16	42.16	35976.0
2014-06-27 19:00:00	MSFT	Stock	42.17	42.22	42.16	42.22	1600.0
2014-06-27 06:00:00	NVDA	Stock	0.4588	0.4588	0.4588	0.4588	12000.0
2014-06-27 09:00:00	NVDA	Stock	0.4585	0.46	0.4558	0.46	24326600.0
2014-06-27 10:00:00	NVDA	Stock	0.4599	0.461	0.4585	0.461	25071120.0
2014-06-27 11:00:00	NVDA	Stock	0.461	0.4622	0.4603	0.4612	18040640.0
2014-06-27 12:00:00	NVDA	Stock	0.4615	0.462	0.4605	0.4608	9770920.0
2014-06-27 13:00:00	NVDA	Stock	0.4608	0.4608	0.4588	0.4603	28012440.0
2014-06-27 14:00:00	NVDA	Stock	0.4603	0.461	0.4595	0.46	20277520.0
2014-06-27 15:00:00	NVDA	Stock	0.4603	0.4605	0.4586	0.4598	50690040.0
2014-06-27 16:00:00	NVDA	Stock	0.4595	0.4598	0.4573	0.4595	50499000.0
2014-06-27 17:00:00	NVDA	Stock	0.4594	0.4596	0.4594	0.4596	12995160.0
2014-06-27 06:00:00	AMZN	Stock	16.3225	16.3225	16.3225	16.3225	2000.0
2014-06-27 08:00:00	AMZN	Stock	16.315	16.315	16.275	16.2845	26000.0
2014-06-27 09:00:00	AMZN	Stock	16.3045	16.326	16.1955	16.216	5057920.0
2014-06-27 10:00:00	AMZN	Stock	16.212	16.2714	16.1885	16.2186	6890820.0
2014-06-27 11:00:00	AMZN	Stock	16.2225	16.25	16.196	16.2458	3318200.0
2014-06-27 12:00:00	AMZN	Stock	16.241	16.299	16.2405	16.258	3048980.0
2014-06-27 13:00:00	AMZN	Stock	16.258	16.2649	16.1635	16.1838	5777220.0
2014-06-27 14:00:00	AMZN	Stock	16.182	16.23	16.1805	16.201	2614480.0
2014-06-27 15:00:00	AMZN	Stock	16.1985	16.2425	16.1925	16.228	7786740.0
2014-06-27 16:00:00	AMZN	Stock	16.2285	16.2342	16.195	16.213	5002180.0
2014-06-27 17:00:00	AMZN	Stock	16.22	16.2318	16.213	16.213	608400.0
2014-06-27 18:00:00	AMZN	Stock	16.2285	16.2285	16.22	16.22	30900.0
2014-06-27 19:00:00	AMZN	Stock	16.215	16.215	16.215	16.215	63880.0

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

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