PREVIEW / stock_1hour / 2002-03-05

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-03-05.parquet
  size:    402 KB
  rows:    18,813
  symbols: 1,402

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-03-05 08:00:00	AAPL	Stock	0.434	0.434	0.4321	0.4321	240800.0
2002-03-05 09:00:00	AAPL	Stock	0.4321	0.4327	0.4232	0.4273	30996000.0
2002-03-05 10:00:00	AAPL	Stock	0.4277	0.4304	0.4196	0.423	55949600.0
2002-03-05 11:00:00	AAPL	Stock	0.423	0.4279	0.4205	0.4243	22405600.0
2002-03-05 12:00:00	AAPL	Stock	0.4245	0.4363	0.4245	0.4316	23228800.0
2002-03-05 13:00:00	AAPL	Stock	0.4316	0.4321	0.4179	0.4254	44536800.0
2002-03-05 14:00:00	AAPL	Stock	0.4252	0.4295	0.4225	0.4257	19112800.0
2002-03-05 15:00:00	AAPL	Stock	0.4257	0.4284	0.4202	0.4202	50153600.0
2002-03-05 16:00:00	AAPL	Stock	0.4202	0.4254	0.4196	0.4202	14257600.0
2002-03-05 08:00:00	MSFT	Stock	31.425	31.645	31.325	31.56	170600.0
2002-03-05 09:00:00	MSFT	Stock	31.5605	31.665	31.4	31.555	7654200.0
2002-03-05 10:00:00	MSFT	Stock	31.56	31.94	31.17	31.3	14885800.0
2002-03-05 11:00:00	MSFT	Stock	31.305	31.64	31.2865	31.47	6842400.0
2002-03-05 12:00:00	MSFT	Stock	31.47	31.8695	31.435	31.77	5179800.0
2002-03-05 13:00:00	MSFT	Stock	31.765	31.85	31.49	31.63	4095600.0
2002-03-05 14:00:00	MSFT	Stock	31.63	31.775	31.3745	31.42	5132400.0
2002-03-05 15:00:00	MSFT	Stock	31.395	31.73	31.32	31.54	7198200.0
2002-03-05 16:00:00	MSFT	Stock	31.53	31.715	31.46	31.55	2142000.0
2002-03-05 17:00:00	MSFT	Stock	31.85	31.85	31.475	31.5	32200.0
2002-03-05 18:00:00	MSFT	Stock	31.505	31.5055	31.505	31.5055	400.0
2002-03-05 08:00:00	NVDA	Stock	0.492	0.4971	0.4875	0.4875	7380000.0
2002-03-05 09:00:00	NVDA	Stock	0.4875	0.5017	0.4838	0.4972	222948000.0
2002-03-05 10:00:00	NVDA	Stock	0.4973	0.5041	0.4858	0.4884	381204000.0
2002-03-05 11:00:00	NVDA	Stock	0.4882	0.4954	0.4872	0.4906	140904000.0
2002-03-05 12:00:00	NVDA	Stock	0.4905	0.4987	0.4897	0.4942	112416000.0
2002-03-05 13:00:00	NVDA	Stock	0.4942	0.4942	0.4871	0.4903	123672000.0
2002-03-05 14:00:00	NVDA	Stock	0.4903	0.4934	0.488	0.4896	121764000.0
2002-03-05 15:00:00	NVDA	Stock	0.4894	0.4967	0.4877	0.4919	193572000.0
2002-03-05 16:00:00	NVDA	Stock	0.491	0.4929	0.4894	0.491	11112000.0
2002-03-05 17:00:00	NVDA	Stock	0.4917	0.4917	0.4849	0.4849	1776000.0
2002-03-05 18:00:00	NVDA	Stock	0.4862	0.4875	0.4862	0.4862	144000.0
2002-03-05 08:00:00	AMZN	Stock	0.82	0.82	0.8075	0.809	372000.0
2002-03-05 09:00:00	AMZN	Stock	0.81	0.8315	0.7955	0.826	33138000.0
2002-03-05 10:00:00	AMZN	Stock	0.826	0.834	0.7885	0.7945	43266000.0
2002-03-05 11:00:00	AMZN	Stock	0.7945	0.8085	0.793	0.8035	17984000.0
2002-03-05 12:00:00	AMZN	Stock	0.8035	0.81	0.799	0.8	8914000.0
2002-03-05 13:00:00	AMZN	Stock	0.801	0.809	0.7985	0.8045	10110000.0
2002-03-05 14:00:00	AMZN	Stock	0.805	0.807	0.798	0.8005	15606000.0
2002-03-05 15:00:00	AMZN	Stock	0.8	0.805	0.795	0.7985	20306000.0
2002-03-05 16:00:00	AMZN	Stock	0.798	0.8075	0.7476	0.7675	20374000.0
2002-03-05 17:00:00	AMZN	Stock	0.7675	0.7985	0.764	0.767	712000.0
2002-03-05 18:00:00	AMZN	Stock	0.767	0.769	0.767	0.7685	112000.0
2002-03-05 09:00:00	CL	Stock	27.875	27.895	27.75	27.75	777000.0
2002-03-05 10:00:00	CL	Stock	27.75	27.825	27.47	27.52	834400.0
2002-03-05 11:00:00	CL	Stock	27.51	27.54	27.29	27.34	652400.0
2002-03-05 12:00:00	CL	Stock	27.355	27.525	27.24	27.485	697000.0
2002-03-05 13:00:00	CL	Stock	27.475	27.5	27.35	27.43	399800.0
2002-03-05 14:00:00	CL	Stock	27.445	27.545	27.39	27.45	383000.0
2002-03-05 15:00:00	CL	Stock	27.465	27.75	27.45	27.69	563000.0
2002-03-05 16:00:00	CL	Stock	27.695	27.7	27.675	27.675	88800.0

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

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