PREVIEW / stock_1hour / 2004-01-23

all stock 1-hour files

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

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-23 08:00:00	AAPL	Stock	0.4052	0.4052	0.4052	0.4052	56000.0
2004-01-23 09:00:00	AAPL	Stock	0.3982	0.4027	0.3973	0.4002	24835440.0
2004-01-23 10:00:00	AAPL	Stock	0.4	0.4061	0.3998	0.4036	35951664.0
2004-01-23 11:00:00	AAPL	Stock	0.4036	0.4041	0.4009	0.4034	25798976.0
2004-01-23 12:00:00	AAPL	Stock	0.4032	0.405	0.4009	0.4023	32357640.0
2004-01-23 13:00:00	AAPL	Stock	0.4029	0.4034	0.401	0.4011	11886896.0
2004-01-23 14:00:00	AAPL	Stock	0.4011	0.403	0.4004	0.4013	22177064.0
2004-01-23 15:00:00	AAPL	Stock	0.4013	0.4045	0.4004	0.4036	59248560.0
2004-01-23 16:00:00	AAPL	Stock	0.4036	0.4048	0.4029	0.4043	3774568.0
2004-01-23 18:00:00	AAPL	Stock	0.4036	0.4038	0.4036	0.4038	39200.0
2004-01-23 08:00:00	MSFT	Stock	27.6	28.39	27.6	28.25	2708424.0
2004-01-23 09:00:00	MSFT	Stock	28.25	28.62	27.83	28.53	26807751.0
2004-01-23 10:00:00	MSFT	Stock	28.54	28.76	28.52	28.67	22638841.0
2004-01-23 11:00:00	MSFT	Stock	28.66	28.7	28.52	28.55	16040137.0
2004-01-23 12:00:00	MSFT	Stock	28.55	28.59	28.4	28.41	12248597.0
2004-01-23 13:00:00	MSFT	Stock	28.41	28.6	28.37	28.48	13610191.0
2004-01-23 14:00:00	MSFT	Stock	28.48	28.56	28.39	28.48	10381997.0
2004-01-23 15:00:00	MSFT	Stock	28.47	28.5	28.28	28.48	15520039.0
2004-01-23 16:00:00	MSFT	Stock	28.48	28.58	28.42	28.45	2270997.0
2004-01-23 17:00:00	MSFT	Stock	28.45	28.52	28.42	28.46	17600.0
2004-01-23 18:00:00	MSFT	Stock	28.5	28.51	28.45	28.51	4350.0
2004-01-23 08:00:00	NVDA	Stock	0.1967	0.1971	0.1967	0.1971	142680.0
2004-01-23 09:00:00	NVDA	Stock	0.1971	0.1998	0.1925	0.195	78396840.0
2004-01-23 10:00:00	NVDA	Stock	0.1951	0.1977	0.194	0.1951	103236120.0
2004-01-23 11:00:00	NVDA	Stock	0.1949	0.1962	0.1943	0.1952	59149560.0
2004-01-23 12:00:00	NVDA	Stock	0.1952	0.1956	0.1936	0.1938	46204800.0
2004-01-23 13:00:00	NVDA	Stock	0.1937	0.1952	0.1937	0.1942	40402200.0
2004-01-23 14:00:00	NVDA	Stock	0.1942	0.1947	0.1927	0.1932	44509920.0
2004-01-23 15:00:00	NVDA	Stock	0.1931	0.1938	0.192	0.1932	80480760.0
2004-01-23 16:00:00	NVDA	Stock	0.1925	0.1931	0.1918	0.1926	17287920.0
2004-01-23 17:00:00	NVDA	Stock	0.1934	0.1935	0.1933	0.1933	408000.0
2004-01-23 18:00:00	NVDA	Stock	0.1934	0.1935	0.1934	0.1935	216000.0
2004-01-23 08:00:00	AMZN	Stock	2.8475	2.8575	2.8475	2.854	36000.0
2004-01-23 09:00:00	AMZN	Stock	2.8575	2.861	2.831	2.84	13077700.0
2004-01-23 10:00:00	AMZN	Stock	2.841	2.87	2.838	2.867	21051800.0
2004-01-23 11:00:00	AMZN	Stock	2.8658	2.867	2.8455	2.863	17162420.0
2004-01-23 12:00:00	AMZN	Stock	2.863	2.8805	2.861	2.867	15304280.0
2004-01-23 13:00:00	AMZN	Stock	2.8675	2.8705	2.8555	2.856	9705940.0
2004-01-23 14:00:00	AMZN	Stock	2.855	2.865	2.85	2.8625	13233460.0
2004-01-23 15:00:00	AMZN	Stock	2.862	2.865	2.8445	2.857	23415220.0
2004-01-23 16:00:00	AMZN	Stock	2.8555	2.858	2.8506	2.8568	2126960.0
2004-01-23 17:00:00	AMZN	Stock	2.858	2.858	2.8565	2.8565	294720.0
2004-01-23 18:00:00	AMZN	Stock	2.8535	2.858	2.8535	2.858	4000.0
2004-01-23 09:00:00	CL	Stock	25.665	25.775	25.635	25.745	398200.0
2004-01-23 10:00:00	CL	Stock	25.745	25.8	25.625	25.685	376200.0
2004-01-23 11:00:00	CL	Stock	25.67	25.695	25.62	25.63	404800.0
2004-01-23 12:00:00	CL	Stock	25.625	25.64	25.51	25.53	358800.0
2004-01-23 13:00:00	CL	Stock	25.535	25.59	25.5	25.5	338600.0
2004-01-23 14:00:00	CL	Stock	25.5	25.555	25.5	25.515	428800.0
2004-01-23 15:00:00	CL	Stock	25.51	25.53	25.475	25.495	873000.0

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

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