PREVIEW / stock_1hour / 2003-11-03

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-11-03.parquet
  size:    515 KB
  rows:    23,062
  symbols: 1,661

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
2003-11-03 09:00:00	AAPL	Stock	0.4088	0.413	0.4068	0.413	18684792.0
2003-11-03 10:00:00	AAPL	Stock	0.413	0.4161	0.413	0.4148	24058496.0
2003-11-03 11:00:00	AAPL	Stock	0.4148	0.4161	0.4121	0.4121	10236856.0
2003-11-03 12:00:00	AAPL	Stock	0.4125	0.4125	0.4095	0.4107	57807792.0
2003-11-03 13:00:00	AAPL	Stock	0.4107	0.4141	0.4104	0.413	40572448.0
2003-11-03 14:00:00	AAPL	Stock	0.413	0.413	0.4095	0.4123	54316304.0
2003-11-03 15:00:00	AAPL	Stock	0.4121	0.4152	0.4105	0.4152	47054672.0
2003-11-03 16:00:00	AAPL	Stock	0.4152	0.4159	0.4104	0.4155	10536568.0
2003-11-03 17:00:00	AAPL	Stock	0.4154	0.4155	0.4131	0.4154	4472048.0
2003-11-03 08:00:00	MSFT	Stock	26.33	26.44	26.15	26.34	232040.0
2003-11-03 09:00:00	MSFT	Stock	26.34	26.46	26.15	26.44	7014056.0
2003-11-03 10:00:00	MSFT	Stock	26.44	26.64	26.43	26.57	11073656.0
2003-11-03 11:00:00	MSFT	Stock	26.57	26.67	26.57	26.63	6101382.0
2003-11-03 12:00:00	MSFT	Stock	26.631	26.7	26.6	26.68	5219378.0
2003-11-03 13:00:00	MSFT	Stock	26.68	26.711	26.58	26.63	5269321.0
2003-11-03 14:00:00	MSFT	Stock	26.64	26.66	26.53	26.65	5272237.0
2003-11-03 15:00:00	MSFT	Stock	26.64	26.72	26.61	26.7	11377884.0
2003-11-03 16:00:00	MSFT	Stock	26.65	26.7	26.54	26.6	966604.0
2003-11-03 17:00:00	MSFT	Stock	26.68	26.719	26.57	26.59	177815.0
2003-11-03 18:00:00	MSFT	Stock	26.59	26.59	26.541	26.58	10077.0
2003-11-03 08:00:00	NVDA	Stock	0.1494	0.1575	0.1492	0.1494	3429600.0
2003-11-03 09:00:00	NVDA	Stock	0.1494	0.1504	0.1442	0.1496	133000200.0
2003-11-03 10:00:00	NVDA	Stock	0.1496	0.1528	0.1494	0.1522	182787120.0
2003-11-03 11:00:00	NVDA	Stock	0.1521	0.1529	0.1517	0.1526	52094040.0
2003-11-03 12:00:00	NVDA	Stock	0.1525	0.1527	0.1517	0.1521	79570920.0
2003-11-03 13:00:00	NVDA	Stock	0.1521	0.1528	0.1505	0.1511	60397320.0
2003-11-03 14:00:00	NVDA	Stock	0.151	0.1518	0.1505	0.1515	47898000.0
2003-11-03 15:00:00	NVDA	Stock	0.1515	0.1522	0.1492	0.1501	115044720.0
2003-11-03 16:00:00	NVDA	Stock	0.1501	0.1512	0.1471	0.1492	16430400.0
2003-11-03 17:00:00	NVDA	Stock	0.1492	0.151	0.1492	0.1506	3433320.0
2003-11-03 18:00:00	NVDA	Stock	0.1512	0.1512	0.1512	0.1512	24000.0
2003-11-03 08:00:00	AMZN	Stock	2.75	2.75	2.744	2.745	230200.0
2003-11-03 09:00:00	AMZN	Stock	2.746	2.7645	2.7155	2.7625	26348400.0
2003-11-03 10:00:00	AMZN	Stock	2.7625	2.787	2.7525	2.7605	32040980.0
2003-11-03 11:00:00	AMZN	Stock	2.7615	2.7775	2.7605	2.7725	14266540.0
2003-11-03 12:00:00	AMZN	Stock	2.7715	2.7775	2.763	2.774	10449940.0
2003-11-03 13:00:00	AMZN	Stock	2.7735	2.807	2.7735	2.8	24323200.0
2003-11-03 14:00:00	AMZN	Stock	2.8	2.8105	2.796	2.81	15930620.0
2003-11-03 15:00:00	AMZN	Stock	2.8105	2.8395	2.8095	2.8375	40824040.0
2003-11-03 16:00:00	AMZN	Stock	2.837	2.845	2.8224	2.8375	1258020.0
2003-11-03 17:00:00	AMZN	Stock	2.8375	2.8425	2.8372	2.8425	623980.0
2003-11-03 18:00:00	AMZN	Stock	2.8425	2.8465	2.84	2.8444	194600.0
2003-11-03 09:00:00	CL	Stock	26.625	26.72	26.605	26.675	563780.0
2003-11-03 10:00:00	CL	Stock	26.67	26.865	26.655	26.77	754862.0
2003-11-03 11:00:00	CL	Stock	26.765	26.795	26.71	26.755	388414.0
2003-11-03 12:00:00	CL	Stock	26.76	26.865	26.715	26.715	439454.0
2003-11-03 13:00:00	CL	Stock	26.715	26.77	26.65	26.75	415840.0
2003-11-03 14:00:00	CL	Stock	26.755	26.755	26.6	26.62	485462.0
2003-11-03 15:00:00	CL	Stock	26.625	26.63	26.545	26.59	955418.0
2003-11-03 16:00:00	CL	Stock	26.585	26.585	26.575	26.58	85000.0

> showing 50 of 23,062 rows — these rows as CSV

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