PREVIEW / stock_1hour / 2003-09-18

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-09-18.parquet
  size:    462 KB
  rows:    21,953
  symbols: 1,608

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-09-18 09:00:00	AAPL	Stock	0.3946	0.397	0.392	0.3964	21432264.0
2003-09-18 10:00:00	AAPL	Stock	0.3963	0.4039	0.3954	0.4039	37400160.0
2003-09-18 11:00:00	AAPL	Stock	0.4039	0.4089	0.403	0.407	39429264.0
2003-09-18 12:00:00	AAPL	Stock	0.4071	0.4105	0.405	0.4105	33417496.0
2003-09-18 13:00:00	AAPL	Stock	0.4104	0.4105	0.4071	0.4091	26519752.0
2003-09-18 14:00:00	AAPL	Stock	0.4089	0.4099	0.4064	0.4071	21998592.0
2003-09-18 15:00:00	AAPL	Stock	0.4071	0.4102	0.4064	0.4086	43285536.0
2003-09-18 16:00:00	AAPL	Stock	0.4088	0.4095	0.4073	0.4086	761600.0
2003-09-18 08:00:00	MSFT	Stock	28.45	28.9	28.354	28.511	85489.0
2003-09-18 09:00:00	MSFT	Stock	28.588	28.64	28.43	28.62	4540374.0
2003-09-18 10:00:00	MSFT	Stock	28.62	28.81	28.589	28.78	7952371.0
2003-09-18 11:00:00	MSFT	Stock	28.79	29.1	28.76	29.04	12394996.0
2003-09-18 12:00:00	MSFT	Stock	29.06	29.2	28.94	29.15	7100864.0
2003-09-18 13:00:00	MSFT	Stock	29.16	29.28	29.09	29.2	5838718.0
2003-09-18 14:00:00	MSFT	Stock	29.21	29.43	29.19	29.38	8026251.0
2003-09-18 15:00:00	MSFT	Stock	29.38	29.51	29.35	29.48	12634201.0
2003-09-18 16:00:00	MSFT	Stock	29.49	29.5	29.44	29.46	1143224.0
2003-09-18 17:00:00	MSFT	Stock	29.49	29.49	28.9454	29.43	27355.0
2003-09-18 18:00:00	MSFT	Stock	29.45	29.47	29.45	29.47	700.0
2003-09-18 08:00:00	NVDA	Stock	0.1635	0.165	0.1635	0.1648	948000.0
2003-09-18 09:00:00	NVDA	Stock	0.1647	0.1654	0.1627	0.1652	70810920.0
2003-09-18 10:00:00	NVDA	Stock	0.1652	0.166	0.1634	0.1642	125730840.0
2003-09-18 11:00:00	NVDA	Stock	0.1642	0.1652	0.1634	0.165	49126200.0
2003-09-18 12:00:00	NVDA	Stock	0.165	0.1653	0.1641	0.1649	40450080.0
2003-09-18 13:00:00	NVDA	Stock	0.165	0.1653	0.1646	0.165	25933320.0
2003-09-18 14:00:00	NVDA	Stock	0.1649	0.1659	0.1646	0.1655	63757800.0
2003-09-18 15:00:00	NVDA	Stock	0.1655	0.1667	0.1651	0.1667	139034760.0
2003-09-18 16:00:00	NVDA	Stock	0.1667	0.1667	0.166	0.1667	37548000.0
2003-09-18 17:00:00	NVDA	Stock	0.1662	0.1667	0.1662	0.1667	684000.0
2003-09-18 18:00:00	NVDA	Stock	0.166	0.166	0.166	0.166	48000.0
2003-09-18 08:00:00	AMZN	Stock	2.303	2.312	2.3	2.305	151500.0
2003-09-18 09:00:00	AMZN	Stock	2.309	2.324	2.297	2.322	11234100.0
2003-09-18 10:00:00	AMZN	Stock	2.3235	2.3314	2.3145	2.324	21284340.0
2003-09-18 11:00:00	AMZN	Stock	2.324	2.3625	2.3215	2.3515	23834300.0
2003-09-18 12:00:00	AMZN	Stock	2.3508	2.372	2.3445	2.3685	23950100.0
2003-09-18 13:00:00	AMZN	Stock	2.3685	2.375	2.363	2.371	15133480.0
2003-09-18 14:00:00	AMZN	Stock	2.371	2.3775	2.356	2.374	16646720.0
2003-09-18 15:00:00	AMZN	Stock	2.3735	2.412	2.3735	2.396	49761040.0
2003-09-18 16:00:00	AMZN	Stock	2.3945	2.3965	2.3865	2.3955	1781500.0
2003-09-18 17:00:00	AMZN	Stock	2.395	2.4025	2.3945	2.4	424760.0
2003-09-18 18:00:00	AMZN	Stock	2.3995	2.3995	2.3965	2.3995	34000.0
2003-09-18 09:00:00	CL	Stock	27.525	27.61	27.5	27.57	363400.0
2003-09-18 10:00:00	CL	Stock	27.575	27.62	27.55	27.575	502200.0
2003-09-18 11:00:00	CL	Stock	27.575	27.61	27.53	27.55	361400.0
2003-09-18 12:00:00	CL	Stock	27.535	27.55	27.495	27.5	570200.0
2003-09-18 13:00:00	CL	Stock	27.495	27.5	27.35	27.375	744200.0
2003-09-18 14:00:00	CL	Stock	27.36	27.425	27.315	27.42	678400.0
2003-09-18 15:00:00	CL	Stock	27.42	27.47	27.4	27.425	1407800.0
2003-09-18 16:00:00	CL	Stock	27.425	27.45	27.425	27.425	351600.0

> showing 49 of 21,953 rows — these rows as CSV

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