PREVIEW / stock_1hour / 2016-11-08

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-08.parquet
  size:    1.0 MB
  rows:    47,491
  symbols: 3,159

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-11-08 04:00:00	AAPL	Stock	27.565	27.5725	27.4825	27.4975	16472.0
2016-11-08 05:00:00	AAPL	Stock	27.4975	27.4975	27.4975	27.4975	2800.0
2016-11-08 06:00:00	AAPL	Stock	27.4975	27.52	27.475	27.485	15952.0
2016-11-08 07:00:00	AAPL	Stock	27.53	27.535	27.5	27.515	11152.0
2016-11-08 08:00:00	AAPL	Stock	27.5225	27.595	27.5025	27.55	83448.0
2016-11-08 09:00:00	AAPL	Stock	27.5425	27.6275	27.455	27.485	9581672.0
2016-11-08 10:00:00	AAPL	Stock	27.4825	27.5325	27.425	27.5075	10584196.0
2016-11-08 11:00:00	AAPL	Stock	27.5075	27.735	27.4925	27.7282	12460964.0
2016-11-08 12:00:00	AAPL	Stock	27.73	27.93	27.725	27.91	12771220.0
2016-11-08 13:00:00	AAPL	Stock	27.91	27.925	27.78	27.7842	10322460.0
2016-11-08 14:00:00	AAPL	Stock	27.7835	27.795	27.665	27.7275	9299964.0
2016-11-08 15:00:00	AAPL	Stock	27.7275	27.8525	27.705	27.765	18055068.0
2016-11-08 16:00:00	AAPL	Stock	27.765	27.8025	27.7075	27.7725	5221752.0
2016-11-08 17:00:00	AAPL	Stock	27.77	27.775	27.75	27.7625	63020.0
2016-11-08 18:00:00	AAPL	Stock	27.7625	27.8175	27.7625	27.805	59628.0
2016-11-08 19:00:00	AAPL	Stock	27.8	27.8875	27.7375	27.865	379936.0
2016-11-08 07:00:00	MSFT	Stock	60.5	60.5	60.5	60.5	442.0
2016-11-08 08:00:00	MSFT	Stock	60.49	60.49	60.38	60.47	11200.0
2016-11-08 09:00:00	MSFT	Stock	60.39	60.55	60.2	60.22	2637508.0
2016-11-08 10:00:00	MSFT	Stock	60.225	60.42	60.15	60.35	2808022.0
2016-11-08 11:00:00	MSFT	Stock	60.36	60.6	60.32	60.485	2301537.0
2016-11-08 12:00:00	MSFT	Stock	60.485	60.77	60.48	60.76	2309650.0
2016-11-08 13:00:00	MSFT	Stock	60.76	60.78	60.47	60.51	2727140.0
2016-11-08 14:00:00	MSFT	Stock	60.501	60.53	60.305	60.435	2247019.0
2016-11-08 15:00:00	MSFT	Stock	60.435	60.57	60.36	60.47	4599349.0
2016-11-08 16:00:00	MSFT	Stock	60.47	60.47	60.27	60.4	1740822.0
2016-11-08 17:00:00	MSFT	Stock	60.4	60.5	60.31	60.5	60689.0
2016-11-08 18:00:00	MSFT	Stock	60.47	60.54	60.47	60.54	533.0
2016-11-08 19:00:00	MSFT	Stock	60.47	60.6	60.33	60.6	2230.0
2016-11-08 07:00:00	NVDA	Stock	1.7805	1.7885	1.7805	1.7818	68000.0
2016-11-08 08:00:00	NVDA	Stock	1.785	1.7925	1.7812	1.7925	432520.0
2016-11-08 09:00:00	NVDA	Stock	1.79	1.7908	1.7625	1.7728	45163200.0
2016-11-08 10:00:00	NVDA	Stock	1.772	1.778	1.7655	1.7746	35504080.0
2016-11-08 11:00:00	NVDA	Stock	1.7745	1.7828	1.7718	1.7812	40615360.0
2016-11-08 12:00:00	NVDA	Stock	1.7815	1.7942	1.7815	1.792	33278160.0
2016-11-08 13:00:00	NVDA	Stock	1.7918	1.7918	1.7808	1.7839	27829000.0
2016-11-08 14:00:00	NVDA	Stock	1.7838	1.7838	1.7678	1.7705	34666640.0
2016-11-08 15:00:00	NVDA	Stock	1.7705	1.7835	1.7704	1.779	59874040.0
2016-11-08 16:00:00	NVDA	Stock	1.779	1.7838	1.779	1.7838	136446080.0
2016-11-08 17:00:00	NVDA	Stock	1.7838	1.7862	1.7802	1.7852	347440.0
2016-11-08 18:00:00	NVDA	Stock	1.7855	1.787	1.7835	1.787	237000.0
2016-11-08 19:00:00	NVDA	Stock	1.787	1.7875	1.7802	1.7825	414440.0
2016-11-08 06:00:00	AMZN	Stock	39.263	39.3	39.263	39.2875	9080.0
2016-11-08 07:00:00	AMZN	Stock	39.2835	39.2835	39.225	39.225	12000.0
2016-11-08 08:00:00	AMZN	Stock	39.282	39.2875	39.1	39.105	161140.0
2016-11-08 09:00:00	AMZN	Stock	39.125	39.341	39.0135	39.0792	9239120.0
2016-11-08 10:00:00	AMZN	Stock	39.079	39.1295	38.955	39.0825	7568520.0
2016-11-08 11:00:00	AMZN	Stock	39.0965	39.444	39.0125	39.4317	9893180.0
2016-11-08 12:00:00	AMZN	Stock	39.443	39.587	39.409	39.5146	8299620.0
2016-11-08 13:00:00	AMZN	Stock	39.5155	39.5285	39.3345	39.35	5517080.0

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

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