PREVIEW / stock_1hour / 2025-07-21

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-07-21.parquet
  size:    1.5 MB
  rows:    64,919
  symbols: 367

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-07-21 04:00:00	AAPL	Stock	211.22	211.88	211.22	211.77	10102.0
2025-07-21 05:00:00	AAPL	Stock	211.78	211.95	211.78	211.9	7528.0
2025-07-21 06:00:00	AAPL	Stock	211.94	212.7	211.91	212.4	42665.0
2025-07-21 07:00:00	AAPL	Stock	212.28	212.65	212.07	212.55	25314.0
2025-07-21 08:00:00	AAPL	Stock	212.31	213.0	211.61	212.44	213990.0
2025-07-21 09:00:00	AAPL	Stock	212.4	215.78	211.58	214.0	10110209.0
2025-07-21 10:00:00	AAPL	Stock	214.01	215.19	213.2852	213.41	7434313.0
2025-07-21 11:00:00	AAPL	Stock	213.41	213.71	212.87	213.3996	3782155.0
2025-07-21 12:00:00	AAPL	Stock	213.385	213.86	213.14	213.56	2219625.0
2025-07-21 13:00:00	AAPL	Stock	213.55	213.73	212.885	212.9099	2208017.0
2025-07-21 14:00:00	AAPL	Stock	212.91	213.43	212.505	213.0502	2406928.0
2025-07-21 15:00:00	AAPL	Stock	213.07	213.1099	212.06	212.54	4071200.0
2025-07-21 16:00:00	AAPL	Stock	212.529	212.75	211.9	212.28	4653228.0
2025-07-21 17:00:00	AAPL	Stock	212.2501	212.48	212.15	212.2523	39789.0
2025-07-21 18:00:00	AAPL	Stock	212.42	212.48	212.25	212.48	15146.0
2025-07-21 19:00:00	AAPL	Stock	212.48	212.7375	212.4799	212.67	26531.0
2025-07-21 04:00:00	MSFT	Stock	510.0	510.18	509.0	509.1	5830.0
2025-07-21 05:00:00	MSFT	Stock	509.51	509.64	509.5	509.5	444.0
2025-07-21 06:00:00	MSFT	Stock	509.85	509.85	509.17	509.39	2629.0
2025-07-21 07:00:00	MSFT	Stock	509.56	509.61	509.0	509.0	5859.0
2025-07-21 08:00:00	MSFT	Stock	509.1	510.21	506.56	506.94	60663.0
2025-07-21 09:00:00	MSFT	Stock	506.7	512.09	505.55	511.51	1514838.0
2025-07-21 10:00:00	MSFT	Stock	511.53	512.07	510.5601	510.635	915354.0
2025-07-21 11:00:00	MSFT	Stock	510.66	510.85	509.99	510.75	666076.0
2025-07-21 12:00:00	MSFT	Stock	510.75	511.3699	509.8	510.97	744740.0
2025-07-21 13:00:00	MSFT	Stock	510.99	511.0485	510.31	510.34	452873.0
2025-07-21 14:00:00	MSFT	Stock	510.3141	510.59	509.97	510.505	392515.0
2025-07-21 15:00:00	MSFT	Stock	510.55	510.8	509.5	510.2	1358546.0
2025-07-21 16:00:00	MSFT	Stock	510.06	510.28	508.05	510.0	2341751.0
2025-07-21 17:00:00	MSFT	Stock	510.0	510.06	509.0235	510.06	7136.0
2025-07-21 18:00:00	MSFT	Stock	509.7	510.0	509.7	510.0	200.0
2025-07-21 19:00:00	MSFT	Stock	509.731	509.95	509.512	509.7	4177.0
2025-07-21 04:00:00	NVDA	Stock	172.93	173.0	172.52	172.59	184401.0
2025-07-21 05:00:00	NVDA	Stock	172.6	172.89	172.59	172.75	121631.0
2025-07-21 06:00:00	NVDA	Stock	172.74	173.25	172.62	172.85	194251.0
2025-07-21 07:00:00	NVDA	Stock	172.86	172.89	172.4	172.48	220241.0
2025-07-21 08:00:00	NVDA	Stock	172.83	173.2	172.4	172.5	1078943.0
2025-07-21 09:00:00	NVDA	Stock	172.49	173.38	171.68	172.4318	17407145.0
2025-07-21 10:00:00	NVDA	Stock	172.43	173.165	172.09	172.905	15960634.0
2025-07-21 11:00:00	NVDA	Stock	172.9	173.03	172.23	172.3552	9903061.0
2025-07-21 12:00:00	NVDA	Stock	172.355	172.49	171.45	172.345	11921773.0
2025-07-21 13:00:00	NVDA	Stock	172.35	172.76	172.2	172.64	6431656.0
2025-07-21 14:00:00	NVDA	Stock	172.6499	172.81	172.1847	172.2914	6259553.0
2025-07-21 15:00:00	NVDA	Stock	172.3	172.355	171.0	171.46	14866693.0
2025-07-21 16:00:00	NVDA	Stock	171.45	171.52	170.9	171.19	11319593.0
2025-07-21 17:00:00	NVDA	Stock	171.24	171.38	170.23	170.6801	832245.0
2025-07-21 18:00:00	NVDA	Stock	170.75	171.05	170.61	171.0101	268190.0
2025-07-21 19:00:00	NVDA	Stock	171.02	171.12	170.83	171.0	236056.0
2025-07-21 04:00:00	AMZN	Stock	226.78	227.08	226.69	227.03	15168.0
2025-07-21 05:00:00	AMZN	Stock	227.05	227.06	226.96	227.0	4642.0

> showing 50 of 64,919 rows — these rows as CSV

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