PREVIEW / stock_1hour / 2025-02-04

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-02-04.parquet
  size:    1.4 MB
  rows:    62,536
  symbols: 551

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
2025-02-04 04:00:00	AAPL	Stock	226.65	227.0	226.47	226.71	19875.0
2025-02-04 05:00:00	AAPL	Stock	226.57	227.4	226.55	227.17	7819.0
2025-02-04 06:00:00	AAPL	Stock	227.29	227.65	226.79	226.98	28471.0
2025-02-04 07:00:00	AAPL	Stock	226.94	227.46	226.41	227.07	33234.0
2025-02-04 08:00:00	AAPL	Stock	226.85	228.0	226.18	227.39	192387.0
2025-02-04 09:00:00	AAPL	Stock	227.3	229.21	226.65	228.922	4670055.0
2025-02-04 10:00:00	AAPL	Stock	228.94	231.5488	228.64	230.52	5439750.0
2025-02-04 11:00:00	AAPL	Stock	230.52	232.465	230.12	232.19	3849930.0
2025-02-04 12:00:00	AAPL	Stock	232.19	232.79	231.39	232.245	3332654.0
2025-02-04 13:00:00	AAPL	Stock	232.24	232.38	231.49	231.49	1802429.0
2025-02-04 14:00:00	AAPL	Stock	231.49	232.77	231.37	232.547	2072331.0
2025-02-04 15:00:00	AAPL	Stock	232.5564	233.13	232.01	232.79	3988568.0
2025-02-04 16:00:00	AAPL	Stock	232.75	233.1	232.0	232.34	6389884.0
2025-02-04 17:00:00	AAPL	Stock	232.39	232.59	231.61	231.79	38617.0
2025-02-04 18:00:00	AAPL	Stock	231.88	232.79	231.75	232.25	40359.0
2025-02-04 19:00:00	AAPL	Stock	232.13	233.0	232.055	232.75	41140.0
2025-02-04 04:00:00	MSFT	Stock	410.77	411.95	409.34	409.71	13637.0
2025-02-04 05:00:00	MSFT	Stock	409.96	410.44	409.73	410.05	7240.0
2025-02-04 06:00:00	MSFT	Stock	410.04	410.5	410.0	410.25	12969.0
2025-02-04 07:00:00	MSFT	Stock	410.3	412.72	410.2	411.74	22060.0
2025-02-04 08:00:00	MSFT	Stock	410.49	412.5	409.0	411.77	64467.0
2025-02-04 09:00:00	MSFT	Stock	411.8	413.35	409.74	411.27	2570076.0
2025-02-04 10:00:00	MSFT	Stock	411.33	413.9199	411.275	413.1708	1709669.0
2025-02-04 11:00:00	MSFT	Stock	413.245	413.65	412.18	412.55	1007578.0
2025-02-04 12:00:00	MSFT	Stock	412.55	413.0	410.66	411.73	1166947.0
2025-02-04 13:00:00	MSFT	Stock	411.7	411.88	410.8	411.59	901557.0
2025-02-04 14:00:00	MSFT	Stock	411.53	412.88	411.3363	412.54	1096600.0
2025-02-04 15:00:00	MSFT	Stock	412.61	413.04	411.36	412.31	2071876.0
2025-02-04 16:00:00	MSFT	Stock	412.24	412.5	410.3	410.9	3240784.0
2025-02-04 17:00:00	MSFT	Stock	410.97	411.0	410.32	410.32	23387.0
2025-02-04 18:00:00	MSFT	Stock	410.36	411.9767	410.36	411.0	17044.0
2025-02-04 19:00:00	MSFT	Stock	411.17	412.35	411.17	411.78	11857.0
2025-02-04 04:00:00	NVDA	Stock	117.36	118.05	117.07	117.59	446714.0
2025-02-04 05:00:00	NVDA	Stock	117.57	117.72	117.25	117.52	258528.0
2025-02-04 06:00:00	NVDA	Stock	117.52	117.65	116.96	116.97	335937.0
2025-02-04 07:00:00	NVDA	Stock	117.03	117.48	116.89	117.12	784290.0
2025-02-04 08:00:00	NVDA	Stock	117.4	118.0	115.33	116.58	3534288.0
2025-02-04 09:00:00	NVDA	Stock	116.57	119.88	116.17	119.355	32918811.0
2025-02-04 10:00:00	NVDA	Stock	119.355	121.2	119.28	119.535	43234347.0
2025-02-04 11:00:00	NVDA	Stock	119.535	120.24	119.05	119.0601	21316249.0
2025-02-04 12:00:00	NVDA	Stock	119.065	119.125	117.8501	118.8338	24294078.0
2025-02-04 13:00:00	NVDA	Stock	118.845	119.82	118.18	119.3699	16956545.0
2025-02-04 14:00:00	NVDA	Stock	119.365	119.6	118.35	118.635	15891691.0
2025-02-04 15:00:00	NVDA	Stock	118.64	118.955	118.08	118.69	22331616.0
2025-02-04 16:00:00	NVDA	Stock	118.7	120.59	118.2	119.21	21405860.0
2025-02-04 17:00:00	NVDA	Stock	119.21	119.3	118.75	118.96	936480.0
2025-02-04 18:00:00	NVDA	Stock	118.95	119.15	118.28	118.31	605791.0
2025-02-04 19:00:00	NVDA	Stock	118.3	119.0	118.26	118.75	435380.0
2025-02-04 04:00:00	AMZN	Stock	237.98	237.98	236.82	237.17	17524.0
2025-02-04 05:00:00	AMZN	Stock	237.01	237.33	237.0	237.33	18113.0

> showing 50 of 62,536 rows — these rows as CSV

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