PREVIEW / stock_1hour / 2025-01-24

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-01-24.parquet
  size:    1.4 MB
  rows:    64,072
  symbols: 584

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-01-24 04:00:00	AAPL	Stock	223.2	224.32	223.12	223.72	31044.0
2025-01-24 05:00:00	AAPL	Stock	223.65	224.06	223.65	224.06	13239.0
2025-01-24 06:00:00	AAPL	Stock	224.18	225.5	224.01	225.25	86591.0
2025-01-24 07:00:00	AAPL	Stock	225.15	225.42	224.66	225.09	131065.0
2025-01-24 08:00:00	AAPL	Stock	225.125	225.846	223.25	225.76	333111.0
2025-01-24 09:00:00	AAPL	Stock	225.76	226.29	224.31	224.51	6796702.0
2025-01-24 10:00:00	AAPL	Stock	224.525	224.59	222.5301	223.065	6487710.0
2025-01-24 11:00:00	AAPL	Stock	223.065	223.49	222.3501	222.73	4656539.0
2025-01-24 12:00:00	AAPL	Stock	222.7399	223.27	221.94	222.4	3351203.0
2025-01-24 13:00:00	AAPL	Stock	222.4099	222.56	221.92	222.05	2216631.0
2025-01-24 14:00:00	AAPL	Stock	222.06	222.88	222.02	222.56	2543347.0
2025-01-24 15:00:00	AAPL	Stock	222.5517	223.045	221.41	222.79	6488767.0
2025-01-24 16:00:00	AAPL	Stock	222.79	222.9	222.47	222.56	8906138.0
2025-01-24 17:00:00	AAPL	Stock	222.56	222.56	222.3	222.47	31975.0
2025-01-24 18:00:00	AAPL	Stock	222.35	222.45	222.0	222.15	30520.0
2025-01-24 19:00:00	AAPL	Stock	222.2	222.34	222.03	222.17	28641.0
2025-01-24 04:00:00	MSFT	Stock	445.8	446.76	445.8	446.21	4624.0
2025-01-24 05:00:00	MSFT	Stock	446.28	446.28	446.06	446.14	507.0
2025-01-24 06:00:00	MSFT	Stock	446.31	446.31	445.0	445.34	9000.0
2025-01-24 07:00:00	MSFT	Stock	445.7	447.14	445.7	446.8	7804.0
2025-01-24 08:00:00	MSFT	Stock	446.54	447.0	445.53	446.58	25207.0
2025-01-24 09:00:00	MSFT	Stock	446.58	446.71	441.4	444.655	1633682.0
2025-01-24 10:00:00	MSFT	Stock	444.69	445.49	443.38	445.1211	1135481.0
2025-01-24 11:00:00	MSFT	Stock	445.055	446.65	444.632	445.83	665804.0
2025-01-24 12:00:00	MSFT	Stock	445.81	445.93	444.06	444.22	703427.0
2025-01-24 13:00:00	MSFT	Stock	444.14	444.49	442.03	442.27	769512.0
2025-01-24 14:00:00	MSFT	Stock	442.231	442.77	441.7	442.16	594699.0
2025-01-24 15:00:00	MSFT	Stock	442.17	444.29	442.11	443.98	1176985.0
2025-01-24 16:00:00	MSFT	Stock	443.95	444.17	443.05	443.7	2839653.0
2025-01-24 17:00:00	MSFT	Stock	443.91	443.91	443.21	443.62	3262.0
2025-01-24 18:00:00	MSFT	Stock	443.57	443.7484	443.2845	443.7484	1372.0
2025-01-24 19:00:00	MSFT	Stock	443.85	443.85	443.2562	443.2562	1839.0
2025-01-24 04:00:00	NVDA	Stock	146.03	147.4	146.03	147.13	384404.0
2025-01-24 05:00:00	NVDA	Stock	147.15	147.21	146.8	146.9	130825.0
2025-01-24 06:00:00	NVDA	Stock	146.89	146.94	145.52	146.1	510563.0
2025-01-24 07:00:00	NVDA	Stock	146.1	146.75	146.02	146.63	592845.0
2025-01-24 08:00:00	NVDA	Stock	146.13	147.3596	145.82	146.18	1532776.0
2025-01-24 09:00:00	NVDA	Stock	146.18	149.1	146.01	147.86	32615536.0
2025-01-24 10:00:00	NVDA	Stock	147.86	148.21	145.03	145.15	32696245.0
2025-01-24 11:00:00	NVDA	Stock	145.14	145.69	144.24	144.35	20715047.0
2025-01-24 12:00:00	NVDA	Stock	144.35	144.77	142.9	143.19	20207965.0
2025-01-24 13:00:00	NVDA	Stock	143.19	143.7	142.29	142.3	20457606.0
2025-01-24 14:00:00	NVDA	Stock	142.3	142.85	141.9401	142.35	19165620.0
2025-01-24 15:00:00	NVDA	Stock	142.35	142.836	141.88	142.6004	26839367.0
2025-01-24 16:00:00	NVDA	Stock	142.61	142.72	142.3105	142.4649	19281934.0
2025-01-24 17:00:00	NVDA	Stock	142.47	142.48	142.17	142.3	445210.0
2025-01-24 18:00:00	NVDA	Stock	142.29	142.33	142.05	142.16	391351.0
2025-01-24 19:00:00	NVDA	Stock	142.1798	142.2	142.0	142.02	404443.0
2025-01-24 04:00:00	AMZN	Stock	235.19	235.92	235.19	235.6	8613.0
2025-01-24 05:00:00	AMZN	Stock	235.64	235.64	235.45	235.58	3604.0

> showing 50 of 64,072 rows — these rows as CSV

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