PREVIEW / stock_1hour / 2025-07-01

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-07-01.parquet
  size:    1.4 MB
  rows:    62,675
  symbols: 387

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-01 04:00:00	AAPL	Stock	205.5	205.59	204.61	205.42	60230.0
2025-07-01 05:00:00	AAPL	Stock	205.45	205.51	205.16	205.41	11849.0
2025-07-01 06:00:00	AAPL	Stock	205.42	205.76	205.42	205.76	22517.0
2025-07-01 07:00:00	AAPL	Stock	205.72	206.57	205.7	206.27	106352.0
2025-07-01 08:00:00	AAPL	Stock	205.8	207.47	204.44	207.2	767120.0
2025-07-01 09:00:00	AAPL	Stock	207.21	209.11	205.17	209.0848	13570346.0
2025-07-01 10:00:00	AAPL	Stock	209.06	209.9	207.47	208.96	12078764.0
2025-07-01 11:00:00	AAPL	Stock	208.96	210.1865	206.79	207.3029	9011169.0
2025-07-01 12:00:00	AAPL	Stock	207.3	208.53	207.14	207.1754	5010331.0
2025-07-01 13:00:00	AAPL	Stock	207.18	208.37	207.09	208.15	3666390.0
2025-07-01 14:00:00	AAPL	Stock	208.15	208.43	207.8501	208.01	2975024.0
2025-07-01 15:00:00	AAPL	Stock	208.02	208.35	207.375	207.86	6105208.0
2025-07-01 16:00:00	AAPL	Stock	207.86	209.8	207.7696	209.23	6128343.0
2025-07-01 17:00:00	AAPL	Stock	209.17	209.5	207.82	209.2	142776.0
2025-07-01 18:00:00	AAPL	Stock	209.2	209.3	209.0	209.18	38289.0
2025-07-01 19:00:00	AAPL	Stock	209.07	209.29	208.8	208.92	57213.0
2025-07-01 04:00:00	MSFT	Stock	497.89	498.77	497.89	498.33	10110.0
2025-07-01 05:00:00	MSFT	Stock	498.22	498.22	497.64	497.64	477.0
2025-07-01 06:00:00	MSFT	Stock	498.08	498.25	497.8	497.8	685.0
2025-07-01 07:00:00	MSFT	Stock	497.87	497.97	497.43	497.43	3025.0
2025-07-01 08:00:00	MSFT	Stock	498.23	498.41	496.167	497.818	27591.0
2025-07-01 09:00:00	MSFT	Stock	497.57	498.05	495.39	497.465	1265704.0
2025-07-01 10:00:00	MSFT	Stock	497.38	498.02	495.27	495.3925	1438363.0
2025-07-01 11:00:00	MSFT	Stock	495.372	495.59	491.81	491.845	1604145.0
2025-07-01 12:00:00	MSFT	Stock	491.845	494.05	490.98	493.49	1112430.0
2025-07-01 13:00:00	MSFT	Stock	493.49	493.86	492.23	493.2574	782827.0
2025-07-01 14:00:00	MSFT	Stock	493.25	493.31	492.2813	492.375	539192.0
2025-07-01 15:00:00	MSFT	Stock	492.36	493.15	491.19	492.1	1675152.0
2025-07-01 16:00:00	MSFT	Stock	492.05	492.69	491.0	491.8	3251892.0
2025-07-01 17:00:00	MSFT	Stock	491.4453	492.05	491.16	491.49	6245.0
2025-07-01 18:00:00	MSFT	Stock	491.79	491.79	491.2	491.6187	5847.0
2025-07-01 19:00:00	MSFT	Stock	491.7	492.0	491.4	491.5128	2590.0
2025-07-01 04:00:00	NVDA	Stock	156.93	157.33	156.88	157.2	201423.0
2025-07-01 05:00:00	NVDA	Stock	157.18	157.22	156.65	156.84	146429.0
2025-07-01 06:00:00	NVDA	Stock	156.85	157.04	156.65	156.74	104689.0
2025-07-01 07:00:00	NVDA	Stock	156.74	156.97	156.5	156.6	174180.0
2025-07-01 08:00:00	NVDA	Stock	156.8	157.55	155.7	156.42	1790327.0
2025-07-01 09:00:00	NVDA	Stock	156.41	157.2	155.76	156.0508	17151234.0
2025-07-01 10:00:00	NVDA	Stock	156.04	156.3	152.83	153.125	35999868.0
2025-07-01 11:00:00	NVDA	Stock	153.12	153.47	151.49	152.8184	32042491.0
2025-07-01 12:00:00	NVDA	Stock	152.82	154.7883	152.35	154.365	20163877.0
2025-07-01 13:00:00	NVDA	Stock	154.37	154.98	154.01	154.545	15403663.0
2025-07-01 14:00:00	NVDA	Stock	154.55	154.72	153.47	153.595	11693003.0
2025-07-01 15:00:00	NVDA	Stock	153.59	154.5	152.9101	153.29	25327706.0
2025-07-01 16:00:00	NVDA	Stock	153.3	153.52	152.91	153.1	12927090.0
2025-07-01 17:00:00	NVDA	Stock	153.1335	153.3	152.85	152.9638	297652.0
2025-07-01 18:00:00	NVDA	Stock	153.02	153.1	152.87	153.01	235871.0
2025-07-01 19:00:00	NVDA	Stock	153.03	153.11	152.84	152.8998	199666.0
2025-07-01 04:00:00	AMZN	Stock	219.98	219.98	218.39	219.24	28233.0
2025-07-01 05:00:00	AMZN	Stock	219.24	219.24	218.98	219.17	6521.0

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

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