PREVIEW / stock_1hour / 2023-08-01

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-01.parquet
  size:    1.4 MB
  rows:    61,654
  symbols: 1,534

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-08-01 04:00:00	AAPL	Stock	196.35	196.35	195.89	195.95	10486.0
2023-08-01 05:00:00	AAPL	Stock	195.98	196.02	195.8	195.87	5627.0
2023-08-01 06:00:00	AAPL	Stock	195.9	196.15	195.88	196.15	2337.0
2023-08-01 07:00:00	AAPL	Stock	196.17	196.21	195.8	195.9	54949.0
2023-08-01 08:00:00	AAPL	Stock	196.18	196.99	195.79	195.88	112771.0
2023-08-01 09:00:00	AAPL	Stock	195.9	196.73	195.8	196.455	3873224.0
2023-08-01 10:00:00	AAPL	Stock	196.46	196.68	195.28	195.8	5991090.0
2023-08-01 11:00:00	AAPL	Stock	195.81	196.18	195.6	195.915	2659528.0
2023-08-01 12:00:00	AAPL	Stock	195.91	195.92	195.35	195.78	2168581.0
2023-08-01 13:00:00	AAPL	Stock	195.78	196.13	195.53	196.07	2159602.0
2023-08-01 14:00:00	AAPL	Stock	196.0675	196.2701	195.68	195.88	2257600.0
2023-08-01 15:00:00	AAPL	Stock	195.88	196.1	195.5	195.6	4042771.0
2023-08-01 16:00:00	AAPL	Stock	195.58	195.98	195.45	195.72	4527739.0
2023-08-01 17:00:00	AAPL	Stock	195.77	195.81	195.05	195.2	115069.0
2023-08-01 18:00:00	AAPL	Stock	195.15	195.33	194.09	195.33	118064.0
2023-08-01 19:00:00	AAPL	Stock	195.28	195.33	195.02	195.3	26050.0
2023-08-01 04:00:00	MSFT	Stock	335.53	335.58	334.71	334.71	1808.0
2023-08-01 05:00:00	MSFT	Stock	334.75	334.85	334.72	334.72	2396.0
2023-08-01 06:00:00	MSFT	Stock	334.85	335.06	334.85	335.0	2098.0
2023-08-01 07:00:00	MSFT	Stock	335.3	335.46	333.63	333.68	8829.0
2023-08-01 08:00:00	MSFT	Stock	335.5	337.35	333.58	333.82	32198.0
2023-08-01 09:00:00	MSFT	Stock	333.9	335.65	333.7	334.3	1916788.0
2023-08-01 10:00:00	MSFT	Stock	334.27	337.83	333.8	337.02	3039191.0
2023-08-01 11:00:00	MSFT	Stock	337.01	338.325	336.51	337.95	1400372.0
2023-08-01 12:00:00	MSFT	Stock	337.95	338.0	336.71	337.7764	923459.0
2023-08-01 13:00:00	MSFT	Stock	337.8	338.54	336.59	337.735	1077998.0
2023-08-01 14:00:00	MSFT	Stock	337.78	338.0899	337.02	337.36	810043.0
2023-08-01 15:00:00	MSFT	Stock	337.36	337.64	336.3	336.35	1900280.0
2023-08-01 16:00:00	MSFT	Stock	336.36	336.39	335.54	335.54	2396101.0
2023-08-01 17:00:00	MSFT	Stock	335.58	335.89	334.21	334.33	40282.0
2023-08-01 18:00:00	MSFT	Stock	334.33	334.33	333.27	334.25	60701.0
2023-08-01 19:00:00	MSFT	Stock	334.25	334.5	333.8	334.39	10727.0
2023-08-01 04:00:00	NVDA	Stock	46.7	46.72	46.58	46.662	35910.0
2023-08-01 05:00:00	NVDA	Stock	46.654	46.654	46.55	46.6	27290.0
2023-08-01 06:00:00	NVDA	Stock	46.588	46.648	46.566	46.624	44520.0
2023-08-01 07:00:00	NVDA	Stock	46.635	46.68	46.457	46.457	246130.0
2023-08-01 08:00:00	NVDA	Stock	46.601	46.887	46.355	46.422	916920.0
2023-08-01 09:00:00	NVDA	Stock	46.404	46.524	46.04	46.096	32042750.0
2023-08-01 10:00:00	NVDA	Stock	46.106	46.9	46.027	46.824	48002740.0
2023-08-01 11:00:00	NVDA	Stock	46.8245	46.886	46.543	46.6122	27370600.0
2023-08-01 12:00:00	NVDA	Stock	46.6122	46.6758	46.46	46.6741	13277100.0
2023-08-01 13:00:00	NVDA	Stock	46.6702	46.792	46.595	46.689	14182260.0
2023-08-01 14:00:00	NVDA	Stock	46.6961	46.715	46.558	46.625	12569940.0
2023-08-01 15:00:00	NVDA	Stock	46.63	46.697	46.479	46.5125	19315850.0
2023-08-01 16:00:00	NVDA	Stock	46.516	46.828	46.379	46.639	11190980.0
2023-08-01 17:00:00	NVDA	Stock	46.65	46.689	46.13	46.261	1395670.0
2023-08-01 18:00:00	NVDA	Stock	46.225	46.3	46.126	46.25	744510.0
2023-08-01 19:00:00	NVDA	Stock	46.249	46.255	46.165	46.195	590500.0
2023-08-01 04:00:00	AMZN	Stock	133.57	133.77	133.1	133.3	11268.0
2023-08-01 05:00:00	AMZN	Stock	133.3	133.3	133.03	133.2	8604.0

> showing 50 of 61,654 rows — these rows as CSV

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