PREVIEW / stock_1hour / 2004-02-02

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-02-02.parquet
  size:    514 KB
  rows:    23,536
  symbols: 1,723

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-02 08:00:00	AAPL	Stock	0.403	0.403	0.403	0.403	89600.0
2004-02-02 09:00:00	AAPL	Stock	0.4029	0.405	0.4009	0.4014	33965288.0
2004-02-02 10:00:00	AAPL	Stock	0.4014	0.4034	0.3973	0.4007	51193016.0
2004-02-02 11:00:00	AAPL	Stock	0.4007	0.4073	0.3975	0.4071	33220432.0
2004-02-02 12:00:00	AAPL	Stock	0.4071	0.4073	0.4027	0.405	19368104.0
2004-02-02 13:00:00	AAPL	Stock	0.4052	0.4055	0.4021	0.4021	20622952.0
2004-02-02 14:00:00	AAPL	Stock	0.4023	0.4039	0.4013	0.4032	27584816.0
2004-02-02 15:00:00	AAPL	Stock	0.4031	0.4034	0.3954	0.3979	63120232.0
2004-02-02 16:00:00	AAPL	Stock	0.3979	0.3989	0.3943	0.3945	13505912.0
2004-02-02 17:00:00	AAPL	Stock	0.3986	0.3986	0.3945	0.3945	1208928.0
2004-02-02 18:00:00	AAPL	Stock	0.3986	0.3986	0.3968	0.3975	470400.0
2004-02-02 08:00:00	MSFT	Stock	27.65	27.7	27.54	27.63	32026.0
2004-02-02 09:00:00	MSFT	Stock	27.64	27.78	27.57	27.66	3511236.0
2004-02-02 10:00:00	MSFT	Stock	27.66	27.71	27.43	27.46	10008435.0
2004-02-02 11:00:00	MSFT	Stock	27.46	27.8	27.42	27.68	7800733.0
2004-02-02 12:00:00	MSFT	Stock	27.68	27.72	27.54	27.63	8378448.0
2004-02-02 13:00:00	MSFT	Stock	27.63	27.64	27.52	27.57	3980201.0
2004-02-02 14:00:00	MSFT	Stock	27.57	27.62	27.49	27.56	7519508.0
2004-02-02 15:00:00	MSFT	Stock	27.57	27.59	27.24	27.39	16603626.0
2004-02-02 16:00:00	MSFT	Stock	27.43	27.45	27.35	27.37	2669397.0
2004-02-02 17:00:00	MSFT	Stock	27.37	27.5053	27.37	27.39	515481.0
2004-02-02 18:00:00	MSFT	Stock	27.42	27.42	27.41	27.42	5500.0
2004-02-02 08:00:00	NVDA	Stock	0.1854	0.1855	0.1847	0.1855	6360000.0
2004-02-02 09:00:00	NVDA	Stock	0.1851	0.1892	0.1851	0.1882	54114000.0
2004-02-02 10:00:00	NVDA	Stock	0.1883	0.1884	0.185	0.1865	75876000.0
2004-02-02 11:00:00	NVDA	Stock	0.1865	0.192	0.186	0.1917	84218400.0
2004-02-02 12:00:00	NVDA	Stock	0.1917	0.1921	0.1907	0.191	67640400.0
2004-02-02 13:00:00	NVDA	Stock	0.1911	0.1918	0.1904	0.1916	37848840.0
2004-02-02 14:00:00	NVDA	Stock	0.1917	0.1917	0.1905	0.1912	58912080.0
2004-02-02 15:00:00	NVDA	Stock	0.1912	0.1913	0.1883	0.1888	162205560.0
2004-02-02 16:00:00	NVDA	Stock	0.1888	0.1891	0.1877	0.1877	2609040.0
2004-02-02 17:00:00	NVDA	Stock	0.1884	0.189	0.1884	0.1885	1198080.0
2004-02-02 08:00:00	AMZN	Stock	2.525	2.5375	2.5201	2.5375	100000.0
2004-02-02 09:00:00	AMZN	Stock	2.5375	2.5375	2.4635	2.476	27561440.0
2004-02-02 10:00:00	AMZN	Stock	2.4765	2.477	2.4325	2.4465	45658000.0
2004-02-02 11:00:00	AMZN	Stock	2.4465	2.4795	2.4435	2.4695	26623400.0
2004-02-02 12:00:00	AMZN	Stock	2.469	2.4825	2.465	2.478	18478580.0
2004-02-02 13:00:00	AMZN	Stock	2.4775	2.4875	2.467	2.473	13312980.0
2004-02-02 14:00:00	AMZN	Stock	2.4715	2.478	2.4435	2.4555	19010280.0
2004-02-02 15:00:00	AMZN	Stock	2.455	2.4595	2.3975	2.407	69191140.0
2004-02-02 16:00:00	AMZN	Stock	2.407	2.417	2.405	2.4075	2443680.0
2004-02-02 17:00:00	AMZN	Stock	2.4075	2.4441	2.4055	2.4065	319940.0
2004-02-02 18:00:00	AMZN	Stock	2.4065	2.4065	2.4055	2.4055	48000.0
2004-02-02 09:00:00	CL	Stock	25.64	25.665	25.525	25.53	411000.0
2004-02-02 10:00:00	CL	Stock	25.53	25.56	25.305	25.35	1241600.0
2004-02-02 11:00:00	CL	Stock	25.34	25.45	25.32	25.42	826600.0
2004-02-02 12:00:00	CL	Stock	25.425	25.49	25.375	25.49	2059000.0
2004-02-02 13:00:00	CL	Stock	25.495	25.52	25.44	25.46	718400.0
2004-02-02 14:00:00	CL	Stock	25.46	25.5	25.27	25.275	1143200.0
2004-02-02 15:00:00	CL	Stock	25.275	25.39	24.9995	25.18	3092600.0

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

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