PREVIEW / stock_1hour / 2001-05-23

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-05-23.parquet
  size:    369 KB
  rows:    17,849
  symbols: 1,302

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
2001-05-23 08:00:00	AAPL	Stock	0.4241	0.4304	0.4205	0.4282	1926400.0
2001-05-23 09:00:00	AAPL	Stock	0.4286	0.4286	0.4161	0.418	41557600.0
2001-05-23 10:00:00	AAPL	Stock	0.418	0.42	0.4118	0.4159	40784800.0
2001-05-23 11:00:00	AAPL	Stock	0.4161	0.4173	0.4082	0.412	47034400.0
2001-05-23 12:00:00	AAPL	Stock	0.4118	0.4196	0.4118	0.4189	25418400.0
2001-05-23 13:00:00	AAPL	Stock	0.4189	0.4216	0.4114	0.4132	28817600.0
2001-05-23 14:00:00	AAPL	Stock	0.4132	0.4179	0.4116	0.4152	25233600.0
2001-05-23 15:00:00	AAPL	Stock	0.4148	0.417	0.4134	0.4148	34608000.0
2001-05-23 16:00:00	AAPL	Stock	0.4161	0.4214	0.4118	0.415	22696800.0
2001-05-23 17:00:00	AAPL	Stock	0.4148	0.4152	0.4148	0.4148	2055200.0
2001-05-23 18:00:00	AAPL	Stock	0.4148	0.415	0.4148	0.415	162400.0
2001-05-23 08:00:00	MSFT	Stock	35.05	35.155	34.925	35.1	234400.0
2001-05-23 09:00:00	MSFT	Stock	35.1	35.74	34.995	35.54	19670800.0
2001-05-23 10:00:00	MSFT	Stock	35.535	35.8	35.36	35.52	18032000.0
2001-05-23 11:00:00	MSFT	Stock	35.525	35.59	35.185	35.285	16742800.0
2001-05-23 12:00:00	MSFT	Stock	35.29	35.415	35.215	35.36	4397400.0
2001-05-23 13:00:00	MSFT	Stock	35.36	35.41	35.05	35.075	4996600.0
2001-05-23 14:00:00	MSFT	Stock	35.075	35.325	35.005	35.235	7174600.0
2001-05-23 15:00:00	MSFT	Stock	35.235	35.325	34.75	34.855	13080200.0
2001-05-23 16:00:00	MSFT	Stock	34.865	35.78	34.75	34.845	4823600.0
2001-05-23 17:00:00	MSFT	Stock	34.85	35.19	34.755	35.07	341400.0
2001-05-23 18:00:00	MSFT	Stock	34.87	34.87	34.85	34.85	21600.0
2001-05-23 08:00:00	NVDA	Stock	0.4021	0.4125	0.3923	0.4088	27432000.0
2001-05-23 09:00:00	NVDA	Stock	0.4088	0.4104	0.3966	0.4033	487752000.0
2001-05-23 10:00:00	NVDA	Stock	0.4039	0.4163	0.4021	0.4073	602256000.0
2001-05-23 11:00:00	NVDA	Stock	0.4074	0.4076	0.4034	0.406	189888000.0
2001-05-23 12:00:00	NVDA	Stock	0.406	0.4085	0.4043	0.4065	131376000.0
2001-05-23 13:00:00	NVDA	Stock	0.4067	0.4079	0.4038	0.4047	82704000.0
2001-05-23 14:00:00	NVDA	Stock	0.4049	0.4058	0.4	0.402	130392000.0
2001-05-23 15:00:00	NVDA	Stock	0.402	0.4025	0.3792	0.3835	455400000.0
2001-05-23 16:00:00	NVDA	Stock	0.3838	0.4154	0.3823	0.3838	45216000.0
2001-05-23 17:00:00	NVDA	Stock	0.3833	0.3844	0.3819	0.3819	1608000.0
2001-05-23 18:00:00	NVDA	Stock	0.3814	0.3844	0.3814	0.3844	1320000.0
2001-05-23 08:00:00	AMZN	Stock	0.815	0.815	0.815	0.815	6000.0
2001-05-23 09:00:00	AMZN	Stock	0.81	0.815	0.795	0.7975	12420000.0
2001-05-23 10:00:00	AMZN	Stock	0.797	0.834	0.79	0.823	18204000.0
2001-05-23 11:00:00	AMZN	Stock	0.8225	0.835	0.811	0.829	17542000.0
2001-05-23 12:00:00	AMZN	Stock	0.828	0.839	0.827	0.831	8964000.0
2001-05-23 13:00:00	AMZN	Stock	0.8315	0.84	0.756	0.767	60246000.0
2001-05-23 14:00:00	AMZN	Stock	0.766	0.7925	0.756	0.7815	28932000.0
2001-05-23 15:00:00	AMZN	Stock	0.785	0.795	0.7795	0.7805	12466000.0
2001-05-23 16:00:00	AMZN	Stock	0.78	0.81	0.766	0.78	2252000.0
2001-05-23 17:00:00	AMZN	Stock	0.78	0.78	0.7775	0.7775	562000.0
2001-05-23 18:00:00	AMZN	Stock	0.78	0.78	0.78	0.78	82000.0
2001-05-23 09:00:00	CL	Stock	28.1	28.5	28.1	28.47	465200.0
2001-05-23 10:00:00	CL	Stock	28.47	28.475	28.265	28.35	655800.0
2001-05-23 11:00:00	CL	Stock	28.35	28.5	28.26	28.45	452000.0
2001-05-23 12:00:00	CL	Stock	28.43	28.625	28.405	28.55	307800.0
2001-05-23 13:00:00	CL	Stock	28.55	28.58	28.395	28.545	325000.0
2001-05-23 14:00:00	CL	Stock	28.545	28.58	28.45	28.535	258200.0

> showing 50 of 17,849 rows — these rows as CSV

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