PREVIEW / stock_1hour / 2017-04-13

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-04-13.parquet
  size:    1.0 MB
  rows:    47,644
  symbols: 3,048

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
2017-04-13 04:00:00	AAPL	Stock	35.4625	35.4625	35.4	35.4	4020.0
2017-04-13 06:00:00	AAPL	Stock	35.385	35.395	35.385	35.395	4400.0
2017-04-13 07:00:00	AAPL	Stock	35.375	35.375	35.355	35.3625	39604.0
2017-04-13 08:00:00	AAPL	Stock	35.3725	35.43	35.36	35.4	89960.0
2017-04-13 09:00:00	AAPL	Stock	35.4	35.5325	35.39	35.4965	9982700.0
2017-04-13 10:00:00	AAPL	Stock	35.4975	35.585	35.4968	35.5675	9019480.0
2017-04-13 11:00:00	AAPL	Stock	35.5675	35.595	35.5275	35.545	5673092.0
2017-04-13 12:00:00	AAPL	Stock	35.545	35.5475	35.4625	35.48	6168356.0
2017-04-13 13:00:00	AAPL	Stock	35.4825	35.495	35.3975	35.425	6097440.0
2017-04-13 14:00:00	AAPL	Stock	35.425	35.5075	35.425	35.4975	5739260.0
2017-04-13 15:00:00	AAPL	Stock	35.4975	35.5075	35.2625	35.2675	16123972.0
2017-04-13 16:00:00	AAPL	Stock	35.2625	35.3075	35.2625	35.29	5203168.0
2017-04-13 17:00:00	AAPL	Stock	35.285	35.305	35.275	35.275	27664.0
2017-04-13 18:00:00	AAPL	Stock	35.2675	35.275	35.26	35.26	80908.0
2017-04-13 19:00:00	AAPL	Stock	35.265	35.275	35.25	35.265	13620.0
2017-04-13 08:00:00	MSFT	Stock	65.17	65.18	65.17	65.18	1132.0
2017-04-13 09:00:00	MSFT	Stock	65.18	65.66	64.98	65.59	2451326.0
2017-04-13 10:00:00	MSFT	Stock	65.6	65.86	65.59	65.83	2245399.0
2017-04-13 11:00:00	MSFT	Stock	65.83	65.85	65.54	65.56	1371547.0
2017-04-13 12:00:00	MSFT	Stock	65.56	65.565	65.265	65.31	1549804.0
2017-04-13 13:00:00	MSFT	Stock	65.305	65.33	65.14	65.18	1515617.0
2017-04-13 14:00:00	MSFT	Stock	65.18	65.32	65.17	65.265	1371806.0
2017-04-13 15:00:00	MSFT	Stock	65.26	65.3	64.95	64.96	4073449.0
2017-04-13 16:00:00	MSFT	Stock	64.95	64.99	64.9	64.9	1749188.0
2017-04-13 17:00:00	MSFT	Stock	64.98	64.99	64.91	64.95	10758.0
2017-04-13 18:00:00	MSFT	Stock	64.95	64.95	64.95	64.95	300.0
2017-04-13 19:00:00	MSFT	Stock	64.94	64.94	64.9	64.9	580.0
2017-04-13 05:00:00	NVDA	Stock	2.4175	2.4175	2.4175	2.4175	35800.0
2017-04-13 06:00:00	NVDA	Stock	2.4175	2.4175	2.4175	2.4175	80000.0
2017-04-13 07:00:00	NVDA	Stock	2.4075	2.41	2.4	2.4062	363960.0
2017-04-13 08:00:00	NVDA	Stock	2.4062	2.4175	2.3925	2.3925	2407280.0
2017-04-13 09:00:00	NVDA	Stock	2.3975	2.4302	2.394	2.4205	95190680.0
2017-04-13 10:00:00	NVDA	Stock	2.4205	2.4298	2.4023	2.426	94210560.0
2017-04-13 11:00:00	NVDA	Stock	2.4263	2.4295	2.4183	2.426	43684560.0
2017-04-13 12:00:00	NVDA	Stock	2.4258	2.4258	2.409	2.4132	39044800.0
2017-04-13 13:00:00	NVDA	Stock	2.4135	2.4135	2.399	2.3995	48609320.0
2017-04-13 14:00:00	NVDA	Stock	2.4	2.4095	2.3983	2.4064	33070600.0
2017-04-13 15:00:00	NVDA	Stock	2.4062	2.4078	2.3872	2.3872	90408440.0
2017-04-13 16:00:00	NVDA	Stock	2.3872	2.3932	2.3848	2.3883	18832520.0
2017-04-13 17:00:00	NVDA	Stock	2.3883	2.3888	2.3872	2.3872	151520.0
2017-04-13 18:00:00	NVDA	Stock	2.3872	2.3888	2.3852	2.386	85080.0
2017-04-13 19:00:00	NVDA	Stock	2.386	2.3868	2.3838	2.3838	46760.0
2017-04-13 04:00:00	AMZN	Stock	44.8115	44.8115	44.7	44.7	41000.0
2017-04-13 05:00:00	AMZN	Stock	44.6525	44.6525	44.6525	44.6525	4000.0
2017-04-13 06:00:00	AMZN	Stock	44.6555	44.6555	44.65	44.65	12000.0
2017-04-13 07:00:00	AMZN	Stock	44.691	44.691	44.66	44.675	12760.0
2017-04-13 08:00:00	AMZN	Stock	44.675	44.7375	44.6	44.6	186680.0
2017-04-13 09:00:00	AMZN	Stock	44.5805	44.65	44.429	44.6165	10082320.0
2017-04-13 10:00:00	AMZN	Stock	44.629	44.7485	44.5775	44.627	7551940.0
2017-04-13 11:00:00	AMZN	Stock	44.6322	44.6805	44.5375	44.5695	4682200.0

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

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