PREVIEW / stock_1hour / 2003-07-23

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-07-23.parquet
  size:    455 KB
  rows:    21,519
  symbols: 1,589

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-23 08:00:00	AAPL	Stock	0.3721	0.3721	0.3721	0.3721	5600.0
2003-07-23 09:00:00	AAPL	Stock	0.3718	0.3743	0.3661	0.3671	13131384.0
2003-07-23 10:00:00	AAPL	Stock	0.3671	0.3705	0.366	0.367	28637952.0
2003-07-23 11:00:00	AAPL	Stock	0.367	0.3683	0.3661	0.367	16193968.0
2003-07-23 12:00:00	AAPL	Stock	0.3671	0.3671	0.3654	0.3657	8705704.0
2003-07-23 13:00:00	AAPL	Stock	0.3655	0.3707	0.3655	0.3695	16965424.0
2003-07-23 14:00:00	AAPL	Stock	0.3698	0.3739	0.3696	0.3704	24430448.0
2003-07-23 15:00:00	AAPL	Stock	0.3704	0.372	0.3694	0.3716	17785768.0
2003-07-23 16:00:00	AAPL	Stock	0.3714	0.3732	0.3709	0.3713	1394400.0
2003-07-23 08:00:00	MSFT	Stock	26.35	27.37	25.36	26.45	747524.0
2003-07-23 09:00:00	MSFT	Stock	26.45	26.48	26.24	26.31	5056416.0
2003-07-23 10:00:00	MSFT	Stock	26.31	26.42	26.14	26.31	6993957.0
2003-07-23 11:00:00	MSFT	Stock	26.31	26.35	26.2	26.24	4123245.0
2003-07-23 12:00:00	MSFT	Stock	26.23	26.3	26.169	26.25	4790689.0
2003-07-23 13:00:00	MSFT	Stock	26.241	26.39	26.24	26.33	3978531.0
2003-07-23 14:00:00	MSFT	Stock	26.34	26.6	26.34	26.51	7387824.0
2003-07-23 15:00:00	MSFT	Stock	26.51	26.65	26.4	26.45	10208097.0
2003-07-23 16:00:00	MSFT	Stock	26.45	26.54	26.411	26.49	1178057.0
2003-07-23 17:00:00	MSFT	Stock	26.49	26.53	26.48	26.482	9650.0
2003-07-23 18:00:00	MSFT	Stock	26.5	26.5	26.5	26.5	2491.0
2003-07-23 08:00:00	NVDA	Stock	0.1789	0.1789	0.1789	0.1789	12000.0
2003-07-23 09:00:00	NVDA	Stock	0.1779	0.1779	0.1719	0.1732	103814640.0
2003-07-23 10:00:00	NVDA	Stock	0.1731	0.1767	0.1722	0.1758	95506800.0
2003-07-23 11:00:00	NVDA	Stock	0.1758	0.1764	0.1735	0.1737	39113400.0
2003-07-23 12:00:00	NVDA	Stock	0.1737	0.175	0.1737	0.1747	19115760.0
2003-07-23 13:00:00	NVDA	Stock	0.1746	0.1767	0.1745	0.1763	25741440.0
2003-07-23 14:00:00	NVDA	Stock	0.1763	0.1808	0.1761	0.18	138614280.0
2003-07-23 15:00:00	NVDA	Stock	0.18	0.1808	0.1795	0.1797	118823040.0
2003-07-23 16:00:00	NVDA	Stock	0.1795	0.1808	0.1795	0.18	7145280.0
2003-07-23 17:00:00	NVDA	Stock	0.1804	0.1807	0.1786	0.1804	1046640.0
2003-07-23 18:00:00	NVDA	Stock	0.18	0.18	0.18	0.18	120000.0
2003-07-23 08:00:00	AMZN	Stock	1.8655	1.87	1.8515	1.86	6967900.0
2003-07-23 09:00:00	AMZN	Stock	1.8595	1.9455	1.8585	1.933	151931860.0
2003-07-23 10:00:00	AMZN	Stock	1.933	1.9725	1.9175	1.9505	134606760.0
2003-07-23 11:00:00	AMZN	Stock	1.9505	1.9565	1.9375	1.945	41135700.0
2003-07-23 12:00:00	AMZN	Stock	1.945	1.9575	1.94	1.9506	31434300.0
2003-07-23 13:00:00	AMZN	Stock	1.951	1.97	1.9505	1.9695	36954100.0
2003-07-23 14:00:00	AMZN	Stock	1.97	1.983	1.9625	1.978	55366700.0
2003-07-23 15:00:00	AMZN	Stock	1.9785	2.0125	1.976	2.005	92389220.0
2003-07-23 16:00:00	AMZN	Stock	2.0065	2.0175	1.9499	2.017	23556700.0
2003-07-23 17:00:00	AMZN	Stock	2.015	2.02	2.005	2.0175	725240.0
2003-07-23 18:00:00	AMZN	Stock	2.0175	2.0175	2.015	2.015	206340.0
2003-07-23 09:00:00	CL	Stock	28.2	28.25	28.175	28.185	341600.0
2003-07-23 10:00:00	CL	Stock	28.19	28.26	28.175	28.195	387200.0
2003-07-23 11:00:00	CL	Stock	28.2	28.205	28.035	28.14	381800.0
2003-07-23 12:00:00	CL	Stock	28.165	28.19	28.06	28.1	225800.0
2003-07-23 13:00:00	CL	Stock	28.075	28.28	28.06	28.26	158800.0
2003-07-23 14:00:00	CL	Stock	28.265	28.315	28.125	28.155	276600.0
2003-07-23 15:00:00	CL	Stock	28.155	28.19	28.1	28.15	388800.0
2003-07-23 16:00:00	CL	Stock	28.15	28.15	28.14	28.14	51800.0

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

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