PREVIEW / stock_1hour / 2002-01-25

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-01-25.parquet
  size:    380 KB
  rows:    18,036
  symbols: 1,335

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-25 08:00:00	AAPL	Stock	0.4098	0.4098	0.4098	0.4098	56000.0
2002-01-25 09:00:00	AAPL	Stock	0.4098	0.4111	0.4046	0.4073	24875200.0
2002-01-25 10:00:00	AAPL	Stock	0.4077	0.415	0.4071	0.4148	27361600.0
2002-01-25 11:00:00	AAPL	Stock	0.4148	0.4152	0.4084	0.4096	15758400.0
2002-01-25 12:00:00	AAPL	Stock	0.4093	0.4173	0.4093	0.4159	22148000.0
2002-01-25 13:00:00	AAPL	Stock	0.4159	0.4173	0.4113	0.4134	22310400.0
2002-01-25 14:00:00	AAPL	Stock	0.4134	0.415	0.4125	0.4137	14980000.0
2002-01-25 15:00:00	AAPL	Stock	0.4138	0.4182	0.4102	0.4161	38511200.0
2002-01-25 16:00:00	AAPL	Stock	0.4152	0.4161	0.4138	0.4152	10231200.0
2002-01-25 17:00:00	AAPL	Stock	0.4152	0.4152	0.4152	0.4152	504000.0
2002-01-25 08:00:00	MSFT	Stock	32.3	32.35	32.075	32.075	65800.0
2002-01-25 09:00:00	MSFT	Stock	32.075	32.425	32.0	32.37	6025200.0
2002-01-25 10:00:00	MSFT	Stock	32.37	32.42	31.955	32.03	10771600.0
2002-01-25 11:00:00	MSFT	Stock	32.0335	32.095	31.78	31.8	6680400.0
2002-01-25 12:00:00	MSFT	Stock	31.8	32.205	31.755	32.165	6595000.0
2002-01-25 13:00:00	MSFT	Stock	32.1645	32.325	32.055	32.135	5017800.0
2002-01-25 14:00:00	MSFT	Stock	32.125	32.195	31.975	32.035	3890200.0
2002-01-25 15:00:00	MSFT	Stock	32.035	32.08	31.8295	31.885	7324000.0
2002-01-25 16:00:00	MSFT	Stock	31.885	32.1775	31.86	31.9	970000.0
2002-01-25 17:00:00	MSFT	Stock	31.9	32.28	31.875	31.955	75800.0
2002-01-25 18:00:00	MSFT	Stock	31.945	31.945	31.905	31.905	400.0
2002-01-25 08:00:00	NVDA	Stock	0.5461	0.5461	0.5417	0.5422	588000.0
2002-01-25 09:00:00	NVDA	Stock	0.5417	0.5467	0.5325	0.5432	127188000.0
2002-01-25 10:00:00	NVDA	Stock	0.5431	0.5496	0.5423	0.5448	109740000.0
2002-01-25 11:00:00	NVDA	Stock	0.5446	0.5471	0.5423	0.5431	45996000.0
2002-01-25 12:00:00	NVDA	Stock	0.543	0.5579	0.5422	0.5572	103464000.0
2002-01-25 13:00:00	NVDA	Stock	0.5577	0.5592	0.5504	0.5514	115596000.0
2002-01-25 14:00:00	NVDA	Stock	0.5515	0.554	0.5456	0.55	99756000.0
2002-01-25 15:00:00	NVDA	Stock	0.55	0.5515	0.5449	0.5456	132816000.0
2002-01-25 16:00:00	NVDA	Stock	0.5471	0.5507	0.535	0.535	65664000.0
2002-01-25 17:00:00	NVDA	Stock	0.5471	0.5575	0.5456	0.5467	660000.0
2002-01-25 18:00:00	NVDA	Stock	0.5471	0.5492	0.5471	0.5492	48000.0
2002-01-25 08:00:00	AMZN	Stock	0.68	0.6905	0.6775	0.682	374000.0
2002-01-25 09:00:00	AMZN	Stock	0.6835	0.6945	0.6695	0.6765	60320000.0
2002-01-25 10:00:00	AMZN	Stock	0.677	0.7465	0.675	0.7285	119566000.0
2002-01-25 11:00:00	AMZN	Stock	0.7275	0.753	0.7235	0.7425	145094000.0
2002-01-25 12:00:00	AMZN	Stock	0.743	0.7625	0.739	0.76	74560000.0
2002-01-25 13:00:00	AMZN	Stock	0.7595	0.7695	0.7525	0.758	68512000.0
2002-01-25 14:00:00	AMZN	Stock	0.7575	0.7585	0.746	0.751	51346000.0
2002-01-25 15:00:00	AMZN	Stock	0.751	0.7515	0.7205	0.723	58972000.0
2002-01-25 16:00:00	AMZN	Stock	0.723	0.7383	0.718	0.722	2822000.0
2002-01-25 17:00:00	AMZN	Stock	0.7215	0.7605	0.7215	0.726	498000.0
2002-01-25 18:00:00	AMZN	Stock	0.726	0.7265	0.725	0.7265	150000.0
2002-01-25 09:00:00	CL	Stock	27.975	28.0	27.85	27.965	234200.0
2002-01-25 10:00:00	CL	Stock	27.985	28.225	27.97	28.225	512600.0
2002-01-25 11:00:00	CL	Stock	28.22	28.23	28.1	28.16	208200.0
2002-01-25 12:00:00	CL	Stock	28.16	28.225	28.15	28.2	336400.0
2002-01-25 13:00:00	CL	Stock	28.2	28.4	28.2	28.395	210800.0
2002-01-25 14:00:00	CL	Stock	28.39	28.39	28.16	28.165	290000.0
2002-01-25 15:00:00	CL	Stock	28.165	28.24	28.075	28.2	690600.0

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

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