PREVIEW / stock_1hour / 2004-02-23

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-02-23.parquet
  size:    506 KB
  rows:    23,213
  symbols: 1,730

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
2004-02-23 08:00:00	AAPL	Stock	0.4009	0.402	0.396	0.3998	238392.0
2004-02-23 09:00:00	AAPL	Stock	0.4	0.4011	0.3932	0.3979	27396600.0
2004-02-23 10:00:00	AAPL	Stock	0.3977	0.4	0.3964	0.3996	29280720.0
2004-02-23 11:00:00	AAPL	Stock	0.3996	0.3998	0.3945	0.395	14998704.0
2004-02-23 12:00:00	AAPL	Stock	0.395	0.3966	0.3938	0.3945	20205360.0
2004-02-23 13:00:00	AAPL	Stock	0.3941	0.3964	0.3939	0.3945	21184576.0
2004-02-23 14:00:00	AAPL	Stock	0.3941	0.3943	0.3911	0.3916	30753240.0
2004-02-23 15:00:00	AAPL	Stock	0.3916	0.3955	0.3909	0.3954	39901400.0
2004-02-23 16:00:00	AAPL	Stock	0.3955	0.3989	0.3914	0.3963	5093256.0
2004-02-23 18:00:00	AAPL	Stock	0.3937	0.3937	0.3929	0.3929	115920.0
2004-02-23 08:00:00	MSFT	Stock	26.75	26.83	26.6	26.76	219078.0
2004-02-23 09:00:00	MSFT	Stock	26.77	26.8	26.57	26.68	5453836.0
2004-02-23 10:00:00	MSFT	Stock	26.68	26.71	26.6	26.69	7884011.0
2004-02-23 11:00:00	MSFT	Stock	26.69	26.73	26.5699	26.58	6831598.0
2004-02-23 12:00:00	MSFT	Stock	26.57	26.63	26.52	26.54	6004190.0
2004-02-23 13:00:00	MSFT	Stock	26.53	26.63	26.52	26.59	4469106.0
2004-02-23 14:00:00	MSFT	Stock	26.59	26.6	26.4799	26.53	6612028.0
2004-02-23 15:00:00	MSFT	Stock	26.53	26.6	26.5	26.6	9816985.0
2004-02-23 16:00:00	MSFT	Stock	26.6	26.63	26.57	26.58	723632.0
2004-02-23 17:00:00	MSFT	Stock	26.62	26.62	26.55	26.58	7740.0
2004-02-23 18:00:00	MSFT	Stock	26.58	26.58	26.52	26.52	15640.0
2004-02-23 08:00:00	NVDA	Stock	0.2012	0.2017	0.2006	0.2017	252000.0
2004-02-23 09:00:00	NVDA	Stock	0.2016	0.2022	0.1985	0.1987	90397920.0
2004-02-23 10:00:00	NVDA	Stock	0.1987	0.1987	0.1945	0.1959	179827320.0
2004-02-23 11:00:00	NVDA	Stock	0.1958	0.1963	0.1946	0.1946	80551200.0
2004-02-23 12:00:00	NVDA	Stock	0.1946	0.1952	0.1933	0.1949	78418200.0
2004-02-23 13:00:00	NVDA	Stock	0.1949	0.1951	0.1938	0.1943	49539960.0
2004-02-23 14:00:00	NVDA	Stock	0.1944	0.1947	0.1915	0.1929	151847160.0
2004-02-23 15:00:00	NVDA	Stock	0.193	0.1946	0.1927	0.1946	156574440.0
2004-02-23 16:00:00	NVDA	Stock	0.1946	0.2008	0.1932	0.1937	37191360.0
2004-02-23 17:00:00	NVDA	Stock	0.1931	0.1931	0.1929	0.1929	144000.0
2004-02-23 18:00:00	NVDA	Stock	0.1924	0.1924	0.1917	0.1917	4779720.0
2004-02-23 08:00:00	AMZN	Stock	2.259	2.265	2.259	2.261	118000.0
2004-02-23 09:00:00	AMZN	Stock	2.26	2.2627	2.2435	2.2435	19318540.0
2004-02-23 10:00:00	AMZN	Stock	2.2435	2.245	2.189	2.1985	45377200.0
2004-02-23 11:00:00	AMZN	Stock	2.198	2.2145	2.195	2.198	19090260.0
2004-02-23 12:00:00	AMZN	Stock	2.198	2.2045	2.183	2.19	14812660.0
2004-02-23 13:00:00	AMZN	Stock	2.19	2.197	2.1765	2.181	18726920.0
2004-02-23 14:00:00	AMZN	Stock	2.181	2.1905	2.1675	2.1767	21420300.0
2004-02-23 15:00:00	AMZN	Stock	2.1774	2.202	2.1735	2.199	38318060.0
2004-02-23 16:00:00	AMZN	Stock	2.199	2.2005	2.1915	2.1995	4052280.0
2004-02-23 17:00:00	AMZN	Stock	2.1985	2.1995	2.198	2.198	124000.0
2004-02-23 18:00:00	AMZN	Stock	2.198	2.198	2.198	2.198	20000.0
2004-02-23 09:00:00	CL	Stock	28.03	28.085	27.975	27.985	610800.0
2004-02-23 10:00:00	CL	Stock	27.995	28.0	27.865	27.985	728800.0
2004-02-23 11:00:00	CL	Stock	27.99	27.99	27.925	27.935	525800.0
2004-02-23 12:00:00	CL	Stock	27.94	27.975	27.89	27.91	427000.0
2004-02-23 13:00:00	CL	Stock	27.915	27.98	27.91	27.94	433000.0
2004-02-23 14:00:00	CL	Stock	27.94	27.98	27.88	27.975	723000.0
2004-02-23 15:00:00	CL	Stock	27.975	28.055	27.97	28.01	997400.0

> showing 50 of 23,213 rows — these rows as CSV

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