PREVIEW / stock_1hour / 2019-10-31

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-31.parquet
  size:    1.1 MB
  rows:    51,167
  symbols: 2,503

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
2019-10-31 04:00:00	AAPL	Stock	62.3225	62.45	62.2575	62.3275	96568.0
2019-10-31 05:00:00	AAPL	Stock	62.325	62.3425	61.6525	61.76	132956.0
2019-10-31 06:00:00	AAPL	Stock	61.8125	62.2	61.8125	62.1175	105148.0
2019-10-31 07:00:00	AAPL	Stock	62.1175	62.1225	61.675	61.855	512172.0
2019-10-31 08:00:00	AAPL	Stock	62.0975	62.1125	61.5875	61.935	1320392.0
2019-10-31 09:00:00	AAPL	Stock	61.935	62.2925	61.475	61.7035	22627972.0
2019-10-31 10:00:00	AAPL	Stock	61.72	62.0975	59.315	61.83	20541108.0
2019-10-31 11:00:00	AAPL	Stock	61.825	62.2425	61.725	62.0522	14068984.0
2019-10-31 12:00:00	AAPL	Stock	62.055	62.115	61.7425	61.9075	10284896.0
2019-10-31 13:00:00	AAPL	Stock	61.9075	62.045	61.87	61.95	5978144.0
2019-10-31 14:00:00	AAPL	Stock	61.95	61.9675	61.6625	61.9375	7508016.0
2019-10-31 15:00:00	AAPL	Stock	61.945	62.235	61.9025	62.21	19853408.0
2019-10-31 16:00:00	AAPL	Stock	62.205	62.25	61.9548	62.125	11560800.0
2019-10-31 17:00:00	AAPL	Stock	62.1375	62.1625	62.105	62.105	31572.0
2019-10-31 18:00:00	AAPL	Stock	62.1125	62.1375	62.0725	62.125	31980.0
2019-10-31 19:00:00	AAPL	Stock	62.11	62.1625	62.11	62.14	57900.0
2019-10-31 04:00:00	MSFT	Stock	144.61	145.0	144.61	144.75	5591.0
2019-10-31 05:00:00	MSFT	Stock	144.7	144.7	143.8	144.13	12769.0
2019-10-31 06:00:00	MSFT	Stock	144.0	144.38	143.38	144.36	5149.0
2019-10-31 07:00:00	MSFT	Stock	144.36	144.36	143.8	144.15	13612.0
2019-10-31 08:00:00	MSFT	Stock	144.0	144.44	143.86	144.34	27668.0
2019-10-31 09:00:00	MSFT	Stock	144.38	144.97	143.9	144.09	2370770.0
2019-10-31 10:00:00	MSFT	Stock	144.08	144.24	143.55	144.21	2230990.0
2019-10-31 11:00:00	MSFT	Stock	144.22	144.52	143.765	143.88	1657641.0
2019-10-31 12:00:00	MSFT	Stock	143.87	144.06	143.46	143.575	1521452.0
2019-10-31 13:00:00	MSFT	Stock	143.575	143.95	143.51	143.6	1296984.0
2019-10-31 14:00:00	MSFT	Stock	143.6	143.615	143.13	143.29	1413233.0
2019-10-31 15:00:00	MSFT	Stock	143.3	143.5	142.99	143.39	4696623.0
2019-10-31 16:00:00	MSFT	Stock	143.37	143.57	143.37	143.55	4705766.0
2019-10-31 17:00:00	MSFT	Stock	143.52	143.58	143.43	143.53	3050.0
2019-10-31 18:00:00	MSFT	Stock	143.5	143.53	143.4	143.5	3878.0
2019-10-31 19:00:00	MSFT	Stock	143.5	143.52	143.4	143.4	6742.0
2019-10-31 04:00:00	NVDA	Stock	5.1125	5.1125	5.1125	5.1125	8000.0
2019-10-31 05:00:00	NVDA	Stock	5.1125	5.1125	5.0588	5.0625	90320.0
2019-10-31 07:00:00	NVDA	Stock	5.071	5.0755	5.05	5.06	240640.0
2019-10-31 08:00:00	NVDA	Stock	5.0675	5.0755	5.0488	5.0698	361480.0
2019-10-31 09:00:00	NVDA	Stock	5.0748	5.079	4.9725	4.9781	28835680.0
2019-10-31 10:00:00	NVDA	Stock	4.9755	5.0098	4.9453	5.0058	36774120.0
2019-10-31 11:00:00	NVDA	Stock	5.0044	5.0325	4.997	5.0102	30994800.0
2019-10-31 12:00:00	NVDA	Stock	5.012	5.0135	4.9858	4.991	15691400.0
2019-10-31 13:00:00	NVDA	Stock	4.9905	5.0165	4.987	5.0055	11227800.0
2019-10-31 14:00:00	NVDA	Stock	5.0048	5.02	5.001	5.0185	11452400.0
2019-10-31 15:00:00	NVDA	Stock	5.0185	5.029	5.0025	5.0285	21583160.0
2019-10-31 16:00:00	NVDA	Stock	5.0255	5.0375	4.98	4.98	15914640.0
2019-10-31 17:00:00	NVDA	Stock	4.9875	5.0075	4.987	5.0075	35960.0
2019-10-31 18:00:00	NVDA	Stock	5.0138	5.0138	5.0138	5.0138	6000.0
2019-10-31 19:00:00	NVDA	Stock	5.01	5.015	5.0055	5.0063	118640.0
2019-10-31 05:00:00	AMZN	Stock	89.0025	89.0025	88.9	88.9	27460.0
2019-10-31 06:00:00	AMZN	Stock	88.6125	88.7	88.6125	88.7	7700.0
2019-10-31 07:00:00	AMZN	Stock	88.625	88.875	88.62	88.875	94800.0

> showing 50 of 51,167 rows — these rows as CSV

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