PREVIEW / stock_1hour / 2014-07-14

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-14.parquet
  size:    1.0 MB
  rows:    49,712
  symbols: 3,583

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-14 04:00:00	AAPL	Stock	23.805	24.125	23.805	24.1025	61600.0
2014-07-14 05:00:00	AAPL	Stock	24.105	24.1225	24.065	24.065	88940.0
2014-07-14 06:00:00	AAPL	Stock	24.0625	24.075	24.0275	24.0425	42988.0
2014-07-14 07:00:00	AAPL	Stock	24.04	24.075	23.9925	24.04	499320.0
2014-07-14 08:00:00	AAPL	Stock	24.03	24.0725	23.805	23.9838	1558336.0
2014-07-14 09:00:00	AAPL	Stock	23.98	24.1675	23.9125	24.1	37619468.0
2014-07-14 10:00:00	AAPL	Stock	24.1	24.1275	24.0275	24.085	24407848.0
2014-07-14 11:00:00	AAPL	Stock	24.085	24.21	24.085	24.1575	24561944.0
2014-07-14 12:00:00	AAPL	Stock	24.1588	24.2225	24.135	24.15	17207796.0
2014-07-14 13:00:00	AAPL	Stock	24.1515	24.2075	24.1425	24.17	11840816.0
2014-07-14 14:00:00	AAPL	Stock	24.17	24.1975	24.1525	24.175	11161372.0
2014-07-14 15:00:00	AAPL	Stock	24.1765	24.18	24.0775	24.1125	23428884.0
2014-07-14 16:00:00	AAPL	Stock	24.1125	24.1722	24.0875	24.1125	6347200.0
2014-07-14 17:00:00	AAPL	Stock	24.115	24.1425	24.1075	24.1275	376328.0
2014-07-14 18:00:00	AAPL	Stock	24.1325	24.1425	24.1125	24.14	264364.0
2014-07-14 19:00:00	AAPL	Stock	24.14	24.155	24.125	24.155	193320.0
2014-07-14 08:00:00	MSFT	Stock	42.16	42.26	42.09	42.26	40691.0
2014-07-14 09:00:00	MSFT	Stock	42.23	42.3	42.1	42.285	2186669.0
2014-07-14 10:00:00	MSFT	Stock	42.28	42.45	42.2	42.28	2850315.0
2014-07-14 11:00:00	MSFT	Stock	42.27	42.38	42.24	42.29	1992261.0
2014-07-14 12:00:00	MSFT	Stock	42.295	42.43	42.28	42.395	2190733.0
2014-07-14 13:00:00	MSFT	Stock	42.39	42.42	42.35	42.375	2113829.0
2014-07-14 14:00:00	MSFT	Stock	42.375	42.38	42.2	42.255	2177389.0
2014-07-14 15:00:00	MSFT	Stock	42.25	42.26	42.04	42.14	5685084.0
2014-07-14 16:00:00	MSFT	Stock	42.14	42.297	42.06	42.297	1999904.0
2014-07-14 17:00:00	MSFT	Stock	42.14	42.15	42.1	42.12	11457.0
2014-07-14 18:00:00	MSFT	Stock	42.15	42.15	42.14	42.14	1700.0
2014-07-14 19:00:00	MSFT	Stock	42.14	42.14	42.14	42.14	1100.0
2014-07-14 09:00:00	NVDA	Stock	0.4782	0.4812	0.4765	0.48	26889040.0
2014-07-14 10:00:00	NVDA	Stock	0.48	0.4815	0.4772	0.4815	50788240.0
2014-07-14 11:00:00	NVDA	Stock	0.4815	0.4835	0.4803	0.4805	32826200.0
2014-07-14 12:00:00	NVDA	Stock	0.4808	0.4808	0.4788	0.4798	12114880.0
2014-07-14 13:00:00	NVDA	Stock	0.4796	0.4808	0.4795	0.4803	11929560.0
2014-07-14 14:00:00	NVDA	Stock	0.4804	0.481	0.4798	0.4809	13989960.0
2014-07-14 15:00:00	NVDA	Stock	0.4808	0.4828	0.4803	0.4822	104890200.0
2014-07-14 16:00:00	NVDA	Stock	0.4822	0.4822	0.4813	0.4822	2453960.0
2014-07-14 17:00:00	NVDA	Stock	0.4822	0.4835	0.4822	0.4835	533960.0
2014-07-14 04:00:00	AMZN	Stock	17.363	17.3985	17.363	17.3985	4000.0
2014-07-14 05:00:00	AMZN	Stock	17.439	17.447	17.425	17.425	12000.0
2014-07-14 06:00:00	AMZN	Stock	17.425	17.425	17.425	17.425	4000.0
2014-07-14 07:00:00	AMZN	Stock	17.435	17.435	17.405	17.413	174400.0
2014-07-14 08:00:00	AMZN	Stock	17.4015	17.411	17.225	17.3875	519760.0
2014-07-14 09:00:00	AMZN	Stock	17.3875	17.532	17.2678	17.5265	18398560.0
2014-07-14 10:00:00	AMZN	Stock	17.5285	17.6935	17.5065	17.679	22076940.0
2014-07-14 11:00:00	AMZN	Stock	17.6815	17.743	17.6135	17.6995	11379100.0
2014-07-14 12:00:00	AMZN	Stock	17.6935	17.761	17.659	17.6865	10888300.0
2014-07-14 13:00:00	AMZN	Stock	17.687	17.739	17.652	17.7375	6987560.0
2014-07-14 14:00:00	AMZN	Stock	17.734	17.7885	17.64	17.7525	10354780.0
2014-07-14 15:00:00	AMZN	Stock	17.7505	17.774	17.6725	17.766	15890580.0
2014-07-14 16:00:00	AMZN	Stock	17.766	17.785	17.442	17.7845	2564580.0

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

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