PREVIEW / stock_1hour / 2016-10-14

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-14.parquet
  size:    1.0 MB
  rows:    47,011
  symbols: 3,188

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-10-14 05:00:00	AAPL	Stock	29.3125	29.325	29.3125	29.325	6500.0
2016-10-14 06:00:00	AAPL	Stock	29.3225	29.425	29.3225	29.4	38576.0
2016-10-14 07:00:00	AAPL	Stock	29.415	29.43	29.38	29.43	149564.0
2016-10-14 08:00:00	AAPL	Stock	29.435	29.4975	29.1875	29.445	639460.0
2016-10-14 09:00:00	AAPL	Stock	29.45	29.5425	29.3725	29.3912	24187376.0
2016-10-14 10:00:00	AAPL	Stock	29.3925	29.4575	29.31	29.4125	19593388.0
2016-10-14 11:00:00	AAPL	Stock	29.415	29.42	29.2825	29.335	17148112.0
2016-10-14 12:00:00	AAPL	Stock	29.335	29.4275	29.3225	29.3975	11575300.0
2016-10-14 13:00:00	AAPL	Stock	29.395	29.475	29.345	29.3862	12090360.0
2016-10-14 14:00:00	AAPL	Stock	29.385	29.4225	29.3362	29.38	11334632.0
2016-10-14 15:00:00	AAPL	Stock	29.38	29.47	29.38	29.4075	21635868.0
2016-10-14 16:00:00	AAPL	Stock	29.4075	29.4275	29.395	29.4125	10450112.0
2016-10-14 17:00:00	AAPL	Stock	29.415	29.42	29.405	29.405	63784.0
2016-10-14 18:00:00	AAPL	Stock	29.405	29.41	29.39	29.41	30088.0
2016-10-14 19:00:00	AAPL	Stock	29.4125	29.4125	29.4	29.4075	24300.0
2016-10-14 07:00:00	MSFT	Stock	57.2	57.2	57.2	57.2	1800.0
2016-10-14 08:00:00	MSFT	Stock	57.2	57.2	57.16	57.17	4500.0
2016-10-14 09:00:00	MSFT	Stock	57.17	57.57	57.12	57.49	4104892.0
2016-10-14 10:00:00	MSFT	Stock	57.49	57.74	57.43	57.58	3863113.0
2016-10-14 11:00:00	MSFT	Stock	57.585	57.67	57.285	57.32	3051128.0
2016-10-14 12:00:00	MSFT	Stock	57.32	57.48	57.24	57.455	2523696.0
2016-10-14 13:00:00	MSFT	Stock	57.45	57.64	57.39	57.43	2396641.0
2016-10-14 14:00:00	MSFT	Stock	57.43	57.53	57.33	57.46	2053780.0
2016-10-14 15:00:00	MSFT	Stock	57.461	57.62	57.42	57.43	5169969.0
2016-10-14 16:00:00	MSFT	Stock	57.42	57.53	57.42	57.43	3037348.0
2016-10-14 17:00:00	MSFT	Stock	57.43	57.5	57.42	57.5	165325.0
2016-10-14 18:00:00	MSFT	Stock	57.49	57.49	57.45	57.45	839.0
2016-10-14 19:00:00	MSFT	Stock	57.45	57.48	57.43	57.43	1797.0
2016-10-14 05:00:00	NVDA	Stock	1.6488	1.6488	1.6488	1.6488	4000.0
2016-10-14 07:00:00	NVDA	Stock	1.6538	1.6538	1.6492	1.6492	22000.0
2016-10-14 08:00:00	NVDA	Stock	1.6618	1.6618	1.6415	1.6462	144080.0
2016-10-14 09:00:00	NVDA	Stock	1.6462	1.664	1.64	1.6585	38986120.0
2016-10-14 10:00:00	NVDA	Stock	1.6582	1.665	1.656	1.6612	41594760.0
2016-10-14 11:00:00	NVDA	Stock	1.6615	1.6622	1.6492	1.651	38074000.0
2016-10-14 12:00:00	NVDA	Stock	1.6512	1.659	1.6488	1.6582	100207160.0
2016-10-14 13:00:00	NVDA	Stock	1.6575	1.6638	1.6545	1.6573	27525720.0
2016-10-14 14:00:00	NVDA	Stock	1.657	1.6573	1.6465	1.648	29359520.0
2016-10-14 15:00:00	NVDA	Stock	1.648	1.654	1.648	1.6498	42828680.0
2016-10-14 16:00:00	NVDA	Stock	1.6498	1.652	1.6475	1.6475	1312880.0
2016-10-14 19:00:00	NVDA	Stock	1.6538	1.6538	1.6538	1.6538	40000.0
2016-10-14 07:00:00	AMZN	Stock	41.65	41.6525	41.6405	41.6405	11000.0
2016-10-14 08:00:00	AMZN	Stock	41.625	41.7425	41.622	41.7	359400.0
2016-10-14 09:00:00	AMZN	Stock	41.694	41.8175	41.616	41.6955	9828160.0
2016-10-14 10:00:00	AMZN	Stock	41.6865	41.719	41.5455	41.6001	6644140.0
2016-10-14 11:00:00	AMZN	Stock	41.6016	41.625	41.275	41.2901	8762220.0
2016-10-14 12:00:00	AMZN	Stock	41.2939	41.3185	41.1775	41.276	7621420.0
2016-10-14 13:00:00	AMZN	Stock	41.2715	41.314	41.2275	41.2545	3172280.0
2016-10-14 14:00:00	AMZN	Stock	41.2515	41.263	41.15	41.1755	4158980.0
2016-10-14 15:00:00	AMZN	Stock	41.1755	41.266	41.15	41.15	10084520.0
2016-10-14 16:00:00	AMZN	Stock	41.148	41.178	41.1185	41.122	1006380.0

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

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