PREVIEW / stock_1hour / 2026-07-07

all stock 1-hour files

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

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-07 04:00:00	AAPL	Stock	312.88	315.93	312.7	314.13	95510.0
2026-07-07 05:00:00	AAPL	Stock	314.19	315.06	313.87	314.56	26478.0
2026-07-07 06:00:00	AAPL	Stock	314.55	315.69	314.0	314.5	45575.0
2026-07-07 07:00:00	AAPL	Stock	314.45	315.19	314.31	315.07	69456.0
2026-07-07 08:00:00	AAPL	Stock	315.006	315.4982	311.879	315.14	62697.0
2026-07-07 09:00:00	AAPL	Stock	315.03	315.68	310.15	311.57	4332406.0
2026-07-07 10:00:00	AAPL	Stock	311.6	313.43	310.97	312.78	5244858.0
2026-07-07 11:00:00	AAPL	Stock	312.805	314.73	312.67	314.29	3712809.0
2026-07-07 12:00:00	AAPL	Stock	314.27	314.37	312.68	313.61	3359745.0
2026-07-07 13:00:00	AAPL	Stock	313.61	313.62	311.8699	311.89	2210006.0
2026-07-07 14:00:00	AAPL	Stock	311.87	313.18	311.85	312.005	2699841.0
2026-07-07 15:00:00	AAPL	Stock	312.03	312.51	310.29	310.65	5172281.0
2026-07-07 16:00:00	AAPL	Stock	310.68	313.14	310.61	311.02	6354932.0
2026-07-07 17:00:00	AAPL	Stock	311.0	311.2287	310.5	310.7	26357.0
2026-07-07 18:00:00	AAPL	Stock	310.94	311.48	310.67	311.28	16691.0
2026-07-07 19:00:00	AAPL	Stock	311.2073	312.5	311.0	311.39	24742.0
2026-07-07 04:00:00	MSFT	Stock	387.84	392.4	387.26	392.299	132558.0
2026-07-07 05:00:00	MSFT	Stock	392.18	393.42	392.1304	392.67	70518.0
2026-07-07 06:00:00	MSFT	Stock	392.48	392.85	391.6	391.6	41726.0
2026-07-07 07:00:00	MSFT	Stock	391.61	393.69	391.6	392.32	141736.0
2026-07-07 08:00:00	MSFT	Stock	392.4661	392.8235	391.3	392.66	120649.0
2026-07-07 09:00:00	MSFT	Stock	392.516	394.75	388.52	393.44	3859643.0
2026-07-07 10:00:00	MSFT	Stock	393.46	395.57	391.47	391.9	4082936.0
2026-07-07 11:00:00	MSFT	Stock	391.93	394.15	391.785	393.725	2476682.0
2026-07-07 12:00:00	MSFT	Stock	393.725	394.85	392.71	394.05	2059953.0
2026-07-07 13:00:00	MSFT	Stock	394.095	394.31	392.27	392.815	1455847.0
2026-07-07 14:00:00	MSFT	Stock	392.81	393.39	390.66	391.02	1577230.0
2026-07-07 15:00:00	MSFT	Stock	391.02	391.06	388.22	388.83	3147656.0
2026-07-07 16:00:00	MSFT	Stock	388.84	389.3	388.4	389.0	3360417.0
2026-07-07 17:00:00	MSFT	Stock	389.03	389.67	389.03	389.632	36995.0
2026-07-07 18:00:00	MSFT	Stock	389.63	389.63	388.11	388.4	62281.0
2026-07-07 19:00:00	MSFT	Stock	388.7	388.84	388.0037	388.19	47737.0
2026-07-07 04:00:00	NVDA	Stock	194.11	194.6	193.2598	193.78	296821.0
2026-07-07 05:00:00	NVDA	Stock	193.77	194.12	193.66	194.12	90611.0
2026-07-07 06:00:00	NVDA	Stock	194.12	194.39	192.02	192.5782	269568.0
2026-07-07 07:00:00	NVDA	Stock	192.57	192.74	190.6	191.44	1109113.0
2026-07-07 08:00:00	NVDA	Stock	191.43	192.8	191.16	192.35	1024217.0
2026-07-07 09:00:00	NVDA	Stock	192.33	193.2999	191.44	192.64	12549293.0
2026-07-07 10:00:00	NVDA	Stock	192.635	193.5	191.14	192.57	12577586.0
2026-07-07 11:00:00	NVDA	Stock	192.58	194.78	192.32	194.72	9523430.0
2026-07-07 12:00:00	NVDA	Stock	194.725	198.12	194.6	197.44	14477529.0
2026-07-07 13:00:00	NVDA	Stock	197.45	198.41	197.29	197.945	9367188.0
2026-07-07 14:00:00	NVDA	Stock	197.93	197.95	196.32	196.4	6659048.0
2026-07-07 15:00:00	NVDA	Stock	196.418	197.05	195.47	196.93	11910167.0
2026-07-07 16:00:00	NVDA	Stock	196.96	197.1	194.3997	196.6	12401004.0
2026-07-07 17:00:00	NVDA	Stock	196.55	196.8	195.68	195.68	164364.0
2026-07-07 18:00:00	NVDA	Stock	195.8	195.99	195.5468	195.91	183248.0
2026-07-07 19:00:00	NVDA	Stock	195.9	196.4123	195.6	195.88	141777.0
2026-07-07 04:00:00	AMZN	Stock	244.6	246.8807	243.75	246.85	58139.0
2026-07-07 05:00:00	AMZN	Stock	246.75	248.75	246.75	247.86	34953.0

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

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