PREVIEW / stock_1hour / 2002-03-28

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-03-28.parquet
  size:    410 KB
  rows:    19,037
  symbols: 1,401

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-28 08:00:00	AAPL	Stock	0.4195	0.4418	0.4195	0.4241	1954400.0
2002-03-28 09:00:00	AAPL	Stock	0.4214	0.4239	0.4189	0.4216	19644800.0
2002-03-28 10:00:00	AAPL	Stock	0.4216	0.4264	0.4214	0.4254	13804000.0
2002-03-28 11:00:00	AAPL	Stock	0.4254	0.4257	0.4214	0.422	7884800.0
2002-03-28 12:00:00	AAPL	Stock	0.422	0.4259	0.422	0.4239	15584800.0
2002-03-28 13:00:00	AAPL	Stock	0.4239	0.4241	0.4204	0.4229	12784800.0
2002-03-28 14:00:00	AAPL	Stock	0.423	0.4246	0.4214	0.4218	10785600.0
2002-03-28 15:00:00	AAPL	Stock	0.4221	0.4239	0.4214	0.4227	15769600.0
2002-03-28 16:00:00	AAPL	Stock	0.4229	0.4238	0.4216	0.4227	7896000.0
2002-03-28 17:00:00	AAPL	Stock	0.4227	0.4227	0.4227	0.4227	268800.0
2002-03-28 08:00:00	MSFT	Stock	30.6245	30.815	29.875	30.075	584800.0
2002-03-28 09:00:00	MSFT	Stock	30.1	30.125	29.92	30.02	6187200.0
2002-03-28 10:00:00	MSFT	Stock	30.03	30.295	30.02	30.205	7630800.0
2002-03-28 11:00:00	MSFT	Stock	30.2145	30.325	30.085	30.09	5425200.0
2002-03-28 12:00:00	MSFT	Stock	30.091	30.145	29.97	29.975	4667000.0
2002-03-28 13:00:00	MSFT	Stock	29.975	30.125	29.83	30.11	4420000.0
2002-03-28 14:00:00	MSFT	Stock	30.11	30.225	30.02	30.19	3411800.0
2002-03-28 15:00:00	MSFT	Stock	30.185	30.245	30.0	30.13	7367400.0
2002-03-28 16:00:00	MSFT	Stock	30.125	30.165	29.92	30.1086	3474200.0
2002-03-28 17:00:00	MSFT	Stock	30.155	30.16	30.09	30.14	487200.0
2002-03-28 18:00:00	MSFT	Stock	30.14	30.14	30.04	30.04	2400.0
2002-03-28 08:00:00	NVDA	Stock	0.3832	0.435	0.3789	0.3828	38952000.0
2002-03-28 09:00:00	NVDA	Stock	0.3837	0.3854	0.3644	0.3682	302760000.0
2002-03-28 10:00:00	NVDA	Stock	0.3682	0.3702	0.363	0.3644	236712000.0
2002-03-28 11:00:00	NVDA	Stock	0.3642	0.3644	0.3537	0.3552	420936000.0
2002-03-28 12:00:00	NVDA	Stock	0.3552	0.36	0.3506	0.3557	334284000.0
2002-03-28 13:00:00	NVDA	Stock	0.3557	0.3582	0.3489	0.3574	470928000.0
2002-03-28 14:00:00	NVDA	Stock	0.3572	0.3758	0.356	0.3688	822204000.0
2002-03-28 15:00:00	NVDA	Stock	0.3687	0.3715	0.3642	0.3698	374040000.0
2002-03-28 16:00:00	NVDA	Stock	0.3699	0.3712	0.3628	0.3696	28704000.0
2002-03-28 17:00:00	NVDA	Stock	0.3696	0.3701	0.3694	0.37	912000.0
2002-03-28 18:00:00	NVDA	Stock	0.3701	0.3702	0.3692	0.3702	960000.0
2002-03-28 08:00:00	AMZN	Stock	0.714	0.714	0.6925	0.711	1548000.0
2002-03-28 09:00:00	AMZN	Stock	0.7125	0.7275	0.712	0.724	14616000.0
2002-03-28 10:00:00	AMZN	Stock	0.725	0.7325	0.715	0.7184	13920000.0
2002-03-28 11:00:00	AMZN	Stock	0.7185	0.721	0.713	0.7145	6554000.0
2002-03-28 12:00:00	AMZN	Stock	0.7141	0.7195	0.7125	0.7175	4848000.0
2002-03-28 13:00:00	AMZN	Stock	0.717	0.7215	0.7134	0.721	3756000.0
2002-03-28 14:00:00	AMZN	Stock	0.7215	0.7275	0.719	0.7245	6806000.0
2002-03-28 15:00:00	AMZN	Stock	0.724	0.725	0.715	0.715	6030000.0
2002-03-28 16:00:00	AMZN	Stock	0.715	0.722	0.7125	0.715	2458000.0
2002-03-28 17:00:00	AMZN	Stock	0.715	0.715	0.7145	0.715	14000.0
2002-03-28 09:00:00	CL	Stock	28.5	28.735	28.475	28.7	329800.0
2002-03-28 10:00:00	CL	Stock	28.71	28.765	28.675	28.7	467600.0
2002-03-28 11:00:00	CL	Stock	28.7	28.76	28.61	28.61	297400.0
2002-03-28 12:00:00	CL	Stock	28.6	28.675	28.575	28.575	209800.0
2002-03-28 13:00:00	CL	Stock	28.55	28.62	28.5	28.615	128400.0
2002-03-28 14:00:00	CL	Stock	28.61	28.665	28.52	28.615	196400.0
2002-03-28 15:00:00	CL	Stock	28.615	28.71	28.585	28.605	393000.0
2002-03-28 16:00:00	CL	Stock	28.585	28.645	28.575	28.64	205600.0

> showing 50 of 19,037 rows — these rows as CSV

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