PREVIEW / stock_1hour / 2025-06-24

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-06-24.parquet
  size:    1.4 MB
  rows:    63,107
  symbols: 398

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
2025-06-24 04:00:00	AAPL	Stock	202.62	203.44	202.62	203.29	20309.0
2025-06-24 05:00:00	AAPL	Stock	203.32	204.97	203.32	204.44	63160.0
2025-06-24 06:00:00	AAPL	Stock	204.31	204.58	203.7	203.7	36116.0
2025-06-24 07:00:00	AAPL	Stock	203.68	204.0	203.48	203.62	71401.0
2025-06-24 08:00:00	AAPL	Stock	203.61	204.95	202.4	203.8	248187.0
2025-06-24 09:00:00	AAPL	Stock	203.7892	203.8	200.22	200.43	6300838.0
2025-06-24 10:00:00	AAPL	Stock	200.43	201.58	200.2	200.98	4656528.0
2025-06-24 11:00:00	AAPL	Stock	200.98	202.09	200.73	201.905	3216360.0
2025-06-24 12:00:00	AAPL	Stock	201.905	203.44	201.81	202.435	5244670.0
2025-06-24 13:00:00	AAPL	Stock	202.42	202.54	201.84	202.205	3225021.0
2025-06-24 14:00:00	AAPL	Stock	202.21	202.265	201.305	201.4453	3468239.0
2025-06-24 15:00:00	AAPL	Stock	201.449	202.015	200.27	200.29	7664453.0
2025-06-24 16:00:00	AAPL	Stock	200.3	200.7988	200.25	200.75	6476332.0
2025-06-24 17:00:00	AAPL	Stock	200.7965	200.8	200.4	200.7	43283.0
2025-06-24 18:00:00	AAPL	Stock	200.66	200.7	200.5	200.6	39055.0
2025-06-24 19:00:00	AAPL	Stock	200.6	200.8	200.6	200.7901	36534.0
2025-06-24 04:00:00	MSFT	Stock	491.52	491.52	490.0	490.0	4798.0
2025-06-24 05:00:00	MSFT	Stock	489.91	490.41	489.9	489.9	2442.0
2025-06-24 06:00:00	MSFT	Stock	489.78	489.78	488.28	488.94	1800.0
2025-06-24 07:00:00	MSFT	Stock	488.5	488.84	487.05	488.75	8731.0
2025-06-24 08:00:00	MSFT	Stock	488.84	491.76	487.505	487.7	24761.0
2025-06-24 09:00:00	MSFT	Stock	487.8	489.66	486.795	487.525	1427621.0
2025-06-24 10:00:00	MSFT	Stock	487.625	489.53	487.1	489.0	1483897.0
2025-06-24 11:00:00	MSFT	Stock	489.02	491.49	488.99	491.21	1795682.0
2025-06-24 12:00:00	MSFT	Stock	491.183	491.41	490.07	490.28	971180.0
2025-06-24 13:00:00	MSFT	Stock	490.28	491.849	489.94	491.64	944562.0
2025-06-24 14:00:00	MSFT	Stock	491.64	491.68	490.45	490.62	711676.0
2025-06-24 15:00:00	MSFT	Stock	490.6	491.19	489.51	490.12	1990917.0
2025-06-24 16:00:00	MSFT	Stock	490.29	490.9763	489.62	490.0	3347453.0
2025-06-24 17:00:00	MSFT	Stock	490.0	490.49	490.0	490.4	2063.0
2025-06-24 18:00:00	MSFT	Stock	490.3777	490.3777	489.8363	489.8363	350.0
2025-06-24 19:00:00	MSFT	Stock	490.05	490.23	489.9001	490.23	2022.0
2025-06-24 04:00:00	NVDA	Stock	145.82	145.95	145.5	145.73	290933.0
2025-06-24 05:00:00	NVDA	Stock	145.73	145.95	145.69	145.75	135085.0
2025-06-24 06:00:00	NVDA	Stock	145.73	145.78	145.54	145.69	188266.0
2025-06-24 07:00:00	NVDA	Stock	145.66	145.77	145.25	145.5	461243.0
2025-06-24 08:00:00	NVDA	Stock	145.51	146.36	145.23	145.44	1477169.0
2025-06-24 09:00:00	NVDA	Stock	145.42	147.91	145.33	147.1292	31815147.0
2025-06-24 10:00:00	NVDA	Stock	147.125	147.43	146.05	147.055	23968715.0
2025-06-24 11:00:00	NVDA	Stock	147.06	147.28	146.55	146.669	12316673.0
2025-06-24 12:00:00	NVDA	Stock	146.665	147.43	146.6533	147.1013	10589142.0
2025-06-24 13:00:00	NVDA	Stock	147.105	147.59	147.02	147.455	11323325.0
2025-06-24 14:00:00	NVDA	Stock	147.4586	147.6	147.17	147.3902	9034684.0
2025-06-24 15:00:00	NVDA	Stock	147.3982	147.96	147.185	147.83	20677724.0
2025-06-24 16:00:00	NVDA	Stock	147.83	147.93	147.61	147.61	22382426.0
2025-06-24 17:00:00	NVDA	Stock	147.62	147.63	147.4	147.5999	267735.0
2025-06-24 18:00:00	NVDA	Stock	147.59	147.59	147.42	147.52	175988.0
2025-06-24 19:00:00	NVDA	Stock	147.53	147.8	147.51	147.8	268413.0
2025-06-24 04:00:00	AMZN	Stock	211.3	212.47	211.3	212.2	40210.0
2025-06-24 05:00:00	AMZN	Stock	212.22	212.43	211.9	211.9	12797.0

> showing 50 of 63,107 rows — these rows as CSV

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