PREVIEW / stock_1hour / 2002-01-22

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-01-22.parquet
  size:    391 KB
  rows:    18,639
  symbols: 1,352

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
2002-01-22 08:00:00	AAPL	Stock	0.4	0.4	0.3964	0.3973	252000.0
2002-01-22 09:00:00	AAPL	Stock	0.4	0.4	0.3957	0.3982	18860800.0
2002-01-22 10:00:00	AAPL	Stock	0.3982	0.3995	0.3925	0.3936	40947200.0
2002-01-22 11:00:00	AAPL	Stock	0.3936	0.3943	0.3925	0.3927	65559200.0
2002-01-22 12:00:00	AAPL	Stock	0.3927	0.3938	0.392	0.3932	26846400.0
2002-01-22 13:00:00	AAPL	Stock	0.3932	0.3955	0.3923	0.3925	29741600.0
2002-01-22 14:00:00	AAPL	Stock	0.3925	0.3936	0.3921	0.393	62731200.0
2002-01-22 15:00:00	AAPL	Stock	0.393	0.3941	0.3896	0.3896	66841600.0
2002-01-22 16:00:00	AAPL	Stock	0.3896	0.3939	0.3888	0.3896	11883200.0
2002-01-22 17:00:00	AAPL	Stock	0.3911	0.3932	0.3886	0.3927	100800.0
2002-01-22 18:00:00	AAPL	Stock	0.3938	0.3938	0.3893	0.3893	16800.0
2002-01-22 08:00:00	MSFT	Stock	33.45	33.515	33.25	33.4	57800.0
2002-01-22 09:00:00	MSFT	Stock	33.355	33.375	33.005	33.165	11794400.0
2002-01-22 10:00:00	MSFT	Stock	33.175	33.25	32.3705	32.485	18932200.0
2002-01-22 11:00:00	MSFT	Stock	32.47	32.575	32.325	32.395	9577400.0
2002-01-22 12:00:00	MSFT	Stock	32.3955	32.54	32.335	32.52	6567400.0
2002-01-22 13:00:00	MSFT	Stock	32.515	32.52	32.215	32.345	6716800.0
2002-01-22 14:00:00	MSFT	Stock	32.35	32.425	32.2	32.2305	7433800.0
2002-01-22 15:00:00	MSFT	Stock	32.2305	32.4005	32.125	32.23	10767800.0
2002-01-22 16:00:00	MSFT	Stock	32.23	32.5911	32.18	32.23	2953200.0
2002-01-22 17:00:00	MSFT	Stock	32.25	32.5731	32.195	32.195	57200.0
2002-01-22 18:00:00	MSFT	Stock	32.195	32.195	32.17	32.17	4400.0
2002-01-22 08:00:00	NVDA	Stock	0.5354	0.5409	0.5354	0.5392	1212000.0
2002-01-22 09:00:00	NVDA	Stock	0.5392	0.5397	0.5234	0.528	99816000.0
2002-01-22 10:00:00	NVDA	Stock	0.528	0.5302	0.5208	0.5228	196812000.0
2002-01-22 11:00:00	NVDA	Stock	0.5227	0.5263	0.5196	0.5225	142788000.0
2002-01-22 12:00:00	NVDA	Stock	0.5225	0.5247	0.5147	0.5212	137496000.0
2002-01-22 13:00:00	NVDA	Stock	0.5209	0.5219	0.5165	0.5209	101952000.0
2002-01-22 14:00:00	NVDA	Stock	0.5208	0.5217	0.5162	0.5167	100248000.0
2002-01-22 15:00:00	NVDA	Stock	0.5165	0.5221	0.5123	0.5185	224124000.0
2002-01-22 16:00:00	NVDA	Stock	0.5186	0.5371	0.5129	0.5217	45276000.0
2002-01-22 17:00:00	NVDA	Stock	0.5217	0.5223	0.52	0.5217	540000.0
2002-01-22 18:00:00	NVDA	Stock	0.5217	0.5223	0.5208	0.5223	84000.0
2002-01-22 08:00:00	AMZN	Stock	0.6	0.6625	0.535	0.6525	80820140.0
2002-01-22 09:00:00	AMZN	Stock	0.6535	0.6574	0.53	0.618	292060000.0
2002-01-22 10:00:00	AMZN	Stock	0.6186	0.6265	0.6105	0.617	239214000.0
2002-01-22 11:00:00	AMZN	Stock	0.6165	0.625	0.611	0.613	104864000.0
2002-01-22 12:00:00	AMZN	Stock	0.613	0.62	0.6074	0.619	69872000.0
2002-01-22 13:00:00	AMZN	Stock	0.619	0.627	0.615	0.6245	61942000.0
2002-01-22 14:00:00	AMZN	Stock	0.6245	0.631	0.6225	0.625	79102000.0
2002-01-22 15:00:00	AMZN	Stock	0.625	0.639	0.624	0.63	126376000.0
2002-01-22 16:00:00	AMZN	Stock	0.63	0.6375	0.618	0.6255	18744000.0
2002-01-22 17:00:00	AMZN	Stock	0.6255	0.63	0.621	0.6285	812000.0
2002-01-22 18:00:00	AMZN	Stock	0.6275	0.632	0.625	0.63	302000.0
2002-01-22 09:00:00	CL	Stock	28.4	28.4	28.125	28.215	382600.0
2002-01-22 10:00:00	CL	Stock	28.21	28.25	28.12	28.175	301800.0
2002-01-22 11:00:00	CL	Stock	28.17	28.24	28.1	28.165	473800.0
2002-01-22 12:00:00	CL	Stock	28.14	28.195	28.1	28.19	171600.0
2002-01-22 13:00:00	CL	Stock	28.175	28.19	28.1	28.165	195600.0
2002-01-22 14:00:00	CL	Stock	28.16	28.325	28.125	28.245	255400.0

> showing 50 of 18,639 rows — these rows as CSV

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