PREVIEW / stock_1hour / 2016-07-07

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-07.parquet
  size:    1.0 MB
  rows:    47,780
  symbols: 3,261

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
2016-07-07 05:00:00	AAPL	Stock	23.9225	23.9225	23.9225	23.9225	644.0
2016-07-07 06:00:00	AAPL	Stock	23.9225	23.9225	23.9	23.9	3756.0
2016-07-07 07:00:00	AAPL	Stock	23.92	23.94	23.8775	23.8775	35360.0
2016-07-07 08:00:00	AAPL	Stock	23.9	23.93	23.8875	23.93	87476.0
2016-07-07 09:00:00	AAPL	Stock	23.9375	24.1225	23.9125	24.0812	17238592.0
2016-07-07 10:00:00	AAPL	Stock	24.08	24.125	24.005	24.025	15365408.0
2016-07-07 11:00:00	AAPL	Stock	24.025	24.0675	23.97	24.0472	9780812.0
2016-07-07 12:00:00	AAPL	Stock	24.045	24.07	23.9875	23.9975	10419736.0
2016-07-07 13:00:00	AAPL	Stock	23.9975	24.015	23.9475	23.9825	7536020.0
2016-07-07 14:00:00	AAPL	Stock	23.9838	24.0025	23.905	23.9212	7784964.0
2016-07-07 15:00:00	AAPL	Stock	23.9212	24.0025	23.9125	23.985	13819388.0
2016-07-07 16:00:00	AAPL	Stock	23.985	24.0335	23.9125	23.965	7661784.0
2016-07-07 17:00:00	AAPL	Stock	23.985	23.985	23.96	23.9675	67916.0
2016-07-07 18:00:00	AAPL	Stock	23.9675	23.97	23.9625	23.9675	26876.0
2016-07-07 19:00:00	AAPL	Stock	23.9675	23.9675	23.96	23.965	35996.0
2016-07-07 04:00:00	MSFT	Stock	51.3	51.3	51.3	51.3	100.0
2016-07-07 07:00:00	MSFT	Stock	51.35	51.39	51.35	51.39	3634.0
2016-07-07 08:00:00	MSFT	Stock	51.39	51.56	51.38	51.56	9400.0
2016-07-07 09:00:00	MSFT	Stock	51.42	51.61	51.285	51.55	2325560.0
2016-07-07 10:00:00	MSFT	Stock	51.555	51.6	51.38	51.43	2547117.0
2016-07-07 11:00:00	MSFT	Stock	51.43	51.52	51.24	51.3	2090571.0
2016-07-07 12:00:00	MSFT	Stock	51.29	51.395	51.12	51.125	1588593.0
2016-07-07 13:00:00	MSFT	Stock	51.14	51.295	51.09	51.23	1692793.0
2016-07-07 14:00:00	MSFT	Stock	51.222	51.285	51.08	51.115	2317654.0
2016-07-07 15:00:00	MSFT	Stock	51.115	51.405	51.07	51.38	4195964.0
2016-07-07 16:00:00	MSFT	Stock	51.38	51.566	51.34	51.34	1555868.0
2016-07-07 18:00:00	MSFT	Stock	51.34	51.35	51.34	51.34	1508.0
2016-07-07 19:00:00	MSFT	Stock	51.35	51.38	51.35	51.38	1028.0
2016-07-07 08:00:00	NVDA	Stock	1.19	1.1925	1.19	1.1905	26040.0
2016-07-07 09:00:00	NVDA	Stock	1.1995	1.2025	1.1938	1.202	36051600.0
2016-07-07 10:00:00	NVDA	Stock	1.2023	1.2241	1.201	1.2153	101183400.0
2016-07-07 11:00:00	NVDA	Stock	1.215	1.223	1.2136	1.2198	49318240.0
2016-07-07 12:00:00	NVDA	Stock	1.2198	1.2265	1.2161	1.2187	42100240.0
2016-07-07 13:00:00	NVDA	Stock	1.2185	1.2249	1.2168	1.2222	36470880.0
2016-07-07 14:00:00	NVDA	Stock	1.2222	1.224	1.2154	1.2182	37957760.0
2016-07-07 15:00:00	NVDA	Stock	1.2182	1.225	1.2182	1.222	81364560.0
2016-07-07 16:00:00	NVDA	Stock	1.2222	1.225	1.2002	1.225	1202640.0
2016-07-07 17:00:00	NVDA	Stock	1.2222	1.2222	1.2213	1.2213	44400.0
2016-07-07 18:00:00	NVDA	Stock	1.2213	1.2222	1.2213	1.2222	46800.0
2016-07-07 19:00:00	NVDA	Stock	1.2222	1.2222	1.2222	1.2222	30320.0
2016-07-07 04:00:00	AMZN	Stock	36.9085	37.0	36.9085	37.0	10000.0
2016-07-07 05:00:00	AMZN	Stock	37.0645	37.0645	36.976	36.9805	18000.0
2016-07-07 06:00:00	AMZN	Stock	36.99	36.99	36.99	36.99	18000.0
2016-07-07 07:00:00	AMZN	Stock	36.97	36.97	36.927	36.927	18820.0
2016-07-07 08:00:00	AMZN	Stock	36.9	36.9735	36.9	36.9625	296400.0
2016-07-07 09:00:00	AMZN	Stock	36.9625	36.9925	36.7132	36.766	10975600.0
2016-07-07 10:00:00	AMZN	Stock	36.7742	36.8125	36.6522	36.6615	11585600.0
2016-07-07 11:00:00	AMZN	Stock	36.6615	36.694	36.5815	36.677	5613300.0
2016-07-07 12:00:00	AMZN	Stock	36.6825	36.771	36.5905	36.596	4865200.0
2016-07-07 13:00:00	AMZN	Stock	36.6	36.7485	36.6	36.6785	3515900.0

> showing 50 of 47,780 rows — these rows as CSV

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