PREVIEW / stock_1hour / 2001-12-20

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-12-20.parquet
  size:    391 KB
  rows:    18,791
  symbols: 1,371

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-12-20 08:00:00	AAPL	Stock	0.383	0.383	0.3813	0.3813	78400.0
2001-12-20 09:00:00	AAPL	Stock	0.3821	0.3823	0.3645	0.3793	18827200.0
2001-12-20 10:00:00	AAPL	Stock	0.3796	0.3834	0.3682	0.3693	38623200.0
2001-12-20 11:00:00	AAPL	Stock	0.3693	0.3748	0.3689	0.3743	41260800.0
2001-12-20 12:00:00	AAPL	Stock	0.3746	0.3761	0.3696	0.3718	24180800.0
2001-12-20 13:00:00	AAPL	Stock	0.3718	0.3764	0.3709	0.372	18155200.0
2001-12-20 14:00:00	AAPL	Stock	0.3716	0.3768	0.3714	0.3743	23984800.0
2001-12-20 15:00:00	AAPL	Stock	0.3743	0.3755	0.3691	0.3691	40084800.0
2001-12-20 16:00:00	AAPL	Stock	0.3698	0.3705	0.3684	0.3684	8019200.0
2001-12-20 08:00:00	MSFT	Stock	34.75	34.7525	33.5	34.75	104000.0
2001-12-20 09:00:00	MSFT	Stock	34.5	34.75	34.44	34.5255	5233400.0
2001-12-20 10:00:00	MSFT	Stock	34.505	34.605	34.315	34.365	9169600.0
2001-12-20 11:00:00	MSFT	Stock	34.3745	34.4145	34.19	34.35	6509800.0
2001-12-20 12:00:00	MSFT	Stock	34.35	34.3805	34.025	34.08	5817000.0
2001-12-20 13:00:00	MSFT	Stock	34.08	34.1595	33.5355	33.5355	9121200.0
2001-12-20 14:00:00	MSFT	Stock	33.555	33.91	33.313	33.5755	21495000.0
2001-12-20 15:00:00	MSFT	Stock	33.585	33.655	33.3745	33.385	14941400.0
2001-12-20 16:00:00	MSFT	Stock	33.38	33.975	33.359	33.359	3850800.0
2001-12-20 17:00:00	MSFT	Stock	33.4	34.49	33.4	34.49	7200.0
2001-12-20 18:00:00	MSFT	Stock	33.425	33.425	33.425	33.425	6600.0
2001-12-20 08:00:00	NVDA	Stock	0.545	0.545	0.5251	0.5342	1944000.0
2001-12-20 09:00:00	NVDA	Stock	0.535	0.5489	0.5337	0.5452	133020000.0
2001-12-20 10:00:00	NVDA	Stock	0.5452	0.5467	0.5317	0.5322	195696000.0
2001-12-20 11:00:00	NVDA	Stock	0.5328	0.5352	0.5267	0.5319	105360000.0
2001-12-20 12:00:00	NVDA	Stock	0.5322	0.5341	0.5229	0.5247	89160000.0
2001-12-20 13:00:00	NVDA	Stock	0.5242	0.5279	0.5212	0.5213	87228000.0
2001-12-20 14:00:00	NVDA	Stock	0.5212	0.5237	0.5139	0.5155	139836000.0
2001-12-20 15:00:00	NVDA	Stock	0.5155	0.5194	0.5143	0.5154	165744000.0
2001-12-20 16:00:00	NVDA	Stock	0.5158	0.5168	0.5126	0.5155	21792000.0
2001-12-20 17:00:00	NVDA	Stock	0.5296	0.5296	0.5163	0.5171	3228000.0
2001-12-20 18:00:00	NVDA	Stock	0.5175	0.5175	0.5158	0.5158	384000.0
2001-12-20 08:00:00	AMZN	Stock	0.5345	0.535	0.5255	0.5255	206000.0
2001-12-20 09:00:00	AMZN	Stock	0.534	0.5365	0.525	0.535	16218000.0
2001-12-20 10:00:00	AMZN	Stock	0.535	0.5416	0.514	0.515	26804000.0
2001-12-20 11:00:00	AMZN	Stock	0.5159	0.5206	0.5105	0.516	15004000.0
2001-12-20 12:00:00	AMZN	Stock	0.516	0.5185	0.5125	0.5175	11244000.0
2001-12-20 13:00:00	AMZN	Stock	0.517	0.53	0.516	0.5225	14220000.0
2001-12-20 14:00:00	AMZN	Stock	0.5225	0.5255	0.514	0.517	34248000.0
2001-12-20 15:00:00	AMZN	Stock	0.517	0.518	0.507	0.507	30674000.0
2001-12-20 16:00:00	AMZN	Stock	0.507	0.5194	0.505	0.506	2640000.0
2001-12-20 17:00:00	AMZN	Stock	0.506	0.5075	0.505	0.506	220000.0
2001-12-20 18:00:00	AMZN	Stock	0.505	0.505	0.505	0.505	20000.0
2001-12-20 09:00:00	CL	Stock	29.0	29.095	28.95	29.025	486200.0
2001-12-20 10:00:00	CL	Stock	29.04	29.07	28.975	29.07	333000.0
2001-12-20 11:00:00	CL	Stock	29.07	29.17	29.05	29.15	479200.0
2001-12-20 12:00:00	CL	Stock	29.155	29.23	29.15	29.15	216800.0
2001-12-20 13:00:00	CL	Stock	29.155	29.175	29.06	29.12	127800.0
2001-12-20 14:00:00	CL	Stock	29.12	29.29	29.075	29.175	525800.0
2001-12-20 15:00:00	CL	Stock	29.175	29.175	29.045	29.055	625400.0
2001-12-20 16:00:00	CL	Stock	29.055	29.12	29.055	29.095	131400.0

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

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