PREVIEW / stock_1hour / 2001-05-31

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-05-31.parquet
  size:    374 KB
  rows:    17,742
  symbols: 1,300

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-05-31 08:00:00	AAPL	Stock	0.3536	0.3554	0.3527	0.3527	1024800.0
2001-05-31 09:00:00	AAPL	Stock	0.3532	0.3584	0.348	0.3564	70050400.0
2001-05-31 10:00:00	AAPL	Stock	0.3563	0.3591	0.3527	0.3548	67250400.0
2001-05-31 11:00:00	AAPL	Stock	0.3541	0.3591	0.3541	0.3571	48865600.0
2001-05-31 12:00:00	AAPL	Stock	0.3571	0.3586	0.3536	0.358	19600000.0
2001-05-31 13:00:00	AAPL	Stock	0.358	0.3598	0.357	0.3571	97983200.0
2001-05-31 14:00:00	AAPL	Stock	0.3571	0.3614	0.357	0.36	33516000.0
2001-05-31 15:00:00	AAPL	Stock	0.3598	0.3611	0.3554	0.3564	62602400.0
2001-05-31 16:00:00	AAPL	Stock	0.3563	0.3607	0.3555	0.3563	19045600.0
2001-05-31 17:00:00	AAPL	Stock	0.3589	0.3589	0.3563	0.3563	856800.0
2001-05-31 18:00:00	AAPL	Stock	0.3582	0.3582	0.3582	0.3582	11200.0
2001-05-31 08:00:00	MSFT	Stock	34.675	34.825	34.6	34.65	193400.0
2001-05-31 09:00:00	MSFT	Stock	34.65	34.92	34.43	34.62	9520200.0
2001-05-31 10:00:00	MSFT	Stock	34.62	34.665	34.2	34.32	15038200.0
2001-05-31 11:00:00	MSFT	Stock	34.32	34.73	34.25	34.665	8003200.0
2001-05-31 12:00:00	MSFT	Stock	34.665	34.98	34.525	34.88	5577800.0
2001-05-31 13:00:00	MSFT	Stock	34.885	35.15	34.755	35.03	7604000.0
2001-05-31 14:00:00	MSFT	Stock	35.03	35.19	34.88	35.035	8423400.0
2001-05-31 15:00:00	MSFT	Stock	35.035	35.045	34.555	34.585	9536400.0
2001-05-31 16:00:00	MSFT	Stock	34.57	35.07	34.3	34.59	3406200.0
2001-05-31 17:00:00	MSFT	Stock	34.85	34.85	34.55	34.61	317000.0
2001-05-31 18:00:00	MSFT	Stock	34.625	34.625	34.555	34.555	4600.0
2001-05-31 08:00:00	NVDA	Stock	0.3595	0.3666	0.3595	0.36	9432000.0
2001-05-31 09:00:00	NVDA	Stock	0.3606	0.3644	0.3541	0.3563	239016000.0
2001-05-31 10:00:00	NVDA	Stock	0.3563	0.3588	0.3513	0.3527	305496000.0
2001-05-31 11:00:00	NVDA	Stock	0.3531	0.3571	0.349	0.3552	140808000.0
2001-05-31 12:00:00	NVDA	Stock	0.3552	0.3577	0.3526	0.3552	82488000.0
2001-05-31 13:00:00	NVDA	Stock	0.3552	0.3643	0.3548	0.3608	124992000.0
2001-05-31 14:00:00	NVDA	Stock	0.3605	0.3646	0.3594	0.3597	116568000.0
2001-05-31 15:00:00	NVDA	Stock	0.3596	0.3632	0.3563	0.3563	191448000.0
2001-05-31 16:00:00	NVDA	Stock	0.3563	0.3597	0.3561	0.3567	20928000.0
2001-05-31 17:00:00	NVDA	Stock	0.3567	0.3569	0.349	0.3569	384000.0
2001-05-31 18:00:00	NVDA	Stock	0.3569	0.3569	0.3563	0.3563	96000.0
2001-05-31 08:00:00	AMZN	Stock	0.785	0.785	0.785	0.785	10000.0
2001-05-31 09:00:00	AMZN	Stock	0.787	0.808	0.787	0.806	21208000.0
2001-05-31 10:00:00	AMZN	Stock	0.8055	0.8335	0.8035	0.8225	35412000.0
2001-05-31 11:00:00	AMZN	Stock	0.8225	0.8375	0.821	0.8335	21742000.0
2001-05-31 12:00:00	AMZN	Stock	0.8305	0.845	0.8265	0.841	10518000.0
2001-05-31 13:00:00	AMZN	Stock	0.8405	0.855	0.8365	0.8455	28088000.0
2001-05-31 14:00:00	AMZN	Stock	0.8455	0.8525	0.8405	0.8495	20462000.0
2001-05-31 15:00:00	AMZN	Stock	0.85	0.86	0.8325	0.8375	26382000.0
2001-05-31 16:00:00	AMZN	Stock	0.834	0.8485	0.8285	0.83	4278000.0
2001-05-31 17:00:00	AMZN	Stock	0.8285	0.8345	0.828	0.828	15926000.0
2001-05-31 18:00:00	AMZN	Stock	0.8485	0.8495	0.8485	0.8485	48000.0
2001-05-31 09:00:00	CL	Stock	28.625	28.71	28.405	28.545	329200.0
2001-05-31 10:00:00	CL	Stock	28.545	28.65	28.375	28.535	548200.0
2001-05-31 11:00:00	CL	Stock	28.54	28.64	28.45	28.515	350400.0
2001-05-31 12:00:00	CL	Stock	28.475	28.55	28.26	28.51	456400.0
2001-05-31 13:00:00	CL	Stock	28.51	28.51	28.34	28.375	298200.0
2001-05-31 14:00:00	CL	Stock	28.375	28.4	28.22	28.32	407200.0

> showing 50 of 17,742 rows — these rows as CSV

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