PREVIEW / stock_daily / 2006-09-07

all stock daily files

  file:    by_date/stock_daily/2006/2006-09-07.parquet
  size:    149 KB
  rows:    4,494
  symbols: 2,837

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-09-07	AAPL	Stock	2.5214	2.6243	2.5089	2.6	1267957600.0
2006-09-07	MSFT	Stock	25.48	25.7	25.39	25.43	51266900.0
2006-09-07	NVDA	Stock	0.4438	0.4703	0.439	0.4602	742836000.0
2006-09-07	AMZN	Stock	1.5285	1.532	1.484	1.4865	178034000.0
2006-09-07	CL	Stock	30.635	30.85	30.31	30.34	4904400.0
2006-09-07	A	Stock	21.8526	22.1388	21.681	21.774	3284321.0
2006-09-07	AABA-DELISTED	Stock	28.3999996185303	28.5100002288818	27.8199996948242	27.8600006103516	18434400.0
2006-09-07	AACC-DELISTED	Stock	14.61	14.64	14.42	14.47	94550.0
2006-09-07	AACQ-DELISTED	Stock	5.3	5.3	5.3	5.3	1000.0
2006-09-07	AACQW-DELISTED	Stock	0.39	0.39	0.39	0.39	10000.0
2006-09-07	AAI-DELISTED	Stock	10.84	10.84	10.54	10.67	1627600.0
2006-09-07	AAIC-DELISTED	Stock	158.2	159.4	154.0	156.0	1366000.0
2006-09-07	AAON	Stock	3.1855	3.1934	2.9458	2.9524	383484.0
2006-09-07	AAP	Stock	30.93	31.6	30.8	31.25	1835000.0
2006-09-07	AATI-DELISTED	Stock	9.0	9.02	8.5	8.54	163911.0
2006-09-07	AAU-DELISTED	Stock	2.64	2.6401	2.56	2.6	49400.0
2006-09-07	AAUAF-DELISTED	Stock	2.64	2.6401	2.56	2.6	49400.0
2006-09-07	AAV-DELISTED	Stock	15.26	15.3	14.61	14.92	894600.0
2006-09-07	AAWW-DELISTED	Stock	43.53	43.62	42.52	43.14	34387.0
2006-09-07	AAXN-DELISTED	Stock	7.75	7.75	7.5	7.55000019073486	617300.0
2006-09-07	AB	Stock	66.45	66.82	65.94	66.65	139500.0
2006-09-07	ABAX-DELISTED	Stock	22.85	22.87	21.82	22.29	173277.0
2006-09-07	ABB-DELISTED	Stock	13.23	13.36	13.1401	13.24	1645500.0
2006-09-07	ABBC-DELISTED	Stock	14.99	15.09	14.96	15.0	10640.0
2006-09-07	ABC-DELISTED	Stock	22.3	22.475	22.26	22.35	1119000.0
2006-09-07	ABCB	Stock	25.3081	25.4735	24.6856	24.7246	18403.0
2006-09-07	ABCO-DELISTED	Stock	24.62	25.18	24.51	24.86	141924.0
2006-09-07	ABCW-DELISTED	Stock	28.77	28.77	28.55	28.67	24060.0
2006-09-07	ABD-DELISTED	Stock	21.64	21.69	21.18	21.2	182310.0
2006-09-07	ABE-DELISTED	Stock	13.8	13.8	12.9	13.43	40400.0
2006-09-07	ABFS-DELISTED	Stock	43.23	43.51	42.5	43.02	390358.0
2006-09-07	ABG	Stock	20.7	20.81	20.43	20.5	42600.0
2006-09-07	ABK-DELISTED	Stock	84.69	84.98	84.19	84.38	523700.0
2006-09-07	ABM	Stock	18.92	18.95	18.09	18.13	461600.0
2006-09-07	ABMD-DELISTED	Stock	14.88	14.98	14.37	14.53	250905.0
2006-09-07	ABP-DELISTED	Stock	3.95	4.03	3.95	4.0	139900.0
2006-09-07	ABR	Stock	24.95	24.99	24.75	24.8	51100.0
2006-09-07	ABT	Stock	22.8865	22.992	22.7905	22.9824	11818466.0
2006-09-07	ABTL-DELISTED	Stock	12.848	12.996	12.602	12.75	30275.0
2006-09-07	ABV-DELISTED	Stock	44.05	44.28	43.2	43.76	291900.0
2006-09-07	ABVA-DELISTED	Stock	16.35	16.94	16.35	16.93	6853.0
2006-09-07	ABVT-DELISTED	Stock	47.75	47.75	47.75	47.75	100.0
2006-09-07	ABX-DELISTED	Stock	32.9	33.12	32.36	32.4	4367400.0
2006-09-07	ACAD	Stock	7.87	8.05	7.55	8.0	366300.0
2006-09-07	ACAP-DELISTED	Stock	47.3	47.3	46.53	46.56	24001.0
2006-09-07	ACAS-DELISTED	Stock	37.3	37.3	36.1	36.77	1776324.0
2006-09-07	ACAT-DELISTED	Stock	15.65	15.86	15.54	15.78	76184.0
2006-09-07	ACC-DELISTED	Stock	25.2	25.35	24.83	24.84	142700.0
2006-09-07	ACCL-DELISTED	Stock	5.34	5.4	5.25	5.38	64011.0
2006-09-07	ACCO	Stock	21.65	21.7	21.18	21.19	186300.0

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

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