PREVIEW / stock_1hour / 2023-12-22

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-12-22.parquet
  size:    1.4 MB
  rows:    60,090
  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-22 04:00:00	AAPL	Stock	194.46	194.46	193.84	194.21	15128.0
2023-12-22 05:00:00	AAPL	Stock	194.21	194.56	194.15	194.53	7248.0
2023-12-22 06:00:00	AAPL	Stock	194.59	194.69	194.58	194.69	2643.0
2023-12-22 07:00:00	AAPL	Stock	194.74	194.99	194.74	194.94	24172.0
2023-12-22 08:00:00	AAPL	Stock	194.665	195.2	194.1	195.18	166809.0
2023-12-22 09:00:00	AAPL	Stock	195.18	195.41	194.425	195.235	3961461.0
2023-12-22 10:00:00	AAPL	Stock	195.23	195.29	194.33	194.345	4247007.0
2023-12-22 11:00:00	AAPL	Stock	194.34	194.38	194.01	194.13	3096919.0
2023-12-22 12:00:00	AAPL	Stock	194.1399	194.32	193.84	194.25	2832429.0
2023-12-22 13:00:00	AAPL	Stock	194.259	194.46	193.98	194.0	2321222.0
2023-12-22 14:00:00	AAPL	Stock	194.01	194.02	192.97	193.8	3650702.0
2023-12-22 15:00:00	AAPL	Stock	193.81	193.99	193.485	193.53	5562338.0
2023-12-22 16:00:00	AAPL	Stock	193.62	193.76	193.53	193.6	4843320.0
2023-12-22 17:00:00	AAPL	Stock	193.5809	193.6	193.55	193.58	50461.0
2023-12-22 18:00:00	AAPL	Stock	193.57	193.65	193.56	193.6	4234.0
2023-12-22 19:00:00	AAPL	Stock	193.57	193.59	193.55	193.58	15420.0
2023-12-22 04:00:00	MSFT	Stock	372.3	372.76	372.08	372.08	2074.0
2023-12-22 05:00:00	MSFT	Stock	372.4	372.67	372.04	372.67	895.0
2023-12-22 06:00:00	MSFT	Stock	372.8	372.97	372.64	372.8	1200.0
2023-12-22 07:00:00	MSFT	Stock	372.71	372.89	372.55	372.55	19876.0
2023-12-22 08:00:00	MSFT	Stock	372.74	373.48	372.0	373.3	50320.0
2023-12-22 09:00:00	MSFT	Stock	373.35	374.2969	372.71	374.07	1448769.0
2023-12-22 10:00:00	MSFT	Stock	374.09	375.18	373.9	374.64	1467131.0
2023-12-22 11:00:00	MSFT	Stock	374.6	375.0	374.01	374.4382	995292.0
2023-12-22 12:00:00	MSFT	Stock	374.46	374.68	373.63	374.67	763986.0
2023-12-22 13:00:00	MSFT	Stock	374.64	375.03	374.59	374.8269	713845.0
2023-12-22 14:00:00	MSFT	Stock	374.8	374.9539	373.15	374.6	1149576.0
2023-12-22 15:00:00	MSFT	Stock	374.6	374.8	374.07	374.605	1507014.0
2023-12-22 16:00:00	MSFT	Stock	374.58	375.25	374.58	374.867	2232823.0
2023-12-22 17:00:00	MSFT	Stock	374.7	375.06	374.58	374.58	7334.0
2023-12-22 18:00:00	MSFT	Stock	375.05	375.25	375.0	375.0	5649.0
2023-12-22 19:00:00	MSFT	Stock	375.04	375.06	374.88	375.05	11501.0
2023-12-22 04:00:00	NVDA	Stock	48.9	48.9	48.73	48.743	67020.0
2023-12-22 05:00:00	NVDA	Stock	48.738	48.83	48.738	48.823	33240.0
2023-12-22 06:00:00	NVDA	Stock	48.838	48.838	48.8	48.8	13770.0
2023-12-22 07:00:00	NVDA	Stock	48.85	49.115	48.85	49.035	339350.0
2023-12-22 08:00:00	NVDA	Stock	48.915	49.28	48.721	49.27	2181910.0
2023-12-22 09:00:00	NVDA	Stock	49.275	49.383	49.003	49.0922	34600240.0
2023-12-22 10:00:00	NVDA	Stock	49.0876	49.3122	49.002	49.105	33773500.0
2023-12-22 11:00:00	NVDA	Stock	49.1	49.1109	48.918	49.0329	24821820.0
2023-12-22 12:00:00	NVDA	Stock	49.036	49.148	48.848	49.0	21395770.0
2023-12-22 13:00:00	NVDA	Stock	49.0001	49.084	48.957	48.9874	14108130.0
2023-12-22 14:00:00	NVDA	Stock	48.984	48.998	48.467	48.8165	33002230.0
2023-12-22 15:00:00	NVDA	Stock	48.82	48.843	48.664	48.827	25145090.0
2023-12-22 16:00:00	NVDA	Stock	48.83	48.848	48.794	48.805	11570770.0
2023-12-22 17:00:00	NVDA	Stock	48.805	48.83	48.805	48.813	154310.0
2023-12-22 18:00:00	NVDA	Stock	48.82	48.84	48.815	48.825	119370.0
2023-12-22 19:00:00	NVDA	Stock	48.824	48.849	48.82	48.82	139080.0
2023-12-22 04:00:00	AMZN	Stock	153.35	153.69	153.26	153.26	14519.0
2023-12-22 05:00:00	AMZN	Stock	153.34	153.39	153.12	153.25	9114.0

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

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