PREVIEW / stock_1hour / 2001-11-06

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-11-06.parquet
  size:    374 KB
  rows:    17,913
  symbols: 1,357

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-11-06 08:00:00	AAPL	Stock	0.3421	0.3427	0.3393	0.3393	274400.0
2001-11-06 09:00:00	AAPL	Stock	0.3393	0.3404	0.3348	0.3364	39289600.0
2001-11-06 10:00:00	AAPL	Stock	0.3363	0.3396	0.3355	0.338	53620000.0
2001-11-06 11:00:00	AAPL	Stock	0.3379	0.338	0.3329	0.3348	24813600.0
2001-11-06 12:00:00	AAPL	Stock	0.3341	0.3345	0.3309	0.3316	28448000.0
2001-11-06 13:00:00	AAPL	Stock	0.3316	0.3343	0.3314	0.3325	26101600.0
2001-11-06 14:00:00	AAPL	Stock	0.3325	0.3376	0.3313	0.3359	49632800.0
2001-11-06 15:00:00	AAPL	Stock	0.3361	0.3504	0.3345	0.3495	85853600.0
2001-11-06 16:00:00	AAPL	Stock	0.3489	0.3564	0.3377	0.3495	6697600.0
2001-11-06 17:00:00	AAPL	Stock	0.3516	0.3529	0.3495	0.3502	106400.0
2001-11-06 08:00:00	MSFT	Stock	31.495	31.635	31.335	31.375	366200.0
2001-11-06 09:00:00	MSFT	Stock	31.375	31.525	31.08	31.48	10336000.0
2001-11-06 10:00:00	MSFT	Stock	31.479	31.84	31.38	31.805	8017200.0
2001-11-06 11:00:00	MSFT	Stock	31.805	31.815	31.525	31.59	5243000.0
2001-11-06 12:00:00	MSFT	Stock	31.59	31.725	31.27	31.355	4873600.0
2001-11-06 13:00:00	MSFT	Stock	31.345	31.525	31.21	31.28	5583800.0
2001-11-06 14:00:00	MSFT	Stock	31.28	31.775	31.235	31.605	13200400.0
2001-11-06 15:00:00	MSFT	Stock	31.62	32.47	31.505	32.395	16763000.0
2001-11-06 16:00:00	MSFT	Stock	32.395	32.55	31.26	32.395	2787000.0
2001-11-06 17:00:00	MSFT	Stock	32.305	32.39	31.48	32.3	70800.0
2001-11-06 18:00:00	MSFT	Stock	32.25	32.3	32.18	32.3	9000.0
2001-11-06 08:00:00	NVDA	Stock	0.3965	0.398	0.3937	0.3937	672000.0
2001-11-06 09:00:00	NVDA	Stock	0.3939	0.4096	0.3917	0.4084	181332000.0
2001-11-06 10:00:00	NVDA	Stock	0.4084	0.4133	0.4056	0.4119	259872000.0
2001-11-06 11:00:00	NVDA	Stock	0.4119	0.412	0.4074	0.4097	88992000.0
2001-11-06 12:00:00	NVDA	Stock	0.4095	0.4125	0.4048	0.4076	86772000.0
2001-11-06 13:00:00	NVDA	Stock	0.4077	0.4108	0.4058	0.4081	84756000.0
2001-11-06 14:00:00	NVDA	Stock	0.4081	0.4165	0.4042	0.4068	254748000.0
2001-11-06 15:00:00	NVDA	Stock	0.4067	0.4234	0.4028	0.4212	421824000.0
2001-11-06 16:00:00	NVDA	Stock	0.4212	0.4258	0.393	0.4212	19728000.0
2001-11-06 17:00:00	NVDA	Stock	0.4209	0.4216	0.4092	0.4208	2772000.0
2001-11-06 18:00:00	NVDA	Stock	0.4212	0.4225	0.4208	0.4208	336000.0
2001-11-06 08:00:00	AMZN	Stock	0.3565	0.3575	0.3555	0.3555	144000.0
2001-11-06 09:00:00	AMZN	Stock	0.3545	0.3565	0.3465	0.353	15212000.0
2001-11-06 10:00:00	AMZN	Stock	0.3535	0.355	0.35	0.351	18474000.0
2001-11-06 11:00:00	AMZN	Stock	0.3505	0.353	0.3505	0.3515	9766000.0
2001-11-06 12:00:00	AMZN	Stock	0.3515	0.3535	0.35	0.3515	10844000.0
2001-11-06 13:00:00	AMZN	Stock	0.3505	0.3535	0.3455	0.346	7702000.0
2001-11-06 14:00:00	AMZN	Stock	0.3465	0.355	0.3455	0.3485	17544000.0
2001-11-06 15:00:00	AMZN	Stock	0.3495	0.355	0.348	0.353	22214000.0
2001-11-06 16:00:00	AMZN	Stock	0.3505	0.3545	0.349	0.3525	5814000.0
2001-11-06 17:00:00	AMZN	Stock	0.3525	0.354	0.3525	0.3535	112000.0
2001-11-06 18:00:00	AMZN	Stock	0.353	0.353	0.3505	0.3505	42000.0
2001-11-06 09:00:00	CL	Stock	29.175	29.175	29.055	29.11	195800.0
2001-11-06 10:00:00	CL	Stock	29.11	29.225	29.03	29.205	304800.0
2001-11-06 11:00:00	CL	Stock	29.19	29.35	29.19	29.335	202600.0
2001-11-06 12:00:00	CL	Stock	29.35	29.375	29.185	29.27	114600.0
2001-11-06 13:00:00	CL	Stock	29.3	29.35	29.11	29.125	219800.0
2001-11-06 14:00:00	CL	Stock	29.125	29.325	29.105	29.2	469400.0
2001-11-06 15:00:00	CL	Stock	29.2	29.495	29.12	29.47	529800.0

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

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