PREVIEW / stock_1hour / 2002-01-28

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-01-28.parquet
  size:    389 KB
  rows:    18,292
  symbols: 1,348

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-28 08:00:00	AAPL	Stock	0.4157	0.4195	0.4157	0.4188	100800.0
2002-01-28 09:00:00	AAPL	Stock	0.4175	0.4205	0.4154	0.4191	17757600.0
2002-01-28 10:00:00	AAPL	Stock	0.4193	0.4193	0.4127	0.4188	27781600.0
2002-01-28 11:00:00	AAPL	Stock	0.4186	0.4191	0.4129	0.4129	23951200.0
2002-01-28 12:00:00	AAPL	Stock	0.4129	0.4143	0.4057	0.4105	47140800.0
2002-01-28 13:00:00	AAPL	Stock	0.4104	0.4113	0.4073	0.4088	12773600.0
2002-01-28 14:00:00	AAPL	Stock	0.4089	0.4134	0.408	0.4105	15416800.0
2002-01-28 15:00:00	AAPL	Stock	0.4104	0.4173	0.41	0.4159	27339200.0
2002-01-28 16:00:00	AAPL	Stock	0.4152	0.4186	0.4114	0.4155	4205600.0
2002-01-28 17:00:00	AAPL	Stock	0.4155	0.4184	0.4155	0.4184	140000.0
2002-01-28 08:00:00	MSFT	Stock	32.0	32.2	32.0	32.175	19400.0
2002-01-28 09:00:00	MSFT	Stock	32.175	32.2	31.905	31.965	6820400.0
2002-01-28 10:00:00	MSFT	Stock	31.955	32.075	31.8855	32.0145	6142600.0
2002-01-28 11:00:00	MSFT	Stock	32.0	32.125	31.835	31.865	5705000.0
2002-01-28 12:00:00	MSFT	Stock	31.86	31.875	31.625	31.6505	5188200.0
2002-01-28 13:00:00	MSFT	Stock	31.6595	31.72	31.5	31.53	4591200.0
2002-01-28 14:00:00	MSFT	Stock	31.525	31.64	31.5	31.555	3489600.0
2002-01-28 15:00:00	MSFT	Stock	31.555	31.9605	31.455	31.905	6674400.0
2002-01-28 16:00:00	MSFT	Stock	31.905	32.075	31.575	31.91	1567600.0
2002-01-28 17:00:00	MSFT	Stock	31.95	31.995	31.91	31.95	43800.0
2002-01-28 18:00:00	MSFT	Stock	32.0	32.005	32.0	32.005	1400.0
2002-01-28 08:00:00	NVDA	Stock	0.547	0.5561	0.547	0.5554	6072000.0
2002-01-28 09:00:00	NVDA	Stock	0.5542	0.5617	0.5507	0.5582	194904000.0
2002-01-28 10:00:00	NVDA	Stock	0.558	0.5604	0.5528	0.5595	178260000.0
2002-01-28 11:00:00	NVDA	Stock	0.5597	0.5621	0.5552	0.5577	125400000.0
2002-01-28 12:00:00	NVDA	Stock	0.5576	0.5597	0.5552	0.5577	61848000.0
2002-01-28 13:00:00	NVDA	Stock	0.5577	0.5586	0.5555	0.5569	43140000.0
2002-01-28 14:00:00	NVDA	Stock	0.5569	0.5624	0.5567	0.5606	87696000.0
2002-01-28 15:00:00	NVDA	Stock	0.5607	0.5667	0.5603	0.5666	197760000.0
2002-01-28 16:00:00	NVDA	Stock	0.5665	0.5708	0.5601	0.5679	9312000.0
2002-01-28 17:00:00	NVDA	Stock	0.5671	0.57	0.559	0.5675	1200000.0
2002-01-28 18:00:00	NVDA	Stock	0.5677	0.5677	0.5677	0.5677	144000.0
2002-01-28 08:00:00	AMZN	Stock	0.7315	0.7475	0.7315	0.7425	922000.0
2002-01-28 09:00:00	AMZN	Stock	0.7425	0.7495	0.738	0.7435	46878000.0
2002-01-28 10:00:00	AMZN	Stock	0.7435	0.759	0.739	0.758	64014000.0
2002-01-28 11:00:00	AMZN	Stock	0.7585	0.764	0.754	0.76	61902000.0
2002-01-28 12:00:00	AMZN	Stock	0.759	0.76	0.745	0.747	48554000.0
2002-01-28 13:00:00	AMZN	Stock	0.7455	0.753	0.7455	0.749	25764000.0
2002-01-28 14:00:00	AMZN	Stock	0.7495	0.763	0.749	0.754	32982000.0
2002-01-28 15:00:00	AMZN	Stock	0.754	0.7885	0.752	0.775	119450000.0
2002-01-28 16:00:00	AMZN	Stock	0.775	0.781	0.7725	0.7775	15676000.0
2002-01-28 17:00:00	AMZN	Stock	0.778	0.781	0.7475	0.7785	346000.0
2002-01-28 18:00:00	AMZN	Stock	0.78	0.7825	0.78	0.7825	42000.0
2002-01-28 09:00:00	CL	Stock	28.05	28.05	27.83	28.015	336400.0
2002-01-28 10:00:00	CL	Stock	28.0	28.095	27.95	28.075	211000.0
2002-01-28 11:00:00	CL	Stock	28.09	28.1	28.0	28.09	220600.0
2002-01-28 12:00:00	CL	Stock	28.095	28.125	28.025	28.045	274400.0
2002-01-28 13:00:00	CL	Stock	28.03	28.16	28.005	28.03	242000.0
2002-01-28 14:00:00	CL	Stock	28.035	28.13	28.005	28.085	332200.0
2002-01-28 15:00:00	CL	Stock	28.09	28.275	28.085	28.235	426400.0

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

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