PREVIEW / stock_1hour / 2004-01-26

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-01-26.parquet
  size:    518 KB
  rows:    23,715
  symbols: 1,719

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-01-26 08:00:00	AAPL	Stock	0.4014	0.4029	0.4014	0.4029	112000.0
2004-01-26 09:00:00	AAPL	Stock	0.4032	0.4068	0.4005	0.4054	26121480.0
2004-01-26 10:00:00	AAPL	Stock	0.4054	0.4063	0.4025	0.405	41312096.0
2004-01-26 11:00:00	AAPL	Stock	0.4048	0.4079	0.4048	0.4066	33765536.0
2004-01-26 12:00:00	AAPL	Stock	0.4068	0.4098	0.4063	0.4068	25733064.0
2004-01-26 13:00:00	AAPL	Stock	0.4068	0.4091	0.4063	0.4086	22223768.0
2004-01-26 14:00:00	AAPL	Stock	0.4084	0.41	0.4079	0.41	32909968.0
2004-01-26 15:00:00	AAPL	Stock	0.41	0.4118	0.4098	0.4107	72069648.0
2004-01-26 16:00:00	AAPL	Stock	0.4107	0.4116	0.4091	0.4109	6413344.0
2004-01-26 17:00:00	AAPL	Stock	0.4107	0.4109	0.4107	0.4109	683200.0
2004-01-26 18:00:00	AAPL	Stock	0.4105	0.4105	0.4105	0.4105	56000.0
2004-01-26 08:00:00	MSFT	Stock	28.53	28.65	28.42	28.48	75159.0
2004-01-26 09:00:00	MSFT	Stock	28.48	28.73	28.47	28.65	7018160.0
2004-01-26 10:00:00	MSFT	Stock	28.65	28.66	28.34	28.43	9752823.0
2004-01-26 11:00:00	MSFT	Stock	28.421	28.47	28.32	28.38	6058077.0
2004-01-26 12:00:00	MSFT	Stock	28.38	28.46	28.36	28.36	4798561.0
2004-01-26 13:00:00	MSFT	Stock	28.36	28.49	28.35	28.48	4304522.0
2004-01-26 14:00:00	MSFT	Stock	28.48	28.68	28.48	28.67	8418720.0
2004-01-26 15:00:00	MSFT	Stock	28.67	28.8	28.65	28.8	13339799.0
2004-01-26 16:00:00	MSFT	Stock	28.8	28.83	28.5729	28.78	1390725.0
2004-01-26 17:00:00	MSFT	Stock	28.75	28.81	28.72	28.72	36680.0
2004-01-26 18:00:00	MSFT	Stock	28.72	28.74	28.67	28.68	13890.0
2004-01-26 08:00:00	NVDA	Stock	0.1929	0.1929	0.1925	0.1925	76680.0
2004-01-26 09:00:00	NVDA	Stock	0.1925	0.1947	0.1922	0.1937	42969000.0
2004-01-26 10:00:00	NVDA	Stock	0.1936	0.1952	0.1922	0.1947	74463240.0
2004-01-26 11:00:00	NVDA	Stock	0.1947	0.1957	0.1945	0.1953	37224240.0
2004-01-26 12:00:00	NVDA	Stock	0.1953	0.1973	0.1952	0.1967	39294120.0
2004-01-26 13:00:00	NVDA	Stock	0.1967	0.197	0.1958	0.1966	22059000.0
2004-01-26 14:00:00	NVDA	Stock	0.1962	0.1993	0.1962	0.1989	52322400.0
2004-01-26 15:00:00	NVDA	Stock	0.1988	0.2008	0.1984	0.2	109305480.0
2004-01-26 16:00:00	NVDA	Stock	0.2	0.2002	0.1992	0.1992	6308280.0
2004-01-26 17:00:00	NVDA	Stock	0.1992	0.1992	0.1976	0.1983	1250640.0
2004-01-26 08:00:00	AMZN	Stock	2.8555	2.8555	2.825	2.85	40000.0
2004-01-26 09:00:00	AMZN	Stock	2.85	2.85	2.817	2.831	18452140.0
2004-01-26 10:00:00	AMZN	Stock	2.831	2.8345	2.8155	2.8245	19307580.0
2004-01-26 11:00:00	AMZN	Stock	2.8255	2.83	2.815	2.829	11370920.0
2004-01-26 12:00:00	AMZN	Stock	2.8295	2.84	2.825	2.8345	6871340.0
2004-01-26 13:00:00	AMZN	Stock	2.834	2.8465	2.824	2.8375	13828260.0
2004-01-26 14:00:00	AMZN	Stock	2.838	2.854	2.819	2.847	11094480.0
2004-01-26 15:00:00	AMZN	Stock	2.847	2.8575	2.84	2.854	23733340.0
2004-01-26 16:00:00	AMZN	Stock	2.855	2.885	2.8465	2.8595	2219800.0
2004-01-26 17:00:00	AMZN	Stock	2.855	2.8625	2.8475	2.85	406940.0
2004-01-26 18:00:00	AMZN	Stock	2.8595	2.8595	2.8595	2.8595	2000.0
2004-01-26 09:00:00	CL	Stock	25.675	25.725	25.59	25.675	744400.0
2004-01-26 10:00:00	CL	Stock	25.665	25.73	25.625	25.715	998800.0
2004-01-26 11:00:00	CL	Stock	25.71	25.74	25.65	25.675	2061000.0
2004-01-26 12:00:00	CL	Stock	25.68	25.7	25.605	25.65	1017200.0
2004-01-26 13:00:00	CL	Stock	25.655	25.675	25.615	25.63	544200.0
2004-01-26 14:00:00	CL	Stock	25.625	25.75	25.625	25.725	612400.0
2004-01-26 15:00:00	CL	Stock	25.725	25.73	25.68	25.7	843800.0

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

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