PREVIEW / stock_1hour / 2001-05-09

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-05-09.parquet
  size:    351 KB
  rows:    16,798
  symbols: 1,291

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-09 08:00:00	AAPL	Stock	0.4321	0.4321	0.4321	0.4321	22400.0
2001-05-09 09:00:00	AAPL	Stock	0.4286	0.4343	0.4227	0.4282	55216000.0
2001-05-09 10:00:00	AAPL	Stock	0.4282	0.4384	0.425	0.4366	80623200.0
2001-05-09 11:00:00	AAPL	Stock	0.4359	0.4371	0.4307	0.4323	43971200.0
2001-05-09 12:00:00	AAPL	Stock	0.4323	0.4377	0.4305	0.4355	20871200.0
2001-05-09 13:00:00	AAPL	Stock	0.4361	0.4364	0.4321	0.4329	14263200.0
2001-05-09 14:00:00	AAPL	Stock	0.4334	0.4334	0.4298	0.4304	28946400.0
2001-05-09 15:00:00	AAPL	Stock	0.4304	0.4313	0.4268	0.4277	57069600.0
2001-05-09 16:00:00	AAPL	Stock	0.4273	0.4282	0.4243	0.4282	4648000.0
2001-05-09 17:00:00	AAPL	Stock	0.4282	0.4305	0.4259	0.4286	95200.0
2001-05-09 08:00:00	MSFT	Stock	35.55	36.025	35.4	35.625	103600.0
2001-05-09 09:00:00	MSFT	Stock	35.625	35.85	35.32	35.49	10736000.0
2001-05-09 10:00:00	MSFT	Stock	35.495	35.515	35.15	35.4	14016800.0
2001-05-09 11:00:00	MSFT	Stock	35.4	35.64	35.375	35.53	11364600.0
2001-05-09 12:00:00	MSFT	Stock	35.53	35.65	35.4	35.64	7283800.0
2001-05-09 13:00:00	MSFT	Stock	35.64	35.645	35.345	35.39	4841800.0
2001-05-09 14:00:00	MSFT	Stock	35.39	35.435	35.005	35.06	7226200.0
2001-05-09 15:00:00	MSFT	Stock	35.005	35.25	34.93	35.185	13980600.0
2001-05-09 16:00:00	MSFT	Stock	35.2	35.335	35.0	35.2	4427600.0
2001-05-09 17:00:00	MSFT	Stock	35.2	35.27	35.02	35.2	527600.0
2001-05-09 18:00:00	MSFT	Stock	35.2	35.2	35.2	35.2	400.0
2001-05-09 08:00:00	NVDA	Stock	0.35	0.3556	0.3458	0.3488	5232000.0
2001-05-09 09:00:00	NVDA	Stock	0.3488	0.357	0.3442	0.3489	344184000.0
2001-05-09 10:00:00	NVDA	Stock	0.3491	0.3516	0.3433	0.3496	221040000.0
2001-05-09 11:00:00	NVDA	Stock	0.3497	0.3576	0.3492	0.3528	193104000.0
2001-05-09 12:00:00	NVDA	Stock	0.3528	0.3556	0.3508	0.3518	125328000.0
2001-05-09 13:00:00	NVDA	Stock	0.3518	0.3538	0.3453	0.3463	106608000.0
2001-05-09 14:00:00	NVDA	Stock	0.346	0.3498	0.3448	0.3466	108480000.0
2001-05-09 15:00:00	NVDA	Stock	0.3471	0.3471	0.3441	0.3448	141504000.0
2001-05-09 16:00:00	NVDA	Stock	0.3447	0.3458	0.3438	0.3458	18744000.0
2001-05-09 17:00:00	NVDA	Stock	0.3442	0.3458	0.3442	0.3458	312000.0
2001-05-09 18:00:00	NVDA	Stock	0.3463	0.3463	0.3463	0.3463	72000.0
2001-05-09 08:00:00	AMZN	Stock	0.7735	0.788	0.7735	0.785	206000.0
2001-05-09 09:00:00	AMZN	Stock	0.785	0.788	0.7675	0.773	9446000.0
2001-05-09 10:00:00	AMZN	Stock	0.773	0.7745	0.7565	0.762	16316000.0
2001-05-09 11:00:00	AMZN	Stock	0.7625	0.7775	0.76	0.771	17440000.0
2001-05-09 12:00:00	AMZN	Stock	0.771	0.7755	0.766	0.774	13402000.0
2001-05-09 13:00:00	AMZN	Stock	0.7735	0.7765	0.7695	0.7755	3596000.0
2001-05-09 14:00:00	AMZN	Stock	0.7765	0.7765	0.7575	0.7575	10824000.0
2001-05-09 15:00:00	AMZN	Stock	0.757	0.7665	0.75	0.7505	14040000.0
2001-05-09 16:00:00	AMZN	Stock	0.7505	0.7645	0.75	0.7505	3874000.0
2001-05-09 17:00:00	AMZN	Stock	0.7505	0.755	0.7505	0.754	16000.0
2001-05-09 18:00:00	AMZN	Stock	0.7525	0.754	0.7525	0.754	14000.0
2001-05-09 09:00:00	CL	Stock	28.75	28.85	28.45	28.475	233800.0
2001-05-09 10:00:00	CL	Stock	28.475	28.865	28.475	28.695	377000.0
2001-05-09 11:00:00	CL	Stock	28.69	28.925	28.565	28.825	300800.0
2001-05-09 12:00:00	CL	Stock	28.8	28.875	28.7	28.815	213400.0
2001-05-09 13:00:00	CL	Stock	28.815	28.825	28.7	28.8	121800.0
2001-05-09 14:00:00	CL	Stock	28.77	28.825	28.75	28.77	196000.0
2001-05-09 15:00:00	CL	Stock	28.765	28.825	28.67	28.705	302400.0

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

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