PREVIEW / stock_1hour / 2014-10-21

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-21.parquet
  size:    1.0 MB
  rows:    49,168
  symbols: 3,553

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-10-21 04:00:00	AAPL	Stock	25.525	25.525	25.4225	25.4625	162300.0
2014-10-21 05:00:00	AAPL	Stock	25.4625	25.4625	25.4075	25.4625	144052.0
2014-10-21 06:00:00	AAPL	Stock	25.47	25.5	25.4	25.5	373944.0
2014-10-21 07:00:00	AAPL	Stock	25.5	25.5225	25.3625	25.475	1681220.0
2014-10-21 08:00:00	AAPL	Stock	25.5	25.725	25.2	25.7075	7686564.0
2014-10-21 09:00:00	AAPL	Stock	25.705	25.7875	25.3825	25.51	96507860.0
2014-10-21 10:00:00	AAPL	Stock	25.515	25.53	25.3175	25.519	65850716.0
2014-10-21 11:00:00	AAPL	Stock	25.5175	25.6025	25.44	25.4942	41417584.0
2014-10-21 12:00:00	AAPL	Stock	25.4925	25.5288	25.4575	25.504	22937004.0
2014-10-21 13:00:00	AAPL	Stock	25.5038	25.61	25.4975	25.56	28945064.0
2014-10-21 14:00:00	AAPL	Stock	25.5588	25.6075	25.5075	25.6038	25629572.0
2014-10-21 15:00:00	AAPL	Stock	25.6012	25.6225	25.53	25.6175	44166428.0
2014-10-21 16:00:00	AAPL	Stock	25.6175	25.65	24.9145	25.645	9858760.0
2014-10-21 17:00:00	AAPL	Stock	25.6425	25.655	25.6125	25.635	3373552.0
2014-10-21 18:00:00	AAPL	Stock	25.6275	25.635	25.6075	25.6075	392812.0
2014-10-21 19:00:00	AAPL	Stock	25.6075	25.6175	25.5625	25.5625	214284.0
2014-10-21 06:00:00	MSFT	Stock	44.28	44.39	44.28	44.39	300.0
2014-10-21 07:00:00	MSFT	Stock	44.3	44.3	44.3	44.3	300.0
2014-10-21 08:00:00	MSFT	Stock	44.57	44.57	44.2	44.34	11971.0
2014-10-21 09:00:00	MSFT	Stock	44.33	44.66	44.19	44.49	4458570.0
2014-10-21 10:00:00	MSFT	Stock	44.5	44.695	44.39	44.62	4243325.0
2014-10-21 11:00:00	MSFT	Stock	44.62	44.74	44.57	44.72	3025687.0
2014-10-21 12:00:00	MSFT	Stock	44.72	44.84	44.71	44.785	2739100.0
2014-10-21 13:00:00	MSFT	Stock	44.785	44.975	44.76	44.92	3481078.0
2014-10-21 14:00:00	MSFT	Stock	44.92	44.965	44.78	44.822	3210198.0
2014-10-21 15:00:00	MSFT	Stock	44.82	44.88	44.745	44.88	9209061.0
2014-10-21 16:00:00	MSFT	Stock	44.88	44.98	44.637	44.88	4072792.0
2014-10-21 17:00:00	MSFT	Stock	44.9	44.9	44.88	44.88	286712.0
2014-10-21 18:00:00	MSFT	Stock	44.88	44.9	44.88	44.88	47876.0
2014-10-21 19:00:00	MSFT	Stock	44.9	44.9	44.9	44.9	485.0
2014-10-21 09:00:00	NVDA	Stock	0.442	0.45	0.4412	0.4478	36791080.0
2014-10-21 10:00:00	NVDA	Stock	0.4478	0.4532	0.446	0.4502	71283600.0
2014-10-21 11:00:00	NVDA	Stock	0.4502	0.451	0.4472	0.4478	31175440.0
2014-10-21 12:00:00	NVDA	Stock	0.4478	0.4492	0.4465	0.4478	15416600.0
2014-10-21 13:00:00	NVDA	Stock	0.4478	0.4545	0.4475	0.453	53489240.0
2014-10-21 14:00:00	NVDA	Stock	0.453	0.4568	0.4525	0.4559	40253000.0
2014-10-21 15:00:00	NVDA	Stock	0.4559	0.4585	0.4555	0.4581	69986360.0
2014-10-21 16:00:00	NVDA	Stock	0.458	0.458	0.458	0.458	5597520.0
2014-10-21 17:00:00	NVDA	Stock	0.458	0.458	0.4578	0.4578	316120.0
2014-10-21 18:00:00	NVDA	Stock	0.458	0.458	0.458	0.458	28000.0
2014-10-21 19:00:00	NVDA	Stock	0.458	0.458	0.458	0.458	12000.0
2014-10-21 07:00:00	AMZN	Stock	15.4	15.4	15.4	15.4	8460.0
2014-10-21 08:00:00	AMZN	Stock	15.3625	15.4085	15.3105	15.4085	123500.0
2014-10-21 09:00:00	AMZN	Stock	15.4085	15.53	15.3535	15.4085	7354360.0
2014-10-21 10:00:00	AMZN	Stock	15.409	15.4865	15.384	15.4625	10197100.0
2014-10-21 11:00:00	AMZN	Stock	15.4655	15.6365	15.4575	15.6325	12322880.0
2014-10-21 12:00:00	AMZN	Stock	15.6355	15.75	15.6305	15.6971	9200620.0
2014-10-21 13:00:00	AMZN	Stock	15.695	15.715	15.602	15.6885	6738900.0
2014-10-21 14:00:00	AMZN	Stock	15.6895	15.7555	15.6785	15.744	4736340.0
2014-10-21 15:00:00	AMZN	Stock	15.744	15.782	15.7285	15.767	11120680.0

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

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