PREVIEW / stock_1hour / 2023-12-14

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-12-14.parquet
  size:    1.4 MB
  rows:    63,176
  symbols: 1,273

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-14 04:00:00	AAPL	Stock	198.53	198.6	197.8	197.99	29854.0
2023-12-14 05:00:00	AAPL	Stock	197.99	198.28	197.91	198.19	12881.0
2023-12-14 06:00:00	AAPL	Stock	198.09	198.1	197.78	197.95	13983.0
2023-12-14 07:00:00	AAPL	Stock	197.98	198.15	197.93	198.0	56488.0
2023-12-14 08:00:00	AAPL	Stock	197.98	198.97	197.9	198.26	250355.0
2023-12-14 09:00:00	AAPL	Stock	198.26	199.62	197.5	199.2	9881350.0
2023-12-14 10:00:00	AAPL	Stock	199.19	199.6	198.6584	199.12	8902734.0
2023-12-14 11:00:00	AAPL	Stock	199.125	199.215	197.76	197.7979	5694786.0
2023-12-14 12:00:00	AAPL	Stock	197.795	198.56	197.59	197.71	4164388.0
2023-12-14 13:00:00	AAPL	Stock	197.71	197.71	196.16	196.7977	4581607.0
2023-12-14 14:00:00	AAPL	Stock	196.795	197.905	196.77	197.715	4094172.0
2023-12-14 15:00:00	AAPL	Stock	197.72	198.16	197.56	198.14	8355468.0
2023-12-14 16:00:00	AAPL	Stock	198.11	198.27	197.85	198.0	7639240.0
2023-12-14 17:00:00	AAPL	Stock	198.0	198.02	197.81	197.89	17714.0
2023-12-14 18:00:00	AAPL	Stock	197.94	198.08	197.8	197.94	18834.0
2023-12-14 19:00:00	AAPL	Stock	197.92	198.14	197.9	197.9	16589.0
2023-12-14 04:00:00	MSFT	Stock	376.0	376.0	375.16	375.25	5113.0
2023-12-14 05:00:00	MSFT	Stock	375.24	375.5	375.05	375.5	3893.0
2023-12-14 06:00:00	MSFT	Stock	375.43	375.48	375.1	375.4	4570.0
2023-12-14 07:00:00	MSFT	Stock	375.4	375.77	374.5	374.5	30271.0
2023-12-14 08:00:00	MSFT	Stock	375.65	376.2	374.15	374.9	76239.0
2023-12-14 09:00:00	MSFT	Stock	374.93	375.5	369.685	370.27	4847571.0
2023-12-14 10:00:00	MSFT	Stock	370.315	370.315	367.65	369.17	4352880.0
2023-12-14 11:00:00	MSFT	Stock	369.17	369.25	366.05	367.1	3377095.0
2023-12-14 12:00:00	MSFT	Stock	367.1	368.04	366.54	366.55	2133980.0
2023-12-14 13:00:00	MSFT	Stock	366.5396	366.545	364.13	364.9	3801894.0
2023-12-14 14:00:00	MSFT	Stock	364.8808	366.18	364.82	365.565	2750813.0
2023-12-14 15:00:00	MSFT	Stock	365.57	366.27	364.89	365.95	5199202.0
2023-12-14 16:00:00	MSFT	Stock	365.93	366.35	365.87	366.33	5138199.0
2023-12-14 17:00:00	MSFT	Stock	366.33	366.39	366.1087	366.3022	10693.0
2023-12-14 18:00:00	MSFT	Stock	366.35	366.77	366.2561	366.65	27825.0
2023-12-14 19:00:00	MSFT	Stock	366.63	366.8	366.2	366.3	9968.0
2023-12-14 04:00:00	NVDA	Stock	48.55	48.55	48.3	48.42	181140.0
2023-12-14 05:00:00	NVDA	Stock	48.4	48.568	48.37	48.539	158110.0
2023-12-14 06:00:00	NVDA	Stock	48.504	48.504	48.42	48.42	103100.0
2023-12-14 07:00:00	NVDA	Stock	48.402	48.55	48.402	48.426	623540.0
2023-12-14 08:00:00	NVDA	Stock	48.53	48.59	48.287	48.43	1763050.0
2023-12-14 09:00:00	NVDA	Stock	48.425	48.67	48.075	48.311	47038070.0
2023-12-14 10:00:00	NVDA	Stock	48.317	48.4	47.889	48.3125	59593210.0
2023-12-14 11:00:00	NVDA	Stock	48.31	48.48	48.04	48.2255	31333260.0
2023-12-14 12:00:00	NVDA	Stock	48.22	48.248	47.845	47.855	22520720.0
2023-12-14 13:00:00	NVDA	Stock	47.869	47.869	47.422	47.675	37589860.0
2023-12-14 14:00:00	NVDA	Stock	47.6792	48.199	47.677	48.193	31603500.0
2023-12-14 15:00:00	NVDA	Stock	48.194	48.35	48.021	48.35	36077890.0
2023-12-14 16:00:00	NVDA	Stock	48.342	48.379	48.25	48.251	17926980.0
2023-12-14 17:00:00	NVDA	Stock	48.25	48.27	48.203	48.215	206790.0
2023-12-14 18:00:00	NVDA	Stock	48.218	48.242	48.171	48.242	239470.0
2023-12-14 19:00:00	NVDA	Stock	48.238	48.25	48.195	48.195	272940.0
2023-12-14 04:00:00	AMZN	Stock	149.8	149.8	149.4	149.49	18772.0
2023-12-14 05:00:00	AMZN	Stock	149.55	149.84	149.45	149.6	10478.0

> showing 50 of 63,176 rows — these rows as CSV

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