PREVIEW / stock_1hour / 2016-08-16

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-16.parquet
  size:    1.0 MB
  rows:    48,921
  symbols: 3,276

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-08-16 04:00:00	AAPL	Stock	27.4975	27.4975	27.4275	27.475	64216.0
2016-08-16 05:00:00	AAPL	Stock	27.4975	27.4975	27.465	27.465	9380.0
2016-08-16 06:00:00	AAPL	Stock	27.465	27.485	27.415	27.485	75416.0
2016-08-16 07:00:00	AAPL	Stock	27.4825	27.4975	27.4	27.435	206812.0
2016-08-16 08:00:00	AAPL	Stock	27.435	27.485	27.4	27.4325	454428.0
2016-08-16 09:00:00	AAPL	Stock	27.4225	27.53	27.375	27.5	26773764.0
2016-08-16 10:00:00	AAPL	Stock	27.505	27.5575	27.4475	27.4715	19655412.0
2016-08-16 11:00:00	AAPL	Stock	27.47	27.5	27.46	27.4875	9213612.0
2016-08-16 12:00:00	AAPL	Stock	27.485	27.495	27.45	27.4612	10115340.0
2016-08-16 13:00:00	AAPL	Stock	27.4612	27.4625	27.3275	27.3678	12685088.0
2016-08-16 14:00:00	AAPL	Stock	27.3675	27.42	27.3025	27.41	11404512.0
2016-08-16 15:00:00	AAPL	Stock	27.41	27.445	27.34	27.345	17294524.0
2016-08-16 16:00:00	AAPL	Stock	27.345	27.37	27.3325	27.35	9176552.0
2016-08-16 17:00:00	AAPL	Stock	27.35	27.37	27.34	27.35	37296.0
2016-08-16 18:00:00	AAPL	Stock	27.35	27.3575	27.3175	27.3525	52948.0
2016-08-16 19:00:00	AAPL	Stock	27.35	27.3575	27.345	27.345	27344.0
2016-08-16 04:00:00	MSFT	Stock	58.06	58.06	57.89	57.89	1428.0
2016-08-16 07:00:00	MSFT	Stock	57.89	57.89	57.77	57.78	1715.0
2016-08-16 08:00:00	MSFT	Stock	57.8	57.8	57.7	57.7	7255.0
2016-08-16 09:00:00	MSFT	Stock	57.75	57.75	57.27	57.295	2898572.0
2016-08-16 10:00:00	MSFT	Stock	57.29	57.55	57.29	57.48	2699864.0
2016-08-16 11:00:00	MSFT	Stock	57.475	57.57	57.413	57.43	2447513.0
2016-08-16 12:00:00	MSFT	Stock	57.42	57.5	57.37	57.495	1629917.0
2016-08-16 13:00:00	MSFT	Stock	57.495	57.5	57.39	57.45	1346690.0
2016-08-16 14:00:00	MSFT	Stock	57.455	57.48	57.37	57.445	1679411.0
2016-08-16 15:00:00	MSFT	Stock	57.45	57.55	57.4	57.43	3427820.0
2016-08-16 16:00:00	MSFT	Stock	57.44	57.57	57.41	57.44	2088652.0
2016-08-16 17:00:00	MSFT	Stock	57.46	57.46	57.46	57.46	300.0
2016-08-16 18:00:00	MSFT	Stock	57.49	57.49	57.49	57.49	700.0
2016-08-16 19:00:00	MSFT	Stock	57.5	57.5	57.5	57.5	100.0
2016-08-16 08:00:00	NVDA	Stock	1.5613	1.57	1.56	1.567	839600.0
2016-08-16 09:00:00	NVDA	Stock	1.5663	1.5748	1.5602	1.572	49817800.0
2016-08-16 10:00:00	NVDA	Stock	1.5723	1.5743	1.562	1.5643	64165320.0
2016-08-16 11:00:00	NVDA	Stock	1.5643	1.5698	1.5635	1.5661	32236680.0
2016-08-16 12:00:00	NVDA	Stock	1.5662	1.5715	1.5658	1.5703	36592720.0
2016-08-16 13:00:00	NVDA	Stock	1.5705	1.5705	1.5652	1.5655	22831920.0
2016-08-16 14:00:00	NVDA	Stock	1.5655	1.568	1.5625	1.5674	24326000.0
2016-08-16 15:00:00	NVDA	Stock	1.5672	1.5693	1.565	1.565	46665920.0
2016-08-16 16:00:00	NVDA	Stock	1.565	1.569	1.565	1.5655	2384000.0
2016-08-16 17:00:00	NVDA	Stock	1.567	1.567	1.567	1.567	19160.0
2016-08-16 18:00:00	NVDA	Stock	1.5655	1.5655	1.5655	1.5655	8000.0
2016-08-16 19:00:00	NVDA	Stock	1.5675	1.5675	1.5658	1.5658	14000.0
2016-08-16 07:00:00	AMZN	Stock	38.4215	38.4215	38.375	38.4125	9340.0
2016-08-16 08:00:00	AMZN	Stock	38.394	38.495	38.371	38.3975	223640.0
2016-08-16 09:00:00	AMZN	Stock	38.3805	38.4366	38.191	38.2195	4488440.0
2016-08-16 10:00:00	AMZN	Stock	38.219	38.306	38.2	38.2345	3444300.0
2016-08-16 11:00:00	AMZN	Stock	38.2252	38.3315	38.2252	38.3045	2355080.0
2016-08-16 12:00:00	AMZN	Stock	38.2983	38.305	38.265	38.2965	1106240.0
2016-08-16 13:00:00	AMZN	Stock	38.2925	38.305	38.2232	38.2572	1918680.0
2016-08-16 14:00:00	AMZN	Stock	38.261	38.2725	38.2063	38.2348	3628180.0

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

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