PREVIEW / stock_1hour / 2005-02-01

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-02-01.parquet
  size:    561 KB
  rows:    26,457
  symbols: 1,925

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
2005-02-01 08:00:00	AAPL	Stock	1.3761	1.3761	1.3688	1.3716	2446304.0
2005-02-01 09:00:00	AAPL	Stock	1.3732	1.3888	1.3707	1.3746	193395832.0
2005-02-01 10:00:00	AAPL	Stock	1.3745	1.3839	1.3675	1.3786	146528648.0
2005-02-01 11:00:00	AAPL	Stock	1.3788	1.3813	1.3736	1.3788	79204720.0
2005-02-01 12:00:00	AAPL	Stock	1.3784	1.3818	1.3759	1.3779	49080976.0
2005-02-01 13:00:00	AAPL	Stock	1.3784	1.3836	1.3777	1.3836	39106424.0
2005-02-01 14:00:00	AAPL	Stock	1.3832	1.3875	1.3796	1.38	67487168.0
2005-02-01 15:00:00	AAPL	Stock	1.38	1.3854	1.3764	1.3845	88418344.0
2005-02-01 16:00:00	AAPL	Stock	1.3841	1.3893	1.3829	1.3882	3061464.0
2005-02-01 17:00:00	AAPL	Stock	1.3877	1.3904	1.3845	1.3902	1039640.0
2005-02-01 18:00:00	AAPL	Stock	1.388	1.3902	1.3838	1.3893	522704.0
2005-02-01 08:00:00	MSFT	Stock	26.28	26.34	26.25	26.28	134938.0
2005-02-01 09:00:00	MSFT	Stock	26.28	26.34	26.22	26.26	5904399.0
2005-02-01 10:00:00	MSFT	Stock	26.27	26.34	26.22	26.3	9227474.0
2005-02-01 11:00:00	MSFT	Stock	26.3	26.41	26.3	26.38	7126069.0
2005-02-01 12:00:00	MSFT	Stock	26.37	26.4	26.29	26.39	6920813.0
2005-02-01 13:00:00	MSFT	Stock	26.39	26.43	26.35	26.42	6467773.0
2005-02-01 14:00:00	MSFT	Stock	26.42	26.43	26.35	26.39	8403701.0
2005-02-01 15:00:00	MSFT	Stock	26.4	26.42	26.33	26.38	11885477.0
2005-02-01 16:00:00	MSFT	Stock	26.38	26.43	26.35	26.41	552010.0
2005-02-01 17:00:00	MSFT	Stock	26.41	26.42	26.39	26.42	81479.0
2005-02-01 18:00:00	MSFT	Stock	26.42	26.42	26.36	26.38	45337.0
2005-02-01 08:00:00	NVDA	Stock	0.1908	0.1908	0.1908	0.1908	324000.0
2005-02-01 09:00:00	NVDA	Stock	0.191	0.1932	0.1897	0.1915	81408360.0
2005-02-01 10:00:00	NVDA	Stock	0.1914	0.1937	0.1911	0.193	55094160.0
2005-02-01 11:00:00	NVDA	Stock	0.1931	0.1942	0.1928	0.1937	51026400.0
2005-02-01 12:00:00	NVDA	Stock	0.1937	0.1942	0.1921	0.1925	33587040.0
2005-02-01 13:00:00	NVDA	Stock	0.1925	0.1945	0.1924	0.1941	38404200.0
2005-02-01 14:00:00	NVDA	Stock	0.1941	0.1954	0.1938	0.1942	77965800.0
2005-02-01 15:00:00	NVDA	Stock	0.1942	0.1947	0.193	0.1946	65616600.0
2005-02-01 16:00:00	NVDA	Stock	0.1946	0.2067	0.1946	0.2063	98486400.0
2005-02-01 17:00:00	NVDA	Stock	0.2064	0.2067	0.2042	0.205	7899120.0
2005-02-01 18:00:00	NVDA	Stock	0.205	0.2062	0.2029	0.2029	4422960.0
2005-02-01 08:00:00	AMZN	Stock	2.161	2.1625	2.1605	2.1605	50760.0
2005-02-01 09:00:00	AMZN	Stock	2.1505	2.1635	2.1415	2.148	18801680.0
2005-02-01 10:00:00	AMZN	Stock	2.148	2.152	2.1335	2.1355	20967520.0
2005-02-01 11:00:00	AMZN	Stock	2.135	2.145	2.131	2.134	16056200.0
2005-02-01 12:00:00	AMZN	Stock	2.135	2.1425	2.134	2.14	9813740.0
2005-02-01 13:00:00	AMZN	Stock	2.1405	2.1475	2.1385	2.1475	15363260.0
2005-02-01 14:00:00	AMZN	Stock	2.147	2.1475	2.1415	2.144	16196820.0
2005-02-01 15:00:00	AMZN	Stock	2.144	2.144	2.119	2.1215	33022960.0
2005-02-01 16:00:00	AMZN	Stock	2.123	2.145	2.112	2.1401	2745320.0
2005-02-01 17:00:00	AMZN	Stock	2.14	2.1425	2.124	2.124	130720.0
2005-02-01 18:00:00	AMZN	Stock	2.1425	2.143	2.1425	2.1425	40000.0
2005-02-01 09:00:00	CL	Stock	26.27	26.375	26.1	26.365	624200.0
2005-02-01 10:00:00	CL	Stock	26.37	26.585	26.36	26.45	1620200.0
2005-02-01 11:00:00	CL	Stock	26.455	26.53	26.335	26.335	758600.0
2005-02-01 12:00:00	CL	Stock	26.345	26.54	26.335	26.535	407000.0
2005-02-01 13:00:00	CL	Stock	26.53	26.585	26.475	26.58	306200.0
2005-02-01 14:00:00	CL	Stock	26.585	26.625	26.395	26.4	598200.0

> showing 50 of 26,457 rows — these rows as CSV

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