PREVIEW / stock_1hour / 2016-12-27

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-27.parquet
  size:    1.0 MB
  rows:    48,272
  symbols: 3,165

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-12-27 05:00:00	AAPL	Stock	29.1375	29.1375	29.1375	29.1375	400.0
2016-12-27 06:00:00	AAPL	Stock	29.1725	29.1725	29.1725	29.1725	864.0
2016-12-27 07:00:00	AAPL	Stock	29.225	29.23	29.185	29.185	29960.0
2016-12-27 08:00:00	AAPL	Stock	29.225	29.225	29.1625	29.1775	56664.0
2016-12-27 09:00:00	AAPL	Stock	29.17	29.445	29.1225	29.4438	17822504.0
2016-12-27 10:00:00	AAPL	Stock	29.4438	29.45	29.365	29.4075	10700296.0
2016-12-27 11:00:00	AAPL	Stock	29.4062	29.4375	29.385	29.4	6874012.0
2016-12-27 12:00:00	AAPL	Stock	29.4025	29.4025	29.335	29.3725	5401584.0
2016-12-27 13:00:00	AAPL	Stock	29.3725	29.4075	29.365	29.3825	4923904.0
2016-12-27 14:00:00	AAPL	Stock	29.38	29.3975	29.35	29.3525	4804332.0
2016-12-27 15:00:00	AAPL	Stock	29.3535	29.3688	29.3	29.3125	9821592.0
2016-12-27 16:00:00	AAPL	Stock	29.315	29.325	29.305	29.3125	6142992.0
2016-12-27 17:00:00	AAPL	Stock	29.3125	29.345	29.3125	29.325	52984.0
2016-12-27 18:00:00	AAPL	Stock	29.325	29.345	29.3125	29.325	18632.0
2016-12-27 19:00:00	AAPL	Stock	29.325	29.3425	29.315	29.315	19016.0
2016-12-27 06:00:00	MSFT	Stock	63.45	63.45	63.45	63.45	100.0
2016-12-27 08:00:00	MSFT	Stock	63.22	63.4	63.22	63.4	1220.0
2016-12-27 09:00:00	MSFT	Stock	63.21	64.07	63.21	63.93	2347647.0
2016-12-27 10:00:00	MSFT	Stock	63.93	63.97	63.64	63.65	1539819.0
2016-12-27 11:00:00	MSFT	Stock	63.65	63.74	63.48	63.48	1244558.0
2016-12-27 12:00:00	MSFT	Stock	63.48	63.506	63.32	63.4	933544.0
2016-12-27 13:00:00	MSFT	Stock	63.405	63.48	63.38	63.404	791119.0
2016-12-27 14:00:00	MSFT	Stock	63.4	63.42	63.31	63.314	805747.0
2016-12-27 15:00:00	MSFT	Stock	63.315	63.37	63.23	63.27	1923072.0
2016-12-27 16:00:00	MSFT	Stock	63.28	63.28	63.19	63.28	1419502.0
2016-12-27 17:00:00	MSFT	Stock	63.28	63.28	63.22	63.22	1471.0
2016-12-27 18:00:00	MSFT	Stock	63.28	63.28	63.22	63.22	12378.0
2016-12-27 04:00:00	NVDA	Stock	2.7575	2.8	2.7575	2.7863	156480.0
2016-12-27 05:00:00	NVDA	Stock	2.805	2.8155	2.8	2.8	88000.0
2016-12-27 06:00:00	NVDA	Stock	2.8075	2.81	2.8025	2.8052	243840.0
2016-12-27 07:00:00	NVDA	Stock	2.8038	2.8038	2.7852	2.7895	350600.0
2016-12-27 08:00:00	NVDA	Stock	2.7882	2.8088	2.7812	2.7845	3865960.0
2016-12-27 09:00:00	NVDA	Stock	2.7815	2.8543	2.7805	2.848	183353400.0
2016-12-27 10:00:00	NVDA	Stock	2.8478	2.8965	2.8452	2.8948	216222360.0
2016-12-27 11:00:00	NVDA	Stock	2.8942	2.9163	2.8772	2.9011	189581880.0
2016-12-27 12:00:00	NVDA	Stock	2.9011	2.9079	2.8795	2.8863	132178280.0
2016-12-27 13:00:00	NVDA	Stock	2.8863	2.9145	2.88	2.9072	125821240.0
2016-12-27 14:00:00	NVDA	Stock	2.907	2.92	2.8972	2.9095	115594520.0
2016-12-27 15:00:00	NVDA	Stock	2.9095	2.934	2.9005	2.933	203887040.0
2016-12-27 16:00:00	NVDA	Stock	2.9338	2.9483	2.932	2.943	6323920.0
2016-12-27 17:00:00	NVDA	Stock	2.9448	2.9633	2.9448	2.954	3006040.0
2016-12-27 18:00:00	NVDA	Stock	2.9563	2.972	2.9525	2.9625	1987360.0
2016-12-27 19:00:00	NVDA	Stock	2.9633	2.972	2.9608	2.972	966960.0
2016-12-27 07:00:00	AMZN	Stock	38.1	38.1	38.1	38.1	3000.0
2016-12-27 08:00:00	AMZN	Stock	38.1125	38.1275	38.098	38.115	104720.0
2016-12-27 09:00:00	AMZN	Stock	38.115	38.505	38.06	38.475	10326420.0
2016-12-27 10:00:00	AMZN	Stock	38.4926	38.6845	38.468	38.6614	12020460.0
2016-12-27 11:00:00	AMZN	Stock	38.6612	38.7325	38.5585	38.5915	7993580.0
2016-12-27 12:00:00	AMZN	Stock	38.58	38.6495	38.522	38.646	3932200.0
2016-12-27 13:00:00	AMZN	Stock	38.6408	38.672	38.596	38.6575	3935720.0

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

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