PREVIEW / stock_1hour / 2026-07-29

all stock 1-hour files

  file:    by_date/stock_1hour/2026/2026-07-29.parquet
  size:    1.4 MB
  rows:    60,026

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
2026-07-29 04:00:00	AAPL	Stock	341.25	344.51	340.0	341.44	149802.0
2026-07-29 05:00:00	AAPL	Stock	341.5	341.5	338.69	339.23	38684.0
2026-07-29 06:00:00	AAPL	Stock	339.57	341.22	339.0	341.01	29690.0
2026-07-29 07:00:00	AAPL	Stock	341.11	341.48	340.52	340.75	62701.0
2026-07-29 08:00:00	AAPL	Stock	340.7891	340.8426	338.0	339.0	208762.0
2026-07-29 09:00:00	AAPL	Stock	338.99	343.67	338.5	342.87	5889615.0
2026-07-29 10:00:00	AAPL	Stock	342.825	343.48	340.12	340.39	5433344.0
2026-07-29 11:00:00	AAPL	Stock	340.4	341.23	339.52	341.06	3710740.0
2026-07-29 12:00:00	AAPL	Stock	341.09	341.57	340.05	341.31	2260345.0
2026-07-29 13:00:00	AAPL	Stock	341.33	343.4489	341.115	343.21	3862340.0
2026-07-29 14:00:00	AAPL	Stock	343.195	344.5699	342.7401	342.9	4875272.0
2026-07-29 15:00:00	AAPL	Stock	342.9	343.0	337.3501	338.05	9416247.0
2026-07-29 16:00:00	AAPL	Stock	338.23	339.38	337.12	339.0	7310104.0
2026-07-29 17:00:00	AAPL	Stock	339.0	340.16	338.19	339.48	171682.0
2026-07-29 18:00:00	AAPL	Stock	339.48	340.8	338.87	339.4	90340.0
2026-07-29 19:00:00	AAPL	Stock	339.2	340.4	339.06	340.15	73722.0
2026-07-29 04:00:00	MSFT	Stock	396.8	398.07	394.79	396.68	100302.0
2026-07-29 05:00:00	MSFT	Stock	396.51	396.51	392.0	393.01	41564.0
2026-07-29 06:00:00	MSFT	Stock	393.17	395.34	392.456	394.77	33977.0
2026-07-29 07:00:00	MSFT	Stock	395.12	395.9679	392.99	394.29	57121.0
2026-07-29 08:00:00	MSFT	Stock	394.11	394.9396	393.0496	394.8	51058.0
2026-07-29 09:00:00	MSFT	Stock	394.7	394.89	388.74	392.33	2610871.0
2026-07-29 10:00:00	MSFT	Stock	392.365	394.99	390.81	394.25	2916723.0
2026-07-29 11:00:00	MSFT	Stock	394.27	395.82	394.05	394.66	1795807.0
2026-07-29 12:00:00	MSFT	Stock	394.7	396.0	392.805	395.315	1956287.0
2026-07-29 13:00:00	MSFT	Stock	395.315	397.185	395.05	396.5	2261374.0
2026-07-29 14:00:00	MSFT	Stock	396.5	401.25	396.5	399.56	3988357.0
2026-07-29 15:00:00	MSFT	Stock	399.56	399.66	389.36	392.4	6873643.0
2026-07-29 16:00:00	MSFT	Stock	392.32	409.49	390.0	402.1	6625345.0
2026-07-29 17:00:00	MSFT	Stock	402.11	404.5	396.5	397.42	622276.0
2026-07-29 18:00:00	MSFT	Stock	397.86	429.94	397.86	420.44	2581661.0
2026-07-29 19:00:00	MSFT	Stock	420.48	426.8	419.34	425.21	788313.0
2026-07-29 04:00:00	NVDA	Stock	195.73	197.0	194.1	196.59	377185.0
2026-07-29 05:00:00	NVDA	Stock	196.64	198.19	196.64	198.08	108327.0
2026-07-29 06:00:00	NVDA	Stock	198.01	198.3	196.7896	196.87	83252.0
2026-07-29 07:00:00	NVDA	Stock	196.885	197.7	196.7	197.5	141979.0
2026-07-29 08:00:00	NVDA	Stock	197.4	197.5	196.2217	196.81	197613.0
2026-07-29 09:00:00	NVDA	Stock	196.81	197.074	192.65	193.38	9293444.0
2026-07-29 10:00:00	NVDA	Stock	193.36	193.65	190.923	192.485	15074901.0
2026-07-29 11:00:00	NVDA	Stock	192.48	193.16	191.44	191.86	8404087.0
2026-07-29 12:00:00	NVDA	Stock	191.85	192.18	190.68	191.97	7900024.0
2026-07-29 13:00:00	NVDA	Stock	191.97	193.08	191.71	192.32	7898099.0
2026-07-29 14:00:00	NVDA	Stock	192.35	196.18	192.305	195.9399	11859939.0
2026-07-29 15:00:00	NVDA	Stock	195.9301	196.3299	190.01	190.07	20595629.0
2026-07-29 16:00:00	NVDA	Stock	190.08	190.38	188.88	189.66	20202084.0
2026-07-29 17:00:00	NVDA	Stock	189.64	190.12	188.79	189.26	625802.0
2026-07-29 18:00:00	NVDA	Stock	189.3	192.1	189.3	191.0	577936.0
2026-07-29 19:00:00	NVDA	Stock	191.0	191.75	190.95	191.2446	223658.0
2026-07-29 04:00:00	AMZN	Stock	231.1764	232.3	230.86	232.2033	75691.0
2026-07-29 05:00:00	AMZN	Stock	231.915	232.01	231.0	231.29	15238.0

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

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