PREVIEW / stock_1hour / 2023-03-03

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-03.parquet
  size:    1.4 MB
  rows:    60,371
  symbols: 1,801

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-03 04:00:00	AAPL	Stock	145.92	147.1	145.92	146.79	36806.0
2023-03-03 05:00:00	AAPL	Stock	146.92	147.2	146.92	147.06	19732.0
2023-03-03 06:00:00	AAPL	Stock	147.1	147.87	147.02	147.76	56163.0
2023-03-03 07:00:00	AAPL	Stock	147.73	147.85	147.16	147.32	96575.0
2023-03-03 08:00:00	AAPL	Stock	147.66	148.12	145.23	148.0941	325277.0
2023-03-03 09:00:00	AAPL	Stock	148.12	149.48	147.33	149.47	9047573.0
2023-03-03 10:00:00	AAPL	Stock	149.47	150.17	149.03	149.6384	9970473.0
2023-03-03 11:00:00	AAPL	Stock	149.64	149.98	149.26	149.8367	5427335.0
2023-03-03 12:00:00	AAPL	Stock	149.84	150.24	149.6001	150.2117	4533535.0
2023-03-03 13:00:00	AAPL	Stock	150.23	150.32	149.8846	150.2287	4437246.0
2023-03-03 14:00:00	AAPL	Stock	150.22	150.89	150.1	150.83	5131967.0
2023-03-03 15:00:00	AAPL	Stock	150.835	151.11	150.53	151.1	9684620.0
2023-03-03 16:00:00	AAPL	Stock	151.1	151.25	150.93	151.22	12002405.0
2023-03-03 17:00:00	AAPL	Stock	151.2	151.23	151.0604	151.1	39122.0
2023-03-03 18:00:00	AAPL	Stock	151.1	151.15	151.06	151.1	19529.0
2023-03-03 19:00:00	AAPL	Stock	151.1	151.42	151.08	151.42	34994.0
2023-03-03 04:00:00	MSFT	Stock	251.87	251.95	251.12	251.44	4482.0
2023-03-03 05:00:00	MSFT	Stock	251.5	251.93	251.5	251.9	4661.0
2023-03-03 06:00:00	MSFT	Stock	252.01	252.32	251.2	251.82	7665.0
2023-03-03 07:00:00	MSFT	Stock	251.95	252.0	250.9	250.98	14734.0
2023-03-03 08:00:00	MSFT	Stock	251.94	252.1	250.483	251.94	41558.0
2023-03-03 09:00:00	MSFT	Stock	251.94	254.47	251.39	254.37	1984119.0
2023-03-03 10:00:00	MSFT	Stock	254.38	255.25	253.23	254.1	2560996.0
2023-03-03 11:00:00	MSFT	Stock	254.1246	254.17	253.25	253.87	1807633.0
2023-03-03 12:00:00	MSFT	Stock	253.88	254.97	253.6	254.94	1280783.0
2023-03-03 13:00:00	MSFT	Stock	254.95	255.42	254.72	254.89	1163238.0
2023-03-03 14:00:00	MSFT	Stock	254.91	255.62	254.6443	254.81	1451999.0
2023-03-03 15:00:00	MSFT	Stock	254.83	255.42	254.425	255.33	3670129.0
2023-03-03 16:00:00	MSFT	Stock	255.29	255.55	255.07	255.54	7427279.0
2023-03-03 17:00:00	MSFT	Stock	255.46	255.54	255.39	255.4	8632.0
2023-03-03 18:00:00	MSFT	Stock	255.46	255.52	255.4	255.5	1442.0
2023-03-03 19:00:00	MSFT	Stock	255.5	255.55	255.44	255.55	10710.0
2023-03-03 04:00:00	NVDA	Stock	23.3	23.378	23.28	23.34	144340.0
2023-03-03 05:00:00	NVDA	Stock	23.35	23.385	23.338	23.345	119080.0
2023-03-03 06:00:00	NVDA	Stock	23.376	23.39	23.35	23.37	107460.0
2023-03-03 07:00:00	NVDA	Stock	23.37	23.455	23.355	23.361	630070.0
2023-03-03 08:00:00	NVDA	Stock	23.405	23.46	23.203	23.4	1381470.0
2023-03-03 09:00:00	NVDA	Stock	23.415	23.493	23.23	23.326	45496460.0
2023-03-03 10:00:00	NVDA	Stock	23.326	23.41	23.13	23.2619	54505730.0
2023-03-03 11:00:00	NVDA	Stock	23.261	23.304	23.1386	23.258	32814660.0
2023-03-03 12:00:00	NVDA	Stock	23.258	23.546	23.251	23.536	32627090.0
2023-03-03 13:00:00	NVDA	Stock	23.538	23.63	23.487	23.623	30580410.0
2023-03-03 14:00:00	NVDA	Stock	23.622	23.816	23.616	23.812	40046930.0
2023-03-03 15:00:00	NVDA	Stock	23.815	23.9	23.774	23.891	60489760.0
2023-03-03 16:00:00	NVDA	Stock	23.891	23.891	23.786	23.79	30482470.0
2023-03-03 17:00:00	NVDA	Stock	23.785	23.835	23.785	23.835	242770.0
2023-03-03 18:00:00	NVDA	Stock	23.838	23.879	23.823	23.862	209830.0
2023-03-03 19:00:00	NVDA	Stock	23.856	23.927	23.855	23.919	304820.0
2023-03-03 04:00:00	AMZN	Stock	92.31	92.53	92.2	92.42	25246.0
2023-03-03 05:00:00	AMZN	Stock	92.54	92.67	92.39	92.45	8910.0

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

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