PREVIEW / stock_1hour / 2003-07-15

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-07-15.parquet
  size:    463 KB
  rows:    21,891
  symbols: 1,593

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
2003-07-15 08:00:00	AAPL	Stock	0.3554	0.3554	0.3554	0.3554	716800.0
2003-07-15 09:00:00	AAPL	Stock	0.358	0.3611	0.3563	0.3605	23492840.0
2003-07-15 10:00:00	AAPL	Stock	0.3604	0.3614	0.3557	0.3571	24735424.0
2003-07-15 11:00:00	AAPL	Stock	0.3571	0.3577	0.3509	0.3525	22383760.0
2003-07-15 12:00:00	AAPL	Stock	0.3523	0.3539	0.3514	0.3534	18146968.0
2003-07-15 13:00:00	AAPL	Stock	0.3532	0.3534	0.3482	0.3511	22079176.0
2003-07-15 14:00:00	AAPL	Stock	0.3509	0.3511	0.3484	0.3484	17965808.0
2003-07-15 15:00:00	AAPL	Stock	0.3486	0.3509	0.347	0.3502	31282104.0
2003-07-15 16:00:00	AAPL	Stock	0.3505	0.3543	0.35	0.3543	7190400.0
2003-07-15 17:00:00	AAPL	Stock	0.3543	0.3543	0.3504	0.3504	252000.0
2003-07-15 08:00:00	MSFT	Stock	27.4	27.469	27.24	27.44	213225.0
2003-07-15 09:00:00	MSFT	Stock	27.44	27.53	27.2	27.35	8408423.0
2003-07-15 10:00:00	MSFT	Stock	27.35	27.43	27.2	27.38	9037394.0
2003-07-15 11:00:00	MSFT	Stock	27.39	27.46	27.23	27.42	6392804.0
2003-07-15 12:00:00	MSFT	Stock	27.42	27.421	27.23	27.307	3970358.0
2003-07-15 13:00:00	MSFT	Stock	27.3	27.34	27.13	27.32	4326540.0
2003-07-15 14:00:00	MSFT	Stock	27.31	27.32	27.12	27.15	4904855.0
2003-07-15 15:00:00	MSFT	Stock	27.169	27.34	27.1	27.26	6765520.0
2003-07-15 16:00:00	MSFT	Stock	27.26	27.68	27.1	27.55	3933431.0
2003-07-15 17:00:00	MSFT	Stock	27.67	27.68	27.29	27.65	100064.0
2003-07-15 18:00:00	MSFT	Stock	27.61	27.69	27.2713	27.688	35558.0
2003-07-15 08:00:00	NVDA	Stock	0.2029	0.2051	0.2029	0.2044	666000.0
2003-07-15 09:00:00	NVDA	Stock	0.2044	0.2059	0.1975	0.2	156727440.0
2003-07-15 10:00:00	NVDA	Stock	0.2	0.2008	0.1957	0.1971	249949920.0
2003-07-15 11:00:00	NVDA	Stock	0.1971	0.1977	0.1946	0.1957	157408200.0
2003-07-15 12:00:00	NVDA	Stock	0.1957	0.1958	0.195	0.1957	110860800.0
2003-07-15 13:00:00	NVDA	Stock	0.1957	0.1958	0.1943	0.195	87937560.0
2003-07-15 14:00:00	NVDA	Stock	0.1951	0.1953	0.1941	0.1941	87541200.0
2003-07-15 15:00:00	NVDA	Stock	0.1942	0.1959	0.1935	0.1954	174556560.0
2003-07-15 16:00:00	NVDA	Stock	0.1954	0.2041	0.195	0.1992	28986000.0
2003-07-15 17:00:00	NVDA	Stock	0.1996	0.2002	0.1955	0.2002	2825040.0
2003-07-15 18:00:00	NVDA	Stock	0.1954	0.2002	0.1954	0.2002	1454040.0
2003-07-15 08:00:00	AMZN	Stock	1.9635	1.985	1.9635	1.9825	291000.0
2003-07-15 09:00:00	AMZN	Stock	1.9805	1.985	1.944	1.95	16923900.0
2003-07-15 10:00:00	AMZN	Stock	1.95	1.9675	1.933	1.954	27978520.0
2003-07-15 11:00:00	AMZN	Stock	1.9535	1.9555	1.9385	1.9445	10243580.0
2003-07-15 12:00:00	AMZN	Stock	1.944	1.945	1.929	1.938	6862840.0
2003-07-15 13:00:00	AMZN	Stock	1.938	1.941	1.9255	1.9336	10256520.0
2003-07-15 14:00:00	AMZN	Stock	1.9335	1.9335	1.902	1.909	12489260.0
2003-07-15 15:00:00	AMZN	Stock	1.9085	1.922	1.888	1.9185	19408760.0
2003-07-15 16:00:00	AMZN	Stock	1.918	1.9765	1.918	1.935	3224780.0
2003-07-15 17:00:00	AMZN	Stock	1.9375	1.9475	1.9092	1.922	161000.0
2003-07-15 18:00:00	AMZN	Stock	1.9465	1.9465	1.9465	1.9465	2000.0
2003-07-15 09:00:00	CL	Stock	28.475	28.55	28.455	28.48	334400.0
2003-07-15 10:00:00	CL	Stock	28.49	28.605	28.435	28.6	675000.0
2003-07-15 11:00:00	CL	Stock	28.6	28.61	28.48	28.55	626600.0
2003-07-15 12:00:00	CL	Stock	28.55	28.57	28.4	28.475	359600.0
2003-07-15 13:00:00	CL	Stock	28.47	28.525	28.35	28.51	304400.0
2003-07-15 14:00:00	CL	Stock	28.51	28.52	28.4	28.515	491200.0
2003-07-15 15:00:00	CL	Stock	28.515	28.56	28.48	28.525	756600.0

> showing 50 of 21,891 rows — these rows as CSV

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