PREVIEW / stock_1hour / 2016-11-07

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-07.parquet
  size:    1.0 MB
  rows:    48,237
  symbols: 3,165

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-11-07 04:00:00	AAPL	Stock	27.6625	27.7025	27.5875	27.6675	14704.0
2016-11-07 05:00:00	AAPL	Stock	27.665	27.665	27.615	27.615	18592.0
2016-11-07 06:00:00	AAPL	Stock	27.635	27.6375	27.54	27.5925	40636.0
2016-11-07 07:00:00	AAPL	Stock	27.5875	27.5875	27.5375	27.5625	107728.0
2016-11-07 08:00:00	AAPL	Stock	27.57	27.6075	27.47	27.4775	453220.0
2016-11-07 09:00:00	AAPL	Stock	27.49	27.625	27.365	27.435	22266036.0
2016-11-07 10:00:00	AAPL	Stock	27.4325	27.5075	27.3875	27.475	18575884.0
2016-11-07 11:00:00	AAPL	Stock	27.475	27.5172	27.465	27.5125	15714180.0
2016-11-07 12:00:00	AAPL	Stock	27.5125	27.5238	27.485	27.52	10062552.0
2016-11-07 13:00:00	AAPL	Stock	27.52	27.6125	27.5025	27.6112	10846448.0
2016-11-07 14:00:00	AAPL	Stock	27.612	27.6225	27.4325	27.4825	11859080.0
2016-11-07 15:00:00	AAPL	Stock	27.4812	27.6275	27.46	27.6025	17559108.0
2016-11-07 16:00:00	AAPL	Stock	27.59	27.615	27.4915	27.6025	12275308.0
2016-11-07 17:00:00	AAPL	Stock	27.605	27.61	27.5825	27.585	38724.0
2016-11-07 18:00:00	AAPL	Stock	27.5975	27.6125	27.5975	27.6	27748.0
2016-11-07 19:00:00	AAPL	Stock	27.5875	27.6	27.5825	27.585	39976.0
2016-11-07 04:00:00	MSFT	Stock	59.74	59.74	59.74	59.74	520.0
2016-11-07 06:00:00	MSFT	Stock	59.64	59.64	59.64	59.64	1000.0
2016-11-07 07:00:00	MSFT	Stock	59.64	59.69	59.43	59.52	9870.0
2016-11-07 08:00:00	MSFT	Stock	59.58	59.6	59.39	59.56	34162.0
2016-11-07 09:00:00	MSFT	Stock	59.6	60.3	59.55	60.13	4834214.0
2016-11-07 10:00:00	MSFT	Stock	60.14	60.4	60.1	60.39	3702477.0
2016-11-07 11:00:00	MSFT	Stock	60.39	60.486	60.34	60.47	3487846.0
2016-11-07 12:00:00	MSFT	Stock	60.475	60.52	60.41	60.46	2181081.0
2016-11-07 13:00:00	MSFT	Stock	60.47	60.5	60.41	60.475	1725932.0
2016-11-07 14:00:00	MSFT	Stock	60.475	60.49	60.285	60.341	2512422.0
2016-11-07 15:00:00	MSFT	Stock	60.35	60.48	60.29	60.42	5795090.0
2016-11-07 16:00:00	MSFT	Stock	60.425	60.75	60.42	60.75	5287718.0
2016-11-07 18:00:00	MSFT	Stock	60.57	60.57	60.47	60.53	3248.0
2016-11-07 19:00:00	MSFT	Stock	60.43	60.52	60.43	60.52	660.0
2016-11-07 04:00:00	NVDA	Stock	1.722	1.725	1.722	1.725	12000.0
2016-11-07 06:00:00	NVDA	Stock	1.7278	1.7278	1.7278	1.7278	4000.0
2016-11-07 07:00:00	NVDA	Stock	1.7305	1.7362	1.7268	1.7305	318680.0
2016-11-07 08:00:00	NVDA	Stock	1.7278	1.737	1.7265	1.735	837320.0
2016-11-07 09:00:00	NVDA	Stock	1.735	1.767	1.7338	1.757	84292800.0
2016-11-07 10:00:00	NVDA	Stock	1.7568	1.7768	1.7555	1.7712	75484080.0
2016-11-07 11:00:00	NVDA	Stock	1.7711	1.7842	1.7698	1.7841	48633000.0
2016-11-07 12:00:00	NVDA	Stock	1.7842	1.793	1.779	1.781	39375080.0
2016-11-07 13:00:00	NVDA	Stock	1.781	1.787	1.7774	1.7828	30686880.0
2016-11-07 14:00:00	NVDA	Stock	1.7828	1.7832	1.7665	1.77	37638080.0
2016-11-07 15:00:00	NVDA	Stock	1.7702	1.7825	1.7688	1.7815	89218040.0
2016-11-07 16:00:00	NVDA	Stock	1.7818	1.7835	1.7696	1.7818	28818240.0
2016-11-07 17:00:00	NVDA	Stock	1.7838	1.7888	1.782	1.785	205720.0
2016-11-07 18:00:00	NVDA	Stock	1.782	1.787	1.782	1.7865	67040.0
2016-11-07 19:00:00	NVDA	Stock	1.782	1.782	1.782	1.782	4000.0
2016-11-07 04:00:00	AMZN	Stock	38.4625	38.599	38.4625	38.5485	12280.0
2016-11-07 05:00:00	AMZN	Stock	38.5485	38.5485	38.4805	38.5445	33660.0
2016-11-07 06:00:00	AMZN	Stock	38.5	38.5025	38.467	38.4785	16740.0
2016-11-07 07:00:00	AMZN	Stock	38.5385	38.5385	38.363	38.392	86660.0
2016-11-07 08:00:00	AMZN	Stock	38.4	38.45	38.365	38.4	303500.0

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

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