PREVIEW / stock_1hour / 2002-04-02

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-04-02.parquet
  size:    397 KB
  rows:    18,679
  symbols: 1,395

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-04-02 08:00:00	AAPL	Stock	0.4252	0.4366	0.4229	0.4307	201600.0
2002-04-02 09:00:00	AAPL	Stock	0.4321	0.4339	0.4263	0.4307	21011200.0
2002-04-02 10:00:00	AAPL	Stock	0.4305	0.4334	0.4264	0.4282	46664800.0
2002-04-02 11:00:00	AAPL	Stock	0.4288	0.432	0.4286	0.4289	13792800.0
2002-04-02 12:00:00	AAPL	Stock	0.4289	0.4314	0.4288	0.4293	11877600.0
2002-04-02 13:00:00	AAPL	Stock	0.4293	0.4313	0.4273	0.4298	13848800.0
2002-04-02 14:00:00	AAPL	Stock	0.4298	0.4311	0.4282	0.4311	32676000.0
2002-04-02 15:00:00	AAPL	Stock	0.4311	0.4316	0.4279	0.43	43019200.0
2002-04-02 16:00:00	AAPL	Stock	0.43	0.4368	0.4268	0.4298	9889600.0
2002-04-02 17:00:00	AAPL	Stock	0.4298	0.4298	0.4298	0.4298	873600.0
2002-04-02 08:00:00	MSFT	Stock	29.65	30.1925	29.4	29.6735	657400.0
2002-04-02 09:00:00	MSFT	Stock	29.55	30.19	29.375	29.415	8363200.0
2002-04-02 10:00:00	MSFT	Stock	29.41	29.435	29.1	29.165	12170400.0
2002-04-02 11:00:00	MSFT	Stock	29.165	29.275	29.1	29.115	5405200.0
2002-04-02 12:00:00	MSFT	Stock	29.115	29.155	28.975	29.085	9035000.0
2002-04-02 13:00:00	MSFT	Stock	29.07	29.105	28.8	28.93	9390000.0
2002-04-02 14:00:00	MSFT	Stock	28.93	29.075	28.7755	28.815	9563400.0
2002-04-02 15:00:00	MSFT	Stock	28.8105	28.85	28.555	28.65	16389000.0
2002-04-02 16:00:00	MSFT	Stock	28.66	30.19	28.62	28.625	3188800.0
2002-04-02 17:00:00	MSFT	Stock	28.675	28.675	28.6	28.655	662400.0
2002-04-02 18:00:00	MSFT	Stock	28.67	28.67	28.625	28.665	4000.0
2002-04-02 08:00:00	NVDA	Stock	0.3604	0.3692	0.3558	0.3558	3708000.0
2002-04-02 09:00:00	NVDA	Stock	0.3558	0.3724	0.3522	0.3692	266592000.0
2002-04-02 10:00:00	NVDA	Stock	0.3688	0.3697	0.3612	0.3644	286332000.0
2002-04-02 11:00:00	NVDA	Stock	0.364	0.3648	0.36	0.3612	177336000.0
2002-04-02 12:00:00	NVDA	Stock	0.3612	0.3622	0.3557	0.3577	121848000.0
2002-04-02 13:00:00	NVDA	Stock	0.3577	0.3608	0.3528	0.3598	136752000.0
2002-04-02 14:00:00	NVDA	Stock	0.3598	0.3617	0.3554	0.3558	139848000.0
2002-04-02 15:00:00	NVDA	Stock	0.3561	0.3598	0.352	0.3542	226680000.0
2002-04-02 16:00:00	NVDA	Stock	0.3545	0.3636	0.3535	0.3536	23952000.0
2002-04-02 17:00:00	NVDA	Stock	0.3536	0.3541	0.3535	0.3541	768000.0
2002-04-02 18:00:00	NVDA	Stock	0.3537	0.3537	0.3533	0.3533	372000.0
2002-04-02 08:00:00	AMZN	Stock	0.731	0.731	0.731	0.731	6000.0
2002-04-02 09:00:00	AMZN	Stock	0.73	0.7545	0.729	0.7535	16640000.0
2002-04-02 10:00:00	AMZN	Stock	0.7535	0.754	0.733	0.734	22286000.0
2002-04-02 11:00:00	AMZN	Stock	0.733	0.7415	0.7305	0.731	7090000.0
2002-04-02 12:00:00	AMZN	Stock	0.731	0.7326	0.7135	0.719	12730000.0
2002-04-02 13:00:00	AMZN	Stock	0.719	0.7195	0.71	0.7185	7932000.0
2002-04-02 14:00:00	AMZN	Stock	0.718	0.721	0.715	0.7165	7270000.0
2002-04-02 15:00:00	AMZN	Stock	0.7166	0.717	0.7095	0.713	13502000.0
2002-04-02 16:00:00	AMZN	Stock	0.7125	0.74	0.7125	0.7145	2278000.0
2002-04-02 17:00:00	AMZN	Stock	0.7145	0.7145	0.7125	0.7125	212000.0
2002-04-02 09:00:00	CL	Stock	28.35	28.4	28.245	28.255	213800.0
2002-04-02 10:00:00	CL	Stock	28.25	28.315	28.175	28.25	218400.0
2002-04-02 11:00:00	CL	Stock	28.25	28.35	28.195	28.29	137000.0
2002-04-02 12:00:00	CL	Stock	28.285	28.455	28.255	28.38	171200.0
2002-04-02 13:00:00	CL	Stock	28.365	28.5	28.33	28.49	127800.0
2002-04-02 14:00:00	CL	Stock	28.495	28.51	28.39	28.47	265200.0
2002-04-02 15:00:00	CL	Stock	28.47	28.55	28.45	28.45	363800.0
2002-04-02 16:00:00	CL	Stock	28.445	28.48	28.37	28.42	537600.0

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

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