PREVIEW / stock_1hour / 2023-11-17

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-17.parquet
  size:    1.3 MB
  rows:    58,108
  symbols: 1,289

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
2023-11-17 04:00:00	AAPL	Stock	189.8	190.3	189.8	190.05	14839.0
2023-11-17 05:00:00	AAPL	Stock	190.06	190.31	190.06	190.15	11989.0
2023-11-17 06:00:00	AAPL	Stock	190.15	190.18	189.82	190.0	8892.0
2023-11-17 07:00:00	AAPL	Stock	190.08	190.29	190.0	190.1	29625.0
2023-11-17 08:00:00	AAPL	Stock	190.15	190.39	189.63	189.95	144157.0
2023-11-17 09:00:00	AAPL	Stock	189.91	190.4	189.14	189.77	7670807.0
2023-11-17 10:00:00	AAPL	Stock	189.77	189.78	188.57	189.5709	6913353.0
2023-11-17 11:00:00	AAPL	Stock	189.57	189.6	188.82	189.245	3820315.0
2023-11-17 12:00:00	AAPL	Stock	189.245	189.46	188.89	189.25	2612902.0
2023-11-17 13:00:00	AAPL	Stock	189.25	189.7401	189.085	189.5386	2762588.0
2023-11-17 14:00:00	AAPL	Stock	189.54	189.97	189.535	189.97	3138245.0
2023-11-17 15:00:00	AAPL	Stock	189.97	190.18	189.52	189.71	6989233.0
2023-11-17 16:00:00	AAPL	Stock	189.69	189.97	189.6	189.95	7496998.0
2023-11-17 17:00:00	AAPL	Stock	189.88	190.04	189.69	189.93	56825.0
2023-11-17 18:00:00	AAPL	Stock	189.9	189.97	189.78	189.95	4341.0
2023-11-17 19:00:00	AAPL	Stock	189.9	189.9	189.69	189.69	7821.0
2023-11-17 04:00:00	MSFT	Stock	377.54	377.75	377.29	377.31	5863.0
2023-11-17 05:00:00	MSFT	Stock	377.28	377.53	376.73	376.73	7335.0
2023-11-17 06:00:00	MSFT	Stock	376.82	376.95	376.15	376.25	5839.0
2023-11-17 07:00:00	MSFT	Stock	376.4	376.6	375.35	375.74	45724.0
2023-11-17 08:00:00	MSFT	Stock	376.6	377.6	373.91	374.07	95688.0
2023-11-17 09:00:00	MSFT	Stock	374.07	376.17	370.4435	371.57	4842692.0
2023-11-17 10:00:00	MSFT	Stock	371.55	371.876	369.97	370.296	2575885.0
2023-11-17 11:00:00	MSFT	Stock	370.35	372.05	369.21	372.0428	2266817.0
2023-11-17 12:00:00	MSFT	Stock	372.0187	372.65	371.27	371.88	1587376.0
2023-11-17 13:00:00	MSFT	Stock	371.9	372.8	371.77	372.24	1197061.0
2023-11-17 14:00:00	MSFT	Stock	372.225	373.4	372.09	372.65	1474054.0
2023-11-17 15:00:00	MSFT	Stock	372.65	373.19	367.0	369.79	9552318.0
2023-11-17 16:00:00	MSFT	Stock	369.85	370.14	367.3	367.45	5454938.0
2023-11-17 17:00:00	MSFT	Stock	367.4119	369.85	366.55	366.9999	227462.0
2023-11-17 18:00:00	MSFT	Stock	366.9005	367.17	366.55	366.78	35706.0
2023-11-17 19:00:00	MSFT	Stock	366.7	366.75	365.48	366.42	92613.0
2023-11-17 04:00:00	NVDA	Stock	49.65	49.75	49.565	49.689	204460.0
2023-11-17 05:00:00	NVDA	Stock	49.725	49.782	49.68	49.701	82190.0
2023-11-17 06:00:00	NVDA	Stock	49.681	49.681	49.588	49.655	43390.0
2023-11-17 07:00:00	NVDA	Stock	49.639	49.718	49.6	49.684	444950.0
2023-11-17 08:00:00	NVDA	Stock	49.714	49.73	49.3333	49.4096	2116670.0
2023-11-17 09:00:00	NVDA	Stock	49.416	49.717	49.1434	49.4608	45767820.0
2023-11-17 10:00:00	NVDA	Stock	49.4615	49.52	49.111	49.271	40359920.0
2023-11-17 11:00:00	NVDA	Stock	49.266	49.359	49.007	49.358	30429820.0
2023-11-17 12:00:00	NVDA	Stock	49.354	49.504	49.24	49.39	23765750.0
2023-11-17 13:00:00	NVDA	Stock	49.395	49.635	49.351	49.468	29454720.0
2023-11-17 14:00:00	NVDA	Stock	49.467	49.584	49.351	49.4245	22017260.0
2023-11-17 15:00:00	NVDA	Stock	49.4294	49.482	49.129	49.297	33968030.0
2023-11-17 16:00:00	NVDA	Stock	49.296	49.298	49.19	49.263	20327430.0
2023-11-17 17:00:00	NVDA	Stock	49.28	49.32	49.267	49.283	376800.0
2023-11-17 18:00:00	NVDA	Stock	49.291	49.306	49.285	49.3	235850.0
2023-11-17 19:00:00	NVDA	Stock	49.306	49.37	49.306	49.36	288550.0
2023-11-17 04:00:00	AMZN	Stock	143.31	143.79	143.31	143.5	13964.0
2023-11-17 05:00:00	AMZN	Stock	143.61	143.95	143.53	143.89	11703.0

> showing 50 of 58,108 rows — these rows as CSV

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