PREVIEW / stock_1hour / 2001-06-21

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-06-21.parquet
  size:    369 KB
  rows:    17,563
  symbols: 1,318

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-06-21 08:00:00	AAPL	Stock	0.387	0.387	0.3848	0.3848	252000.0
2001-06-21 09:00:00	AAPL	Stock	0.3866	0.3929	0.3768	0.3852	34692000.0
2001-06-21 10:00:00	AAPL	Stock	0.3857	0.3945	0.3845	0.3893	47303200.0
2001-06-21 11:00:00	AAPL	Stock	0.3893	0.3998	0.3875	0.3989	26896800.0
2001-06-21 12:00:00	AAPL	Stock	0.3986	0.4013	0.3946	0.4011	24522400.0
2001-06-21 13:00:00	AAPL	Stock	0.4011	0.4107	0.3964	0.4088	67659200.0
2001-06-21 14:00:00	AAPL	Stock	0.4086	0.4098	0.3979	0.4038	41596800.0
2001-06-21 15:00:00	AAPL	Stock	0.4038	0.4091	0.3982	0.4016	59785600.0
2001-06-21 16:00:00	AAPL	Stock	0.4014	0.4089	0.397	0.4013	18608800.0
2001-06-21 17:00:00	AAPL	Stock	0.4016	0.4016	0.3989	0.4016	2576000.0
2001-06-21 08:00:00	MSFT	Stock	34.55	34.705	34.5	34.61	313600.0
2001-06-21 09:00:00	MSFT	Stock	34.61	34.955	34.495	34.85	9928400.0
2001-06-21 10:00:00	MSFT	Stock	34.84	35.0	34.55	34.625	11592000.0
2001-06-21 11:00:00	MSFT	Stock	34.615	34.85	34.48	34.84	5666400.0
2001-06-21 12:00:00	MSFT	Stock	34.84	34.99	34.785	34.985	6163200.0
2001-06-21 13:00:00	MSFT	Stock	34.99	35.13	34.825	35.125	6851000.0
2001-06-21 14:00:00	MSFT	Stock	35.115	35.135	34.91	35.075	5120400.0
2001-06-21 15:00:00	MSFT	Stock	35.07	35.275	34.9	34.92	13394400.0
2001-06-21 16:00:00	MSFT	Stock	34.925	35.135	34.225	34.57	6011000.0
2001-06-21 17:00:00	MSFT	Stock	34.92	34.955	34.525	34.92	1590200.0
2001-06-21 18:00:00	MSFT	Stock	34.575	34.92	34.575	34.675	22400.0
2001-06-21 08:00:00	NVDA	Stock	0.374	0.3758	0.374	0.375	264000.0
2001-06-21 09:00:00	NVDA	Stock	0.374	0.3808	0.3635	0.3683	191040000.0
2001-06-21 10:00:00	NVDA	Stock	0.3683	0.3763	0.366	0.372	277944000.0
2001-06-21 11:00:00	NVDA	Stock	0.3722	0.376	0.3673	0.3748	147912000.0
2001-06-21 12:00:00	NVDA	Stock	0.3748	0.3758	0.3679	0.3701	125544000.0
2001-06-21 13:00:00	NVDA	Stock	0.3704	0.3854	0.3667	0.3848	217104000.0
2001-06-21 14:00:00	NVDA	Stock	0.3848	0.3869	0.3767	0.3813	216696000.0
2001-06-21 15:00:00	NVDA	Stock	0.3813	0.3888	0.3756	0.3821	238368000.0
2001-06-21 16:00:00	NVDA	Stock	0.3821	0.3833	0.375	0.3821	12168000.0
2001-06-21 17:00:00	NVDA	Stock	0.3821	0.3822	0.3813	0.3821	2688000.0
2001-06-21 18:00:00	NVDA	Stock	0.3802	0.3802	0.3792	0.3792	744000.0
2001-06-21 08:00:00	AMZN	Stock	0.628	0.6345	0.6	0.63	164000.0
2001-06-21 09:00:00	AMZN	Stock	0.6325	0.65	0.625	0.637	21180000.0
2001-06-21 10:00:00	AMZN	Stock	0.6375	0.6475	0.63	0.642	30296000.0
2001-06-21 11:00:00	AMZN	Stock	0.6425	0.6465	0.635	0.645	26908000.0
2001-06-21 12:00:00	AMZN	Stock	0.6425	0.66	0.6425	0.653	23526000.0
2001-06-21 13:00:00	AMZN	Stock	0.6535	0.66	0.646	0.6545	37484000.0
2001-06-21 14:00:00	AMZN	Stock	0.654	0.66	0.6475	0.6535	19788000.0
2001-06-21 15:00:00	AMZN	Stock	0.654	0.6595	0.635	0.654	17698000.0
2001-06-21 16:00:00	AMZN	Stock	0.654	0.659	0.645	0.65	3138000.0
2001-06-21 17:00:00	AMZN	Stock	0.654	0.654	0.6375	0.654	392000.0
2001-06-21 18:00:00	AMZN	Stock	0.647	0.654	0.647	0.654	28000.0
2001-06-21 09:00:00	CL	Stock	29.7	29.7	29.495	29.515	500000.0
2001-06-21 10:00:00	CL	Stock	29.515	29.62	29.475	29.535	501400.0
2001-06-21 11:00:00	CL	Stock	29.535	29.575	29.425	29.525	335800.0
2001-06-21 12:00:00	CL	Stock	29.525	29.74	29.5	29.73	204400.0
2001-06-21 13:00:00	CL	Stock	29.73	30.0	29.73	29.995	623200.0
2001-06-21 14:00:00	CL	Stock	29.995	30.185	29.955	30.18	605600.0
2001-06-21 15:00:00	CL	Stock	30.18	30.25	30.05	30.25	1134200.0

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

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