PREVIEW / stock_1hour / 2016-09-06

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-06.parquet
  size:    1.0 MB
  rows:    49,543
  symbols: 3,271

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-06 04:00:00	AAPL	Stock	26.985	27.0	26.97	26.9925	36076.0
2016-09-06 05:00:00	AAPL	Stock	26.97	27.0	26.97	27.0	10480.0
2016-09-06 06:00:00	AAPL	Stock	27.035	27.045	26.99	26.99	6028.0
2016-09-06 07:00:00	AAPL	Stock	27.0175	27.0425	27.0	27.0125	174536.0
2016-09-06 08:00:00	AAPL	Stock	27.0	27.04	26.985	27.0125	297680.0
2016-09-06 09:00:00	AAPL	Stock	27.0125	27.075	26.9375	27.0275	17656420.0
2016-09-06 10:00:00	AAPL	Stock	27.025	27.05	26.91	26.965	15322476.0
2016-09-06 11:00:00	AAPL	Stock	26.9625	26.9975	26.945	26.97	8327800.0
2016-09-06 12:00:00	AAPL	Stock	26.9685	26.9875	26.95	26.98	6475416.0
2016-09-06 13:00:00	AAPL	Stock	26.9812	26.985	26.885	26.9115	9119120.0
2016-09-06 14:00:00	AAPL	Stock	26.9112	26.92	26.8775	26.9	7071712.0
2016-09-06 15:00:00	AAPL	Stock	26.9025	26.9338	26.895	26.925	12464268.0
2016-09-06 16:00:00	AAPL	Stock	26.925	26.929	26.9025	26.925	22590060.0
2016-09-06 17:00:00	AAPL	Stock	26.925	26.935	26.905	26.925	119964.0
2016-09-06 18:00:00	AAPL	Stock	26.91	26.945	26.91	26.94	87312.0
2016-09-06 19:00:00	AAPL	Stock	26.9425	26.9675	26.9425	26.965	92744.0
2016-09-06 06:00:00	MSFT	Stock	57.79	57.79	57.79	57.79	240.0
2016-09-06 07:00:00	MSFT	Stock	57.67	57.67	57.65	57.65	840.0
2016-09-06 08:00:00	MSFT	Stock	57.73	57.78	57.7	57.78	2770.0
2016-09-06 09:00:00	MSFT	Stock	57.78	57.8	57.4	57.475	2040143.0
2016-09-06 10:00:00	MSFT	Stock	57.47	57.53	57.21	57.44	2483151.0
2016-09-06 11:00:00	MSFT	Stock	57.445	57.53	57.39	57.49	1581855.0
2016-09-06 12:00:00	MSFT	Stock	57.485	57.61	57.46	57.555	1279889.0
2016-09-06 13:00:00	MSFT	Stock	57.55	57.59	57.53	57.55	1053418.0
2016-09-06 14:00:00	MSFT	Stock	57.56	57.6	57.51	57.6	1198675.0
2016-09-06 15:00:00	MSFT	Stock	57.6	57.6	57.54	57.6	2453730.0
2016-09-06 16:00:00	MSFT	Stock	57.6	57.62	57.59	57.62	2890122.0
2016-09-06 17:00:00	MSFT	Stock	57.62	57.62	57.62	57.62	1178.0
2016-09-06 18:00:00	MSFT	Stock	57.62	57.62	57.62	57.62	3460.0
2016-09-06 19:00:00	MSFT	Stock	57.58	57.58	57.58	57.58	378.0
2016-09-06 04:00:00	NVDA	Stock	1.56	1.56	1.56	1.56	4000.0
2016-09-06 05:00:00	NVDA	Stock	1.5675	1.5675	1.5675	1.5675	5200.0
2016-09-06 06:00:00	NVDA	Stock	1.5688	1.5688	1.5688	1.5688	80000.0
2016-09-06 08:00:00	NVDA	Stock	1.5628	1.5725	1.5628	1.57	248080.0
2016-09-06 09:00:00	NVDA	Stock	1.5675	1.57	1.5607	1.5693	39192560.0
2016-09-06 10:00:00	NVDA	Stock	1.5688	1.575	1.5659	1.5693	58357200.0
2016-09-06 11:00:00	NVDA	Stock	1.5693	1.572	1.5636	1.5668	30044720.0
2016-09-06 12:00:00	NVDA	Stock	1.5668	1.5732	1.5668	1.5725	26054560.0
2016-09-06 13:00:00	NVDA	Stock	1.5723	1.5731	1.5675	1.5689	24557800.0
2016-09-06 14:00:00	NVDA	Stock	1.5685	1.5718	1.5643	1.5705	27748640.0
2016-09-06 15:00:00	NVDA	Stock	1.5706	1.578	1.5706	1.578	71849800.0
2016-09-06 16:00:00	NVDA	Stock	1.578	1.5788	1.5568	1.5688	2243920.0
2016-09-06 17:00:00	NVDA	Stock	1.5602	1.578	1.5602	1.569	523240.0
2016-09-06 18:00:00	NVDA	Stock	1.563	1.5693	1.5625	1.5693	144480.0
2016-09-06 19:00:00	NVDA	Stock	1.5743	1.5755	1.5712	1.5755	431120.0
2016-09-06 06:00:00	AMZN	Stock	38.75	38.75	38.75	38.75	3160.0
2016-09-06 07:00:00	AMZN	Stock	38.7195	38.725	38.7195	38.725	9000.0
2016-09-06 08:00:00	AMZN	Stock	38.6875	38.7415	38.6875	38.6965	149400.0
2016-09-06 09:00:00	AMZN	Stock	38.696	38.941	38.511	38.8785	10711660.0
2016-09-06 10:00:00	AMZN	Stock	38.8705	39.029	38.8555	39.0235	10630760.0

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

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