PREVIEW / stock_1hour / 2002-03-20

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-03-20.parquet
  size:    395 KB
  rows:    18,988
  symbols: 1,407

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-20 08:00:00	AAPL	Stock	0.4414	0.4414	0.4384	0.4384	39200.0
2002-03-20 09:00:00	AAPL	Stock	0.4393	0.4418	0.4375	0.4395	33846400.0
2002-03-20 10:00:00	AAPL	Stock	0.4395	0.4431	0.4388	0.443	32334400.0
2002-03-20 11:00:00	AAPL	Stock	0.443	0.4463	0.4413	0.4455	29881600.0
2002-03-20 12:00:00	AAPL	Stock	0.4454	0.4468	0.4441	0.4452	31225600.0
2002-03-20 13:00:00	AAPL	Stock	0.4457	0.447	0.4432	0.4463	34221600.0
2002-03-20 14:00:00	AAPL	Stock	0.4463	0.4489	0.4429	0.447	52180800.0
2002-03-20 15:00:00	AAPL	Stock	0.447	0.4484	0.4441	0.445	57500800.0
2002-03-20 16:00:00	AAPL	Stock	0.4448	0.4463	0.4439	0.445	9514400.0
2002-03-20 17:00:00	AAPL	Stock	0.445	0.445	0.4429	0.4429	1719200.0
2002-03-20 18:00:00	AAPL	Stock	0.445	0.445	0.445	0.445	28000.0
2002-03-20 08:00:00	MSFT	Stock	30.875	31.4	30.755	30.805	230600.0
2002-03-20 09:00:00	MSFT	Stock	30.84	31.105	30.695	30.925	4458200.0
2002-03-20 10:00:00	MSFT	Stock	30.915	30.95	30.47	30.55	8287400.0
2002-03-20 11:00:00	MSFT	Stock	30.55	30.61	30.445	30.57	4318200.0
2002-03-20 12:00:00	MSFT	Stock	30.575	30.575	30.39	30.42	5693000.0
2002-03-20 13:00:00	MSFT	Stock	30.42	30.425	30.255	30.335	4978800.0
2002-03-20 14:00:00	MSFT	Stock	30.34	30.3459	30.12	30.26	9338200.0
2002-03-20 15:00:00	MSFT	Stock	30.26	30.31	30.05	30.05	10660600.0
2002-03-20 16:00:00	MSFT	Stock	30.055	30.5599	30.0	30.0	2468400.0
2002-03-20 17:00:00	MSFT	Stock	29.975	30.05	29.975	30.0	250400.0
2002-03-20 18:00:00	MSFT	Stock	30.05	30.05	30.0	30.0	273400.0
2002-03-20 08:00:00	NVDA	Stock	0.4325	0.4413	0.4234	0.4251	1524000.0
2002-03-20 09:00:00	NVDA	Stock	0.425	0.4298	0.4083	0.4087	271176000.0
2002-03-20 10:00:00	NVDA	Stock	0.4087	0.4117	0.3969	0.398	542940000.0
2002-03-20 11:00:00	NVDA	Stock	0.398	0.4012	0.395	0.3953	232392000.0
2002-03-20 12:00:00	NVDA	Stock	0.3953	0.3998	0.3917	0.3975	257412000.0
2002-03-20 13:00:00	NVDA	Stock	0.3975	0.399	0.3928	0.3947	123336000.0
2002-03-20 14:00:00	NVDA	Stock	0.3946	0.395	0.3917	0.3919	204960000.0
2002-03-20 15:00:00	NVDA	Stock	0.3918	0.3918	0.3862	0.3878	419784000.0
2002-03-20 16:00:00	NVDA	Stock	0.3878	0.3987	0.3866	0.3871	47340000.0
2002-03-20 17:00:00	NVDA	Stock	0.3871	0.3877	0.3868	0.3871	2268000.0
2002-03-20 18:00:00	NVDA	Stock	0.3877	0.3877	0.387	0.3875	1716000.0
2002-03-20 08:00:00	AMZN	Stock	0.7348	0.7525	0.725	0.7275	512000.0
2002-03-20 09:00:00	AMZN	Stock	0.7255	0.7565	0.715	0.745	25462000.0
2002-03-20 10:00:00	AMZN	Stock	0.745	0.745	0.731	0.7355	14576000.0
2002-03-20 11:00:00	AMZN	Stock	0.736	0.741	0.735	0.736	7040000.0
2002-03-20 12:00:00	AMZN	Stock	0.736	0.738	0.732	0.732	11256000.0
2002-03-20 13:00:00	AMZN	Stock	0.7325	0.735	0.725	0.727	15294000.0
2002-03-20 14:00:00	AMZN	Stock	0.7265	0.7275	0.7155	0.718	16688000.0
2002-03-20 15:00:00	AMZN	Stock	0.7181	0.731	0.7155	0.7255	22942000.0
2002-03-20 16:00:00	AMZN	Stock	0.725	0.7315	0.7225	0.7245	20324000.0
2002-03-20 17:00:00	AMZN	Stock	0.7245	0.725	0.7225	0.724	438000.0
2002-03-20 18:00:00	AMZN	Stock	0.725	0.725	0.725	0.725	388000.0
2002-03-20 09:00:00	CL	Stock	28.5	28.59	28.44	28.5	294600.0
2002-03-20 10:00:00	CL	Stock	28.49	28.575	28.4	28.565	367200.0
2002-03-20 11:00:00	CL	Stock	28.57	28.61	28.535	28.575	289600.0
2002-03-20 12:00:00	CL	Stock	28.575	28.64	28.525	28.54	153600.0
2002-03-20 13:00:00	CL	Stock	28.575	28.59	28.525	28.545	262000.0
2002-03-20 14:00:00	CL	Stock	28.555	28.59	28.525	28.535	299000.0

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

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