PREVIEW / stock_1hour / 2005-03-22

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-03-22.parquet
  size:    538 KB
  rows:    25,437
  symbols: 1,944

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-03-22 08:00:00	AAPL	Stock	1.5625	1.5648	1.5568	1.5589	5866532.0
2005-03-22 09:00:00	AAPL	Stock	1.56	1.57	1.5482	1.5539	73007144.0
2005-03-22 10:00:00	AAPL	Stock	1.5543	1.5579	1.5325	1.5554	122841824.0
2005-03-22 11:00:00	AAPL	Stock	1.555	1.5557	1.545	1.5486	46199076.0
2005-03-22 12:00:00	AAPL	Stock	1.5486	1.5525	1.5468	1.5482	15802500.0
2005-03-22 13:00:00	AAPL	Stock	1.5482	1.5568	1.5436	1.5557	42186172.0
2005-03-22 14:00:00	AAPL	Stock	1.5554	1.5625	1.5386	1.5443	104151684.0
2005-03-22 15:00:00	AAPL	Stock	1.5439	1.5457	1.5243	1.5289	129079580.0
2005-03-22 16:00:00	AAPL	Stock	1.5289	1.5462	1.5236	1.5286	3858596.0
2005-03-22 17:00:00	AAPL	Stock	1.5289	1.5448	1.5271	1.5275	484932.0
2005-03-22 18:00:00	AAPL	Stock	1.5314	1.5314	1.5268	1.5279	11200.0
2005-03-22 08:00:00	MSFT	Stock	24.21	24.24	24.135	24.23	1076032.0
2005-03-22 09:00:00	MSFT	Stock	24.22	24.27	24.12	24.14	8222020.0
2005-03-22 10:00:00	MSFT	Stock	24.15	24.19	24.09	24.19	17018162.0
2005-03-22 11:00:00	MSFT	Stock	24.19	24.25	24.14	24.15	14261673.0
2005-03-22 12:00:00	MSFT	Stock	24.16	24.19	24.12	24.15	5280823.0
2005-03-22 13:00:00	MSFT	Stock	24.15	24.22	24.13	24.199	7748776.0
2005-03-22 14:00:00	MSFT	Stock	24.19	24.26	24.11	24.13	19352794.0
2005-03-22 15:00:00	MSFT	Stock	24.139	24.141	23.96	23.98	24631639.0
2005-03-22 16:00:00	MSFT	Stock	23.99	24.144	23.95	23.97	1258622.0
2005-03-22 17:00:00	MSFT	Stock	23.96	24.143	23.94	24.0	313829.0
2005-03-22 18:00:00	MSFT	Stock	23.97	24.13	23.95	23.96	15657.0
2005-03-22 08:00:00	NVDA	Stock	0.2076	0.2076	0.2061	0.2071	180000.0
2005-03-22 09:00:00	NVDA	Stock	0.2077	0.2104	0.2067	0.2082	133104480.0
2005-03-22 10:00:00	NVDA	Stock	0.2082	0.2082	0.2052	0.2068	97817640.0
2005-03-22 11:00:00	NVDA	Stock	0.2068	0.2081	0.2062	0.2076	62433720.0
2005-03-22 12:00:00	NVDA	Stock	0.2077	0.2083	0.2074	0.208	42078600.0
2005-03-22 13:00:00	NVDA	Stock	0.208	0.2083	0.2074	0.2081	63468240.0
2005-03-22 14:00:00	NVDA	Stock	0.2081	0.2083	0.2056	0.2064	88346400.0
2005-03-22 15:00:00	NVDA	Stock	0.2063	0.2071	0.2038	0.2046	126438120.0
2005-03-22 16:00:00	NVDA	Stock	0.2046	0.2052	0.2044	0.2044	2189160.0
2005-03-22 17:00:00	NVDA	Stock	0.2067	0.2067	0.2046	0.2046	2187840.0
2005-03-22 08:00:00	AMZN	Stock	1.6775	1.6775	1.6775	1.6775	2000.0
2005-03-22 09:00:00	AMZN	Stock	1.692	1.697	1.68	1.682	12055400.0
2005-03-22 10:00:00	AMZN	Stock	1.682	1.695	1.6795	1.6945	15773960.0
2005-03-22 11:00:00	AMZN	Stock	1.6945	1.695	1.6875	1.689	12959780.0
2005-03-22 12:00:00	AMZN	Stock	1.689	1.69	1.6845	1.685	6059180.0
2005-03-22 13:00:00	AMZN	Stock	1.685	1.69	1.682	1.6885	6920680.0
2005-03-22 14:00:00	AMZN	Stock	1.688	1.692	1.6665	1.6695	20503760.0
2005-03-22 15:00:00	AMZN	Stock	1.669	1.678	1.6535	1.6575	31442240.0
2005-03-22 16:00:00	AMZN	Stock	1.6585	1.6782	1.655	1.6782	1250420.0
2005-03-22 17:00:00	AMZN	Stock	1.6525	1.6575	1.652	1.6575	134700.0
2005-03-22 18:00:00	AMZN	Stock	1.6585	1.6585	1.6585	1.6585	10000.0
2005-03-22 09:00:00	CL	Stock	25.715	25.83	25.68	25.7	338200.0
2005-03-22 10:00:00	CL	Stock	25.7	25.75	25.64	25.7	379800.0
2005-03-22 11:00:00	CL	Stock	25.7	25.715	25.625	25.645	437400.0
2005-03-22 12:00:00	CL	Stock	25.65	25.7	25.63	25.635	572600.0
2005-03-22 13:00:00	CL	Stock	25.635	25.65	25.625	25.65	264600.0
2005-03-22 14:00:00	CL	Stock	25.65	25.65	25.3	25.375	1079600.0
2005-03-22 15:00:00	CL	Stock	25.38	25.415	25.275	25.325	1260400.0

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

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