PREVIEW / stock_1hour / 2023-11-10

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-10.parquet
  size:    1.3 MB
  rows:    57,242
  symbols: 1,299

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-10 04:00:00	AAPL	Stock	182.08	182.32	181.78	182.32	20806.0
2023-11-10 05:00:00	AAPL	Stock	182.17	182.17	181.92	182.16	8240.0
2023-11-10 06:00:00	AAPL	Stock	182.1	182.17	181.89	182.04	8381.0
2023-11-10 07:00:00	AAPL	Stock	182.05	183.0	182.04	182.99	34100.0
2023-11-10 08:00:00	AAPL	Stock	182.07	183.45	181.71	183.37	108705.0
2023-11-10 09:00:00	AAPL	Stock	183.3603	184.79	183.21	184.18	6843340.0
2023-11-10 10:00:00	AAPL	Stock	184.17	184.49	183.53	184.32	6413796.0
2023-11-10 11:00:00	AAPL	Stock	184.33	184.94	184.3	184.73	4718834.0
2023-11-10 12:00:00	AAPL	Stock	184.73	185.43	184.66	185.2837	5330488.0
2023-11-10 13:00:00	AAPL	Stock	185.28	185.83	185.16	185.7401	4557255.0
2023-11-10 14:00:00	AAPL	Stock	185.75	185.975	185.555	185.5801	4128564.0
2023-11-10 15:00:00	AAPL	Stock	185.585	186.565	185.58	186.34	9470639.0
2023-11-10 16:00:00	AAPL	Stock	186.34	186.51	186.01	186.11	11145591.0
2023-11-10 17:00:00	AAPL	Stock	186.11	186.4	185.94	186.01	86101.0
2023-11-10 18:00:00	AAPL	Stock	186.0	186.1	185.95	186.03	21605.0
2023-11-10 19:00:00	AAPL	Stock	186.03	186.26	186.0	186.26	18510.0
2023-11-10 04:00:00	MSFT	Stock	360.99	361.1	359.78	360.15	12647.0
2023-11-10 05:00:00	MSFT	Stock	360.04	360.2	359.86	360.06	2218.0
2023-11-10 06:00:00	MSFT	Stock	359.85	360.36	359.6	360.36	5910.0
2023-11-10 07:00:00	MSFT	Stock	360.36	360.7	360.2	360.7	39023.0
2023-11-10 08:00:00	MSFT	Stock	360.37	361.77	360.1	361.75	75399.0
2023-11-10 09:00:00	MSFT	Stock	361.75	364.31	361.07	363.92	1934148.0
2023-11-10 10:00:00	MSFT	Stock	363.89	365.21	363.09	365.19	2009868.0
2023-11-10 11:00:00	MSFT	Stock	365.21	367.3798	365.21	366.96	2505579.0
2023-11-10 12:00:00	MSFT	Stock	366.975	368.8	366.85	368.2116	1699423.0
2023-11-10 13:00:00	MSFT	Stock	368.23	369.37	367.5	369.14	1435053.0
2023-11-10 14:00:00	MSFT	Stock	369.13	369.53	368.81	368.84	1575352.0
2023-11-10 15:00:00	MSFT	Stock	368.81	370.1	368.66	369.52	3215554.0
2023-11-10 16:00:00	MSFT	Stock	369.66	369.99	369.12	369.19	5067999.0
2023-11-10 17:00:00	MSFT	Stock	369.3699	369.3699	368.9501	369.12	12597.0
2023-11-10 18:00:00	MSFT	Stock	369.12	369.28	369.01	369.12	10301.0
2023-11-10 19:00:00	MSFT	Stock	369.23	369.4	369.15	369.39	8252.0
2023-11-10 04:00:00	NVDA	Stock	46.962	47.132	46.512	46.646	324880.0
2023-11-10 05:00:00	NVDA	Stock	46.622	46.79	46.55	46.68	99650.0
2023-11-10 06:00:00	NVDA	Stock	46.662	46.7	46.64	46.7	56820.0
2023-11-10 07:00:00	NVDA	Stock	46.7	47.251	46.68	47.221	1162530.0
2023-11-10 08:00:00	NVDA	Stock	46.88	47.39	46.702	47.38	3545880.0
2023-11-10 09:00:00	NVDA	Stock	47.386	47.935	47.283	47.784	56199030.0
2023-11-10 10:00:00	NVDA	Stock	47.781	47.873	47.423	47.8725	49336880.0
2023-11-10 11:00:00	NVDA	Stock	47.873	48.01	47.711	47.829	38101580.0
2023-11-10 12:00:00	NVDA	Stock	47.83	48.222	47.804	48.1361	36349250.0
2023-11-10 13:00:00	NVDA	Stock	48.14	48.2738	48.014	48.17	27300120.0
2023-11-10 14:00:00	NVDA	Stock	48.175	48.472	48.112	48.351	35450370.0
2023-11-10 15:00:00	NVDA	Stock	48.3455	48.438	48.218	48.34	42234440.0
2023-11-10 16:00:00	NVDA	Stock	48.34	48.6	48.332	48.441	26134210.0
2023-11-10 17:00:00	NVDA	Stock	48.442	48.452	48.315	48.32	705370.0
2023-11-10 18:00:00	NVDA	Stock	48.325	48.399	48.308	48.399	400030.0
2023-11-10 19:00:00	NVDA	Stock	48.4	48.433	48.36	48.399	534250.0
2023-11-10 04:00:00	AMZN	Stock	140.22	140.22	139.84	140.19	7572.0
2023-11-10 05:00:00	AMZN	Stock	140.02	140.02	139.76	139.97	3887.0

> showing 50 of 57,242 rows — these rows as CSV

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