PREVIEW / stock_1hour / 2016-09-22

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-22.parquet
  size:    1.0 MB
  rows:    48,975
  symbols: 3,242

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-09-22 04:00:00	AAPL	Stock	28.455	28.455	28.455	28.455	400.0
2016-09-22 05:00:00	AAPL	Stock	28.4675	28.5	28.4675	28.5	7648.0
2016-09-22 06:00:00	AAPL	Stock	28.5325	28.5325	28.5325	28.5325	3860.0
2016-09-22 07:00:00	AAPL	Stock	28.5325	28.5325	28.4775	28.5225	76800.0
2016-09-22 08:00:00	AAPL	Stock	28.5225	28.53	28.4875	28.515	384548.0
2016-09-22 09:00:00	AAPL	Stock	28.515	28.7175	28.5	28.6975	24974396.0
2016-09-22 10:00:00	AAPL	Stock	28.6998	28.735	28.595	28.6138	22021324.0
2016-09-22 11:00:00	AAPL	Stock	28.6125	28.705	28.6075	28.655	11515008.0
2016-09-22 12:00:00	AAPL	Stock	28.6575	28.67	28.605	28.6425	9734264.0
2016-09-22 13:00:00	AAPL	Stock	28.645	28.68	28.63	28.67	7619680.0
2016-09-22 14:00:00	AAPL	Stock	28.6675	28.68	28.555	28.6312	11973584.0
2016-09-22 15:00:00	AAPL	Stock	28.6325	28.6975	28.6112	28.6525	18892016.0
2016-09-22 16:00:00	AAPL	Stock	28.6525	28.675	28.64	28.6575	8503980.0
2016-09-22 17:00:00	AAPL	Stock	28.6625	28.6725	28.6625	28.6625	17816.0
2016-09-22 18:00:00	AAPL	Stock	28.6625	28.6725	28.6625	28.6675	17924.0
2016-09-22 19:00:00	AAPL	Stock	28.6625	28.67	28.65	28.65	50352.0
2016-09-22 07:00:00	MSFT	Stock	57.76	57.76	57.63	57.63	490.0
2016-09-22 08:00:00	MSFT	Stock	57.97	58.0	57.83	57.92	5857.0
2016-09-22 09:00:00	MSFT	Stock	57.94	58.0	57.83	57.92	2744800.0
2016-09-22 10:00:00	MSFT	Stock	57.92	58.0	57.85	57.89	2721946.0
2016-09-22 11:00:00	MSFT	Stock	57.89	57.95	57.82	57.865	1955940.0
2016-09-22 12:00:00	MSFT	Stock	57.87	57.9	57.81	57.837	1291794.0
2016-09-22 13:00:00	MSFT	Stock	57.83	57.895	57.8	57.86	1899085.0
2016-09-22 14:00:00	MSFT	Stock	57.855	57.88	57.63	57.745	2559275.0
2016-09-22 15:00:00	MSFT	Stock	57.74	57.9	57.73	57.79	3997417.0
2016-09-22 16:00:00	MSFT	Stock	57.82	57.85	57.79	57.85	1504799.0
2016-09-22 17:00:00	MSFT	Stock	57.85	57.85	57.82	57.82	1437.0
2016-09-22 18:00:00	MSFT	Stock	57.82	57.82	57.8	57.8	200.0
2016-09-22 05:00:00	NVDA	Stock	1.6312	1.6312	1.6312	1.6312	20000.0
2016-09-22 07:00:00	NVDA	Stock	1.631	1.631	1.631	1.631	8000.0
2016-09-22 08:00:00	NVDA	Stock	1.6312	1.6372	1.625	1.6368	421200.0
2016-09-22 09:00:00	NVDA	Stock	1.6353	1.637	1.6255	1.6328	49447520.0
2016-09-22 10:00:00	NVDA	Stock	1.6328	1.6332	1.6163	1.6185	48883800.0
2016-09-22 11:00:00	NVDA	Stock	1.6186	1.6215	1.6168	1.6191	31184120.0
2016-09-22 12:00:00	NVDA	Stock	1.6192	1.6228	1.6188	1.6225	29970320.0
2016-09-22 13:00:00	NVDA	Stock	1.6223	1.6255	1.6208	1.622	23490920.0
2016-09-22 14:00:00	NVDA	Stock	1.622	1.625	1.618	1.6248	37082000.0
2016-09-22 15:00:00	NVDA	Stock	1.6245	1.6268	1.6228	1.6255	61501160.0
2016-09-22 16:00:00	NVDA	Stock	1.6255	1.6255	1.6255	1.6255	668720.0
2016-09-22 17:00:00	NVDA	Stock	1.6255	1.6255	1.6255	1.6255	640960.0
2016-09-22 18:00:00	NVDA	Stock	1.625	1.625	1.6225	1.6225	60000.0
2016-09-22 19:00:00	NVDA	Stock	1.6253	1.6255	1.6253	1.6255	60000.0
2016-09-22 04:00:00	AMZN	Stock	39.549	39.549	39.549	39.549	2000.0
2016-09-22 05:00:00	AMZN	Stock	39.613	39.613	39.613	39.613	4000.0
2016-09-22 06:00:00	AMZN	Stock	39.646	39.646	39.646	39.646	3000.0
2016-09-22 07:00:00	AMZN	Stock	39.6	39.673	39.585	39.626	329520.0
2016-09-22 08:00:00	AMZN	Stock	39.606	39.6695	39.6035	39.6605	445220.0
2016-09-22 09:00:00	AMZN	Stock	39.666	39.9875	39.6525	39.985	15590420.0
2016-09-22 10:00:00	AMZN	Stock	39.9778	40.2115	39.963	40.1165	17492260.0
2016-09-22 11:00:00	AMZN	Stock	40.122	40.2715	40.1	40.2245	10668220.0

> showing 50 of 48,975 rows — these rows as CSV

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