PREVIEW / stock_1hour / 2001-08-14

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-08-14.parquet
  size:    357 KB
  rows:    17,047
  symbols: 1,327

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-08-14 08:00:00	AAPL	Stock	0.3432	0.3464	0.3427	0.3461	515200.0
2001-08-14 09:00:00	AAPL	Stock	0.3461	0.3466	0.3423	0.3439	23917600.0
2001-08-14 10:00:00	AAPL	Stock	0.3439	0.3446	0.3375	0.3398	35879200.0
2001-08-14 11:00:00	AAPL	Stock	0.3398	0.3404	0.3339	0.3352	55076000.0
2001-08-14 12:00:00	AAPL	Stock	0.3357	0.3393	0.3334	0.3379	23716000.0
2001-08-14 13:00:00	AAPL	Stock	0.3375	0.3386	0.3354	0.3363	17701600.0
2001-08-14 14:00:00	AAPL	Stock	0.3368	0.3384	0.335	0.3355	16738400.0
2001-08-14 15:00:00	AAPL	Stock	0.3361	0.3377	0.3341	0.3346	43590400.0
2001-08-14 16:00:00	AAPL	Stock	0.3348	0.343	0.3341	0.3341	5936000.0
2001-08-14 08:00:00	MSFT	Stock	32.91	33.025	32.77	32.775	334200.0
2001-08-14 09:00:00	MSFT	Stock	32.95	33.045	32.68	32.835	5691000.0
2001-08-14 10:00:00	MSFT	Stock	32.83	33.01	32.605	32.745	6653800.0
2001-08-14 11:00:00	MSFT	Stock	32.735	32.79	32.59	32.62	4342000.0
2001-08-14 12:00:00	MSFT	Stock	32.62	32.705	32.6	32.635	2525000.0
2001-08-14 13:00:00	MSFT	Stock	32.635	32.645	32.26	32.365	5386600.0
2001-08-14 14:00:00	MSFT	Stock	32.36	32.59	32.3	32.385	3162800.0
2001-08-14 15:00:00	MSFT	Stock	32.385	32.435	32.225	32.345	5213000.0
2001-08-14 16:00:00	MSFT	Stock	32.34	33.0	32.285	32.495	1501600.0
2001-08-14 17:00:00	MSFT	Stock	32.375	32.49	32.375	32.48	12800.0
2001-08-14 08:00:00	NVDA	Stock	0.3678	0.3678	0.3575	0.3575	20784000.0
2001-08-14 09:00:00	NVDA	Stock	0.3575	0.3613	0.3532	0.358	565680000.0
2001-08-14 10:00:00	NVDA	Stock	0.358	0.3598	0.356	0.3574	457704000.0
2001-08-14 11:00:00	NVDA	Stock	0.3573	0.3631	0.3547	0.3585	380472000.0
2001-08-14 12:00:00	NVDA	Stock	0.3585	0.3625	0.3573	0.3609	148344000.0
2001-08-14 13:00:00	NVDA	Stock	0.3609	0.3619	0.3578	0.3599	136056000.0
2001-08-14 14:00:00	NVDA	Stock	0.36	0.3628	0.358	0.3611	101136000.0
2001-08-14 15:00:00	NVDA	Stock	0.3614	0.3621	0.3542	0.3575	345288000.0
2001-08-14 16:00:00	NVDA	Stock	0.3577	0.3667	0.3466	0.3575	99264000.0
2001-08-14 17:00:00	NVDA	Stock	0.3575	0.3703	0.3573	0.3687	41712000.0
2001-08-14 18:00:00	NVDA	Stock	0.369	0.3692	0.3648	0.3666	9480000.0
2001-08-14 08:00:00	AMZN	Stock	0.5175	0.52	0.5165	0.52	42000.0
2001-08-14 09:00:00	AMZN	Stock	0.5145	0.524	0.5125	0.5235	13732000.0
2001-08-14 10:00:00	AMZN	Stock	0.5225	0.5275	0.5205	0.5235	13304000.0
2001-08-14 11:00:00	AMZN	Stock	0.5235	0.535	0.522	0.5315	12066000.0
2001-08-14 12:00:00	AMZN	Stock	0.532	0.5465	0.5295	0.543	11276000.0
2001-08-14 13:00:00	AMZN	Stock	0.543	0.5485	0.537	0.545	10340000.0
2001-08-14 14:00:00	AMZN	Stock	0.544	0.552	0.544	0.546	14652000.0
2001-08-14 15:00:00	AMZN	Stock	0.546	0.546	0.524	0.526	14346000.0
2001-08-14 16:00:00	AMZN	Stock	0.526	0.5375	0.5255	0.5375	2032000.0
2001-08-14 17:00:00	AMZN	Stock	0.535	0.54	0.535	0.54	120000.0
2001-08-14 18:00:00	AMZN	Stock	0.535	0.5375	0.535	0.5375	28000.0
2001-08-14 09:00:00	CL	Stock	27.375	27.59	27.365	27.51	380600.0
2001-08-14 10:00:00	CL	Stock	27.525	27.575	27.145	27.225	469000.0
2001-08-14 11:00:00	CL	Stock	27.25	27.45	27.225	27.325	228600.0
2001-08-14 12:00:00	CL	Stock	27.325	27.36	27.225	27.225	162000.0
2001-08-14 13:00:00	CL	Stock	27.26	27.325	27.185	27.22	130600.0
2001-08-14 14:00:00	CL	Stock	27.26	27.325	27.215	27.23	273400.0
2001-08-14 15:00:00	CL	Stock	27.23	27.365	27.23	27.305	469200.0
2001-08-14 16:00:00	CL	Stock	27.305	27.305	27.3	27.305	28800.0

> showing 49 of 17,047 rows — these rows as CSV

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