PREVIEW / stock_daily / 2006-12-28

all stock daily files

  file:    by_date/stock_daily/2006/2006-12-28.parquet
  size:    156 KB
  rows:    4,675
  symbols: 2,966

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-12-28	AAPL	Stock	2.865	2.9018	2.8446	2.8882	1119876800.0
2006-12-28	MSFT	Stock	29.86	30.03	29.81	29.98	26690600.0
2006-12-28	NVDA	Stock	0.6258	0.6265	0.6178	0.6207	213912000.0
2006-12-28	AMZN	Stock	2.019	2.0315	1.996	2.0105	90910000.0
2006-12-28	CL	Stock	32.615	32.89	32.54	32.855	1816600.0
2006-12-28	A	Stock	24.6924	25.4149	24.6924	25.2933	5178332.0
2006-12-28	AABA-DELISTED	Stock	25.6200008392334	25.7199993133545	25.2999992370605	25.3600006103516	11908400.0
2006-12-28	AACC-DELISTED	Stock	16.92	17.2	16.81	17.03	85721.0
2006-12-28	AACQ-DELISTED	Stock	5.47	5.51	5.47	5.5	28009.0
2006-12-28	AACQW-DELISTED	Stock	0.51	0.51	0.46	0.48	144500.0
2006-12-28	AAI-DELISTED	Stock	12.09	12.15	11.91	11.98	2228500.0
2006-12-28	AAIC-DELISTED	Stock	161.4	163.0	160.4	162.6	1754300.0
2006-12-28	AAME	Stock	2.98	3.08	2.84	2.96	3700.0
2006-12-28	AAON	Stock	3.5305	3.6148	3.5305	3.5898	63028.0
2006-12-28	AAP	Stock	35.97	36.21	35.59	35.84	379300.0
2006-12-28	AATI-DELISTED	Stock	5.33	5.45	5.3	5.43	282440.0
2006-12-28	AAU-DELISTED	Stock	2.32	2.41	2.2	2.32	71800.0
2006-12-28	AAUAF-DELISTED	Stock	2.32	2.41	2.2	2.32	71800.0
2006-12-28	AAV-DELISTED	Stock	10.85	10.94	10.5	10.699	1472600.0
2006-12-28	AAWW-DELISTED	Stock	45.2601	45.42	44.81	44.89	112398.0
2006-12-28	AAXN-DELISTED	Stock	7.59999990463257	8.23999977111816	7.44999980926514	7.80999994277954	3604300.0
2006-12-28	AB	Stock	80.2	80.45	80.08	80.3	68800.0
2006-12-28	ABAX-DELISTED	Stock	19.5	19.71	19.27	19.44	92521.0
2006-12-28	ABB-DELISTED	Stock	17.91	17.9201	17.69	17.78	4170600.0
2006-12-28	ABBC-DELISTED	Stock	19.15	19.25	19.07	19.19	3898.0
2006-12-28	ABC-DELISTED	Stock	22.6	22.61	22.4	22.54	1485800.0
2006-12-28	ABCB	Stock	27.2243	27.3507	27.1853	27.1853	14291.0
2006-12-28	ABCO-DELISTED	Stock	27.06	27.06	26.71	26.87	88385.0
2006-12-28	ABCW-DELISTED	Stock	29.39	29.49	29.05	29.05	24630.0
2006-12-28	ABD-DELISTED	Stock	26.8	27.06	26.68	26.99	139200.0
2006-12-28	ABE-DELISTED	Stock	18.1	18.21	18.04	18.04	44600.0
2006-12-28	ABFS-DELISTED	Stock	37.1	37.4	37.01	37.14	247849.0
2006-12-28	ABG	Stock	23.84	23.9	23.57	23.64	104900.0
2006-12-28	ABK-DELISTED	Stock	89.55	90.25	89.31	89.72	215300.0
2006-12-28	ABM	Stock	23.3	23.35	22.94	22.99	426000.0
2006-12-28	ABMD-DELISTED	Stock	14.85	14.89	14.41	14.54	294107.0
2006-12-28	ABP-DELISTED	Stock	3.2	3.28	3.12	3.17	326900.0
2006-12-28	ABR	Stock	29.76	30.11	29.59	29.95	125600.0
2006-12-28	ABT	Stock	23.3903	23.5582	23.3423	23.4766	6916007.0
2006-12-28	ABTL-DELISTED	Stock	17.262	17.81	17.212	17.338	28035.0
2006-12-28	ABV-DELISTED	Stock	49.09	49.26	48.93	49.13	306400.0
2006-12-28	ABVA-DELISTED	Stock	15.73	15.76	15.56	15.65	3750.0
2006-12-28	ABX-DELISTED	Stock	30.85	30.98	30.62	30.97	3340963.0
2006-12-28	ACAD	Stock	9.05	9.1	8.82	8.89	117700.0
2006-12-28	ACAP-DELISTED	Stock	41.21	41.33	40.26	40.39	64495.0
2006-12-28	ACAS-DELISTED	Stock	46.0	46.42	45.94	46.12	414426.0
2006-12-28	ACAT-DELISTED	Stock	17.7	17.74	17.5	17.65	33904.0
2006-12-28	ACC-DELISTED	Stock	28.25	28.49	27.93	28.32	93700.0
2006-12-28	ACCL-DELISTED	Stock	5.76	5.96	5.75	5.95	126100.0
2006-12-28	ACCO	Stock	26.8	27.06	26.68	26.99	188700.0

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

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