PREVIEW / stock_1hour / 2023-12-27

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-12-27.parquet
  size:    1.4 MB
  rows:    60,884
  symbols: 1,232

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-12-27 04:00:00	AAPL	Stock	193.0	193.0	192.74	192.8	11301.0
2023-12-27 05:00:00	AAPL	Stock	192.8	192.86	192.8	192.86	1006.0
2023-12-27 06:00:00	AAPL	Stock	192.81	192.83	192.8	192.82	2893.0
2023-12-27 07:00:00	AAPL	Stock	192.85	192.98	192.82	192.91	9352.0
2023-12-27 08:00:00	AAPL	Stock	192.8214	193.05	192.8	192.9133	57547.0
2023-12-27 09:00:00	AAPL	Stock	192.94	192.99	192.0	192.45	3618234.0
2023-12-27 10:00:00	AAPL	Stock	192.455	192.54	191.1	191.67	6007923.0
2023-12-27 11:00:00	AAPL	Stock	191.6788	192.18	191.09	192.1442	5328571.0
2023-12-27 12:00:00	AAPL	Stock	192.15	192.75	192.1111	192.64	3805835.0
2023-12-27 13:00:00	AAPL	Stock	192.64	193.5	192.64	193.3818	3953139.0
2023-12-27 14:00:00	AAPL	Stock	193.38	193.38	192.76	192.92	3523612.0
2023-12-27 15:00:00	AAPL	Stock	192.92	193.22	192.73	193.19	4810906.0
2023-12-27 16:00:00	AAPL	Stock	193.15	193.23	193.08	193.13	6259152.0
2023-12-27 17:00:00	AAPL	Stock	193.11	193.23	193.0501	193.1494	25227.0
2023-12-27 18:00:00	AAPL	Stock	193.15	193.1954	193.1	193.16	11886.0
2023-12-27 19:00:00	AAPL	Stock	193.16	193.22	193.1	193.1794	13824.0
2023-12-27 04:00:00	MSFT	Stock	374.66	374.89	374.66	374.89	350.0
2023-12-27 05:00:00	MSFT	Stock	374.89	375.0	374.89	375.0	305.0
2023-12-27 06:00:00	MSFT	Stock	374.81	374.81	374.7	374.7	660.0
2023-12-27 07:00:00	MSFT	Stock	374.58	374.74	374.45	374.74	2200.0
2023-12-27 08:00:00	MSFT	Stock	374.7	375.0	374.04	374.2	25777.0
2023-12-27 09:00:00	MSFT	Stock	374.21	375.06	372.72	373.78	1180193.0
2023-12-27 10:00:00	MSFT	Stock	373.815	374.28	372.8116	373.57	1222631.0
2023-12-27 11:00:00	MSFT	Stock	373.58	374.13	373.2	373.91	704882.0
2023-12-27 12:00:00	MSFT	Stock	373.917	374.02	373.38	373.43	707784.0
2023-12-27 13:00:00	MSFT	Stock	373.44	374.57	373.37	373.97	1039577.0
2023-12-27 14:00:00	MSFT	Stock	373.9562	373.9562	372.96	373.32	994135.0
2023-12-27 15:00:00	MSFT	Stock	373.32	374.2	373.12	374.07	1626056.0
2023-12-27 16:00:00	MSFT	Stock	374.07	374.58	374.07	374.07	3069945.0
2023-12-27 17:00:00	MSFT	Stock	374.24	374.3	374.08	374.16	7726.0
2023-12-27 18:00:00	MSFT	Stock	374.16	374.27	374.12	374.12	3953.0
2023-12-27 19:00:00	MSFT	Stock	374.18	374.18	374.08	374.08	3003.0
2023-12-27 04:00:00	NVDA	Stock	49.35	49.375	49.3	49.35	43610.0
2023-12-27 05:00:00	NVDA	Stock	49.335	49.385	49.335	49.37	8190.0
2023-12-27 06:00:00	NVDA	Stock	49.37	49.374	49.35	49.374	11370.0
2023-12-27 07:00:00	NVDA	Stock	49.379	49.45	49.379	49.447	273830.0
2023-12-27 08:00:00	NVDA	Stock	49.4	49.54	49.35	49.504	1081370.0
2023-12-27 09:00:00	NVDA	Stock	49.501	49.68	49.304	49.369	31988470.0
2023-12-27 10:00:00	NVDA	Stock	49.37	49.388	49.085	49.244	40713310.0
2023-12-27 11:00:00	NVDA	Stock	49.245	49.462	49.203	49.3919	25270100.0
2023-12-27 12:00:00	NVDA	Stock	49.3931	49.45	49.3506	49.374	13192370.0
2023-12-27 13:00:00	NVDA	Stock	49.369	49.508	49.355	49.46	17720260.0
2023-12-27 14:00:00	NVDA	Stock	49.458	49.458	49.2828	49.393	18410050.0
2023-12-27 15:00:00	NVDA	Stock	49.395	49.435	49.323	49.421	20940580.0
2023-12-27 16:00:00	NVDA	Stock	49.421	49.45	49.356	49.433	13130180.0
2023-12-27 17:00:00	NVDA	Stock	49.438	49.447	49.421	49.4312	129730.0
2023-12-27 18:00:00	NVDA	Stock	49.431	49.4462	49.417	49.444	120720.0
2023-12-27 19:00:00	NVDA	Stock	49.44	49.451	49.431	49.451	157850.0
2023-12-27 04:00:00	AMZN	Stock	153.35	153.56	153.35	153.4	4700.0
2023-12-27 05:00:00	AMZN	Stock	153.41	153.55	153.38	153.45	2272.0

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

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