PREVIEW / stock_1hour / 2026-06-25

all stock 1-hour files

  file:    by_date/stock_1hour/2026/2026-06-25.parquet
  size:    1.4 MB
  rows:    61,361
  symbols: 9

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-06-25 04:00:00	AAPL	Stock	291.5	292.99	290.543	291.67	66930.0
2026-06-25 05:00:00	AAPL	Stock	291.8	291.89	291.25	291.67	8015.0
2026-06-25 06:00:00	AAPL	Stock	291.85	291.95	291.33	291.61	8549.0
2026-06-25 07:00:00	AAPL	Stock	291.54	291.66	290.8	291.11	73420.0
2026-06-25 08:00:00	AAPL	Stock	291.21	293.94	290.7	291.15	280939.0
2026-06-25 09:00:00	AAPL	Stock	291.01	291.14	277.67	278.97	12384622.0
2026-06-25 10:00:00	AAPL	Stock	278.945	280.1798	277.45	277.605	10264335.0
2026-06-25 11:00:00	AAPL	Stock	277.61	279.65	276.44	277.855	7245807.0
2026-06-25 12:00:00	AAPL	Stock	277.89	278.19	273.75	275.12	9446226.0
2026-06-25 13:00:00	AAPL	Stock	275.135	278.39	275.11	276.7882	7316949.0
2026-06-25 14:00:00	AAPL	Stock	276.795	280.2201	276.22	279.425	6458593.0
2026-06-25 15:00:00	AAPL	Stock	279.43	279.43	273.9	275.05	18099786.0
2026-06-25 16:00:00	AAPL	Stock	275.16	275.7	273.72	275.28	14361296.0
2026-06-25 17:00:00	AAPL	Stock	275.32	275.43	275.08	275.1335	86411.0
2026-06-25 18:00:00	AAPL	Stock	275.14	275.67	274.9	275.4119	74449.0
2026-06-25 19:00:00	AAPL	Stock	275.5	277.92	275.426	276.25	123711.0
2026-06-25 04:00:00	MSFT	Stock	365.0	365.89	362.84	364.4064	115591.0
2026-06-25 05:00:00	MSFT	Stock	364.5	366.5	364.45	365.25	43749.0
2026-06-25 06:00:00	MSFT	Stock	365.42	365.92	364.59	364.6	31048.0
2026-06-25 07:00:00	MSFT	Stock	365.11	365.39	363.6853	363.95	76021.0
2026-06-25 08:00:00	MSFT	Stock	364.0	364.1527	362.52	362.99	139492.0
2026-06-25 09:00:00	MSFT	Stock	362.95	364.77	356.6	357.43	5342080.0
2026-06-25 10:00:00	MSFT	Stock	357.42	360.0	355.33	355.555	5782607.0
2026-06-25 11:00:00	MSFT	Stock	355.6	356.63	353.68	355.605	5630203.0
2026-06-25 12:00:00	MSFT	Stock	355.6	355.6299	351.12	351.6	5697122.0
2026-06-25 13:00:00	MSFT	Stock	351.62	352.31	349.2	350.61	5515615.0
2026-06-25 14:00:00	MSFT	Stock	350.62	357.79	350.26	355.42	5751482.0
2026-06-25 15:00:00	MSFT	Stock	355.45	355.66	351.64	352.6932	8123610.0
2026-06-25 16:00:00	MSFT	Stock	352.731	354.79	351.018	353.92	7066650.0
2026-06-25 17:00:00	MSFT	Stock	353.93	354.605	353.5325	354.58	43134.0
2026-06-25 18:00:00	MSFT	Stock	354.58	354.75	353.75	354.68	34805.0
2026-06-25 19:00:00	MSFT	Stock	354.6801	357.5	354.38	355.444	98952.0
2026-06-25 04:00:00	NVDA	Stock	200.8	201.8	199.92	201.6915	619827.0
2026-06-25 05:00:00	NVDA	Stock	201.75	202.19	201.6	201.605	160433.0
2026-06-25 06:00:00	NVDA	Stock	201.66	202.0	200.85	200.87	124368.0
2026-06-25 07:00:00	NVDA	Stock	200.935	201.48	200.39	200.5	436852.0
2026-06-25 08:00:00	NVDA	Stock	200.58	201.82	200.5	201.77	605987.0
2026-06-25 09:00:00	NVDA	Stock	201.75	201.78	192.13	192.375	20213228.0
2026-06-25 10:00:00	NVDA	Stock	192.385	196.4499	192.37	195.46	18830901.0
2026-06-25 11:00:00	NVDA	Stock	195.48	196.68	194.77	195.61	9634418.0
2026-06-25 12:00:00	NVDA	Stock	195.62	197.13	194.51	194.88	7791990.0
2026-06-25 13:00:00	NVDA	Stock	194.885	195.73	194.38	194.79	5756920.0
2026-06-25 14:00:00	NVDA	Stock	194.79	195.8476	193.7246	194.4	7673255.0
2026-06-25 15:00:00	NVDA	Stock	194.4	195.98	193.7033	195.75	13242501.0
2026-06-25 16:00:00	NVDA	Stock	195.76	196.8	195.0	195.28	19160523.0
2026-06-25 17:00:00	NVDA	Stock	195.24	195.55	195.23	195.5186	121530.0
2026-06-25 18:00:00	NVDA	Stock	195.52	195.78	194.3	194.75	229034.0
2026-06-25 19:00:00	NVDA	Stock	194.7485	195.7	194.5	194.77	287906.0
2026-06-25 04:00:00	AMZN	Stock	233.5101	234.6	233.08	233.75	57263.0
2026-06-25 05:00:00	AMZN	Stock	233.8	234.0	233.56	233.87	19718.0

> showing 50 of 61,361 rows — these rows as CSV

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