PREVIEW / stock_1hour / 2005-04-04

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-04.parquet
  size:    536 KB
  rows:    25,397
  symbols: 1,957

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-04-04 08:00:00	AAPL	Stock	1.4607	1.4607	1.4129	1.4593	2410352.0
2005-04-04 09:00:00	AAPL	Stock	1.4589	1.475	1.4343	1.4589	122578820.0
2005-04-04 10:00:00	AAPL	Stock	1.4586	1.4664	1.4482	1.4607	105224420.0
2005-04-04 11:00:00	AAPL	Stock	1.4604	1.465	1.4432	1.4543	86874032.0
2005-04-04 12:00:00	AAPL	Stock	1.4536	1.4625	1.4525	1.4589	62962060.0
2005-04-04 13:00:00	AAPL	Stock	1.4589	1.4671	1.4539	1.4671	46400732.0
2005-04-04 14:00:00	AAPL	Stock	1.4671	1.4754	1.4611	1.4682	65184672.0
2005-04-04 15:00:00	AAPL	Stock	1.4682	1.4711	1.4604	1.4671	66503696.0
2005-04-04 16:00:00	AAPL	Stock	1.4675	1.4682	1.4554	1.4675	4328464.0
2005-04-04 17:00:00	AAPL	Stock	1.4675	1.4679	1.4671	1.4671	116256.0
2005-04-04 18:00:00	AAPL	Stock	1.4679	1.4689	1.4679	1.4689	46200.0
2005-04-04 08:00:00	MSFT	Stock	24.09	24.12	24.09	24.09	27860.0
2005-04-04 09:00:00	MSFT	Stock	24.11	24.16	24.03	24.04	6747829.0
2005-04-04 10:00:00	MSFT	Stock	24.03	24.08	23.94	24.08	12805172.0
2005-04-04 11:00:00	MSFT	Stock	24.07	24.13	24.01	24.052	6940452.0
2005-04-04 12:00:00	MSFT	Stock	24.06	24.11	24.04	24.05	6987910.0
2005-04-04 13:00:00	MSFT	Stock	24.05	24.12	24.0	24.12	5704313.0
2005-04-04 14:00:00	MSFT	Stock	24.12	24.26	24.11	24.22	10457423.0
2005-04-04 15:00:00	MSFT	Stock	24.22	24.26	24.2	24.22	8830072.0
2005-04-04 16:00:00	MSFT	Stock	24.24	24.24	24.18	24.21	1512563.0
2005-04-04 17:00:00	MSFT	Stock	24.22	24.25	24.21	24.21	13665.0
2005-04-04 18:00:00	MSFT	Stock	24.21	24.21	24.2	24.2	2718.0
2005-04-04 08:00:00	NVDA	Stock	0.1958	0.1958	0.1958	0.1958	36000.0
2005-04-04 09:00:00	NVDA	Stock	0.1961	0.1974	0.1924	0.1937	48853440.0
2005-04-04 10:00:00	NVDA	Stock	0.1937	0.194	0.1906	0.1928	138389640.0
2005-04-04 11:00:00	NVDA	Stock	0.1927	0.1942	0.1922	0.1927	56548800.0
2005-04-04 12:00:00	NVDA	Stock	0.1927	0.1936	0.1919	0.1932	27384000.0
2005-04-04 13:00:00	NVDA	Stock	0.1931	0.1932	0.1918	0.1932	26991360.0
2005-04-04 14:00:00	NVDA	Stock	0.1932	0.1946	0.1931	0.1934	39823560.0
2005-04-04 15:00:00	NVDA	Stock	0.1934	0.1952	0.1933	0.1949	72813840.0
2005-04-04 16:00:00	NVDA	Stock	0.1949	0.195	0.1943	0.1943	5149800.0
2005-04-04 17:00:00	NVDA	Stock	0.1946	0.1947	0.1946	0.1947	528000.0
2005-04-04 08:00:00	AMZN	Stock	1.7005	1.7005	1.6865	1.7	124640.0
2005-04-04 09:00:00	AMZN	Stock	1.7	1.7095	1.695	1.7025	6627460.0
2005-04-04 10:00:00	AMZN	Stock	1.702	1.726	1.6905	1.72	23332880.0
2005-04-04 11:00:00	AMZN	Stock	1.721	1.7255	1.708	1.7125	13733100.0
2005-04-04 12:00:00	AMZN	Stock	1.7125	1.726	1.7115	1.724	11152100.0
2005-04-04 13:00:00	AMZN	Stock	1.724	1.744	1.72	1.7435	15425500.0
2005-04-04 14:00:00	AMZN	Stock	1.7435	1.754	1.743	1.75	32805320.0
2005-04-04 15:00:00	AMZN	Stock	1.7505	1.759	1.7495	1.75	36527980.0
2005-04-04 16:00:00	AMZN	Stock	1.7515	1.755	1.7485	1.7505	4033500.0
2005-04-04 17:00:00	AMZN	Stock	1.752	1.7555	1.75	1.75	39400.0
2005-04-04 18:00:00	AMZN	Stock	1.7505	1.7505	1.7505	1.7505	12000.0
2005-04-04 09:00:00	CL	Stock	25.775	25.815	25.65	25.725	271800.0
2005-04-04 10:00:00	CL	Stock	25.73	25.925	25.73	25.855	429800.0
2005-04-04 11:00:00	CL	Stock	25.85	25.92	25.79	25.905	404400.0
2005-04-04 12:00:00	CL	Stock	25.91	25.915	25.825	25.845	270600.0
2005-04-04 13:00:00	CL	Stock	25.845	25.865	25.73	25.845	391000.0
2005-04-04 14:00:00	CL	Stock	25.84	25.9	25.81	25.865	284000.0
2005-04-04 15:00:00	CL	Stock	25.865	25.925	25.82	25.865	408000.0

> showing 50 of 25,397 rows — these rows as CSV

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