PREVIEW / stock_1hour / 2023-11-30

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-30.parquet
  size:    1.3 MB
  rows:    59,735
  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-30 04:00:00	AAPL	Stock	189.44	189.6	189.31	189.5	2266.0
2023-11-30 05:00:00	AAPL	Stock	189.45	189.5	189.44	189.44	1176.0
2023-11-30 06:00:00	AAPL	Stock	189.51	189.52	189.38	189.4	6041.0
2023-11-30 07:00:00	AAPL	Stock	189.56	190.05	189.56	189.98	26347.0
2023-11-30 08:00:00	AAPL	Stock	189.61	190.2	189.51	189.72	122546.0
2023-11-30 09:00:00	AAPL	Stock	189.7	190.32	189.05	189.205	3747831.0
2023-11-30 10:00:00	AAPL	Stock	189.21	189.35	188.34	188.76	4976484.0
2023-11-30 11:00:00	AAPL	Stock	188.75	188.919	188.19	188.24	3118499.0
2023-11-30 12:00:00	AAPL	Stock	188.25	188.7595	188.19	188.7023	2363814.0
2023-11-30 13:00:00	AAPL	Stock	188.7	188.7679	188.27	188.5099	2185338.0
2023-11-30 14:00:00	AAPL	Stock	188.51	189.21	188.5	189.175	2371437.0
2023-11-30 15:00:00	AAPL	Stock	189.175	190.2	188.69	189.95	7643321.0
2023-11-30 16:00:00	AAPL	Stock	189.94	190.26	189.79	189.87	12759503.0
2023-11-30 17:00:00	AAPL	Stock	189.89	190.08	189.87	190.01	63244.0
2023-11-30 18:00:00	AAPL	Stock	189.95	190.23	189.93	190.11	23251.0
2023-11-30 19:00:00	AAPL	Stock	190.1	190.3	190.06	190.3	47931.0
2023-11-30 04:00:00	MSFT	Stock	379.26	379.89	379.26	379.5	2048.0
2023-11-30 05:00:00	MSFT	Stock	379.39	379.7	379.39	379.7	461.0
2023-11-30 06:00:00	MSFT	Stock	379.59	379.74	379.48	379.73	1340.0
2023-11-30 07:00:00	MSFT	Stock	379.57	380.8	379.57	380.53	18435.0
2023-11-30 08:00:00	MSFT	Stock	379.6	380.99	378.8	378.8	74140.0
2023-11-30 09:00:00	MSFT	Stock	378.75	380.09	377.655	378.57	2031621.0
2023-11-30 10:00:00	MSFT	Stock	378.61	379.42	376.6801	377.56	1725316.0
2023-11-30 11:00:00	MSFT	Stock	377.54	377.78	376.07	376.15	1324298.0
2023-11-30 12:00:00	MSFT	Stock	376.18	377.1399	376.01	376.93	911729.0
2023-11-30 13:00:00	MSFT	Stock	376.93	377.0362	375.47	375.79	898562.0
2023-11-30 14:00:00	MSFT	Stock	375.79	376.78	375.76	376.58	1104755.0
2023-11-30 15:00:00	MSFT	Stock	376.6045	379.32	375.5401	378.92	3608250.0
2023-11-30 16:00:00	MSFT	Stock	378.9	378.98	378.575	378.71	10676712.0
2023-11-30 17:00:00	MSFT	Stock	378.74	378.91	378.71	378.8	635671.0
2023-11-30 18:00:00	MSFT	Stock	378.7	378.91	378.65	378.89	9558.0
2023-11-30 19:00:00	MSFT	Stock	378.9	378.91	378.75	378.75	3551.0
2023-11-30 04:00:00	NVDA	Stock	48.193	48.3	48.19	48.3	31370.0
2023-11-30 05:00:00	NVDA	Stock	48.286	48.345	48.286	48.34	12870.0
2023-11-30 06:00:00	NVDA	Stock	48.339	48.341	48.258	48.26	41250.0
2023-11-30 07:00:00	NVDA	Stock	48.251	48.363	48.25	48.276	360270.0
2023-11-30 08:00:00	NVDA	Stock	48.265	48.367	48.196	48.225	1402980.0
2023-11-30 09:00:00	NVDA	Stock	48.2	48.22	47.562	47.747	40363930.0
2023-11-30 10:00:00	NVDA	Stock	47.745	47.754	46.786	46.994	75244990.0
2023-11-30 11:00:00	NVDA	Stock	46.989	47.118	46.58	46.582	48416230.0
2023-11-30 12:00:00	NVDA	Stock	46.581	46.883	46.55	46.858	32240480.0
2023-11-30 13:00:00	NVDA	Stock	46.849	46.8545	46.422	46.609	36689050.0
2023-11-30 14:00:00	NVDA	Stock	46.6085	46.835	46.55	46.8135	33651550.0
2023-11-30 15:00:00	NVDA	Stock	46.8112	46.846	46.534	46.781	50649580.0
2023-11-30 16:00:00	NVDA	Stock	46.77	46.8	46.57	46.617	83626770.0
2023-11-30 17:00:00	NVDA	Stock	46.615	46.645	46.595	46.601	351590.0
2023-11-30 18:00:00	NVDA	Stock	46.602	46.6299	46.583	46.6163	375120.0
2023-11-30 19:00:00	NVDA	Stock	46.601	46.601	46.57	46.596	409410.0
2023-11-30 04:00:00	AMZN	Stock	146.41	146.9	146.4	146.47	4165.0
2023-11-30 05:00:00	AMZN	Stock	146.6	146.66	146.45	146.47	6210.0

> showing 50 of 59,735 rows — these rows as CSV

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