PREVIEW / stock_1hour / 2026-07-28

all stock 1-hour files

  file:    by_date/stock_1hour/2026/2026-07-28.parquet
  size:    1.4 MB
  rows:    59,578

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-28 04:00:00	AAPL	Stock	337.12	338.5	337.0526	338.36	59483.0
2026-07-28 05:00:00	AAPL	Stock	338.6	339.4	338.07	338.77	31472.0
2026-07-28 06:00:00	AAPL	Stock	338.91	339.0	338.53	338.7	35323.0
2026-07-28 07:00:00	AAPL	Stock	338.58	339.0	338.12	338.56	107796.0
2026-07-28 08:00:00	AAPL	Stock	338.52	339.48	338.18	339.11	126596.0
2026-07-28 09:00:00	AAPL	Stock	339.07	342.89	337.15	337.5	7924969.0
2026-07-28 10:00:00	AAPL	Stock	337.59	338.79	335.6	337.055	5718565.0
2026-07-28 11:00:00	AAPL	Stock	337.0405	339.9	336.6	339.66	3655070.0
2026-07-28 12:00:00	AAPL	Stock	339.66	340.5799	338.94	339.775	3179707.0
2026-07-28 13:00:00	AAPL	Stock	339.79	340.0199	338.9301	339.745	2238244.0
2026-07-28 14:00:00	AAPL	Stock	339.745	340.1599	338.275	339.35	2703005.0
2026-07-28 15:00:00	AAPL	Stock	339.345	340.54	338.07	340.204	5968394.0
2026-07-28 16:00:00	AAPL	Stock	340.22	340.46	339.69	339.87	6193596.0
2026-07-28 17:00:00	AAPL	Stock	339.82	340.0	339.8	339.87	15708.0
2026-07-28 18:00:00	AAPL	Stock	339.98	340.52	339.2301	340.4985	47889.0
2026-07-28 19:00:00	AAPL	Stock	340.48	341.58	339.87	341.2465	88654.0
2026-07-28 04:00:00	MSFT	Stock	392.0	393.0	389.5357	392.11	73430.0
2026-07-28 05:00:00	MSFT	Stock	392.18	393.47	392.0103	393.23	22073.0
2026-07-28 06:00:00	MSFT	Stock	393.14	393.45	392.2	392.35	17233.0
2026-07-28 07:00:00	MSFT	Stock	392.61	395.39	392.23	394.35	109805.0
2026-07-28 08:00:00	MSFT	Stock	394.49	396.24	394.16	395.49	92480.0
2026-07-28 09:00:00	MSFT	Stock	395.49	400.21	391.3	392.36	5124958.0
2026-07-28 10:00:00	MSFT	Stock	392.42	397.69	392.2	396.52	3661493.0
2026-07-28 11:00:00	MSFT	Stock	396.56	400.32	395.9	397.855	2825804.0
2026-07-28 12:00:00	MSFT	Stock	397.855	398.92	396.12	398.845	1730929.0
2026-07-28 13:00:00	MSFT	Stock	398.84	399.56	397.49	399.1401	1340638.0
2026-07-28 14:00:00	MSFT	Stock	399.155	399.22	396.7	396.96	1542140.0
2026-07-28 15:00:00	MSFT	Stock	396.96	397.14	392.37	393.47	4104086.0
2026-07-28 16:00:00	MSFT	Stock	393.46	394.5	392.5	393.91	4455113.0
2026-07-28 17:00:00	MSFT	Stock	393.88	394.4355	393.72	394.3	19176.0
2026-07-28 18:00:00	MSFT	Stock	394.3	395.88	393.5	395.8183	27717.0
2026-07-28 19:00:00	MSFT	Stock	395.49	396.0	394.12	395.01	59602.0
2026-07-28 04:00:00	NVDA	Stock	193.8	195.18	193.0	194.5	522347.0
2026-07-28 05:00:00	NVDA	Stock	194.49	194.81	194.15	194.52	141192.0
2026-07-28 06:00:00	NVDA	Stock	194.5	194.83	193.76	194.53	187211.0
2026-07-28 07:00:00	NVDA	Stock	194.55	195.6974	194.05	195.55	768813.0
2026-07-28 08:00:00	NVDA	Stock	195.55	196.08	195.32	195.45	727603.0
2026-07-28 09:00:00	NVDA	Stock	195.5	196.49	192.8	193.63	14675703.0
2026-07-28 10:00:00	NVDA	Stock	193.64	197.5974	192.74	196.77	17783817.0
2026-07-28 11:00:00	NVDA	Stock	196.78	198.61	195.86	198.33	12268192.0
2026-07-28 12:00:00	NVDA	Stock	198.33	198.7	196.6	198.0201	8070473.0
2026-07-28 13:00:00	NVDA	Stock	198.03	198.24	196.67	197.1	5980256.0
2026-07-28 14:00:00	NVDA	Stock	197.1	197.4	196.5331	197.07	5298468.0
2026-07-28 15:00:00	NVDA	Stock	197.06	198.15	196.72	196.98	12376223.0
2026-07-28 16:00:00	NVDA	Stock	197.02	197.6	196.0	197.22	13220026.0
2026-07-28 17:00:00	NVDA	Stock	197.17	197.24	196.85	196.9	118205.0
2026-07-28 18:00:00	NVDA	Stock	196.9	197.24	195.5	195.51	256854.0
2026-07-28 19:00:00	NVDA	Stock	195.5001	197.75	195.0	197.63	489832.0
2026-07-28 04:00:00	AMZN	Stock	231.16	232.6	230.608	231.93	61551.0
2026-07-28 05:00:00	AMZN	Stock	231.79	232.17	231.57	231.61	16238.0

> showing 50 of 59,578 rows — these rows as CSV

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