PREVIEW / stock_1hour / 2025-07-02

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-07-02.parquet
  size:    1.4 MB
  rows:    62,121
  symbols: 379

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-02 04:00:00	AAPL	Stock	209.38	209.62	209.01	209.19	21966.0
2025-07-02 05:00:00	AAPL	Stock	209.28	209.55	209.21	209.46	17094.0
2025-07-02 06:00:00	AAPL	Stock	209.49	209.57	209.3	209.34	29079.0
2025-07-02 07:00:00	AAPL	Stock	209.35	210.32	209.2	210.05	121510.0
2025-07-02 08:00:00	AAPL	Stock	210.11	210.92	209.18	209.64	548006.0
2025-07-02 09:00:00	AAPL	Stock	209.6982	213.34	208.14	212.62	13086658.0
2025-07-02 10:00:00	AAPL	Stock	212.625	212.97	211.2737	211.91	10030786.0
2025-07-02 11:00:00	AAPL	Stock	211.92	212.59	211.23	211.55	5162891.0
2025-07-02 12:00:00	AAPL	Stock	211.56	211.9188	210.22	211.105	4863526.0
2025-07-02 13:00:00	AAPL	Stock	211.1	211.72	210.43	211.61	3288360.0
2025-07-02 14:00:00	AAPL	Stock	211.61	212.5	211.16	212.27	3479833.0
2025-07-02 15:00:00	AAPL	Stock	212.27	212.96	211.84	212.41	8106253.0
2025-07-02 16:00:00	AAPL	Stock	212.35	212.64	211.85	211.86	5271388.0
2025-07-02 17:00:00	AAPL	Stock	211.84	212.44	211.83	212.08	35269.0
2025-07-02 18:00:00	AAPL	Stock	212.02	212.4	211.92	212.002	12726.0
2025-07-02 19:00:00	AAPL	Stock	212.01	212.16	212.01	212.1111	24524.0
2025-07-02 04:00:00	MSFT	Stock	491.57	491.57	491.4	491.4	1133.0
2025-07-02 05:00:00	MSFT	Stock	491.01	491.01	490.88	490.9	875.0
2025-07-02 06:00:00	MSFT	Stock	490.57	490.57	490.19	490.19	2100.0
2025-07-02 07:00:00	MSFT	Stock	490.73	490.8	489.05	489.43	11092.0
2025-07-02 08:00:00	MSFT	Stock	489.64	491.0	488.33	489.02	27783.0
2025-07-02 09:00:00	MSFT	Stock	488.94	493.5	488.7	491.015	1439812.0
2025-07-02 10:00:00	MSFT	Stock	490.99	492.6487	490.31	491.81	1148505.0
2025-07-02 11:00:00	MSFT	Stock	491.81	492.76	491.24	491.68	862583.0
2025-07-02 12:00:00	MSFT	Stock	491.68	492.69	491.2301	491.3	594613.0
2025-07-02 13:00:00	MSFT	Stock	491.29	491.33	489.85	490.42	905983.0
2025-07-02 14:00:00	MSFT	Stock	490.415	490.56	489.79	490.16	518138.0
2025-07-02 15:00:00	MSFT	Stock	490.19	492.03	489.7	490.97	1653392.0
2025-07-02 16:00:00	MSFT	Stock	491.01	491.88	490.95	491.0277	2478894.0
2025-07-02 17:00:00	MSFT	Stock	491.12	491.49	491.09	491.29	4103.0
2025-07-02 18:00:00	MSFT	Stock	491.25	491.5	491.1	491.49	3260.0
2025-07-02 19:00:00	MSFT	Stock	491.468	491.51	491.05	491.51	1250.0
2025-07-02 04:00:00	NVDA	Stock	153.38	153.61	153.1	153.2	156509.0
2025-07-02 05:00:00	NVDA	Stock	153.22	153.25	152.89	153.15	108107.0
2025-07-02 06:00:00	NVDA	Stock	153.15	153.18	152.18	152.46	239381.0
2025-07-02 07:00:00	NVDA	Stock	152.49	152.63	152.1	152.31	276924.0
2025-07-02 08:00:00	NVDA	Stock	152.52	153.9	151.1	151.52	2021613.0
2025-07-02 09:00:00	NVDA	Stock	151.54	155.3	151.46	154.33	21402957.0
2025-07-02 10:00:00	NVDA	Stock	154.33	157.435	154.29	157.1052	28584971.0
2025-07-02 11:00:00	NVDA	Stock	157.11	157.6	156.0602	156.655	17773332.0
2025-07-02 12:00:00	NVDA	Stock	156.66	157.57	156.53	157.2467	14941482.0
2025-07-02 13:00:00	NVDA	Stock	157.24	157.47	156.9	157.1699	9239526.0
2025-07-02 14:00:00	NVDA	Stock	157.17	157.18	156.66	156.69	10096000.0
2025-07-02 15:00:00	NVDA	Stock	156.69	157.52	156.51	157.24	20907787.0
2025-07-02 16:00:00	NVDA	Stock	157.24	157.45	156.92	157.1064	15734437.0
2025-07-02 17:00:00	NVDA	Stock	157.09	157.13	156.82	157.0	257712.0
2025-07-02 18:00:00	NVDA	Stock	156.96	157.09	156.92	157.07	140203.0
2025-07-02 19:00:00	NVDA	Stock	157.08	157.25	157.04	157.25	173589.0
2025-07-02 04:00:00	AMZN	Stock	221.36	221.42	220.85	221.04	8661.0
2025-07-02 05:00:00	AMZN	Stock	221.02	221.08	220.72	220.95	4145.0

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

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