PREVIEW / stock_1hour / 2005-04-11

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-11.parquet
  size:    521 KB
  rows:    25,017
  symbols: 1,960

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-11 07:00:00	AAPL	Stock	1.5661	1.5661	1.5643	1.5661	86800.0
2005-04-11 08:00:00	AAPL	Stock	1.5707	1.5871	1.5643	1.5782	5561416.0
2005-04-11 09:00:00	AAPL	Stock	1.5786	1.5821	1.5511	1.5546	132453972.0
2005-04-11 10:00:00	AAPL	Stock	1.5543	1.58	1.5189	1.5193	180925024.0
2005-04-11 11:00:00	AAPL	Stock	1.5196	1.5264	1.5125	1.52	112244300.0
2005-04-11 12:00:00	AAPL	Stock	1.52	1.5354	1.5168	1.5354	75115656.0
2005-04-11 13:00:00	AAPL	Stock	1.5354	1.5411	1.52	1.5211	67139716.0
2005-04-11 14:00:00	AAPL	Stock	1.5211	1.5225	1.5089	1.5165	67307604.0
2005-04-11 15:00:00	AAPL	Stock	1.5168	1.5171	1.4968	1.4973	156115176.0
2005-04-11 16:00:00	AAPL	Stock	1.4975	1.5043	1.4893	1.5	4138568.0
2005-04-11 17:00:00	AAPL	Stock	1.4996	1.5025	1.4993	1.5025	545244.0
2005-04-11 18:00:00	AAPL	Stock	1.5025	1.5082	1.5007	1.5071	1862000.0
2005-04-11 08:00:00	MSFT	Stock	25.05	25.05	25.03	25.04	3500.0
2005-04-11 09:00:00	MSFT	Stock	25.04	25.11	24.98	25.03	5846302.0
2005-04-11 10:00:00	MSFT	Stock	25.03	25.09	24.86	25.06	9316043.0
2005-04-11 11:00:00	MSFT	Stock	25.05	25.09	25.01	25.01	3574570.0
2005-04-11 12:00:00	MSFT	Stock	25.019	25.11	25.011	25.041	4091953.0
2005-04-11 13:00:00	MSFT	Stock	25.04	25.08	24.91	24.93	5576873.0
2005-04-11 14:00:00	MSFT	Stock	24.92	25.0	24.92	24.96	5790065.0
2005-04-11 15:00:00	MSFT	Stock	24.97	25.03	24.93	24.98	8328902.0
2005-04-11 16:00:00	MSFT	Stock	24.98	25.05	24.96	24.97	751020.0
2005-04-11 17:00:00	MSFT	Stock	24.97	24.98	24.97	24.97	400907.0
2005-04-11 08:00:00	NVDA	Stock	0.1948	0.1967	0.1942	0.1943	192000.0
2005-04-11 09:00:00	NVDA	Stock	0.1958	0.1975	0.193	0.194	50329560.0
2005-04-11 10:00:00	NVDA	Stock	0.1941	0.1962	0.1937	0.1961	55749720.0
2005-04-11 11:00:00	NVDA	Stock	0.196	0.1961	0.193	0.1931	56701560.0
2005-04-11 12:00:00	NVDA	Stock	0.1932	0.1934	0.1929	0.1932	24758400.0
2005-04-11 13:00:00	NVDA	Stock	0.1931	0.1934	0.1912	0.1912	26885760.0
2005-04-11 14:00:00	NVDA	Stock	0.1912	0.1928	0.191	0.1922	28797960.0
2005-04-11 15:00:00	NVDA	Stock	0.1922	0.1928	0.191	0.1914	73908720.0
2005-04-11 16:00:00	NVDA	Stock	0.1914	0.1916	0.191	0.191	2580720.0
2005-04-11 17:00:00	NVDA	Stock	0.191	0.1915	0.1909	0.1915	236040.0
2005-04-11 18:00:00	NVDA	Stock	0.1912	0.1912	0.1912	0.1912	153000.0
2005-04-11 09:00:00	AMZN	Stock	1.7345	1.75	1.7275	1.7385	11931480.0
2005-04-11 10:00:00	AMZN	Stock	1.739	1.7435	1.718	1.727	14248520.0
2005-04-11 11:00:00	AMZN	Stock	1.7266	1.7275	1.7205	1.726	4289160.0
2005-04-11 12:00:00	AMZN	Stock	1.726	1.739	1.7255	1.734	7599720.0
2005-04-11 13:00:00	AMZN	Stock	1.7344	1.735	1.722	1.722	4419420.0
2005-04-11 14:00:00	AMZN	Stock	1.7215	1.7425	1.7215	1.74	9865640.0
2005-04-11 15:00:00	AMZN	Stock	1.7395	1.74	1.7295	1.7305	11126220.0
2005-04-11 16:00:00	AMZN	Stock	1.73	1.7305	1.7275	1.73	1114520.0
2005-04-11 09:00:00	CL	Stock	26.855	26.87	26.725	26.75	261200.0
2005-04-11 10:00:00	CL	Stock	26.755	26.875	26.72	26.845	462000.0
2005-04-11 11:00:00	CL	Stock	26.84	26.874	26.77	26.775	294400.0
2005-04-11 12:00:00	CL	Stock	26.78	26.975	26.78	26.96	261800.0
2005-04-11 13:00:00	CL	Stock	26.96	27.0	26.91	26.95	285400.0
2005-04-11 14:00:00	CL	Stock	26.955	27.035	26.935	26.955	457600.0
2005-04-11 15:00:00	CL	Stock	26.955	26.955	26.83	26.875	645200.0
2005-04-11 16:00:00	CL	Stock	26.895	26.895	26.875	26.875	600.0

> showing 49 of 25,017 rows — these rows as CSV

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