PREVIEW / stock_1hour / 2001-12-18

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-12-18.parquet
  size:    391 KB
  rows:    18,689
  symbols: 1,372

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-12-18 08:00:00	AAPL	Stock	0.3796	0.3821	0.3689	0.3689	302400.0
2001-12-18 09:00:00	AAPL	Stock	0.3689	0.3809	0.3689	0.377	36400000.0
2001-12-18 10:00:00	AAPL	Stock	0.3761	0.3768	0.3702	0.3714	30945600.0
2001-12-18 11:00:00	AAPL	Stock	0.3719	0.3759	0.3705	0.3713	16144800.0
2001-12-18 12:00:00	AAPL	Stock	0.3713	0.3721	0.3668	0.3673	33096000.0
2001-12-18 13:00:00	AAPL	Stock	0.3682	0.3696	0.3639	0.3659	18832800.0
2001-12-18 14:00:00	AAPL	Stock	0.3659	0.3668	0.3611	0.3654	28470400.0
2001-12-18 15:00:00	AAPL	Stock	0.3654	0.3759	0.3654	0.3752	53048800.0
2001-12-18 16:00:00	AAPL	Stock	0.375	0.3768	0.3698	0.3752	11821600.0
2001-12-18 17:00:00	AAPL	Stock	0.3752	0.3752	0.3746	0.3752	78400.0
2001-12-18 18:00:00	AAPL	Stock	0.3748	0.3748	0.3748	0.3748	28000.0
2001-12-18 08:00:00	MSFT	Stock	34.4	34.55	34.4	34.5	146800.0
2001-12-18 09:00:00	MSFT	Stock	34.505	34.96	34.365	34.505	8567200.0
2001-12-18 10:00:00	MSFT	Stock	34.5	34.5975	34.34	34.425	8645600.0
2001-12-18 11:00:00	MSFT	Stock	34.42	34.55	34.3245	34.4999	6594600.0
2001-12-18 12:00:00	MSFT	Stock	34.5	34.69	34.44	34.67	3859800.0
2001-12-18 13:00:00	MSFT	Stock	34.675	34.7	34.49	34.55	4397000.0
2001-12-18 14:00:00	MSFT	Stock	34.551	34.56	34.3045	34.43	4288600.0
2001-12-18 15:00:00	MSFT	Stock	34.42	34.695	34.405	34.635	7576000.0
2001-12-18 16:00:00	MSFT	Stock	34.635	34.735	34.365	34.5124	2064200.0
2001-12-18 17:00:00	MSFT	Stock	34.635	34.635	34.505	34.525	46200.0
2001-12-18 18:00:00	MSFT	Stock	34.525	34.525	34.5	34.5	6000.0
2001-12-18 08:00:00	NVDA	Stock	0.5625	0.5692	0.5608	0.5683	4368000.0
2001-12-18 09:00:00	NVDA	Stock	0.5684	0.5712	0.5474	0.5574	321756000.0
2001-12-18 10:00:00	NVDA	Stock	0.5572	0.5591	0.551	0.5517	137928000.0
2001-12-18 11:00:00	NVDA	Stock	0.5515	0.5547	0.5478	0.5509	93468000.0
2001-12-18 12:00:00	NVDA	Stock	0.5511	0.5533	0.5496	0.553	47736000.0
2001-12-18 13:00:00	NVDA	Stock	0.553	0.555	0.5488	0.5507	60516000.0
2001-12-18 14:00:00	NVDA	Stock	0.5507	0.5516	0.5483	0.5505	53220000.0
2001-12-18 15:00:00	NVDA	Stock	0.5506	0.5567	0.55	0.5531	129528000.0
2001-12-18 16:00:00	NVDA	Stock	0.5525	0.5554	0.5517	0.5521	29160000.0
2001-12-18 17:00:00	NVDA	Stock	0.5497	0.5499	0.5471	0.5479	204000.0
2001-12-18 18:00:00	NVDA	Stock	0.5471	0.5479	0.5459	0.5459	276000.0
2001-12-18 08:00:00	AMZN	Stock	0.555	0.56	0.54	0.556	318000.0
2001-12-18 09:00:00	AMZN	Stock	0.5575	0.568	0.551	0.5565	24554000.0
2001-12-18 10:00:00	AMZN	Stock	0.5565	0.5576	0.534	0.5375	27262000.0
2001-12-18 11:00:00	AMZN	Stock	0.5375	0.5435	0.5315	0.534	24258000.0
2001-12-18 12:00:00	AMZN	Stock	0.534	0.5375	0.5315	0.534	6034000.0
2001-12-18 13:00:00	AMZN	Stock	0.5345	0.5425	0.534	0.5365	16618000.0
2001-12-18 14:00:00	AMZN	Stock	0.5365	0.544	0.534	0.541	9708000.0
2001-12-18 15:00:00	AMZN	Stock	0.541	0.553	0.541	0.543	31186000.0
2001-12-18 16:00:00	AMZN	Stock	0.5425	0.548	0.5405	0.5415	2242000.0
2001-12-18 17:00:00	AMZN	Stock	0.543	0.543	0.5405	0.541	70000.0
2001-12-18 18:00:00	AMZN	Stock	0.541	0.541	0.54	0.54	64000.0
2001-12-18 09:00:00	CL	Stock	28.275	28.55	28.21	28.48	321000.0
2001-12-18 10:00:00	CL	Stock	28.45	28.79	28.425	28.645	398400.0
2001-12-18 11:00:00	CL	Stock	28.63	28.64	28.425	28.5	300600.0
2001-12-18 12:00:00	CL	Stock	28.5	28.725	28.485	28.675	486000.0
2001-12-18 13:00:00	CL	Stock	28.675	28.68	28.575	28.665	230000.0
2001-12-18 14:00:00	CL	Stock	28.655	28.725	28.505	28.725	378400.0

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

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