PREVIEW / stock_1hour / 2023-12-15

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-12-15.parquet
  size:    1.4 MB
  rows:    61,556
  symbols: 1,265

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-12-15 04:00:00	AAPL	Stock	198.3	198.35	198.21	198.3	5684.0
2023-12-15 05:00:00	AAPL	Stock	198.25	198.3	198.16	198.25	7869.0
2023-12-15 06:00:00	AAPL	Stock	198.25	198.34	198.25	198.25	5394.0
2023-12-15 07:00:00	AAPL	Stock	198.26	198.26	197.46	197.7	30851.0
2023-12-15 08:00:00	AAPL	Stock	198.2501	198.77	197.5	198.15	144270.0
2023-12-15 09:00:00	AAPL	Stock	198.2	198.5	196.66	197.885	20841518.0
2023-12-15 10:00:00	AAPL	Stock	197.89	198.3999	197.42	197.677	6336462.0
2023-12-15 11:00:00	AAPL	Stock	197.68	198.02	197.35	197.935	3985042.0
2023-12-15 12:00:00	AAPL	Stock	197.94	197.95	197.155	197.1699	3147410.0
2023-12-15 13:00:00	AAPL	Stock	197.1612	197.6388	197.02	197.56	3637400.0
2023-12-15 14:00:00	AAPL	Stock	197.565	197.665	197.27	197.4799	2580091.0
2023-12-15 15:00:00	AAPL	Stock	197.475	198.2	197.0	197.12	9705584.0
2023-12-15 16:00:00	AAPL	Stock	197.57	197.57	195.81	196.45	40955570.0
2023-12-15 17:00:00	AAPL	Stock	196.48	197.57	196.15	196.4173	135990.0
2023-12-15 18:00:00	AAPL	Stock	196.5	196.65	196.4	196.62	65175.0
2023-12-15 19:00:00	AAPL	Stock	196.62	196.85	196.52	196.5999	200419.0
2023-12-15 04:00:00	MSFT	Stock	367.3	368.52	367.3	368.39	12811.0
2023-12-15 05:00:00	MSFT	Stock	368.39	368.39	367.0	367.45	5903.0
2023-12-15 06:00:00	MSFT	Stock	367.7	367.76	367.5	367.62	3927.0
2023-12-15 07:00:00	MSFT	Stock	367.51	367.59	366.6	366.6	32823.0
2023-12-15 08:00:00	MSFT	Stock	367.42	368.65	366.8	368.4994	97625.0
2023-12-15 09:00:00	MSFT	Stock	368.5	371.17	365.8	369.09	11451609.0
2023-12-15 10:00:00	MSFT	Stock	369.09	371.74	368.43	371.23	2891653.0
2023-12-15 11:00:00	MSFT	Stock	371.26	372.16	370.12	371.3	1788073.0
2023-12-15 12:00:00	MSFT	Stock	371.31	372.01	370.1	370.1299	1436498.0
2023-12-15 13:00:00	MSFT	Stock	370.12	370.9	368.99	369.54	1367251.0
2023-12-15 14:00:00	MSFT	Stock	369.53	371.065	369.19	370.64	1015291.0
2023-12-15 15:00:00	MSFT	Stock	370.63	372.4	367.21	368.77	6583748.0
2023-12-15 16:00:00	MSFT	Stock	370.73	370.73	369.01	369.88	26925858.0
2023-12-15 17:00:00	MSFT	Stock	369.9	370.73	369.6763	369.76	53096.0
2023-12-15 18:00:00	MSFT	Stock	369.89	370.0	369.5709	370.0	15439.0
2023-12-15 19:00:00	MSFT	Stock	369.99	370.0	369.85	369.85	4845.0
2023-12-15 04:00:00	NVDA	Stock	48.35	48.415	48.325	48.328	62870.0
2023-12-15 05:00:00	NVDA	Stock	48.319	48.319	48.15	48.15	115580.0
2023-12-15 06:00:00	NVDA	Stock	48.144	48.224	48.116	48.2	74760.0
2023-12-15 07:00:00	NVDA	Stock	48.19	48.282	48.123	48.15	259690.0
2023-12-15 08:00:00	NVDA	Stock	48.188	48.403	48.131	48.332	1143950.0
2023-12-15 09:00:00	NVDA	Stock	48.333	49.077	48.103	48.9605	80544960.0
2023-12-15 10:00:00	NVDA	Stock	48.968	49.404	48.896	49.225	64126880.0
2023-12-15 11:00:00	NVDA	Stock	49.23	49.261	48.993	49.081	38211850.0
2023-12-15 12:00:00	NVDA	Stock	49.082	49.14	48.8648	48.912	32702460.0
2023-12-15 13:00:00	NVDA	Stock	48.913	49.293	48.85	48.947	35233380.0
2023-12-15 14:00:00	NVDA	Stock	48.945	49.105	48.9276	48.9895	22739770.0
2023-12-15 15:00:00	NVDA	Stock	48.989	49.087	48.884	48.944	37664930.0
2023-12-15 16:00:00	NVDA	Stock	48.944	48.944	48.8	48.904	66700480.0
2023-12-15 17:00:00	NVDA	Stock	48.905	48.96	48.9005	48.93	381960.0
2023-12-15 18:00:00	NVDA	Stock	48.93	48.948	48.925	48.94	106820.0
2023-12-15 19:00:00	NVDA	Stock	48.925	48.947	48.9	48.915	215500.0
2023-12-15 04:00:00	AMZN	Stock	147.83	147.95	147.83	147.87	5386.0
2023-12-15 05:00:00	AMZN	Stock	147.93	147.97	147.73	147.8	6601.0

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

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