PREVIEW / stock_1hour / 2001-11-07

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-11-07.parquet
  size:    368 KB
  rows:    17,467
  symbols: 1,358

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
2001-11-07 08:00:00	AAPL	Stock	0.347	0.3491	0.347	0.348	1080800.0
2001-11-07 09:00:00	AAPL	Stock	0.348	0.3527	0.3464	0.3502	39866400.0
2001-11-07 10:00:00	AAPL	Stock	0.3502	0.3529	0.3482	0.3498	52388000.0
2001-11-07 11:00:00	AAPL	Stock	0.3498	0.3527	0.3482	0.3488	21313600.0
2001-11-07 12:00:00	AAPL	Stock	0.3486	0.3561	0.3486	0.3546	37458400.0
2001-11-07 13:00:00	AAPL	Stock	0.3546	0.3586	0.3543	0.3557	63520800.0
2001-11-07 14:00:00	AAPL	Stock	0.3557	0.358	0.353	0.358	35067200.0
2001-11-07 15:00:00	AAPL	Stock	0.358	0.3595	0.3452	0.3498	96807200.0
2001-11-07 16:00:00	AAPL	Stock	0.3498	0.3541	0.3489	0.3518	33241600.0
2001-11-07 08:00:00	MSFT	Stock	32.12	32.3925	32.0	32.175	192000.0
2001-11-07 09:00:00	MSFT	Stock	32.15	32.5	32.08	32.375	9315800.0
2001-11-07 10:00:00	MSFT	Stock	32.335	32.48	32.02	32.4055	11117800.0
2001-11-07 11:00:00	MSFT	Stock	32.39	32.49	32.24	32.275	4906400.0
2001-11-07 12:00:00	MSFT	Stock	32.27	32.495	32.195	32.435	3633400.0
2001-11-07 13:00:00	MSFT	Stock	32.44	32.525	32.335	32.3901	8757000.0
2001-11-07 14:00:00	MSFT	Stock	32.39	32.4	32.125	32.33	7353600.0
2001-11-07 15:00:00	MSFT	Stock	32.35	32.47	32.015	32.12	10478200.0
2001-11-07 16:00:00	MSFT	Stock	32.12	32.324	32.05	32.1	1543000.0
2001-11-07 17:00:00	MSFT	Stock	32.1	32.125	32.06	32.075	47600.0
2001-11-07 18:00:00	MSFT	Stock	32.06	32.065	32.035	32.035	7000.0
2001-11-07 08:00:00	NVDA	Stock	0.4104	0.4202	0.4104	0.4183	2952000.0
2001-11-07 09:00:00	NVDA	Stock	0.4187	0.4381	0.4159	0.4328	344004000.0
2001-11-07 10:00:00	NVDA	Stock	0.4329	0.4345	0.4246	0.4284	295104000.0
2001-11-07 11:00:00	NVDA	Stock	0.4285	0.4342	0.4257	0.4287	182208000.0
2001-11-07 12:00:00	NVDA	Stock	0.4284	0.4318	0.4275	0.4306	87864000.0
2001-11-07 13:00:00	NVDA	Stock	0.4307	0.4338	0.4297	0.4312	92232000.0
2001-11-07 14:00:00	NVDA	Stock	0.4321	0.4325	0.4258	0.4279	136944000.0
2001-11-07 15:00:00	NVDA	Stock	0.4277	0.4284	0.42	0.4218	203580000.0
2001-11-07 16:00:00	NVDA	Stock	0.4217	0.4242	0.421	0.4219	24252000.0
2001-11-07 17:00:00	NVDA	Stock	0.4238	0.4238	0.4225	0.4225	288000.0
2001-11-07 18:00:00	NVDA	Stock	0.4241	0.4249	0.4241	0.4249	228000.0
2001-11-07 08:00:00	AMZN	Stock	0.3505	0.37	0.349	0.3501	234000.0
2001-11-07 09:00:00	AMZN	Stock	0.3505	0.365	0.3495	0.362	21940000.0
2001-11-07 10:00:00	AMZN	Stock	0.3625	0.3665	0.353	0.3665	28006000.0
2001-11-07 11:00:00	AMZN	Stock	0.366	0.376	0.365	0.3675	41086000.0
2001-11-07 12:00:00	AMZN	Stock	0.3675	0.3775	0.3665	0.3775	19362000.0
2001-11-07 13:00:00	AMZN	Stock	0.3775	0.3825	0.376	0.3775	15702000.0
2001-11-07 14:00:00	AMZN	Stock	0.3775	0.378	0.368	0.375	17104000.0
2001-11-07 15:00:00	AMZN	Stock	0.3745	0.3775	0.3655	0.372	26746000.0
2001-11-07 16:00:00	AMZN	Stock	0.372	0.3735	0.367	0.3715	13092000.0
2001-11-07 18:00:00	AMZN	Stock	0.374	0.374	0.374	0.374	6000.0
2001-11-07 09:00:00	CL	Stock	29.435	29.5	29.35	29.4	175400.0
2001-11-07 10:00:00	CL	Stock	29.4	29.6	29.215	29.495	275600.0
2001-11-07 11:00:00	CL	Stock	29.495	29.635	29.49	29.51	144600.0
2001-11-07 12:00:00	CL	Stock	29.525	29.625	29.5	29.605	131200.0
2001-11-07 13:00:00	CL	Stock	29.605	29.68	29.45	29.45	241800.0
2001-11-07 14:00:00	CL	Stock	29.45	29.45	29.255	29.375	312800.0
2001-11-07 15:00:00	CL	Stock	29.36	29.48	29.25	29.36	432000.0
2001-11-07 16:00:00	CL	Stock	29.325	29.325	29.325	29.325	55200.0
2001-11-07 17:00:00	CL	Stock	29.325	29.325	29.325	29.325	9200.0

> showing 50 of 17,467 rows — these rows as CSV

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