PREVIEW / stock_1hour / 2016-09-19

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-19.parquet
  size:    1.0 MB
  rows:    48,156
  symbols: 3,223

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-19 04:00:00	AAPL	Stock	28.7625	28.8625	28.7625	28.8575	11840.0
2016-09-19 05:00:00	AAPL	Stock	28.8325	28.8425	28.8325	28.8375	65484.0
2016-09-19 06:00:00	AAPL	Stock	28.825	28.8575	28.7875	28.7925	130000.0
2016-09-19 07:00:00	AAPL	Stock	28.8125	28.85	28.61	28.705	325540.0
2016-09-19 08:00:00	AAPL	Stock	28.72	28.9025	28.625	28.86	1557692.0
2016-09-19 09:00:00	AAPL	Stock	28.86	29.045	28.76	28.7825	35527600.0
2016-09-19 10:00:00	AAPL	Stock	28.78	28.807	28.4625	28.5028	36140456.0
2016-09-19 11:00:00	AAPL	Stock	28.5025	28.6075	28.48	28.58	17127052.0
2016-09-19 12:00:00	AAPL	Stock	28.58	28.5925	28.325	28.37	24990328.0
2016-09-19 13:00:00	AAPL	Stock	28.3685	28.4625	28.3125	28.3962	14273516.0
2016-09-19 14:00:00	AAPL	Stock	28.395	28.5325	28.3925	28.5045	14252128.0
2016-09-19 15:00:00	AAPL	Stock	28.505	28.5075	28.345	28.3825	23852000.0
2016-09-19 16:00:00	AAPL	Stock	28.395	28.6625	28.3425	28.39	8680600.0
2016-09-19 17:00:00	AAPL	Stock	28.3925	28.3925	28.385	28.385	39992.0
2016-09-19 18:00:00	AAPL	Stock	28.39	28.3925	28.3775	28.3775	44828.0
2016-09-19 19:00:00	AAPL	Stock	28.3775	28.3875	28.35	28.35	189260.0
2016-09-19 08:00:00	MSFT	Stock	57.47	57.47	57.44	57.47	1235.0
2016-09-19 09:00:00	MSFT	Stock	57.39	57.75	57.26	57.745	2401533.0
2016-09-19 10:00:00	MSFT	Stock	57.75	57.75	57.44	57.465	2080359.0
2016-09-19 11:00:00	MSFT	Stock	57.47	57.57	57.33	57.37	2350183.0
2016-09-19 12:00:00	MSFT	Stock	57.36	57.38	57.02	57.059	2240469.0
2016-09-19 13:00:00	MSFT	Stock	57.05	57.176	56.85	56.99	1778369.0
2016-09-19 14:00:00	MSFT	Stock	56.98	57.25	56.97	57.22	1606620.0
2016-09-19 15:00:00	MSFT	Stock	57.223	57.24	56.91	56.93	3899406.0
2016-09-19 16:00:00	MSFT	Stock	56.93	57.216	56.93	57.1	2702199.0
2016-09-19 17:00:00	MSFT	Stock	56.96	57.08	56.96	57.08	800.0
2016-09-19 18:00:00	MSFT	Stock	56.98	57.07	56.98	57.07	3145.0
2016-09-19 19:00:00	MSFT	Stock	57.0	57.0	57.0	57.0	423.0
2016-09-19 04:00:00	NVDA	Stock	1.582	1.585	1.582	1.585	57200.0
2016-09-19 05:00:00	NVDA	Stock	1.585	1.585	1.585	1.585	4000.0
2016-09-19 07:00:00	NVDA	Stock	1.5912	1.5948	1.5912	1.5948	57200.0
2016-09-19 08:00:00	NVDA	Stock	1.5925	1.5925	1.5888	1.59	338480.0
2016-09-19 09:00:00	NVDA	Stock	1.5875	1.629	1.5803	1.626	94699960.0
2016-09-19 10:00:00	NVDA	Stock	1.626	1.6315	1.6025	1.6044	80084880.0
2016-09-19 11:00:00	NVDA	Stock	1.6043	1.61	1.6015	1.6067	43714320.0
2016-09-19 12:00:00	NVDA	Stock	1.6069	1.608	1.594	1.599	51795200.0
2016-09-19 13:00:00	NVDA	Stock	1.5985	1.5988	1.5878	1.5935	28680640.0
2016-09-19 14:00:00	NVDA	Stock	1.5932	1.603	1.5915	1.6012	31871360.0
2016-09-19 15:00:00	NVDA	Stock	1.6008	1.601	1.5892	1.5918	58333400.0
2016-09-19 16:00:00	NVDA	Stock	1.5918	1.5938	1.5918	1.5938	16965200.0
2016-09-19 17:00:00	NVDA	Stock	1.5925	1.5925	1.5918	1.5925	753680.0
2016-09-19 18:00:00	NVDA	Stock	1.5925	1.5925	1.5922	1.5922	28000.0
2016-09-19 19:00:00	NVDA	Stock	1.5922	1.5925	1.5922	1.5925	43000.0
2016-09-19 07:00:00	AMZN	Stock	39.13	39.13	39.05	39.05	72940.0
2016-09-19 08:00:00	AMZN	Stock	39.122	39.122	38.985	38.985	231100.0
2016-09-19 09:00:00	AMZN	Stock	38.9995	39.097	38.726	38.9385	11520000.0
2016-09-19 10:00:00	AMZN	Stock	38.944	38.944	38.6385	38.724	9116620.0
2016-09-19 11:00:00	AMZN	Stock	38.7355	38.85	38.684	38.8353	3710620.0
2016-09-19 12:00:00	AMZN	Stock	38.8295	38.8395	38.6625	38.7265	4238300.0
2016-09-19 13:00:00	AMZN	Stock	38.7205	38.764	38.55	38.6594	4247740.0

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

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