PREVIEW / stock_1hour / 2016-12-06

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-06.parquet
  size:    1.1 MB
  rows:    49,146
  symbols: 3,155

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-06 04:00:00	AAPL	Stock	27.335	27.335	27.275	27.275	2876.0
2016-12-06 05:00:00	AAPL	Stock	27.2775	27.2775	27.2775	27.2775	400.0
2016-12-06 06:00:00	AAPL	Stock	27.28	27.3875	27.28	27.3125	14928.0
2016-12-06 07:00:00	AAPL	Stock	27.3125	27.6125	27.3125	27.6	193092.0
2016-12-06 08:00:00	AAPL	Stock	27.5875	27.6	27.325	27.555	388976.0
2016-12-06 09:00:00	AAPL	Stock	27.5575	27.5832	27.3125	27.575	18887616.0
2016-12-06 10:00:00	AAPL	Stock	27.575	27.59	27.3625	27.41	16149516.0
2016-12-06 11:00:00	AAPL	Stock	27.41	27.4225	27.2975	27.3725	10745812.0
2016-12-06 12:00:00	AAPL	Stock	27.3725	27.4225	27.3525	27.365	7446336.0
2016-12-06 13:00:00	AAPL	Stock	27.3652	27.44	27.3375	27.4275	6874984.0
2016-12-06 14:00:00	AAPL	Stock	27.4275	27.4575	27.3875	27.4462	8544480.0
2016-12-06 15:00:00	AAPL	Stock	27.4475	27.5075	27.385	27.485	18630112.0
2016-12-06 16:00:00	AAPL	Stock	27.4875	27.495	27.445	27.4875	8173644.0
2016-12-06 17:00:00	AAPL	Stock	27.4725	27.475	27.4675	27.4725	38116.0
2016-12-06 18:00:00	AAPL	Stock	27.4725	27.4875	27.4725	27.4775	12200.0
2016-12-06 19:00:00	AAPL	Stock	27.485	27.4875	27.4775	27.4825	27124.0
2016-12-06 06:00:00	MSFT	Stock	60.52	60.52	60.52	60.52	431.0
2016-12-06 07:00:00	MSFT	Stock	60.48	60.48	60.48	60.48	100.0
2016-12-06 08:00:00	MSFT	Stock	60.48	60.48	60.48	60.48	300.0
2016-12-06 09:00:00	MSFT	Stock	60.39	60.46	59.8	60.2	2520119.0
2016-12-06 10:00:00	MSFT	Stock	60.195	60.345	59.95	60.11	2917855.0
2016-12-06 11:00:00	MSFT	Stock	60.105	60.12	59.95	60.095	2354308.0
2016-12-06 12:00:00	MSFT	Stock	60.1	60.169	59.96	59.985	1336969.0
2016-12-06 13:00:00	MSFT	Stock	59.98	60.07	59.9	60.026	1512690.0
2016-12-06 14:00:00	MSFT	Stock	60.03	60.13	59.98	60.11	1802930.0
2016-12-06 15:00:00	MSFT	Stock	60.11	60.15	59.92	59.95	3489373.0
2016-12-06 16:00:00	MSFT	Stock	59.95	60.0	59.91	59.95	2172475.0
2016-12-06 17:00:00	MSFT	Stock	59.95	59.95	59.95	59.95	584.0
2016-12-06 18:00:00	MSFT	Stock	59.99	59.99	59.99	59.99	100.0
2016-12-06 19:00:00	MSFT	Stock	59.99	59.99	59.97	59.97	300.0
2016-12-06 06:00:00	NVDA	Stock	2.31	2.31	2.3073	2.3075	52000.0
2016-12-06 07:00:00	NVDA	Stock	2.3113	2.3113	2.31	2.31	24000.0
2016-12-06 08:00:00	NVDA	Stock	2.311	2.3177	2.3075	2.3125	689600.0
2016-12-06 09:00:00	NVDA	Stock	2.315	2.3348	2.2892	2.3343	81071520.0
2016-12-06 10:00:00	NVDA	Stock	2.334	2.3433	2.3115	2.3165	97247600.0
2016-12-06 11:00:00	NVDA	Stock	2.3162	2.3175	2.2962	2.3005	45413240.0
2016-12-06 12:00:00	NVDA	Stock	2.3002	2.309	2.2913	2.2978	43763520.0
2016-12-06 13:00:00	NVDA	Stock	2.2975	2.3155	2.295	2.309	30003880.0
2016-12-06 14:00:00	NVDA	Stock	2.3095	2.327	2.3088	2.327	45296880.0
2016-12-06 15:00:00	NVDA	Stock	2.327	2.335	2.3105	2.3348	85862120.0
2016-12-06 16:00:00	NVDA	Stock	2.3348	2.3358	2.332	2.3348	12960680.0
2016-12-06 17:00:00	NVDA	Stock	2.3335	2.3438	2.3335	2.3438	593760.0
2016-12-06 18:00:00	NVDA	Stock	2.3422	2.3425	2.3395	2.3395	87600.0
2016-12-06 19:00:00	NVDA	Stock	2.34	2.3408	2.34	2.34	55440.0
2016-12-06 05:00:00	AMZN	Stock	38.065	38.065	38.065	38.065	2000.0
2016-12-06 06:00:00	AMZN	Stock	38.1415	38.1415	38.135	38.1385	8000.0
2016-12-06 07:00:00	AMZN	Stock	38.088	38.1435	38.06	38.135	82360.0
2016-12-06 08:00:00	AMZN	Stock	38.06	38.1875	38.06	38.1355	321080.0
2016-12-06 09:00:00	AMZN	Stock	38.1355	38.398	37.8625	38.3751	14348180.0
2016-12-06 10:00:00	AMZN	Stock	38.3782	38.412	38.222	38.3475	8413100.0

> showing 50 of 49,146 rows — these rows as CSV

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