PREVIEW / stock_1hour / 2016-10-28

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-28.parquet
  size:    1.0 MB
  rows:    47,011
  symbols: 3,184

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-10-28 04:00:00	AAPL	Stock	28.5	28.5	28.45	28.45	5600.0
2016-10-28 06:00:00	AAPL	Stock	28.495	28.56	28.495	28.56	22692.0
2016-10-28 07:00:00	AAPL	Stock	28.55	28.625	28.5275	28.55	23500.0
2016-10-28 08:00:00	AAPL	Stock	28.535	28.5825	28.5225	28.555	151864.0
2016-10-28 09:00:00	AAPL	Stock	28.55	28.7775	28.4625	28.7025	17228452.0
2016-10-28 10:00:00	AAPL	Stock	28.705	28.7338	28.59	28.6912	15952824.0
2016-10-28 11:00:00	AAPL	Stock	28.6925	28.7675	28.6825	28.75	10091716.0
2016-10-28 12:00:00	AAPL	Stock	28.7475	28.8025	28.7175	28.7715	9730364.0
2016-10-28 13:00:00	AAPL	Stock	28.77	28.785	28.375	28.3838	26263616.0
2016-10-28 14:00:00	AAPL	Stock	28.385	28.535	28.3625	28.4225	22366968.0
2016-10-28 15:00:00	AAPL	Stock	28.42	28.53	28.375	28.43	24034180.0
2016-10-28 16:00:00	AAPL	Stock	28.43	28.4475	28.4025	28.44	12205212.0
2016-10-28 17:00:00	AAPL	Stock	28.43	28.44	28.425	28.4275	50564.0
2016-10-28 18:00:00	AAPL	Stock	28.425	28.4325	28.4025	28.42	33804.0
2016-10-28 19:00:00	AAPL	Stock	28.42	28.4225	28.38	28.4025	32968.0
2016-10-28 04:00:00	MSFT	Stock	59.79	59.85	59.76	59.85	2600.0
2016-10-28 05:00:00	MSFT	Stock	59.89	59.89	59.89	59.89	500.0
2016-10-28 06:00:00	MSFT	Stock	60.0	60.01	59.94	60.01	2300.0
2016-10-28 07:00:00	MSFT	Stock	60.08	60.17	60.08	60.17	10908.0
2016-10-28 08:00:00	MSFT	Stock	60.2	60.23	60.1	60.14	17299.0
2016-10-28 09:00:00	MSFT	Stock	60.14	60.46	60.01	60.34	3654638.0
2016-10-28 10:00:00	MSFT	Stock	60.34	60.46	60.1	60.4	3975008.0
2016-10-28 11:00:00	MSFT	Stock	60.4	60.52	60.37	60.37	2036010.0
2016-10-28 12:00:00	MSFT	Stock	60.375	60.44	60.26	60.31	1655615.0
2016-10-28 13:00:00	MSFT	Stock	60.305	60.326	59.67	59.7	4920729.0
2016-10-28 14:00:00	MSFT	Stock	59.7	60.07	59.58	60.055	4250741.0
2016-10-28 15:00:00	MSFT	Stock	60.05	60.17	59.82	59.87	5446316.0
2016-10-28 16:00:00	MSFT	Stock	59.88	60.063	59.87	59.96	3024945.0
2016-10-28 17:00:00	MSFT	Stock	59.96	59.97	59.95	59.95	448.0
2016-10-28 18:00:00	MSFT	Stock	59.95	59.95	59.9	59.91	2200.0
2016-10-28 19:00:00	MSFT	Stock	59.89	59.95	59.89	59.95	200.0
2016-10-28 04:00:00	NVDA	Stock	1.7575	1.7575	1.755	1.755	15120.0
2016-10-28 07:00:00	NVDA	Stock	1.7692	1.7692	1.7692	1.7692	12000.0
2016-10-28 08:00:00	NVDA	Stock	1.7688	1.7698	1.7675	1.7675	41120.0
2016-10-28 09:00:00	NVDA	Stock	1.7675	1.7962	1.765	1.775	45523400.0
2016-10-28 10:00:00	NVDA	Stock	1.775	1.7998	1.7745	1.796	40806480.0
2016-10-28 11:00:00	NVDA	Stock	1.7965	1.8025	1.793	1.798	26943400.0
2016-10-28 12:00:00	NVDA	Stock	1.798	1.799	1.7848	1.7878	22497240.0
2016-10-28 13:00:00	NVDA	Stock	1.7878	1.7902	1.767	1.767	31512120.0
2016-10-28 14:00:00	NVDA	Stock	1.7675	1.777	1.762	1.7742	32295840.0
2016-10-28 15:00:00	NVDA	Stock	1.7738	1.7751	1.7608	1.764	48692000.0
2016-10-28 16:00:00	NVDA	Stock	1.764	1.7903	1.7625	1.7625	14609520.0
2016-10-28 17:00:00	NVDA	Stock	1.7625	1.7675	1.7625	1.7663	67200.0
2016-10-28 18:00:00	NVDA	Stock	1.769	1.769	1.769	1.769	4000.0
2016-10-28 19:00:00	NVDA	Stock	1.7688	1.769	1.7665	1.769	300000.0
2016-10-28 04:00:00	AMZN	Stock	38.6	38.75	38.6	38.72	46820.0
2016-10-28 05:00:00	AMZN	Stock	38.675	38.695	38.675	38.675	27940.0
2016-10-28 06:00:00	AMZN	Stock	38.7195	39.1	38.7195	39.0845	257080.0
2016-10-28 07:00:00	AMZN	Stock	39.0975	39.1505	39.003	39.0575	1343120.0
2016-10-28 08:00:00	AMZN	Stock	39.05	39.13	38.615	38.775	4045420.0

> showing 50 of 47,011 rows — these rows as CSV

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