PREVIEW / stock_1hour / 2026-07-31

all stock 1-hour files

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

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-31 04:00:00	AAPL	Stock	312.35	314.12	308.11	309.53	462155.0
2026-07-31 05:00:00	AAPL	Stock	309.54	310.4671	308.69	309.0	185838.0
2026-07-31 06:00:00	AAPL	Stock	309.0	309.9	307.36	308.36	272234.0
2026-07-31 07:00:00	AAPL	Stock	308.54	309.28	306.33	308.01	829826.0
2026-07-31 08:00:00	AAPL	Stock	308.0	308.73	306.5	308.34	1559054.0
2026-07-31 09:00:00	AAPL	Stock	308.285	308.38	300.32	302.79	26558751.0
2026-07-31 10:00:00	AAPL	Stock	302.79	303.57	301.3501	303.16	11184002.0
2026-07-31 11:00:00	AAPL	Stock	303.16	304.25	300.38	301.295	9636191.0
2026-07-31 12:00:00	AAPL	Stock	301.285	302.34	300.0	300.855	7033058.0
2026-07-31 13:00:00	AAPL	Stock	300.86	301.8343	300.5	300.64	5018606.0
2026-07-31 14:00:00	AAPL	Stock	300.64	303.0	300.595	302.83	6442561.0
2026-07-31 15:00:00	AAPL	Stock	302.83	310.69	302.78	309.03	24616011.0
2026-07-31 16:00:00	AAPL	Stock	309.22	310.19	306.69	306.69	15177646.0
2026-07-31 17:00:00	AAPL	Stock	306.91	307.2	306.26	306.5	230700.0
2026-07-31 18:00:00	AAPL	Stock	306.51	307.35	306.51	307.29	84656.0
2026-07-31 19:00:00	AAPL	Stock	307.27	307.8	307.1801	307.3554	72264.0
2026-07-31 04:00:00	MSFT	Stock	447.8	449.63	445.0	448.01	122395.0
2026-07-31 05:00:00	MSFT	Stock	447.86	448.85	447.0	448.79	38206.0
2026-07-31 06:00:00	MSFT	Stock	448.82	448.94	447.66	448.1318	32456.0
2026-07-31 07:00:00	MSFT	Stock	448.06	451.0	447.71	449.55	167437.0
2026-07-31 08:00:00	MSFT	Stock	449.43	451.92	448.48	451.4824	145820.0
2026-07-31 09:00:00	MSFT	Stock	451.46	462.86	448.89	462.57	7497071.0
2026-07-31 10:00:00	MSFT	Stock	462.57	462.95	451.72	452.455	6624392.0
2026-07-31 11:00:00	MSFT	Stock	452.53	463.57	450.69	463.1	5611956.0
2026-07-31 12:00:00	MSFT	Stock	463.07	464.8	461.03	461.9201	3961020.0
2026-07-31 13:00:00	MSFT	Stock	461.92	463.8	460.15	460.385	3129471.0
2026-07-31 14:00:00	MSFT	Stock	460.43	463.52	460.0	461.17	2643819.0
2026-07-31 15:00:00	MSFT	Stock	461.175	466.84	461.11	465.1	8763772.0
2026-07-31 16:00:00	MSFT	Stock	464.9787	464.9787	463.05	463.67	8499447.0
2026-07-31 17:00:00	MSFT	Stock	463.66	463.72	461.5708	461.61	54670.0
2026-07-31 18:00:00	MSFT	Stock	461.5827	462.01	460.65	461.26	45907.0
2026-07-31 19:00:00	MSFT	Stock	461.0027	462.0	461.0027	461.81	28919.0
2026-07-31 04:00:00	NVDA	Stock	198.3	198.89	197.03	198.45	476940.0
2026-07-31 05:00:00	NVDA	Stock	198.4048	198.68	197.74	197.79	68670.0
2026-07-31 06:00:00	NVDA	Stock	197.74	198.16	197.5	197.69	60894.0
2026-07-31 07:00:00	NVDA	Stock	197.66	198.18	197.2	197.65	372602.0
2026-07-31 08:00:00	NVDA	Stock	197.58	197.58	195.04	196.8586	434074.0
2026-07-31 09:00:00	NVDA	Stock	196.88	200.09	196.79	197.69	13025046.0
2026-07-31 10:00:00	NVDA	Stock	197.67	198.93	194.95	198.1101	12704535.0
2026-07-31 11:00:00	NVDA	Stock	198.12	198.34	195.23	196.3	9083985.0
2026-07-31 12:00:00	NVDA	Stock	196.29	198.52	196.15	198.22	6900156.0
2026-07-31 13:00:00	NVDA	Stock	198.22	199.97	198.13	199.495	7131287.0
2026-07-31 14:00:00	NVDA	Stock	199.495	199.7898	198.481	198.97	6362092.0
2026-07-31 15:00:00	NVDA	Stock	198.96	202.0	198.26	200.81	21672460.0
2026-07-31 16:00:00	NVDA	Stock	200.8	200.8	199.49	199.49	23675771.0
2026-07-31 17:00:00	NVDA	Stock	199.69	200.03	198.91	199.03	301062.0
2026-07-31 18:00:00	NVDA	Stock	199.03	199.19	198.9	199.0	125493.0
2026-07-31 19:00:00	NVDA	Stock	198.9998	199.13	198.95	198.98	103075.0
2026-07-31 04:00:00	AMZN	Stock	259.54	264.82	258.7827	263.78	556551.0
2026-07-31 05:00:00	AMZN	Stock	263.75	265.67	263.02	264.67	294044.0

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

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