PREVIEW / stock_1hour / 2022-11-07

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-11-07.parquet
  size:    1.4 MB
  rows:    61,921
  symbols: 2,122

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
2022-11-07 04:00:00	AAPL	Stock	138.0	138.23	135.0	136.8	86918.0
2022-11-07 05:00:00	AAPL	Stock	136.79	137.15	136.71	136.89	51147.0
2022-11-07 06:00:00	AAPL	Stock	136.93	137.25	136.21	136.3	89938.0
2022-11-07 07:00:00	AAPL	Stock	136.39	136.47	135.45	136.14	415024.0
2022-11-07 08:00:00	AAPL	Stock	136.3102	138.65	135.4515	136.4	1123421.0
2022-11-07 09:00:00	AAPL	Stock	136.42	138.22	135.671	136.2793	11842886.0
2022-11-07 10:00:00	AAPL	Stock	136.28	137.58	136.072	136.985	11245593.0
2022-11-07 11:00:00	AAPL	Stock	137.0	137.82	136.38	136.42	9623622.0
2022-11-07 12:00:00	AAPL	Stock	136.4221	137.62	136.25	137.3092	6197642.0
2022-11-07 13:00:00	AAPL	Stock	137.305	137.65	136.84	137.3509	5652069.0
2022-11-07 14:00:00	AAPL	Stock	137.35	138.84	137.35	138.1601	8014116.0
2022-11-07 15:00:00	AAPL	Stock	138.17	139.145	137.71	138.96	10969203.0
2022-11-07 16:00:00	AAPL	Stock	138.92	139.14	138.76	138.92	7224965.0
2022-11-07 17:00:00	AAPL	Stock	138.95	139.0	138.84	138.8601	54136.0
2022-11-07 18:00:00	AAPL	Stock	138.89	139.05	138.88	139.04	42173.0
2022-11-07 19:00:00	AAPL	Stock	139.05	139.56	139.02	139.54	66483.0
2022-11-07 04:00:00	MSFT	Stock	221.85	222.0	221.36	221.38	3470.0
2022-11-07 05:00:00	MSFT	Stock	221.75	222.38	221.68	222.38	4245.0
2022-11-07 06:00:00	MSFT	Stock	222.45	223.46	222.01	222.03	11432.0
2022-11-07 07:00:00	MSFT	Stock	222.35	223.1	221.78	222.36	27447.0
2022-11-07 08:00:00	MSFT	Stock	222.8164	223.1	221.13	221.5	54324.0
2022-11-07 09:00:00	MSFT	Stock	221.42	224.2	221.07	223.95	2515190.0
2022-11-07 10:00:00	MSFT	Stock	224.0	226.45	223.95	226.4207	3385981.0
2022-11-07 11:00:00	MSFT	Stock	226.45	226.55	223.38	223.3898	2204566.0
2022-11-07 12:00:00	MSFT	Stock	223.39	224.357	222.8901	224.357	1745554.0
2022-11-07 13:00:00	MSFT	Stock	224.34	226.3	224.275	226.29	2092986.0
2022-11-07 14:00:00	MSFT	Stock	226.29	228.41	226.29	227.84	2980511.0
2022-11-07 15:00:00	MSFT	Stock	227.835	228.41	227.36	227.93	4526885.0
2022-11-07 16:00:00	MSFT	Stock	227.87	228.25	227.51	227.75	4045397.0
2022-11-07 17:00:00	MSFT	Stock	227.81	228.0	227.57	227.66	13276.0
2022-11-07 18:00:00	MSFT	Stock	227.66	228.14	227.66	228.14	6281.0
2022-11-07 19:00:00	MSFT	Stock	228.13	229.09	228.08	229.0	15538.0
2022-11-07 04:00:00	NVDA	Stock	14.162	14.22	14.11	14.193	107500.0
2022-11-07 05:00:00	NVDA	Stock	14.195	14.266	14.195	14.265	41380.0
2022-11-07 06:00:00	NVDA	Stock	14.29	14.309	14.223	14.247	104900.0
2022-11-07 07:00:00	NVDA	Stock	14.25	14.28	14.218	14.238	350970.0
2022-11-07 08:00:00	NVDA	Stock	14.246	14.2838	14.1	14.2	918830.0
2022-11-07 09:00:00	NVDA	Stock	14.212	14.299	13.954	14.0575	52543700.0
2022-11-07 10:00:00	NVDA	Stock	14.0619	14.265	14.0306	14.148	62719830.0
2022-11-07 11:00:00	NVDA	Stock	14.149	14.215	14.0354	14.0757	48378740.0
2022-11-07 12:00:00	NVDA	Stock	14.076	14.17	14.0489	14.1228	32687630.0
2022-11-07 13:00:00	NVDA	Stock	14.121	14.178	14.074	14.118	27580260.0
2022-11-07 14:00:00	NVDA	Stock	14.12	14.341	14.1179	14.2675	44611900.0
2022-11-07 15:00:00	NVDA	Stock	14.268	14.412	14.256	14.303	58719350.0
2022-11-07 16:00:00	NVDA	Stock	14.301	14.32	14.276	14.3	24744500.0
2022-11-07 17:00:00	NVDA	Stock	14.3	14.301	14.286	14.293	130590.0
2022-11-07 18:00:00	NVDA	Stock	14.294	14.31	14.291	14.306	219440.0
2022-11-07 19:00:00	NVDA	Stock	14.298	14.412	14.298	14.39	320820.0
2022-11-07 04:00:00	AMZN	Stock	91.9	91.9	90.8	91.45	50688.0
2022-11-07 05:00:00	AMZN	Stock	91.59	92.11	91.45	91.99	29844.0

> showing 50 of 61,921 rows — these rows as CSV

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