PREVIEW / stock_1hour / 2025-03-24

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-03-24.parquet
  size:    1.4 MB
  rows:    62,854
  symbols: 484

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-03-24 04:00:00	AAPL	Stock	219.8	220.6	219.3	220.39	46109.0
2025-03-24 05:00:00	AAPL	Stock	220.43	220.84	220.35	220.53	52783.0
2025-03-24 06:00:00	AAPL	Stock	220.6	220.61	219.87	220.15	46536.0
2025-03-24 07:00:00	AAPL	Stock	220.15	220.32	219.77	220.19	60179.0
2025-03-24 08:00:00	AAPL	Stock	219.9	220.59	219.68	220.5	97455.0
2025-03-24 09:00:00	AAPL	Stock	220.5	221.22	218.58	220.2101	4841779.0
2025-03-24 10:00:00	AAPL	Stock	220.2065	220.37	219.22	219.73	3556134.0
2025-03-24 11:00:00	AAPL	Stock	219.73	220.69	218.96	219.79	3218166.0
2025-03-24 12:00:00	AAPL	Stock	219.79	220.05	218.82	219.29	2146588.0
2025-03-24 13:00:00	AAPL	Stock	219.29	219.59	218.89	219.57	1911477.0
2025-03-24 14:00:00	AAPL	Stock	219.59	220.38	219.17	220.125	2401727.0
2025-03-24 15:00:00	AAPL	Stock	220.1332	221.48	219.5837	220.43	6241338.0
2025-03-24 16:00:00	AAPL	Stock	220.38	220.85	220.38	220.72	9019137.0
2025-03-24 17:00:00	AAPL	Stock	220.73	220.82	220.7	220.76	17406.0
2025-03-24 18:00:00	AAPL	Stock	220.76	220.8	220.7	220.71	23840.0
2025-03-24 19:00:00	AAPL	Stock	220.79	220.876	220.7135	220.74	12458.0
2025-03-24 04:00:00	MSFT	Stock	394.46	395.57	393.25	395.36	11126.0
2025-03-24 05:00:00	MSFT	Stock	395.16	395.2	394.66	394.82	5028.0
2025-03-24 06:00:00	MSFT	Stock	394.62	395.35	394.31	394.94	10645.0
2025-03-24 07:00:00	MSFT	Stock	394.97	396.3	394.4	396.0	23349.0
2025-03-24 08:00:00	MSFT	Stock	395.24	396.71	394.15	396.13	42875.0
2025-03-24 09:00:00	MSFT	Stock	396.21	396.53	391.47	391.7	2177276.0
2025-03-24 10:00:00	MSFT	Stock	391.8	392.58	389.81	391.96	1870388.0
2025-03-24 11:00:00	MSFT	Stock	391.97	393.4631	391.81	392.975	1150500.0
2025-03-24 12:00:00	MSFT	Stock	393.0	393.4191	392.17	392.3325	966075.0
2025-03-24 13:00:00	MSFT	Stock	392.37	392.72	391.85	392.16	661847.0
2025-03-24 14:00:00	MSFT	Stock	392.175	392.84	391.65	392.72	698201.0
2025-03-24 15:00:00	MSFT	Stock	392.74	393.94	392.26	392.91	1918865.0
2025-03-24 16:00:00	MSFT	Stock	393.08	393.25	392.5	392.74	4033700.0
2025-03-24 17:00:00	MSFT	Stock	392.9	392.98	392.67	392.86	3542.0
2025-03-24 18:00:00	MSFT	Stock	392.9681	392.98	392.71	392.96	4498.0
2025-03-24 19:00:00	MSFT	Stock	392.85	393.0599	392.71	393.0538	5003.0
2025-03-24 04:00:00	NVDA	Stock	119.3	119.64	118.51	119.06	594487.0
2025-03-24 05:00:00	NVDA	Stock	119.06	119.2	118.74	119.12	313106.0
2025-03-24 06:00:00	NVDA	Stock	119.08	119.49	119.01	119.31	349803.0
2025-03-24 07:00:00	NVDA	Stock	119.29	120.14	119.27	119.88	903873.0
2025-03-24 08:00:00	NVDA	Stock	119.4	120.18	117.406	120.0101	2461956.0
2025-03-24 09:00:00	NVDA	Stock	120.04	121.07	119.58	120.035	29484686.0
2025-03-24 10:00:00	NVDA	Stock	120.04	121.94	119.34	121.715	35029305.0
2025-03-24 11:00:00	NVDA	Stock	121.715	122.22	121.35	121.69	22002876.0
2025-03-24 12:00:00	NVDA	Stock	121.685	122.22	121.61	121.9099	15372471.0
2025-03-24 13:00:00	NVDA	Stock	121.9013	122.0	121.38	121.84	12213622.0
2025-03-24 14:00:00	NVDA	Stock	121.85	122.05	121.56	121.905	13039052.0
2025-03-24 15:00:00	NVDA	Stock	121.91	122.08	121.23	121.23	24303882.0
2025-03-24 16:00:00	NVDA	Stock	121.22	121.41	121.16	121.29	22249816.0
2025-03-24 17:00:00	NVDA	Stock	121.2801	121.41	121.16	121.2128	335945.0
2025-03-24 18:00:00	NVDA	Stock	121.2	121.23	120.94	120.96	404638.0
2025-03-24 19:00:00	NVDA	Stock	120.97	121.03	120.9	120.9305	362636.0
2025-03-24 04:00:00	AMZN	Stock	198.69	199.66	198.69	199.19	34134.0
2025-03-24 05:00:00	AMZN	Stock	199.3	199.46	198.96	199.19	22308.0

> showing 50 of 62,854 rows — these rows as CSV

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