PREVIEW / stock_1hour / 2002-02-20

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-02-20.parquet
  size:    395 KB
  rows:    18,840
  symbols: 1,406

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-02-20 08:00:00	AAPL	Stock	0.4038	0.4054	0.4038	0.4054	2828000.0
2002-02-20 09:00:00	AAPL	Stock	0.4054	0.4125	0.405	0.4125	30777600.0
2002-02-20 10:00:00	AAPL	Stock	0.4123	0.4134	0.4045	0.41	53698400.0
2002-02-20 11:00:00	AAPL	Stock	0.4097	0.4113	0.408	0.4091	30973600.0
2002-02-20 12:00:00	AAPL	Stock	0.4091	0.4096	0.3991	0.4021	25564000.0
2002-02-20 13:00:00	AAPL	Stock	0.4018	0.4063	0.4009	0.4063	26801600.0
2002-02-20 14:00:00	AAPL	Stock	0.4061	0.413	0.4061	0.4125	48596800.0
2002-02-20 15:00:00	AAPL	Stock	0.4125	0.4143	0.4091	0.4132	49789600.0
2002-02-20 16:00:00	AAPL	Stock	0.4134	0.4143	0.4087	0.413	5684000.0
2002-02-20 17:00:00	AAPL	Stock	0.413	0.413	0.413	0.413	84000.0
2002-02-20 08:00:00	MSFT	Stock	29.505	29.75	29.325	29.585	49600.0
2002-02-20 09:00:00	MSFT	Stock	29.585	29.805	29.4295	29.8	6504800.0
2002-02-20 10:00:00	MSFT	Stock	29.8	29.8	29.52	29.765	6509800.0
2002-02-20 11:00:00	MSFT	Stock	29.77	29.875	29.6495	29.75	5505800.0
2002-02-20 12:00:00	MSFT	Stock	29.75	29.75	29.485	29.61	5461200.0
2002-02-20 13:00:00	MSFT	Stock	29.605	29.7985	29.5	29.6299	5235400.0
2002-02-20 14:00:00	MSFT	Stock	29.63	30.18	29.62	30.095	8955000.0
2002-02-20 15:00:00	MSFT	Stock	30.0945	30.125	29.785	29.95	9808000.0
2002-02-20 16:00:00	MSFT	Stock	29.95	30.1	29.7798	29.8232	1227200.0
2002-02-20 17:00:00	MSFT	Stock	29.9575	30.1	29.7426	30.085	62600.0
2002-02-20 18:00:00	MSFT	Stock	30.065	30.065	30.025	30.065	16600.0
2002-02-20 08:00:00	NVDA	Stock	0.4396	0.4508	0.4392	0.45	1752000.0
2002-02-20 09:00:00	NVDA	Stock	0.4501	0.4517	0.4375	0.4439	322608000.0
2002-02-20 10:00:00	NVDA	Stock	0.444	0.451	0.4418	0.449	269712000.0
2002-02-20 11:00:00	NVDA	Stock	0.449	0.452	0.443	0.4492	143748000.0
2002-02-20 12:00:00	NVDA	Stock	0.4488	0.4494	0.4437	0.4477	119844000.0
2002-02-20 13:00:00	NVDA	Stock	0.4477	0.4573	0.4462	0.4562	197244000.0
2002-02-20 14:00:00	NVDA	Stock	0.4562	0.4679	0.4551	0.4667	369720000.0
2002-02-20 15:00:00	NVDA	Stock	0.4667	0.4731	0.4602	0.4692	348888000.0
2002-02-20 16:00:00	NVDA	Stock	0.4697	0.4733	0.4543	0.4717	22788000.0
2002-02-20 17:00:00	NVDA	Stock	0.4717	0.4718	0.4696	0.4717	960000.0
2002-02-20 18:00:00	NVDA	Stock	0.472	0.4724	0.4708	0.4708	552000.0
2002-02-20 08:00:00	AMZN	Stock	0.6513	0.6585	0.6513	0.6585	112000.0
2002-02-20 09:00:00	AMZN	Stock	0.658	0.67	0.6575	0.6661	16068000.0
2002-02-20 10:00:00	AMZN	Stock	0.667	0.667	0.646	0.655	16404000.0
2002-02-20 11:00:00	AMZN	Stock	0.655	0.657	0.6335	0.636	19662000.0
2002-02-20 12:00:00	AMZN	Stock	0.636	0.636	0.6075	0.616	29664000.0
2002-02-20 13:00:00	AMZN	Stock	0.6155	0.625	0.614	0.617	21592000.0
2002-02-20 14:00:00	AMZN	Stock	0.617	0.652	0.617	0.646	26404000.0
2002-02-20 15:00:00	AMZN	Stock	0.646	0.651	0.6405	0.6495	24122000.0
2002-02-20 16:00:00	AMZN	Stock	0.649	0.6525	0.6385	0.649	1748000.0
2002-02-20 17:00:00	AMZN	Stock	0.648	0.648	0.648	0.648	4000.0
2002-02-20 18:00:00	AMZN	Stock	0.652	0.652	0.649	0.649	20000.0
2002-02-20 09:00:00	CL	Stock	27.8	27.8	27.53	27.71	445800.0
2002-02-20 10:00:00	CL	Stock	27.745	27.925	27.65	27.925	478800.0
2002-02-20 11:00:00	CL	Stock	27.925	27.925	27.77	27.825	287600.0
2002-02-20 12:00:00	CL	Stock	27.81	27.87	27.75	27.87	243400.0
2002-02-20 13:00:00	CL	Stock	27.85	27.965	27.825	27.935	214200.0
2002-02-20 14:00:00	CL	Stock	27.93	28.125	27.93	28.075	254800.0
2002-02-20 15:00:00	CL	Stock	28.1	28.19	28.02	28.095	491400.0

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

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