PREVIEW / stock_1hour / 2023-12-06

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-12-06.parquet
  size:    1.3 MB
  rows:    59,721
  symbols: 1,263

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-06 04:00:00	AAPL	Stock	193.78	193.93	193.54	193.55	29146.0
2023-12-06 05:00:00	AAPL	Stock	193.55	193.78	193.55	193.66	4019.0
2023-12-06 06:00:00	AAPL	Stock	193.64	193.69	193.3	193.45	11279.0
2023-12-06 07:00:00	AAPL	Stock	193.45	193.55	193.25	193.53	28351.0
2023-12-06 08:00:00	AAPL	Stock	193.5	194.05	193.25	194.04	184960.0
2023-12-06 09:00:00	AAPL	Stock	194.04	194.76	192.96	193.15	5549114.0
2023-12-06 10:00:00	AAPL	Stock	193.14	193.165	192.205	192.6529	5445902.0
2023-12-06 11:00:00	AAPL	Stock	192.67	193.34	192.47	193.04	3383909.0
2023-12-06 12:00:00	AAPL	Stock	193.03	193.0979	192.65	192.7	1967290.0
2023-12-06 13:00:00	AAPL	Stock	192.69	193.235	192.37	193.1494	2294094.0
2023-12-06 14:00:00	AAPL	Stock	193.1501	193.21	192.75	192.91	2077990.0
2023-12-06 15:00:00	AAPL	Stock	192.9135	192.94	192.11	192.33	5856027.0
2023-12-06 16:00:00	AAPL	Stock	192.33	192.45	192.21	192.26	6514156.0
2023-12-06 17:00:00	AAPL	Stock	192.3	192.38	192.22	192.23	38660.0
2023-12-06 18:00:00	AAPL	Stock	192.23	192.31	192.2197	192.22	9576.0
2023-12-06 19:00:00	AAPL	Stock	192.22	192.26	192.11	192.2	14105.0
2023-12-06 04:00:00	MSFT	Stock	373.59	373.85	373.0	373.29	3745.0
2023-12-06 05:00:00	MSFT	Stock	372.97	373.3	372.97	373.29	1535.0
2023-12-06 06:00:00	MSFT	Stock	373.29	373.3	372.63	372.63	1310.0
2023-12-06 07:00:00	MSFT	Stock	372.77	372.89	372.51	372.89	9773.0
2023-12-06 08:00:00	MSFT	Stock	372.92	374.5	372.57	374.4	69454.0
2023-12-06 09:00:00	MSFT	Stock	374.39	375.0	371.49	371.8	1992763.0
2023-12-06 10:00:00	MSFT	Stock	371.73	371.9268	368.67	371.44	2761608.0
2023-12-06 11:00:00	MSFT	Stock	371.4413	371.55	368.7901	369.73	1627346.0
2023-12-06 12:00:00	MSFT	Stock	369.73	369.88	368.6895	368.75	1050264.0
2023-12-06 13:00:00	MSFT	Stock	368.74	370.0547	368.03	369.92	1135042.0
2023-12-06 14:00:00	MSFT	Stock	369.915	370.53	369.33	369.7765	1062369.0
2023-12-06 15:00:00	MSFT	Stock	369.76	369.97	368.41	368.81	2628000.0
2023-12-06 16:00:00	MSFT	Stock	368.83	368.84	367.97	368.11	3185125.0
2023-12-06 17:00:00	MSFT	Stock	368.1	368.7	367.9083	368.45	9107.0
2023-12-06 18:00:00	MSFT	Stock	368.1461	368.8	368.1461	368.6024	5434.0
2023-12-06 19:00:00	MSFT	Stock	368.79	368.79	368.27	368.29	10679.0
2023-12-06 04:00:00	NVDA	Stock	47.126	47.231	46.966	47.118	213160.0
2023-12-06 05:00:00	NVDA	Stock	47.126	47.24	47.1	47.229	110140.0
2023-12-06 06:00:00	NVDA	Stock	47.216	47.216	47.0	47.082	167580.0
2023-12-06 07:00:00	NVDA	Stock	47.069	47.12	46.866	46.969	704200.0
2023-12-06 08:00:00	NVDA	Stock	47.12	47.235	46.865	47.2011	2742320.0
2023-12-06 09:00:00	NVDA	Stock	47.2194	47.387	46.602	46.6461	55499120.0
2023-12-06 10:00:00	NVDA	Stock	46.646	46.823	46.361	46.5275	46565200.0
2023-12-06 11:00:00	NVDA	Stock	46.52	46.569	46.213	46.419	31374200.0
2023-12-06 12:00:00	NVDA	Stock	46.419	46.471	46.053	46.076	26691670.0
2023-12-06 13:00:00	NVDA	Stock	46.076	46.144	45.711	45.9854	34524700.0
2023-12-06 14:00:00	NVDA	Stock	45.994	46.01	45.762	45.7847	27473480.0
2023-12-06 15:00:00	NVDA	Stock	45.7845	45.837	45.412	45.501	45540670.0
2023-12-06 16:00:00	NVDA	Stock	45.503	45.518	45.325	45.3978	18875170.0
2023-12-06 17:00:00	NVDA	Stock	45.38	45.395	45.235	45.309	933800.0
2023-12-06 18:00:00	NVDA	Stock	45.311	45.46	45.275	45.428	574290.0
2023-12-06 19:00:00	NVDA	Stock	45.42	45.445	45.3	45.3	427010.0
2023-12-06 04:00:00	AMZN	Stock	147.01	147.25	147.0	147.2	12885.0
2023-12-06 05:00:00	AMZN	Stock	147.2	147.35	147.0	147.35	3410.0

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

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