PREVIEW / stock_1hour / 2002-01-31

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-01-31.parquet
  size:    410 KB
  rows:    19,078
  symbols: 1,352

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-31 08:00:00	AAPL	Stock	0.4352	0.4352	0.4295	0.4304	649600.0
2002-01-31 09:00:00	AAPL	Stock	0.4304	0.435	0.4304	0.4339	84980000.0
2002-01-31 10:00:00	AAPL	Stock	0.4343	0.4354	0.4307	0.4329	71948800.0
2002-01-31 11:00:00	AAPL	Stock	0.4327	0.4371	0.4314	0.4348	67552800.0
2002-01-31 12:00:00	AAPL	Stock	0.4348	0.4363	0.4336	0.4339	35806400.0
2002-01-31 13:00:00	AAPL	Stock	0.4341	0.4364	0.4341	0.4364	46300800.0
2002-01-31 14:00:00	AAPL	Stock	0.4364	0.4373	0.4327	0.4341	42380800.0
2002-01-31 15:00:00	AAPL	Stock	0.4339	0.4414	0.4339	0.4413	61796000.0
2002-01-31 16:00:00	AAPL	Stock	0.4413	0.442	0.4345	0.4411	37100000.0
2002-01-31 17:00:00	AAPL	Stock	0.4409	0.4414	0.4409	0.4414	1260000.0
2002-01-31 18:00:00	AAPL	Stock	0.4409	0.4409	0.4409	0.4409	22400.0
2002-01-31 08:00:00	MSFT	Stock	31.4275	31.5555	31.4275	31.53	101400.0
2002-01-31 09:00:00	MSFT	Stock	31.525	31.785	31.505	31.755	7548000.0
2002-01-31 10:00:00	MSFT	Stock	31.76	31.905	31.25	31.285	12397800.0
2002-01-31 11:00:00	MSFT	Stock	31.285	31.37	31.06	31.305	10212600.0
2002-01-31 12:00:00	MSFT	Stock	31.31	31.57	31.25	31.5	6457200.0
2002-01-31 13:00:00	MSFT	Stock	31.52	31.7	31.4445	31.55	5725000.0
2002-01-31 14:00:00	MSFT	Stock	31.55	31.7	31.38	31.57	5806600.0
2002-01-31 15:00:00	MSFT	Stock	31.565	31.875	31.515	31.855	11516600.0
2002-01-31 16:00:00	MSFT	Stock	31.85	31.95	31.5156	31.855	7935400.0
2002-01-31 17:00:00	MSFT	Stock	31.855	31.8725	31.775	31.8	854800.0
2002-01-31 18:00:00	MSFT	Stock	31.8	31.855	31.775	31.85	4600.0
2002-01-31 08:00:00	NVDA	Stock	0.5479	0.5541	0.5479	0.55	852000.0
2002-01-31 09:00:00	NVDA	Stock	0.5519	0.5567	0.5482	0.5516	125088000.0
2002-01-31 10:00:00	NVDA	Stock	0.5514	0.5535	0.5296	0.533	218292000.0
2002-01-31 11:00:00	NVDA	Stock	0.5329	0.54	0.5329	0.5373	113328000.0
2002-01-31 12:00:00	NVDA	Stock	0.5371	0.5456	0.5367	0.544	89784000.0
2002-01-31 13:00:00	NVDA	Stock	0.5437	0.5457	0.5392	0.5442	80880000.0
2002-01-31 14:00:00	NVDA	Stock	0.5441	0.5444	0.5377	0.5403	94008000.0
2002-01-31 15:00:00	NVDA	Stock	0.5407	0.5522	0.5397	0.5471	197760000.0
2002-01-31 16:00:00	NVDA	Stock	0.5468	0.5489	0.5424	0.5437	34776000.0
2002-01-31 17:00:00	NVDA	Stock	0.5437	0.5478	0.5437	0.5466	1032000.0
2002-01-31 18:00:00	NVDA	Stock	0.5466	0.5467	0.5466	0.5467	84000.0
2002-01-31 08:00:00	AMZN	Stock	0.7125	0.7345	0.7025	0.708	428000.0
2002-01-31 09:00:00	AMZN	Stock	0.709	0.719	0.703	0.714	25266000.0
2002-01-31 10:00:00	AMZN	Stock	0.7135	0.7245	0.6905	0.706	34466000.0
2002-01-31 11:00:00	AMZN	Stock	0.705	0.7115	0.7025	0.7115	15092000.0
2002-01-31 12:00:00	AMZN	Stock	0.7111	0.713	0.7	0.7095	18128000.0
2002-01-31 13:00:00	AMZN	Stock	0.7085	0.709	0.6999	0.7025	15314000.0
2002-01-31 14:00:00	AMZN	Stock	0.7035	0.706	0.6925	0.6965	16184000.0
2002-01-31 15:00:00	AMZN	Stock	0.6968	0.71	0.6705	0.71	58888000.0
2002-01-31 16:00:00	AMZN	Stock	0.71	0.713	0.7051	0.7095	7590000.0
2002-01-31 17:00:00	AMZN	Stock	0.7095	0.7095	0.699	0.708	10044000.0
2002-01-31 18:00:00	AMZN	Stock	0.7035	0.7095	0.7035	0.7095	14000.0
2002-01-31 09:00:00	CL	Stock	28.125	28.35	28.125	28.21	386800.0
2002-01-31 10:00:00	CL	Stock	28.25	28.275	27.875	27.975	484000.0
2002-01-31 11:00:00	CL	Stock	27.955	28.155	27.955	28.15	298000.0
2002-01-31 12:00:00	CL	Stock	28.15	28.285	28.095	28.245	504400.0
2002-01-31 13:00:00	CL	Stock	28.225	28.325	28.19	28.28	449000.0
2002-01-31 14:00:00	CL	Stock	28.32	28.525	28.2	28.415	425600.0

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

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