PREVIEW / stock_1hour / 2002-03-25

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-03-25.parquet
  size:    401 KB
  rows:    18,802
  symbols: 1,402

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-03-25 08:00:00	AAPL	Stock	0.4301	0.4302	0.4245	0.4285	319200.0
2002-03-25 09:00:00	AAPL	Stock	0.4285	0.4302	0.4268	0.4286	38455200.0
2002-03-25 10:00:00	AAPL	Stock	0.4293	0.4295	0.4198	0.4198	57209600.0
2002-03-25 11:00:00	AAPL	Stock	0.4198	0.4211	0.4175	0.4188	35162400.0
2002-03-25 12:00:00	AAPL	Stock	0.4188	0.4213	0.4166	0.4209	19840800.0
2002-03-25 13:00:00	AAPL	Stock	0.4207	0.4227	0.4161	0.4196	19600000.0
2002-03-25 14:00:00	AAPL	Stock	0.4193	0.4263	0.4191	0.4245	27020000.0
2002-03-25 15:00:00	AAPL	Stock	0.4239	0.4241	0.415	0.4168	37542400.0
2002-03-25 16:00:00	AAPL	Stock	0.4168	0.4208	0.4168	0.417	12728800.0
2002-03-25 17:00:00	AAPL	Stock	0.4171	0.4171	0.4162	0.4162	1568000.0
2002-03-25 18:00:00	AAPL	Stock	0.417	0.417	0.417	0.417	1366400.0
2002-03-25 08:00:00	MSFT	Stock	30.45	30.45	30.2225	30.285	44800.0
2002-03-25 09:00:00	MSFT	Stock	30.28	30.4	30.2	30.315	4156800.0
2002-03-25 10:00:00	MSFT	Stock	30.31	30.3805	29.96	30.015	6814800.0
2002-03-25 11:00:00	MSFT	Stock	30.015	30.085	29.875	29.99	5388600.0
2002-03-25 12:00:00	MSFT	Stock	29.99	30.05	29.85	29.895	7295000.0
2002-03-25 13:00:00	MSFT	Stock	29.9	30.03	29.83	29.925	3880800.0
2002-03-25 14:00:00	MSFT	Stock	29.93	30.085	29.85	29.94	5692800.0
2002-03-25 15:00:00	MSFT	Stock	29.94	29.9405	29.575	29.605	10316600.0
2002-03-25 16:00:00	MSFT	Stock	29.61	30.0328	29.565	29.63	2379000.0
2002-03-25 17:00:00	MSFT	Stock	29.625	29.645	29.6	29.645	24200.0
2002-03-25 18:00:00	MSFT	Stock	29.65	29.65	29.615	29.615	186800.0
2002-03-25 08:00:00	NVDA	Stock	0.4066	0.4081	0.4062	0.4062	504000.0
2002-03-25 09:00:00	NVDA	Stock	0.4062	0.4062	0.3958	0.3999	146652000.0
2002-03-25 10:00:00	NVDA	Stock	0.4	0.4021	0.3905	0.3921	182724000.0
2002-03-25 11:00:00	NVDA	Stock	0.3921	0.3943	0.3872	0.3915	111492000.0
2002-03-25 12:00:00	NVDA	Stock	0.3914	0.3921	0.3875	0.3881	88452000.0
2002-03-25 13:00:00	NVDA	Stock	0.388	0.3912	0.3879	0.3895	82920000.0
2002-03-25 14:00:00	NVDA	Stock	0.3894	0.3925	0.3892	0.39	76824000.0
2002-03-25 15:00:00	NVDA	Stock	0.39	0.3904	0.3833	0.384	161520000.0
2002-03-25 16:00:00	NVDA	Stock	0.384	0.3923	0.3837	0.3856	21348000.0
2002-03-25 17:00:00	NVDA	Stock	0.3854	0.3858	0.3838	0.3852	900000.0
2002-03-25 18:00:00	NVDA	Stock	0.3851	0.3854	0.3838	0.3854	1188000.0
2002-03-25 08:00:00	AMZN	Stock	0.7753	0.7795	0.7753	0.7795	36000.0
2002-03-25 09:00:00	AMZN	Stock	0.7735	0.7865	0.765	0.772	15528000.0
2002-03-25 10:00:00	AMZN	Stock	0.7725	0.775	0.749	0.749	18934000.0
2002-03-25 11:00:00	AMZN	Stock	0.75	0.756	0.7475	0.7505	8818000.0
2002-03-25 12:00:00	AMZN	Stock	0.751	0.7635	0.7475	0.7605	10308000.0
2002-03-25 13:00:00	AMZN	Stock	0.7609	0.7622	0.7485	0.7495	11506000.0
2002-03-25 14:00:00	AMZN	Stock	0.75	0.7545	0.7475	0.7505	9206000.0
2002-03-25 15:00:00	AMZN	Stock	0.7505	0.7505	0.736	0.736	19050000.0
2002-03-25 16:00:00	AMZN	Stock	0.7365	0.7624	0.735	0.735	6818000.0
2002-03-25 17:00:00	AMZN	Stock	0.7375	0.7375	0.7375	0.7375	78000.0
2002-03-25 18:00:00	AMZN	Stock	0.737	0.7375	0.735	0.7375	452000.0
2002-03-25 09:00:00	CL	Stock	28.35	28.355	28.125	28.15	265400.0
2002-03-25 10:00:00	CL	Stock	28.15	28.215	28.05	28.05	335800.0
2002-03-25 11:00:00	CL	Stock	28.05	28.155	28.05	28.08	179200.0
2002-03-25 12:00:00	CL	Stock	28.085	28.13	28.05	28.07	253800.0
2002-03-25 13:00:00	CL	Stock	28.07	28.2	28.06	28.18	236400.0
2002-03-25 14:00:00	CL	Stock	28.21	28.27	28.16	28.23	253200.0

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

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