PREVIEW / stock_1hour / 2023-11-22

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-22.parquet
  size:    1.3 MB
  rows:    57,312
  symbols: 1,302

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
2023-11-22 04:00:00	AAPL	Stock	190.38	190.5	190.38	190.5	7295.0
2023-11-22 05:00:00	AAPL	Stock	190.51	190.98	190.5	190.88	6993.0
2023-11-22 06:00:00	AAPL	Stock	190.8	190.94	190.69	190.7	5871.0
2023-11-22 07:00:00	AAPL	Stock	190.7	191.15	190.69	191.02	41737.0
2023-11-22 08:00:00	AAPL	Stock	190.72	191.18	190.1	191.1785	119253.0
2023-11-22 09:00:00	AAPL	Stock	191.15	192.93	191.11	191.9125	6839275.0
2023-11-22 10:00:00	AAPL	Stock	191.92	192.37	191.39	191.45	5355765.0
2023-11-22 11:00:00	AAPL	Stock	191.455	191.865	191.44	191.6623	3048132.0
2023-11-22 12:00:00	AAPL	Stock	191.665	191.96	191.55	191.905	3026112.0
2023-11-22 13:00:00	AAPL	Stock	191.9	192.09	191.53	191.63	3109235.0
2023-11-22 14:00:00	AAPL	Stock	191.62	191.71	190.825	191.3501	3270252.0
2023-11-22 15:00:00	AAPL	Stock	191.35	191.7	191.22	191.3	4545944.0
2023-11-22 16:00:00	AAPL	Stock	191.3	191.47	191.23	191.3	4445665.0
2023-11-22 17:00:00	AAPL	Stock	191.35	191.35	191.23	191.31	77088.0
2023-11-22 18:00:00	AAPL	Stock	191.32	191.34	191.22	191.31	4337.0
2023-11-22 19:00:00	AAPL	Stock	191.25	191.31	191.22	191.26	7612.0
2023-11-22 04:00:00	MSFT	Stock	372.57	374.88	372.57	374.72	7511.0
2023-11-22 05:00:00	MSFT	Stock	374.7	375.45	374.69	375.4	4321.0
2023-11-22 06:00:00	MSFT	Stock	375.5	376.15	375.3	375.5	9230.0
2023-11-22 07:00:00	MSFT	Stock	375.4	377.6	375.25	377.0	118425.0
2023-11-22 08:00:00	MSFT	Stock	375.5236	377.95	371.6	377.944	226284.0
2023-11-22 09:00:00	MSFT	Stock	377.8642	379.7899	376.31	376.99	3990576.0
2023-11-22 10:00:00	MSFT	Stock	376.97	378.35	374.965	377.19	2864268.0
2023-11-22 11:00:00	MSFT	Stock	377.19	378.53	377.03	378.365	1546254.0
2023-11-22 12:00:00	MSFT	Stock	378.37	379.0	378.01	378.4001	1379872.0
2023-11-22 13:00:00	MSFT	Stock	378.395	379.22	378.34	378.78	1246518.0
2023-11-22 14:00:00	MSFT	Stock	378.77	378.945	376.85	377.955	1195681.0
2023-11-22 15:00:00	MSFT	Stock	377.95	378.29	377.49	377.88	1661322.0
2023-11-22 16:00:00	MSFT	Stock	377.85	377.99	377.49	377.61	2589792.0
2023-11-22 17:00:00	MSFT	Stock	377.66	377.7	377.35	377.7	6296.0
2023-11-22 18:00:00	MSFT	Stock	377.501	377.85	377.5	377.85	9032.0
2023-11-22 19:00:00	MSFT	Stock	377.8	377.96	377.8	377.95	3436.0
2023-11-22 04:00:00	NVDA	Stock	49.002	49.559	49.002	49.477	658110.0
2023-11-22 05:00:00	NVDA	Stock	49.49	50.0	49.48	49.826	784260.0
2023-11-22 06:00:00	NVDA	Stock	49.823	50.7	49.73	50.54	2240370.0
2023-11-22 07:00:00	NVDA	Stock	50.521	50.55	49.81	49.851	5692240.0
2023-11-22 08:00:00	NVDA	Stock	50.436	50.533	48.95	50.2	12311560.0
2023-11-22 09:00:00	NVDA	Stock	50.2	50.3349	48.082	48.648	140688930.0
2023-11-22 10:00:00	NVDA	Stock	48.648	48.678	47.69	48.248	148109130.0
2023-11-22 11:00:00	NVDA	Stock	48.2479	48.497	48.082	48.3575	61340050.0
2023-11-22 12:00:00	NVDA	Stock	48.369	48.931	48.331	48.677	73183800.0
2023-11-22 13:00:00	NVDA	Stock	48.689	49.315	48.675	49.305	71260020.0
2023-11-22 14:00:00	NVDA	Stock	49.305	49.448	48.55	48.887	88458490.0
2023-11-22 15:00:00	NVDA	Stock	48.88	48.951	48.628	48.7065	73498330.0
2023-11-22 16:00:00	NVDA	Stock	48.703	48.716	48.559	48.575	12779570.0
2023-11-22 17:00:00	NVDA	Stock	48.561	48.579	48.484	48.56	784550.0
2023-11-22 18:00:00	NVDA	Stock	48.552	48.574	48.537	48.544	375230.0
2023-11-22 19:00:00	NVDA	Stock	48.541	48.597	48.52	48.53	610830.0
2023-11-22 04:00:00	AMZN	Stock	143.25	143.59	143.25	143.49	9335.0
2023-11-22 05:00:00	AMZN	Stock	143.68	143.9	143.6	143.89	7687.0

> showing 50 of 57,312 rows — these rows as CSV

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