PREVIEW / stock_1hour / 2025-01-23

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-01-23.parquet
  size:    1.4 MB
  rows:    63,788
  symbols: 579

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-23 04:00:00	AAPL	Stock	223.52	223.52	222.22	222.82	21160.0
2025-01-23 05:00:00	AAPL	Stock	222.83	222.83	222.51	222.62	10028.0
2025-01-23 06:00:00	AAPL	Stock	222.68	223.3	222.68	223.2	36168.0
2025-01-23 07:00:00	AAPL	Stock	223.23	224.25	223.05	224.14	68651.0
2025-01-23 08:00:00	AAPL	Stock	223.04	224.84	222.44	224.7495	306430.0
2025-01-23 09:00:00	AAPL	Stock	224.75	226.26	224.11	225.18	6435337.0
2025-01-23 10:00:00	AAPL	Stock	225.19	227.03	224.8903	225.3242	7158398.0
2025-01-23 11:00:00	AAPL	Stock	225.3337	225.41	223.8	224.04	4745386.0
2025-01-23 12:00:00	AAPL	Stock	224.06	224.16	223.19	223.695	3273549.0
2025-01-23 13:00:00	AAPL	Stock	223.69	223.78	223.01	223.0743	2553550.0
2025-01-23 14:00:00	AAPL	Stock	223.075	223.1599	222.43	222.75	3476325.0
2025-01-23 15:00:00	AAPL	Stock	222.74	223.65	222.3	223.65	7093888.0
2025-01-23 16:00:00	AAPL	Stock	223.65	223.9	223.0	223.3584	8008636.0
2025-01-23 17:00:00	AAPL	Stock	223.32	223.48	223.32	223.45	21075.0
2025-01-23 18:00:00	AAPL	Stock	223.49	223.49	223.2188	223.255	18752.0
2025-01-23 19:00:00	AAPL	Stock	223.2601	223.35	223.15	223.24	20294.0
2025-01-23 04:00:00	MSFT	Stock	443.25	443.76	441.22	443.05	10339.0
2025-01-23 05:00:00	MSFT	Stock	442.64	443.56	442.55	443.38	7782.0
2025-01-23 06:00:00	MSFT	Stock	443.02	443.65	442.55	443.65	5585.0
2025-01-23 07:00:00	MSFT	Stock	443.9	444.29	442.98	443.34	24714.0
2025-01-23 08:00:00	MSFT	Stock	443.0	444.0205	442.731	443.29	23966.0
2025-01-23 09:00:00	MSFT	Stock	443.24	444.48	441.5	443.83	1264578.0
2025-01-23 10:00:00	MSFT	Stock	443.785	444.14	442.51	442.99	965680.0
2025-01-23 11:00:00	MSFT	Stock	442.97	444.15	441.92	443.605	929736.0
2025-01-23 12:00:00	MSFT	Stock	443.65	443.71	442.4303	442.775	546285.0
2025-01-23 13:00:00	MSFT	Stock	442.7512	444.33	442.5401	443.8391	574256.0
2025-01-23 14:00:00	MSFT	Stock	443.855	445.68	443.58	445.34	584678.0
2025-01-23 15:00:00	MSFT	Stock	445.32	446.75	444.72	446.7	1543934.0
2025-01-23 16:00:00	MSFT	Stock	446.68	447.47	446.35	446.3615	3796469.0
2025-01-23 17:00:00	MSFT	Stock	446.47	446.86	446.362	446.6543	5705.0
2025-01-23 18:00:00	MSFT	Stock	446.58	446.7	446.2272	446.63	3209.0
2025-01-23 19:00:00	MSFT	Stock	446.6319	446.7644	446.21	446.35	3650.0
2025-01-23 04:00:00	NVDA	Stock	144.45	145.13	144.05	144.46	903270.0
2025-01-23 05:00:00	NVDA	Stock	144.4	144.6	144.09	144.17	421032.0
2025-01-23 06:00:00	NVDA	Stock	144.16	144.69	144.13	144.65	305600.0
2025-01-23 07:00:00	NVDA	Stock	144.64	145.0	143.8	144.37	1147843.0
2025-01-23 08:00:00	NVDA	Stock	144.65	145.45	143.9	144.7	2121125.0
2025-01-23 09:00:00	NVDA	Stock	144.7	145.72	143.72	145.3524	23899013.0
2025-01-23 10:00:00	NVDA	Stock	145.36	146.29	144.765	145.97	22490462.0
2025-01-23 11:00:00	NVDA	Stock	145.9745	146.32	145.32	145.8248	13532383.0
2025-01-23 12:00:00	NVDA	Stock	145.825	145.85	144.98	145.43	10494929.0
2025-01-23 13:00:00	NVDA	Stock	145.43	146.35	145.42	146.26	10532490.0
2025-01-23 14:00:00	NVDA	Stock	146.265	146.86	146.09	146.284	10633673.0
2025-01-23 15:00:00	NVDA	Stock	146.28	147.23	146.0	147.21	18650386.0
2025-01-23 16:00:00	NVDA	Stock	147.22	147.25	146.39	146.85	12468748.0
2025-01-23 17:00:00	NVDA	Stock	146.85	147.22	146.48	146.55	257668.0
2025-01-23 18:00:00	NVDA	Stock	146.53	146.7	146.3	146.61	313251.0
2025-01-23 19:00:00	NVDA	Stock	146.6104	146.65	146.3	146.41	240588.0
2025-01-23 04:00:00	AMZN	Stock	233.22	234.29	233.22	233.96	19189.0
2025-01-23 05:00:00	AMZN	Stock	233.94	234.27	233.59	234.0	10248.0

> showing 50 of 63,788 rows — these rows as CSV

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