PREVIEW / stock_1hour / 2016-03-24

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-24.parquet
  size:    1024 KB
  rows:    47,562
  symbols: 3,309

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-03-24 04:00:00	AAPL	Stock	26.505	26.505	26.48	26.48	800.0
2016-03-24 05:00:00	AAPL	Stock	26.4375	26.4375	26.4375	26.4375	1996.0
2016-03-24 06:00:00	AAPL	Stock	26.4325	26.4375	26.3825	26.42	8400.0
2016-03-24 07:00:00	AAPL	Stock	26.42	26.425	26.4	26.4	33572.0
2016-03-24 08:00:00	AAPL	Stock	26.41	26.4475	26.4	26.4175	125112.0
2016-03-24 09:00:00	AAPL	Stock	26.4175	26.5625	26.3538	26.4075	13839384.0
2016-03-24 10:00:00	AAPL	Stock	26.4075	26.43	26.2225	26.2898	22199728.0
2016-03-24 11:00:00	AAPL	Stock	26.2912	26.3975	26.2912	26.3975	11518080.0
2016-03-24 12:00:00	AAPL	Stock	26.395	26.43	26.3	26.355	9009016.0
2016-03-24 13:00:00	AAPL	Stock	26.355	26.3975	26.3275	26.3712	6759216.0
2016-03-24 14:00:00	AAPL	Stock	26.3725	26.447	26.3325	26.4225	8746196.0
2016-03-24 15:00:00	AAPL	Stock	26.4238	26.4625	26.39	26.415	13983432.0
2016-03-24 16:00:00	AAPL	Stock	26.4175	26.425	26.3675	26.405	8172888.0
2016-03-24 17:00:00	AAPL	Stock	26.4125	26.425	26.4075	26.42	12000.0
2016-03-24 18:00:00	AAPL	Stock	26.42	26.425	26.4075	26.4125	26912.0
2016-03-24 19:00:00	AAPL	Stock	26.4225	26.425	26.4075	26.4225	43356.0
2016-03-24 08:00:00	MSFT	Stock	53.79	53.79	53.52	53.52	2098.0
2016-03-24 09:00:00	MSFT	Stock	53.57	54.18	53.57	54.17	2533298.0
2016-03-24 10:00:00	MSFT	Stock	54.17	54.32	53.94	54.295	2028496.0
2016-03-24 11:00:00	MSFT	Stock	54.28	54.33	54.13	54.275	1766043.0
2016-03-24 12:00:00	MSFT	Stock	54.27	54.33	53.93	54.08	1735284.0
2016-03-24 13:00:00	MSFT	Stock	54.07	54.21	54.044	54.136	1441960.0
2016-03-24 14:00:00	MSFT	Stock	54.13	54.22	54.06	54.16	1845599.0
2016-03-24 15:00:00	MSFT	Stock	54.16	54.23	54.1	54.21	2766309.0
2016-03-24 16:00:00	MSFT	Stock	54.21	54.29	54.19	54.29	2465320.0
2016-03-24 17:00:00	MSFT	Stock	54.22	54.22	54.22	54.22	1000.0
2016-03-24 18:00:00	MSFT	Stock	54.22	54.28	54.21	54.21	3516.0
2016-03-24 19:00:00	MSFT	Stock	54.22	54.22	54.22	54.22	500.0
2016-03-24 08:00:00	NVDA	Stock	0.8562	0.8562	0.8525	0.8538	32000.0
2016-03-24 09:00:00	NVDA	Stock	0.8585	0.8608	0.8502	0.8582	29726960.0
2016-03-24 10:00:00	NVDA	Stock	0.8585	0.8606	0.8562	0.8596	33439160.0
2016-03-24 11:00:00	NVDA	Stock	0.8598	0.8635	0.859	0.8606	26121680.0
2016-03-24 12:00:00	NVDA	Stock	0.8605	0.863	0.8592	0.8602	24842880.0
2016-03-24 13:00:00	NVDA	Stock	0.86	0.8626	0.8582	0.8603	20207360.0
2016-03-24 14:00:00	NVDA	Stock	0.8604	0.8608	0.8575	0.8606	29471280.0
2016-03-24 15:00:00	NVDA	Stock	0.8608	0.863	0.86	0.862	41075320.0
2016-03-24 16:00:00	NVDA	Stock	0.862	0.863	0.862	0.863	24711280.0
2016-03-24 18:00:00	NVDA	Stock	0.8602	0.8602	0.8602	0.8602	4000.0
2016-03-24 05:00:00	AMZN	Stock	28.25	28.35	28.25	28.35	4400.0
2016-03-24 06:00:00	AMZN	Stock	28.275	28.3	28.275	28.3	4000.0
2016-03-24 07:00:00	AMZN	Stock	28.344	28.3815	28.344	28.376	130340.0
2016-03-24 08:00:00	AMZN	Stock	28.375	28.4	28.3305	28.3305	146660.0
2016-03-24 09:00:00	AMZN	Stock	28.3305	28.6915	28.3	28.6765	13000980.0
2016-03-24 10:00:00	AMZN	Stock	28.664	28.8945	28.6595	28.8652	17076440.0
2016-03-24 11:00:00	AMZN	Stock	28.8655	28.9495	28.828	28.8855	8585680.0
2016-03-24 12:00:00	AMZN	Stock	28.872	29.032	28.847	28.8485	10938160.0
2016-03-24 13:00:00	AMZN	Stock	28.8492	28.9485	28.8435	28.9045	5155220.0
2016-03-24 14:00:00	AMZN	Stock	28.911	29.079	28.8735	29.0075	11242860.0
2016-03-24 15:00:00	AMZN	Stock	29.0125	29.1775	28.9655	29.1475	18620120.0
2016-03-24 16:00:00	AMZN	Stock	29.1475	29.199	29.121	29.1445	1600980.0

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

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