PREVIEW / stock_1hour / 2019-10-24

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-24.parquet
  size:    1.1 MB
  rows:    49,139
  symbols: 2,516

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-24 04:00:00	AAPL	Stock	61.0175	61.0175	60.925	60.9975	18976.0
2019-10-24 05:00:00	AAPL	Stock	61.05	61.1025	61.05	61.0525	14532.0
2019-10-24 06:00:00	AAPL	Stock	61.0525	61.2225	61.0525	61.1575	21380.0
2019-10-24 07:00:00	AAPL	Stock	61.175	61.255	61.1125	61.25	178796.0
2019-10-24 08:00:00	AAPL	Stock	61.144	61.25	60.645	61.1175	445348.0
2019-10-24 09:00:00	AAPL	Stock	61.1275	61.2	60.5475	60.6525	12946840.0
2019-10-24 10:00:00	AAPL	Stock	60.6575	60.7475	60.4512	60.6132	10025460.0
2019-10-24 11:00:00	AAPL	Stock	60.615	60.8662	60.5775	60.82	8065760.0
2019-10-24 12:00:00	AAPL	Stock	60.815	60.8475	60.55	60.7525	5500884.0
2019-10-24 13:00:00	AAPL	Stock	60.7525	60.771	60.58	60.6025	4477800.0
2019-10-24 14:00:00	AAPL	Stock	60.605	60.8075	60.5875	60.75	4294220.0
2019-10-24 15:00:00	AAPL	Stock	60.7525	60.915	60.74	60.9	8090032.0
2019-10-24 16:00:00	AAPL	Stock	60.9	60.9	60.625	60.8	5233856.0
2019-10-24 17:00:00	AAPL	Stock	60.81	60.8325	60.8	60.8125	47872.0
2019-10-24 18:00:00	AAPL	Stock	60.835	60.86	60.825	60.8325	46084.0
2019-10-24 19:00:00	AAPL	Stock	60.8425	60.85	60.8125	60.8225	90804.0
2019-10-24 04:00:00	MSFT	Stock	138.75	138.77	138.0	138.5	5055.0
2019-10-24 05:00:00	MSFT	Stock	138.58	138.58	138.34	138.4	1510.0
2019-10-24 06:00:00	MSFT	Stock	138.5	138.69	138.35	138.38	10640.0
2019-10-24 07:00:00	MSFT	Stock	138.5	138.88	137.86	138.8	162331.0
2019-10-24 08:00:00	MSFT	Stock	138.0	139.13	137.9	138.69	322913.0
2019-10-24 09:00:00	MSFT	Stock	138.689	140.09	138.56	139.37	8616574.0
2019-10-24 10:00:00	MSFT	Stock	139.37	139.918	138.67	139.645	5587873.0
2019-10-24 11:00:00	MSFT	Stock	139.65	140.26	139.32	140.16	4998108.0
2019-10-24 12:00:00	MSFT	Stock	140.17	140.42	139.59	140.362	3505992.0
2019-10-24 13:00:00	MSFT	Stock	140.365	140.4	139.68	139.73	2519018.0
2019-10-24 14:00:00	MSFT	Stock	139.74	140.1	139.642	140.0	1605556.0
2019-10-24 15:00:00	MSFT	Stock	139.995	140.09	139.71	139.95	2989340.0
2019-10-24 16:00:00	MSFT	Stock	139.94	140.09	139.3	139.55	2294095.0
2019-10-24 17:00:00	MSFT	Stock	139.61	139.68	139.56	139.62	25732.0
2019-10-24 18:00:00	MSFT	Stock	139.66	139.78	139.62	139.74	20564.0
2019-10-24 19:00:00	MSFT	Stock	139.7	139.74	139.56	139.68	14472.0
2019-10-24 06:00:00	NVDA	Stock	4.9202	4.935	4.9202	4.935	49720.0
2019-10-24 07:00:00	NVDA	Stock	4.9278	4.9375	4.925	4.9358	175800.0
2019-10-24 08:00:00	NVDA	Stock	4.93	4.9425	4.8893	4.9175	761160.0
2019-10-24 09:00:00	NVDA	Stock	4.915	4.9528	4.904	4.916	40004440.0
2019-10-24 10:00:00	NVDA	Stock	4.9152	4.9298	4.8845	4.9183	33243320.0
2019-10-24 11:00:00	NVDA	Stock	4.9192	4.947	4.918	4.9417	35039480.0
2019-10-24 12:00:00	NVDA	Stock	4.9425	4.9488	4.9082	4.932	25520400.0
2019-10-24 13:00:00	NVDA	Stock	4.9315	4.9553	4.9303	4.9403	31880720.0
2019-10-24 14:00:00	NVDA	Stock	4.9395	4.94	4.921	4.9238	16836760.0
2019-10-24 15:00:00	NVDA	Stock	4.9229	4.9298	4.9171	4.9208	24339840.0
2019-10-24 16:00:00	NVDA	Stock	4.9215	5.0125	4.9062	4.9425	10809000.0
2019-10-24 17:00:00	NVDA	Stock	4.9425	4.97	4.9425	4.9575	3764640.0
2019-10-24 18:00:00	NVDA	Stock	4.9588	4.96	4.95	4.9575	514320.0
2019-10-24 19:00:00	NVDA	Stock	4.9578	4.9688	4.9575	4.9688	279640.0
2019-10-24 05:00:00	AMZN	Stock	88.5355	88.5355	88.5355	88.5355	2000.0
2019-10-24 06:00:00	AMZN	Stock	88.55	88.55	88.4	88.4	91660.0
2019-10-24 07:00:00	AMZN	Stock	88.4	88.492	88.4	88.4105	78320.0
2019-10-24 08:00:00	AMZN	Stock	88.5189	88.5189	88.333	88.375	182740.0

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

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