PREVIEW / stock_1hour / 2002-01-16

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-01-16.parquet
  size:    390 KB
  rows:    18,589
  symbols: 1,352

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
2002-01-16 08:00:00	AAPL	Stock	0.3786	0.3875	0.375	0.3804	313600.0
2002-01-16 09:00:00	AAPL	Stock	0.3816	0.3839	0.3755	0.3757	63280000.0
2002-01-16 10:00:00	AAPL	Stock	0.3755	0.3794	0.3746	0.3757	64618400.0
2002-01-16 11:00:00	AAPL	Stock	0.3757	0.3764	0.3684	0.372	89544000.0
2002-01-16 12:00:00	AAPL	Stock	0.372	0.3761	0.3704	0.3746	43601600.0
2002-01-16 13:00:00	AAPL	Stock	0.3746	0.3782	0.3736	0.3746	39732000.0
2002-01-16 14:00:00	AAPL	Stock	0.3746	0.3761	0.3741	0.3757	30861600.0
2002-01-16 15:00:00	AAPL	Stock	0.375	0.3766	0.3661	0.3711	135928800.0
2002-01-16 16:00:00	AAPL	Stock	0.3736	0.3929	0.3679	0.3848	43976800.0
2002-01-16 17:00:00	AAPL	Stock	0.3857	0.3929	0.3711	0.3893	11032000.0
2002-01-16 18:00:00	AAPL	Stock	0.3889	0.3889	0.3877	0.3882	302400.0
2002-01-16 08:00:00	MSFT	Stock	34.425	34.775	34.375	34.575	239600.0
2002-01-16 09:00:00	MSFT	Stock	34.545	34.8805	34.415	34.82	6877600.0
2002-01-16 10:00:00	MSFT	Stock	34.825	34.92	34.515	34.58	11757200.0
2002-01-16 11:00:00	MSFT	Stock	34.58	34.585	34.355	34.395	7308400.0
2002-01-16 12:00:00	MSFT	Stock	34.395	34.425	34.075	34.275	5950800.0
2002-01-16 13:00:00	MSFT	Stock	34.275	34.28	34.005	34.045	4729000.0
2002-01-16 14:00:00	MSFT	Stock	34.04	34.325	33.975	34.22	7204200.0
2002-01-16 15:00:00	MSFT	Stock	34.2345	34.395	33.93	33.93	9841400.0
2002-01-16 16:00:00	MSFT	Stock	33.93	34.3992	33.815	33.975	2014600.0
2002-01-16 17:00:00	MSFT	Stock	33.95	34.1495	33.935	34.125	285400.0
2002-01-16 18:00:00	MSFT	Stock	34.105	34.125	34.05	34.125	3600.0
2002-01-16 08:00:00	NVDA	Stock	0.527	0.5445	0.527	0.535	3816000.0
2002-01-16 09:00:00	NVDA	Stock	0.5354	0.5442	0.5282	0.5341	158820000.0
2002-01-16 10:00:00	NVDA	Stock	0.534	0.5354	0.5217	0.5264	227100000.0
2002-01-16 11:00:00	NVDA	Stock	0.5268	0.5325	0.5244	0.5317	142896000.0
2002-01-16 12:00:00	NVDA	Stock	0.5315	0.5332	0.5271	0.5327	76272000.0
2002-01-16 13:00:00	NVDA	Stock	0.5325	0.5347	0.5293	0.5317	63600000.0
2002-01-16 14:00:00	NVDA	Stock	0.5316	0.5383	0.5292	0.536	121104000.0
2002-01-16 15:00:00	NVDA	Stock	0.5356	0.5406	0.5212	0.5227	206028000.0
2002-01-16 16:00:00	NVDA	Stock	0.5232	0.5302	0.5224	0.5257	20904000.0
2002-01-16 17:00:00	NVDA	Stock	0.5257	0.5262	0.5232	0.5262	1248000.0
2002-01-16 18:00:00	NVDA	Stock	0.5258	0.5274	0.5258	0.5271	744000.0
2002-01-16 08:00:00	AMZN	Stock	0.5005	0.5145	0.4995	0.5	486000.0
2002-01-16 09:00:00	AMZN	Stock	0.5	0.5025	0.475	0.4825	37118000.0
2002-01-16 10:00:00	AMZN	Stock	0.4815	0.488	0.4755	0.485	42124000.0
2002-01-16 11:00:00	AMZN	Stock	0.485	0.495	0.479	0.493	30698000.0
2002-01-16 12:00:00	AMZN	Stock	0.4935	0.4935	0.4825	0.488	23858000.0
2002-01-16 13:00:00	AMZN	Stock	0.488	0.4885	0.4745	0.4776	19926000.0
2002-01-16 14:00:00	AMZN	Stock	0.4775	0.4815	0.4765	0.478	24094000.0
2002-01-16 15:00:00	AMZN	Stock	0.478	0.4795	0.4525	0.4565	65482000.0
2002-01-16 16:00:00	AMZN	Stock	0.456	0.4875	0.45	0.4675	13050000.0
2002-01-16 17:00:00	AMZN	Stock	0.467	0.47	0.4565	0.465	1228000.0
2002-01-16 18:00:00	AMZN	Stock	0.4675	0.4685	0.4675	0.4685	74000.0
2002-01-16 09:00:00	CL	Stock	28.35	28.6	28.34	28.485	225400.0
2002-01-16 10:00:00	CL	Stock	28.475	28.615	28.445	28.455	320200.0
2002-01-16 11:00:00	CL	Stock	28.46	28.46	28.28	28.415	329200.0
2002-01-16 12:00:00	CL	Stock	28.405	28.405	28.22	28.3	309600.0
2002-01-16 13:00:00	CL	Stock	28.305	28.445	28.29	28.35	291000.0
2002-01-16 14:00:00	CL	Stock	28.35	28.635	28.335	28.6	550600.0

> showing 50 of 18,589 rows — these rows as CSV

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