PREVIEW / stock_1hour / 2026-07-27

all stock 1-hour files

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

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-27 04:00:00	AAPL	Stock	334.3	335.97	333.51	333.83	101906.0
2026-07-27 05:00:00	AAPL	Stock	333.78	334.01	333.26	333.5	20668.0
2026-07-27 06:00:00	AAPL	Stock	333.315	333.71	333.2	333.69	22747.0
2026-07-27 07:00:00	AAPL	Stock	333.7	334.44	332.75	334.18	141325.0
2026-07-27 08:00:00	AAPL	Stock	334.2991	334.76	332.188	333.96	86043.0
2026-07-27 09:00:00	AAPL	Stock	333.99	337.12	333.41	335.585	5402367.0
2026-07-27 10:00:00	AAPL	Stock	335.62	338.3399	335.25	338.2	7613678.0
2026-07-27 11:00:00	AAPL	Stock	338.25	339.57	336.75	337.065	4811169.0
2026-07-27 12:00:00	AAPL	Stock	337.04	338.13	336.02	336.66	2492729.0
2026-07-27 13:00:00	AAPL	Stock	336.68	336.8	335.29	335.5175	2671750.0
2026-07-27 14:00:00	AAPL	Stock	335.54	336.24	334.7	335.85	2516717.0
2026-07-27 15:00:00	AAPL	Stock	335.85	337.23	335.25	336.92	3857543.0
2026-07-27 16:00:00	AAPL	Stock	336.94	337.19	336.4	336.52	6466214.0
2026-07-27 17:00:00	AAPL	Stock	336.51	336.91	336.3	336.78	37532.0
2026-07-27 18:00:00	AAPL	Stock	336.79	337.0	336.4	336.68	13391.0
2026-07-27 19:00:00	AAPL	Stock	336.5	337.47	336.5	337.308	28314.0
2026-07-27 04:00:00	MSFT	Stock	384.5	386.49	383.5	385.81	72092.0
2026-07-27 05:00:00	MSFT	Stock	385.8	385.98	385.2	385.81	15593.0
2026-07-27 06:00:00	MSFT	Stock	385.78	386.36	385.3755	386.24	18781.0
2026-07-27 07:00:00	MSFT	Stock	386.03	387.68	385.89	387.0	81010.0
2026-07-27 08:00:00	MSFT	Stock	387.0	388.2997	382.654	388.08	76769.0
2026-07-27 09:00:00	MSFT	Stock	387.99	392.44	387.72	391.15	3357523.0
2026-07-27 10:00:00	MSFT	Stock	391.1301	393.3425	389.23	389.62	3629114.0
2026-07-27 11:00:00	MSFT	Stock	389.615	393.895	389.34	390.265	2863581.0
2026-07-27 12:00:00	MSFT	Stock	390.23	392.0	389.4	391.305	1779528.0
2026-07-27 13:00:00	MSFT	Stock	391.305	393.78	390.85	393.715	1686414.0
2026-07-27 14:00:00	MSFT	Stock	393.73	394.2	392.51	393.55	1778555.0
2026-07-27 15:00:00	MSFT	Stock	393.56	393.58	388.84	389.13	3384336.0
2026-07-27 16:00:00	MSFT	Stock	389.13	389.55	388.64	389.1	4319433.0
2026-07-27 17:00:00	MSFT	Stock	389.0848	389.4861	388.88	389.4	18623.0
2026-07-27 18:00:00	MSFT	Stock	389.4	389.6	388.88	389.1641	49543.0
2026-07-27 19:00:00	MSFT	Stock	389.02	390.0	388.85	389.5	14145.0
2026-07-27 04:00:00	NVDA	Stock	209.0	209.75	208.36	209.53	269622.0
2026-07-27 05:00:00	NVDA	Stock	209.44	209.44	209.08	209.2	53001.0
2026-07-27 06:00:00	NVDA	Stock	209.18	209.2	208.4	208.53	91827.0
2026-07-27 07:00:00	NVDA	Stock	208.5	208.67	207.8	208.15	356077.0
2026-07-27 08:00:00	NVDA	Stock	208.22	208.573	207.95	208.29	229147.0
2026-07-27 09:00:00	NVDA	Stock	208.3	208.92	201.2	201.765	14873387.0
2026-07-27 10:00:00	NVDA	Stock	201.78	202.929	197.42	199.775	21646487.0
2026-07-27 11:00:00	NVDA	Stock	199.79	199.9	195.92	197.6	16178564.0
2026-07-27 12:00:00	NVDA	Stock	197.6	198.54	196.18	196.3251	10531179.0
2026-07-27 13:00:00	NVDA	Stock	196.33	196.8394	195.44	196.795	8397443.0
2026-07-27 14:00:00	NVDA	Stock	196.8	197.65	196.05	197.44	7228647.0
2026-07-27 15:00:00	NVDA	Stock	197.44	198.02	196.31	196.52	14387335.0
2026-07-27 16:00:00	NVDA	Stock	196.53	197.14	196.43	196.917	20646427.0
2026-07-27 17:00:00	NVDA	Stock	196.91	197.18	196.91	197.0	287421.0
2026-07-27 18:00:00	NVDA	Stock	197.01	197.13	196.27	196.3139	218485.0
2026-07-27 19:00:00	NVDA	Stock	196.35	196.5	196.08	196.1337	209061.0
2026-07-27 04:00:00	AMZN	Stock	236.47	236.47	234.44	235.41	65236.0
2026-07-27 05:00:00	AMZN	Stock	235.32	235.51	235.05	235.36	11462.0

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

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