PREVIEW / stock_1hour / 2023-03-02

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-02.parquet
  size:    1.4 MB
  rows:    60,509
  symbols: 1,822

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-03-02 04:00:00	AAPL	Stock	144.96	144.96	143.88	143.88	34956.0
2023-03-02 05:00:00	AAPL	Stock	143.85	144.02	143.6	144.02	27490.0
2023-03-02 06:00:00	AAPL	Stock	144.1	144.39	144.06	144.39	14629.0
2023-03-02 07:00:00	AAPL	Stock	144.4	144.82	144.11	144.22	51229.0
2023-03-02 08:00:00	AAPL	Stock	144.39	144.947	143.54	143.69	254793.0
2023-03-02 09:00:00	AAPL	Stock	143.68	144.79	143.68	144.34	5745180.0
2023-03-02 10:00:00	AAPL	Stock	144.355	144.705	143.9	144.4871	5984589.0
2023-03-02 11:00:00	AAPL	Stock	144.485	144.7315	143.9714	144.3489	3503331.0
2023-03-02 12:00:00	AAPL	Stock	144.355	144.66	144.2215	144.45	3392950.0
2023-03-02 13:00:00	AAPL	Stock	144.46	145.5599	144.28	145.54	4142751.0
2023-03-02 14:00:00	AAPL	Stock	145.55	146.0482	145.39	145.855	5348248.0
2023-03-02 15:00:00	AAPL	Stock	145.84	146.71	145.5647	145.9101	8749908.0
2023-03-02 16:00:00	AAPL	Stock	145.94	146.0	145.71	145.8	8551705.0
2023-03-02 17:00:00	AAPL	Stock	145.81	145.81	145.3	145.31	35712.0
2023-03-02 18:00:00	AAPL	Stock	145.38	145.58	145.32	145.45	12875.0
2023-03-02 19:00:00	AAPL	Stock	145.43	145.68	145.3	145.6	20635.0
2023-03-02 04:00:00	MSFT	Stock	246.22	246.27	245.5	245.61	19247.0
2023-03-02 05:00:00	MSFT	Stock	245.58	245.9	245.0	245.9	11829.0
2023-03-02 06:00:00	MSFT	Stock	245.9	246.78	245.9	246.67	5319.0
2023-03-02 07:00:00	MSFT	Stock	246.8	247.47	245.0	245.02	46006.0
2023-03-02 08:00:00	MSFT	Stock	247.0	247.37	243.35	244.75	166876.0
2023-03-02 09:00:00	MSFT	Stock	245.1	247.59	245.0313	246.61	2890823.0
2023-03-02 10:00:00	MSFT	Stock	246.66	247.82	246.53	247.63	2482662.0
2023-03-02 11:00:00	MSFT	Stock	247.6599	247.91	246.6	247.42	1560335.0
2023-03-02 12:00:00	MSFT	Stock	247.44	247.65	246.88	247.33	1011775.0
2023-03-02 13:00:00	MSFT	Stock	247.34	249.41	246.86	249.39	1705928.0
2023-03-02 14:00:00	MSFT	Stock	249.39	250.84	249.39	250.04	2076588.0
2023-03-02 15:00:00	MSFT	Stock	250.03	251.4	249.815	251.11	3248595.0
2023-03-02 16:00:00	MSFT	Stock	251.1	251.11	250.76	250.99	4493044.0
2023-03-02 17:00:00	MSFT	Stock	250.92	250.92	250.6	250.9	9241.0
2023-03-02 18:00:00	MSFT	Stock	250.78	250.89	250.7	250.85	2962.0
2023-03-02 19:00:00	MSFT	Stock	250.99	251.05	250.6	250.95	8653.0
2023-03-02 04:00:00	NVDA	Stock	22.308	22.527	22.308	22.421	137690.0
2023-03-02 05:00:00	NVDA	Stock	22.401	22.445	22.36	22.411	244020.0
2023-03-02 06:00:00	NVDA	Stock	22.438	22.525	22.438	22.465	74560.0
2023-03-02 07:00:00	NVDA	Stock	22.5	22.575	22.445	22.448	473160.0
2023-03-02 08:00:00	NVDA	Stock	22.625	22.625	22.295	22.364	2586310.0
2023-03-02 09:00:00	NVDA	Stock	22.364	22.78	22.35	22.702	42067020.0
2023-03-02 10:00:00	NVDA	Stock	22.704	22.83	22.586	22.7453	52288240.0
2023-03-02 11:00:00	NVDA	Stock	22.747	22.794	22.651	22.698	27482820.0
2023-03-02 12:00:00	NVDA	Stock	22.699	22.854	22.694	22.831	26362040.0
2023-03-02 13:00:00	NVDA	Stock	22.834	23.1	22.75	23.0847	34341810.0
2023-03-02 14:00:00	NVDA	Stock	23.086	23.262	23.085	23.21	47488900.0
2023-03-02 15:00:00	NVDA	Stock	23.206	23.3804	23.177	23.315	57693460.0
2023-03-02 16:00:00	NVDA	Stock	23.315	23.325	23.265	23.318	18900240.0
2023-03-02 17:00:00	NVDA	Stock	23.323	23.325	23.206	23.209	578910.0
2023-03-02 18:00:00	NVDA	Stock	23.205	23.245	23.195	23.239	147250.0
2023-03-02 19:00:00	NVDA	Stock	23.238	23.277	23.228	23.265	390420.0
2023-03-02 04:00:00	AMZN	Stock	91.46	91.92	91.18	91.25	15198.0
2023-03-02 05:00:00	AMZN	Stock	91.25	91.46	91.02	91.46	10379.0

> showing 50 of 60,509 rows — these rows as CSV

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