PREVIEW / stock_1hour / 2025-08-07

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-08-07.parquet
  size:    1.4 MB
  rows:    63,633
  symbols: 353

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-08-07 04:00:00	AAPL	Stock	218.97	219.71	218.36	219.7	90141.0
2025-08-07 05:00:00	AAPL	Stock	219.69	220.32	219.2	220.14	76245.0
2025-08-07 06:00:00	AAPL	Stock	220.0	220.31	219.14	219.87	95543.0
2025-08-07 07:00:00	AAPL	Stock	219.9	220.08	218.75	219.5	220575.0
2025-08-07 08:00:00	AAPL	Stock	219.63	220.31	217.93	218.86	668798.0
2025-08-07 09:00:00	AAPL	Stock	218.86	220.33	216.58	219.555	16851779.0
2025-08-07 10:00:00	AAPL	Stock	219.59	219.99	217.56	219.1455	10835974.0
2025-08-07 11:00:00	AAPL	Stock	219.145	220.1998	218.97	219.605	8688991.0
2025-08-07 12:00:00	AAPL	Stock	219.6	220.34	218.8	219.205	7136878.0
2025-08-07 13:00:00	AAPL	Stock	219.22	219.61	218.7026	219.27	4261872.0
2025-08-07 14:00:00	AAPL	Stock	219.28	220.85	219.0354	220.43	5514931.0
2025-08-07 15:00:00	AAPL	Stock	220.45	220.5798	219.24	220.13	8725572.0
2025-08-07 16:00:00	AAPL	Stock	220.16	220.89	220.03	220.11	6070464.0
2025-08-07 17:00:00	AAPL	Stock	220.08	220.2	220.0	220.05	46752.0
2025-08-07 18:00:00	AAPL	Stock	220.18	221.79	220.13	221.71	119737.0
2025-08-07 19:00:00	AAPL	Stock	221.72	221.86	221.05	221.2895	106134.0
2025-08-07 04:00:00	MSFT	Stock	526.65	527.98	526.43	527.69	5443.0
2025-08-07 05:00:00	MSFT	Stock	527.15	528.5	527.15	528.5	4302.0
2025-08-07 06:00:00	MSFT	Stock	528.51	529.49	528.29	529.48	7073.0
2025-08-07 07:00:00	MSFT	Stock	529.81	530.01	527.52	528.2	20810.0
2025-08-07 08:00:00	MSFT	Stock	529.0	529.67	525.58	528.03	48479.0
2025-08-07 09:00:00	MSFT	Stock	528.1	528.88	523.52	525.35	1476240.0
2025-08-07 10:00:00	MSFT	Stock	525.35	526.4229	523.45	525.375	1314302.0
2025-08-07 11:00:00	MSFT	Stock	525.42	525.6798	522.2501	522.26	934851.0
2025-08-07 12:00:00	MSFT	Stock	522.2594	522.92	520.57	521.93	840575.0
2025-08-07 13:00:00	MSFT	Stock	521.93	522.31	520.3512	520.9115	651587.0
2025-08-07 14:00:00	MSFT	Stock	520.9	521.1099	517.5511	518.86	1185281.0
2025-08-07 15:00:00	MSFT	Stock	518.87	521.1	518.39	521.1	1607620.0
2025-08-07 16:00:00	MSFT	Stock	520.985	521.71	520.68	521.25	2340705.0
2025-08-07 17:00:00	MSFT	Stock	521.2452	521.5	521.121	521.5	3220.0
2025-08-07 18:00:00	MSFT	Stock	521.48	522.9286	521.45	522.38	7688.0
2025-08-07 19:00:00	MSFT	Stock	522.36	522.36	521.86	522.0	5746.0
2025-08-07 04:00:00	NVDA	Stock	180.7	181.31	180.2	181.1	341751.0
2025-08-07 05:00:00	NVDA	Stock	181.08	181.4	181.01	181.32	202582.0
2025-08-07 06:00:00	NVDA	Stock	181.32	181.72	181.27	181.58	321726.0
2025-08-07 07:00:00	NVDA	Stock	181.61	182.13	181.5	181.84	757241.0
2025-08-07 08:00:00	NVDA	Stock	181.97	182.13	180.22	181.75	1582136.0
2025-08-07 09:00:00	NVDA	Stock	181.75	183.7515	181.3	183.39	25478780.0
2025-08-07 10:00:00	NVDA	Stock	183.4	183.88	181.38	181.7125	21674005.0
2025-08-07 11:00:00	NVDA	Stock	181.7001	182.29	181.15	181.6617	13384484.0
2025-08-07 12:00:00	NVDA	Stock	181.67	181.77	179.79	180.4527	15076941.0
2025-08-07 13:00:00	NVDA	Stock	180.45	180.9	179.31	179.96	12108801.0
2025-08-07 14:00:00	NVDA	Stock	179.955	180.24	178.795	180.08	12265135.0
2025-08-07 15:00:00	NVDA	Stock	180.09	180.89	179.17	180.88	14307899.0
2025-08-07 16:00:00	NVDA	Stock	180.89	181.77	180.73	181.31	9258209.0
2025-08-07 17:00:00	NVDA	Stock	181.2999	181.75	181.14	181.4	271573.0
2025-08-07 18:00:00	NVDA	Stock	181.39	181.69	181.35	181.6	253284.0
2025-08-07 19:00:00	NVDA	Stock	181.56	181.64	181.41	181.5999	243052.0
2025-08-07 04:00:00	AMZN	Stock	222.3	222.3	221.84	222.09	26092.0
2025-08-07 05:00:00	AMZN	Stock	221.94	222.58	221.85	222.58	13176.0

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

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