PREVIEW / stock_1hour / 2023-05-31

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-31.parquet
  size:    1.4 MB
  rows:    60,935
  symbols: 1,628

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-05-31 04:00:00	AAPL	Stock	177.48	177.48	176.45	176.69	14732.0
2023-05-31 05:00:00	AAPL	Stock	176.7	176.92	176.62	176.85	10110.0
2023-05-31 06:00:00	AAPL	Stock	176.81	177.36	176.72	177.29	23324.0
2023-05-31 07:00:00	AAPL	Stock	177.37	177.5	176.95	177.1	40571.0
2023-05-31 08:00:00	AAPL	Stock	177.46	177.49	176.5	176.82	100573.0
2023-05-31 09:00:00	AAPL	Stock	176.86	179.09	176.53	178.95	7189276.0
2023-05-31 10:00:00	AAPL	Stock	178.97	179.35	177.42	178.34	9558340.0
2023-05-31 11:00:00	AAPL	Stock	178.35	179.07	178.06	178.87	6037173.0
2023-05-31 12:00:00	AAPL	Stock	178.875	179.04	178.46	178.73	4128227.0
2023-05-31 13:00:00	AAPL	Stock	178.74	179.3	178.56	179.06	4084332.0
2023-05-31 14:00:00	AAPL	Stock	179.065	179.29	178.55	178.75	4234968.0
2023-05-31 15:00:00	AAPL	Stock	178.76	179.3	176.76	177.42	14920282.0
2023-05-31 16:00:00	AAPL	Stock	177.43	177.62	176.86	177.38	30108321.0
2023-05-31 17:00:00	AAPL	Stock	177.35	177.65	177.35	177.42	94654.0
2023-05-31 18:00:00	AAPL	Stock	177.46	177.57	177.35	177.5	28482.0
2023-05-31 19:00:00	AAPL	Stock	177.58	177.76	177.5	177.76	34763.0
2023-05-31 04:00:00	MSFT	Stock	330.8	332.91	330.51	332.15	20393.0
2023-05-31 05:00:00	MSFT	Stock	332.63	333.0	332.4	332.55	6553.0
2023-05-31 06:00:00	MSFT	Stock	332.4	332.8	331.61	332.75	6985.0
2023-05-31 07:00:00	MSFT	Stock	333.0	333.69	332.06	332.44	23423.0
2023-05-31 08:00:00	MSFT	Stock	333.0	333.7	330.2	331.95	62745.0
2023-05-31 09:00:00	MSFT	Stock	331.98	335.94	331.28	334.71	3600968.0
2023-05-31 10:00:00	MSFT	Stock	334.73	334.99	330.85	331.56	3438749.0
2023-05-31 11:00:00	MSFT	Stock	331.615	331.68	328.91	329.72	2443249.0
2023-05-31 12:00:00	MSFT	Stock	329.72	330.06	327.33	328.97	1944113.0
2023-05-31 13:00:00	MSFT	Stock	329.01	330.81	328.76	330.55	1667511.0
2023-05-31 14:00:00	MSFT	Stock	330.5331	331.11	329.45	329.8056	1531471.0
2023-05-31 15:00:00	MSFT	Stock	329.79	331.31	328.47	328.76	4482440.0
2023-05-31 16:00:00	MSFT	Stock	328.77	329.1	327.67	328.34	13025311.0
2023-05-31 17:00:00	MSFT	Stock	328.21	329.0514	328.21	329.0514	13529.0
2023-05-31 18:00:00	MSFT	Stock	329.07	329.25	328.5068	328.5068	3325.0
2023-05-31 19:00:00	MSFT	Stock	329.0	329.3999	328.9801	329.15	8389.0
2023-05-31 04:00:00	NVDA	Stock	39.734	39.734	39.48	39.523	243340.0
2023-05-31 05:00:00	NVDA	Stock	39.524	39.59	39.516	39.576	304020.0
2023-05-31 06:00:00	NVDA	Stock	39.581	39.598	39.381	39.469	409230.0
2023-05-31 07:00:00	NVDA	Stock	39.453	39.647	39.363	39.41	1452940.0
2023-05-31 08:00:00	NVDA	Stock	39.45	40.111	39.3	39.351	2836300.0
2023-05-31 09:00:00	NVDA	Stock	39.368	40.295	39.35	39.6216	75545310.0
2023-05-31 10:00:00	NVDA	Stock	39.6235	39.755	38.906	39.1761	109590480.0
2023-05-31 11:00:00	NVDA	Stock	39.184	39.192	38.501	38.687	88391950.0
2023-05-31 12:00:00	NVDA	Stock	38.687	38.741	38.052	38.1884	75323760.0
2023-05-31 13:00:00	NVDA	Stock	38.197	38.792	38.0985	38.7728	73768590.0
2023-05-31 14:00:00	NVDA	Stock	38.7765	38.7829	38.4132	38.467	50103070.0
2023-05-31 15:00:00	NVDA	Stock	38.474	38.498	37.822	37.838	97253120.0
2023-05-31 16:00:00	NVDA	Stock	37.856	37.988	37.79	37.965	154804000.0
2023-05-31 17:00:00	NVDA	Stock	37.965	37.994	37.87	37.908	831410.0
2023-05-31 18:00:00	NVDA	Stock	37.905	37.96	37.875	37.877	279840.0
2023-05-31 19:00:00	NVDA	Stock	37.875	38.0	37.845	38.0	511120.0
2023-05-31 04:00:00	AMZN	Stock	121.66	121.66	121.07	121.39	16756.0
2023-05-31 05:00:00	AMZN	Stock	121.35	121.8	121.35	121.62	15741.0

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

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