PREVIEW / stock_1hour / 2001-04-16

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-04-16.parquet
  size:    340 KB
  rows:    16,224
  symbols: 1,281

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-04-16 08:00:00	AAPL	Stock	0.4016	0.4016	0.3929	0.3929	156800.0
2001-04-16 09:00:00	AAPL	Stock	0.3936	0.4009	0.3925	0.3939	44335200.0
2001-04-16 10:00:00	AAPL	Stock	0.3938	0.3939	0.3788	0.3845	47644800.0
2001-04-16 11:00:00	AAPL	Stock	0.3845	0.3932	0.3811	0.3916	31830400.0
2001-04-16 12:00:00	AAPL	Stock	0.3916	0.3968	0.3893	0.3902	16867200.0
2001-04-16 13:00:00	AAPL	Stock	0.3907	0.3966	0.3902	0.3961	25474400.0
2001-04-16 14:00:00	AAPL	Stock	0.3961	0.3963	0.3796	0.3816	33286400.0
2001-04-16 15:00:00	AAPL	Stock	0.3816	0.3827	0.375	0.3827	59455200.0
2001-04-16 16:00:00	AAPL	Stock	0.383	0.3866	0.3795	0.3821	12432000.0
2001-04-16 17:00:00	AAPL	Stock	0.3786	0.3821	0.3786	0.3795	134400.0
2001-04-16 18:00:00	AAPL	Stock	0.3784	0.3784	0.3782	0.3782	28000.0
2001-04-16 08:00:00	MSFT	Stock	30.905	31.09	30.51	30.75	142600.0
2001-04-16 09:00:00	MSFT	Stock	30.75	30.825	30.48	30.59	10546800.0
2001-04-16 10:00:00	MSFT	Stock	30.595	30.625	30.325	30.425	11868600.0
2001-04-16 11:00:00	MSFT	Stock	30.42	30.565	30.31	30.51	6309000.0
2001-04-16 12:00:00	MSFT	Stock	30.515	30.65	30.14	30.25	5599000.0
2001-04-16 13:00:00	MSFT	Stock	30.255	30.605	30.205	30.585	5075200.0
2001-04-16 14:00:00	MSFT	Stock	30.59	30.61	30.185	30.31	6443200.0
2001-04-16 15:00:00	MSFT	Stock	30.315	30.405	30.06	30.39	10284800.0
2001-04-16 16:00:00	MSFT	Stock	30.39	30.645	29.75	30.1	5598200.0
2001-04-16 17:00:00	MSFT	Stock	30.12	30.2	30.12	30.2	25200.0
2001-04-16 18:00:00	MSFT	Stock	30.125	30.15	30.125	30.15	5600.0
2001-04-16 08:00:00	NVDA	Stock	0.29	0.2917	0.2844	0.2877	1080000.0
2001-04-16 09:00:00	NVDA	Stock	0.2877	0.2896	0.2833	0.2863	101544000.0
2001-04-16 10:00:00	NVDA	Stock	0.2863	0.2888	0.2803	0.2875	150312000.0
2001-04-16 11:00:00	NVDA	Stock	0.288	0.2935	0.2871	0.2898	108720000.0
2001-04-16 12:00:00	NVDA	Stock	0.2895	0.2925	0.2883	0.2894	57072000.0
2001-04-16 13:00:00	NVDA	Stock	0.2894	0.2919	0.2881	0.2919	39624000.0
2001-04-16 14:00:00	NVDA	Stock	0.2919	0.2921	0.2815	0.2824	114336000.0
2001-04-16 15:00:00	NVDA	Stock	0.2833	0.2865	0.2805	0.2856	139008000.0
2001-04-16 16:00:00	NVDA	Stock	0.2855	0.2857	0.2792	0.2812	9696000.0
2001-04-16 17:00:00	NVDA	Stock	0.2809	0.2833	0.2809	0.2833	528000.0
2001-04-16 08:00:00	AMZN	Stock	0.74	0.7405	0.7125	0.715	180000.0
2001-04-16 09:00:00	AMZN	Stock	0.7175	0.7255	0.685	0.6895	23670000.0
2001-04-16 10:00:00	AMZN	Stock	0.689	0.7155	0.6825	0.715	28262000.0
2001-04-16 11:00:00	AMZN	Stock	0.7145	0.72	0.6925	0.7035	14102000.0
2001-04-16 12:00:00	AMZN	Stock	0.704	0.72	0.701	0.705	7966000.0
2001-04-16 13:00:00	AMZN	Stock	0.705	0.725	0.7025	0.7225	8060000.0
2001-04-16 14:00:00	AMZN	Stock	0.723	0.727	0.7015	0.7065	14770000.0
2001-04-16 15:00:00	AMZN	Stock	0.706	0.707	0.6925	0.701	15746000.0
2001-04-16 16:00:00	AMZN	Stock	0.7015	0.7125	0.69	0.6925	3792000.0
2001-04-16 17:00:00	AMZN	Stock	0.691	0.694	0.6765	0.6765	298000.0
2001-04-16 18:00:00	AMZN	Stock	0.6875	0.6875	0.6875	0.6875	12000.0
2001-04-16 09:00:00	CL	Stock	26.75	26.925	26.65	26.89	361600.0
2001-04-16 10:00:00	CL	Stock	26.89	26.98	26.68	26.935	455800.0
2001-04-16 11:00:00	CL	Stock	26.95	26.95	26.55	26.6	275400.0
2001-04-16 12:00:00	CL	Stock	26.575	26.65	26.51	26.51	250600.0
2001-04-16 13:00:00	CL	Stock	26.505	26.58	26.505	26.545	113600.0
2001-04-16 14:00:00	CL	Stock	26.545	26.65	26.51	26.51	203800.0
2001-04-16 15:00:00	CL	Stock	26.51	26.645	26.45	26.625	495400.0

> showing 50 of 16,224 rows — these rows as CSV

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