PREVIEW / stock_1hour / 2025-07-24

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-07-24.parquet
  size:    1.4 MB
  rows:    63,149
  symbols: 364

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-24 04:00:00	AAPL	Stock	213.7	214.14	213.1	213.9	17216.0
2025-07-24 05:00:00	AAPL	Stock	213.89	214.0	213.8	213.9	18312.0
2025-07-24 06:00:00	AAPL	Stock	213.85	213.9	213.4	213.5	32716.0
2025-07-24 07:00:00	AAPL	Stock	213.59	213.93	213.59	213.67	15951.0
2025-07-24 08:00:00	AAPL	Stock	213.6	214.08	213.34	213.7799	167517.0
2025-07-24 09:00:00	AAPL	Stock	213.74	215.69	213.4	213.83	5339400.0
2025-07-24 10:00:00	AAPL	Stock	213.84	214.83	213.565	214.3223	4618958.0
2025-07-24 11:00:00	AAPL	Stock	214.32	215.5	214.31	214.8953	5238502.0
2025-07-24 12:00:00	AAPL	Stock	214.89	214.89	214.2	214.675	2560830.0
2025-07-24 13:00:00	AAPL	Stock	214.67	215.2	214.56	214.68	1908961.0
2025-07-24 14:00:00	AAPL	Stock	214.68	215.21	214.33	214.53	2308511.0
2025-07-24 15:00:00	AAPL	Stock	214.52	215.02	213.72	213.76	5877995.0
2025-07-24 16:00:00	AAPL	Stock	213.76	214.15	213.71	213.95	6173081.0
2025-07-24 17:00:00	AAPL	Stock	214.0	214.08	213.89	214.01	35435.0
2025-07-24 18:00:00	AAPL	Stock	214.01	214.22	213.99	214.01	22049.0
2025-07-24 19:00:00	AAPL	Stock	214.0152	214.2	214.01	214.05	9366.0
2025-07-24 04:00:00	MSFT	Stock	506.42	506.5	506.39	506.4	810.0
2025-07-24 05:00:00	MSFT	Stock	506.4	506.4	506.15	506.17	922.0
2025-07-24 06:00:00	MSFT	Stock	505.82	505.82	505.07	505.31	900.0
2025-07-24 07:00:00	MSFT	Stock	505.48	506.05	505.05	506.05	1250.0
2025-07-24 08:00:00	MSFT	Stock	506.0	506.44	505.0	505.77	16062.0
2025-07-24 09:00:00	MSFT	Stock	505.69	510.53	505.3006	509.31	1416424.0
2025-07-24 10:00:00	MSFT	Stock	509.32	510.41	507.675	510.1463	999956.0
2025-07-24 11:00:00	MSFT	Stock	510.15	512.41	509.833	511.87	1067130.0
2025-07-24 12:00:00	MSFT	Stock	511.87	512.69	510.96	512.185	716096.0
2025-07-24 13:00:00	MSFT	Stock	512.185	513.22	511.89	511.965	550059.0
2025-07-24 14:00:00	MSFT	Stock	511.965	512.92	511.61	511.97	714547.0
2025-07-24 15:00:00	MSFT	Stock	511.98	513.67	510.6368	510.85	1662735.0
2025-07-24 16:00:00	MSFT	Stock	510.88	512.0	510.88	511.39	3015071.0
2025-07-24 17:00:00	MSFT	Stock	511.56	512.05	511.56	511.97	4447.0
2025-07-24 18:00:00	MSFT	Stock	511.9931	512.5476	511.53	511.53	2539.0
2025-07-24 19:00:00	MSFT	Stock	511.95	512.2286	511.5	511.61	1886.0
2025-07-24 04:00:00	NVDA	Stock	172.79	173.0	172.17	172.83	191534.0
2025-07-24 05:00:00	NVDA	Stock	172.83	172.83	172.53	172.74	69101.0
2025-07-24 06:00:00	NVDA	Stock	172.74	172.83	172.61	172.7	113355.0
2025-07-24 07:00:00	NVDA	Stock	172.71	172.98	172.2	172.62	322735.0
2025-07-24 08:00:00	NVDA	Stock	172.28	172.97	172.01	172.35	1235203.0
2025-07-24 09:00:00	NVDA	Stock	172.35	173.45	171.71	172.34	18377086.0
2025-07-24 10:00:00	NVDA	Stock	172.33	172.98	171.3	172.88	18180902.0
2025-07-24 11:00:00	NVDA	Stock	172.89	173.2	172.4	172.7452	13632174.0
2025-07-24 12:00:00	NVDA	Stock	172.74	173.33	172.41	173.178	9737071.0
2025-07-24 13:00:00	NVDA	Stock	173.1799	173.68	173.04	173.255	10083117.0
2025-07-24 14:00:00	NVDA	Stock	173.25	173.83	173.22	173.615	8672460.0
2025-07-24 15:00:00	NVDA	Stock	173.61	173.82	173.315	173.78	12845850.0
2025-07-24 16:00:00	NVDA	Stock	173.74	173.78	173.45	173.48	10694992.0
2025-07-24 17:00:00	NVDA	Stock	173.4702	173.66	173.4	173.55	190858.0
2025-07-24 18:00:00	NVDA	Stock	173.55	173.72	173.49	173.53	260990.0
2025-07-24 19:00:00	NVDA	Stock	173.54	173.65	173.5	173.57	155890.0
2025-07-24 04:00:00	AMZN	Stock	228.91	229.95	228.91	229.8	25079.0
2025-07-24 05:00:00	AMZN	Stock	229.82	229.86	229.6	229.8	6681.0

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

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