PREVIEW / stock_1hour / 2025-03-28

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-03-28.parquet
  size:    1.4 MB
  rows:    60,090
  symbols: 480

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-28 04:00:00	AAPL	Stock	222.0	222.7	222.0	222.25	21437.0
2025-03-28 05:00:00	AAPL	Stock	222.12	222.29	222.0	222.03	8708.0
2025-03-28 06:00:00	AAPL	Stock	222.1	222.6	222.1	222.39	13428.0
2025-03-28 07:00:00	AAPL	Stock	222.39	222.45	221.99	222.2	15682.0
2025-03-28 08:00:00	AAPL	Stock	222.05	223.64	221.58	221.92	70494.0
2025-03-28 09:00:00	AAPL	Stock	221.82	223.81	220.99	223.38	3903381.0
2025-03-28 10:00:00	AAPL	Stock	223.35	223.73	219.62	220.6	4711317.0
2025-03-28 11:00:00	AAPL	Stock	220.595	220.6	219.17	219.53	2748586.0
2025-03-28 12:00:00	AAPL	Stock	219.51	219.83	218.35	218.6	2001022.0
2025-03-28 13:00:00	AAPL	Stock	218.59	219.1	218.18	218.76	1910490.0
2025-03-28 14:00:00	AAPL	Stock	218.74	219.1665	218.4031	218.51	1777556.0
2025-03-28 15:00:00	AAPL	Stock	218.49	219.04	217.68	217.85	5391866.0
2025-03-28 16:00:00	AAPL	Stock	217.84	223.85	217.4	217.42	7148998.0
2025-03-28 17:00:00	AAPL	Stock	217.42	217.59	217.32	217.59	14412.0
2025-03-28 18:00:00	AAPL	Stock	217.5	217.5365	217.4	217.4508	16519.0
2025-03-28 19:00:00	AAPL	Stock	217.45	217.54	217.22	217.22	12654.0
2025-03-28 04:00:00	MSFT	Stock	388.7	388.79	388.39	388.62	877.0
2025-03-28 05:00:00	MSFT	Stock	388.73	388.89	388.5	388.5	460.0
2025-03-28 06:00:00	MSFT	Stock	389.06	389.3	389.06	389.19	551.0
2025-03-28 07:00:00	MSFT	Stock	389.18	389.19	388.55	388.55	1885.0
2025-03-28 08:00:00	MSFT	Stock	389.18	389.25	387.3808	387.8	19870.0
2025-03-28 09:00:00	MSFT	Stock	387.7	389.29	386.07	387.675	1077245.0
2025-03-28 10:00:00	MSFT	Stock	387.62	388.29	382.09	382.64	1437505.0
2025-03-28 11:00:00	MSFT	Stock	382.7	383.07	381.47	381.59	1062001.0
2025-03-28 12:00:00	MSFT	Stock	381.55	382.07	379.35	379.435	1079867.0
2025-03-28 13:00:00	MSFT	Stock	379.435	379.435	377.4	378.6	1413367.0
2025-03-28 14:00:00	MSFT	Stock	378.58	379.63	378.1006	378.17	1194026.0
2025-03-28 15:00:00	MSFT	Stock	378.17	380.0	376.93	378.82	2542837.0
2025-03-28 16:00:00	MSFT	Stock	378.72	390.58	377.0	377.0	4303809.0
2025-03-28 17:00:00	MSFT	Stock	377.97	378.2	377.05	377.82	11117.0
2025-03-28 18:00:00	MSFT	Stock	378.01	378.05	377.13	377.3416	6540.0
2025-03-28 19:00:00	MSFT	Stock	377.64	377.64	377.5037	377.62	3359.0
2025-03-28 04:00:00	NVDA	Stock	111.0	111.74	110.74	111.53	431051.0
2025-03-28 05:00:00	NVDA	Stock	111.54	111.85	111.3	111.4	207470.0
2025-03-28 06:00:00	NVDA	Stock	111.37	112.38	111.37	112.09	286165.0
2025-03-28 07:00:00	NVDA	Stock	112.1	112.25	111.65	111.89	385754.0
2025-03-28 08:00:00	NVDA	Stock	112.08	112.37	110.7604	111.29	1803471.0
2025-03-28 09:00:00	NVDA	Stock	111.26	112.87	110.81	111.56	25972001.0
2025-03-28 10:00:00	NVDA	Stock	111.56	111.84	109.0701	109.72	39586453.0
2025-03-28 11:00:00	NVDA	Stock	109.72	110.1839	109.28	109.385	21046524.0
2025-03-28 12:00:00	NVDA	Stock	109.39	110.145	109.1	109.515	21613874.0
2025-03-28 13:00:00	NVDA	Stock	109.51	109.99	109.24	109.89	16861084.0
2025-03-28 14:00:00	NVDA	Stock	109.88	110.4182	109.7	110.3844	17240371.0
2025-03-28 15:00:00	NVDA	Stock	110.3801	110.61	109.4	109.63	29232914.0
2025-03-28 16:00:00	NVDA	Stock	109.62	111.43	109.1	109.13	17369460.0
2025-03-28 17:00:00	NVDA	Stock	109.15	109.67	109.07	109.26	462230.0
2025-03-28 18:00:00	NVDA	Stock	109.26	109.29	109.06	109.07	216641.0
2025-03-28 19:00:00	NVDA	Stock	109.07	109.08	109.0	109.0101	364685.0
2025-03-28 04:00:00	AMZN	Stock	200.25	200.48	199.94	200.09	16075.0
2025-03-28 05:00:00	AMZN	Stock	200.05	200.32	200.0	200.11	2212.0

> showing 50 of 60,090 rows — these rows as CSV

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