PREVIEW / stock_1hour / 2002-09-05

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-09-05.parquet
  size:    392 KB
  rows:    18,493
  symbols: 1,467

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-09-05 08:00:00	AAPL	Stock	0.2552	0.2554	0.2552	0.2552	89600.0
2002-09-05 09:00:00	AAPL	Stock	0.2543	0.2567	0.2523	0.2541	28049840.0
2002-09-05 10:00:00	AAPL	Stock	0.2543	0.2554	0.2509	0.2518	40890192.0
2002-09-05 11:00:00	AAPL	Stock	0.2516	0.2538	0.2516	0.2521	28500752.0
2002-09-05 12:00:00	AAPL	Stock	0.2521	0.2538	0.2514	0.2538	22676024.0
2002-09-05 13:00:00	AAPL	Stock	0.2538	0.2548	0.2518	0.2521	17109904.0
2002-09-05 14:00:00	AAPL	Stock	0.2521	0.2532	0.2516	0.253	19824000.0
2002-09-05 15:00:00	AAPL	Stock	0.253	0.2543	0.2521	0.2534	41808984.0
2002-09-05 16:00:00	AAPL	Stock	0.2536	0.258	0.2529	0.2552	11603200.0
2002-09-05 17:00:00	AAPL	Stock	0.2532	0.2554	0.2532	0.2534	974400.0
2002-09-05 18:00:00	AAPL	Stock	0.2554	0.2554	0.2554	0.2554	44800.0
2002-09-05 08:00:00	MSFT	Stock	23.755	24.09	23.725	23.79	98738.0
2002-09-05 09:00:00	MSFT	Stock	23.775	24.09	23.505	23.55	13130576.0
2002-09-05 10:00:00	MSFT	Stock	23.55	23.605	23.17	23.235	17538410.0
2002-09-05 11:00:00	MSFT	Stock	23.235	23.62	23.235	23.4	12674256.0
2002-09-05 12:00:00	MSFT	Stock	23.4	23.46	23.22	23.33	6554282.0
2002-09-05 13:00:00	MSFT	Stock	23.33	23.515	23.195	23.2105	8425594.0
2002-09-05 14:00:00	MSFT	Stock	23.215	23.31	23.0	23.0745	10192560.0
2002-09-05 15:00:00	MSFT	Stock	23.075	23.14	22.94	22.965	14824362.0
2002-09-05 16:00:00	MSFT	Stock	22.97	23.5	22.91	23.35	4132468.0
2002-09-05 17:00:00	MSFT	Stock	23.35	23.4	22.955	23.38	935558.0
2002-09-05 18:00:00	MSFT	Stock	23.3575	23.67	23.35	23.5	155288.0
2002-09-05 08:00:00	NVDA	Stock	0.0786	0.0787	0.0771	0.0771	3756000.0
2002-09-05 09:00:00	NVDA	Stock	0.0776	0.0786	0.0759	0.0763	79741320.0
2002-09-05 10:00:00	NVDA	Stock	0.0763	0.0767	0.0755	0.0761	151919640.0
2002-09-05 11:00:00	NVDA	Stock	0.0762	0.0772	0.0756	0.076	100125480.0
2002-09-05 12:00:00	NVDA	Stock	0.0759	0.0763	0.0756	0.0759	67940400.0
2002-09-05 13:00:00	NVDA	Stock	0.0759	0.0769	0.0758	0.0762	77093040.0
2002-09-05 14:00:00	NVDA	Stock	0.0763	0.0768	0.0758	0.076	53435400.0
2002-09-05 15:00:00	NVDA	Stock	0.076	0.0765	0.075	0.0754	153345360.0
2002-09-05 16:00:00	NVDA	Stock	0.0755	0.0785	0.0749	0.0768	16857000.0
2002-09-05 17:00:00	NVDA	Stock	0.0764	0.0768	0.0755	0.0768	2964000.0
2002-09-05 18:00:00	NVDA	Stock	0.0768	0.0768	0.0764	0.0767	1020000.0
2002-09-05 08:00:00	AMZN	Stock	0.7418	0.7418	0.726	0.7275	364000.0
2002-09-05 09:00:00	AMZN	Stock	0.7275	0.739	0.712	0.727	15881160.0
2002-09-05 10:00:00	AMZN	Stock	0.727	0.73	0.719	0.7205	14130980.0
2002-09-05 11:00:00	AMZN	Stock	0.721	0.736	0.72	0.7265	12674800.0
2002-09-05 12:00:00	AMZN	Stock	0.7265	0.7325	0.7235	0.7325	6856780.0
2002-09-05 13:00:00	AMZN	Stock	0.7315	0.734	0.723	0.724	9730480.0
2002-09-05 14:00:00	AMZN	Stock	0.7235	0.7305	0.7215	0.725	12334860.0
2002-09-05 15:00:00	AMZN	Stock	0.724	0.726	0.7145	0.7165	19682460.0
2002-09-05 16:00:00	AMZN	Stock	0.715	0.7415	0.7115	0.7415	9590000.0
2002-09-05 17:00:00	AMZN	Stock	0.7125	0.7125	0.7125	0.7125	188000.0
2002-09-05 18:00:00	AMZN	Stock	0.7225	0.7225	0.7225	0.7225	20000.0
2002-09-05 09:00:00	CL	Stock	27.5	27.675	27.41	27.65	1215800.0
2002-09-05 10:00:00	CL	Stock	27.655	27.7	27.5	27.665	1312800.0
2002-09-05 11:00:00	CL	Stock	27.675	28.365	27.66	28.3	2207600.0
2002-09-05 12:00:00	CL	Stock	28.3	28.475	28.255	28.465	1583800.0
2002-09-05 13:00:00	CL	Stock	28.47	28.625	28.42	28.525	1067400.0
2002-09-05 14:00:00	CL	Stock	28.53	28.53	28.275	28.275	1344000.0

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

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