PREVIEW / stock_daily / 2006-11-22

all stock daily files

  file:    by_date/stock_daily/2006/2006-11-22.parquet
  size:    154 KB
  rows:    4,597
  symbols: 2,917

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2006-11-22	AAPL	Stock	3.1782	3.2411	3.1375	3.2254	671941200.0
2006-11-22	MSFT	Stock	29.97	30.0	29.82	29.92	43907200.0
2006-11-22	NVDA	Stock	0.6037	0.6125	0.6005	0.6118	240258000.0
2006-11-22	AMZN	Stock	2.125	2.149	2.109	2.148	90712000.0
2006-11-22	CL	Stock	33.12	33.4	33.04	33.37	3224800.0
2006-11-22	A	Stock	23.9986	24.0343	23.8197	23.9056	5975332.0
2006-11-22	AABA-DELISTED	Stock	27.5100002288818	28.5599994659424	27.2900009155273	28.4899997711182	32055800.0
2006-11-22	AACC-DELISTED	Stock	17.36	17.53	17.35	17.42	67057.0
2006-11-22	AACQ-DELISTED	Stock	5.48	5.49	5.48	5.49	114500.0
2006-11-22	AACQW-DELISTED	Stock	0.65	0.65	0.64	0.64	9000.0
2006-11-22	AAI-DELISTED	Stock	13.3	13.39	13.05	13.27	1694500.0
2006-11-22	AAIC-DELISTED	Stock	147.8	150.2	146.6	149.8	1584800.0
2006-11-22	AAME	Stock	2.78	2.78	2.77	2.77	2800.0
2006-11-22	AAON	Stock	3.6872	3.6872	3.6649	3.6754	43284.0
2006-11-22	AAP	Stock	37.96	38.16	37.76	38.15	420000.0
2006-11-22	AATI-DELISTED	Stock	5.69	5.79	5.61	5.62	93074.0
2006-11-22	AAU-DELISTED	Stock	2.51	2.62	2.5001	2.55	43500.0
2006-11-22	AAUAF-DELISTED	Stock	2.51	2.62	2.5001	2.55	43500.0
2006-11-22	AAV-DELISTED	Stock	12.75	13.1	12.32	12.57	1352800.0
2006-11-22	AAWW-DELISTED	Stock	40.04	40.33	39.46	39.89	92372.0
2006-11-22	AAXN-DELISTED	Stock	8.81999969482422	8.85999965667725	8.6899995803833	8.85000038146973	1326600.0
2006-11-22	AB	Stock	76.99	77.16	76.31	77.0	131000.0
2006-11-22	ABAX-DELISTED	Stock	19.99	20.28	19.895	20.07	120210.0
2006-11-22	ABB-DELISTED	Stock	16.19	16.24	16.16	16.2	4400800.0
2006-11-22	ABBC-DELISTED	Stock	16.27	16.27	16.17	16.2	4727.0
2006-11-22	ABC-DELISTED	Stock	22.89	23.04	22.8	22.92	1928000.0
2006-11-22	ABCB	Stock	27.7592	27.7592	27.234	27.2437	9048.0
2006-11-22	ABCO-DELISTED	Stock	28.47	29.03	28.38	28.85	1148065.0
2006-11-22	ABCW-DELISTED	Stock	29.38	29.38	28.75	28.85	36760.0
2006-11-22	ABD-DELISTED	Stock	25.35	25.75	25.14	25.32	150220.0
2006-11-22	ABE-DELISTED	Stock	17.1	17.25	16.9671	17.05	25000.0
2006-11-22	ABFS-DELISTED	Stock	39.75	39.8	39.03	39.27	278517.0
2006-11-22	ABG	Stock	24.09	24.14	23.89	24.05	219100.0
2006-11-22	ABK-DELISTED	Stock	84.45	84.52	83.63	84.06	488800.0
2006-11-22	ABM	Stock	20.81	20.84	20.62	20.71	36800.0
2006-11-22	ABMD-DELISTED	Stock	12.81	12.84	12.63	12.7	73140.0
2006-11-22	ABP-DELISTED	Stock	3.53	3.62	3.5	3.55	124000.0
2006-11-22	ABR	Stock	28.36	28.36	28.05	28.17	90900.0
2006-11-22	ABT	Stock	22.7329	22.8433	22.6849	22.8145	4512297.0
2006-11-22	ABTL-DELISTED	Stock	15.225	15.876	15.175	15.475	32747.0
2006-11-22	ABV-DELISTED	Stock	46.2	46.5	46.01	46.39	265000.0
2006-11-22	ABVA-DELISTED	Stock	16.25	16.48	16.25	16.4	3272.0
2006-11-22	ABX-DELISTED	Stock	29.42	29.47	28.81	29.01	3923600.0
2006-11-22	ACAD	Stock	9.72	9.75	9.2	9.32	134100.0
2006-11-22	ACAP-DELISTED	Stock	39.04	39.04	38.01	38.29	22481.0
2006-11-22	ACAS-DELISTED	Stock	44.56	44.87	44.36	44.86	633649.0
2006-11-22	ACAT-DELISTED	Stock	17.55	17.65	17.47	17.6	53799.0
2006-11-22	ACC-DELISTED	Stock	28.56	28.65	28.24	28.45	179700.0
2006-11-22	ACCL-DELISTED	Stock	6.33	6.36	6.31	6.34	27276.0
2006-11-22	ACCO	Stock	25.35	25.75	25.17	25.32	166400.0

> showing 50 of 4,597 rows — these rows as CSV

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