PREVIEW / stock_daily / 2006-12-06

all stock daily files

  file:    by_date/stock_daily/2006/2006-12-06.parquet
  size:    156 KB
  rows:    4,650
  symbols: 2,951

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-06	AAPL	Stock	3.2371	3.2639	3.2025	3.2082	638184400.0
2006-12-06	MSFT	Stock	29.1	29.13	28.87	28.99	48564100.0
2006-12-06	NVDA	Stock	0.612	0.612	0.6008	0.6092	478242000.0
2006-12-06	AMZN	Stock	1.9385	1.979	1.932	1.945	115538000.0
2006-12-06	CL	Stock	32.795	32.96	32.755	32.93	2638400.0
2006-12-06	A	Stock	23.7411	23.834	23.5265	23.6552	2662771.0
2006-12-06	AABA-DELISTED	Stock	27.25	27.4500007629395	26.6000003814697	26.8600006103516	35202800.0
2006-12-06	AACC-DELISTED	Stock	16.83	16.86	16.33	16.45	58639.0
2006-12-06	AACQ-DELISTED	Stock	5.47	5.47	5.45	5.45	842.0
2006-12-06	AACQU-DELISTED	Stock	6.55	6.55	6.55	6.55	1200.0
2006-12-06	AACQW-DELISTED	Stock	0.58	0.58	0.5525	0.5525	19400.0
2006-12-06	AAI-DELISTED	Stock	12.44	12.63	12.35	12.4	1224700.0
2006-12-06	AAIC-DELISTED	Stock	158.0	158.8	156.2	157.2	1054500.0
2006-12-06	AAME	Stock	2.85	2.91	2.8	2.91	7600.0
2006-12-06	AAON	Stock	3.7162	3.7202	3.6372	3.653	268819.0
2006-12-06	AAP	Stock	36.38	36.38	35.75	35.92	1978200.0
2006-12-06	AATI-DELISTED	Stock	5.66	5.74	5.63	5.64	202522.0
2006-12-06	AAU-DELISTED	Stock	2.49	2.51	2.44	2.46	48100.0
2006-12-06	AAUAF-DELISTED	Stock	2.49	2.51	2.44	2.46	48100.0
2006-12-06	AAV-DELISTED	Stock	12.04	12.24	12.04	12.12	531400.0
2006-12-06	AAWW-DELISTED	Stock	43.4	44.0	42.998	43.76	215389.0
2006-12-06	AAXN-DELISTED	Stock	8.47999954223633	8.68000030517578	8.46000003814697	8.5600004196167	623900.0
2006-12-06	AB	Stock	80.4	82.92	80.22	80.65	716700.0
2006-12-06	ABAX-DELISTED	Stock	19.54	19.84	19.54	19.68	59581.0
2006-12-06	ABB-DELISTED	Stock	16.5	16.84	16.5	16.74	3270600.0
2006-12-06	ABBC-DELISTED	Stock	19.34	19.37	19.18	19.34	13827.0
2006-12-06	ABC-DELISTED	Stock	23.26	23.32	23.04	23.18	2031600.0
2006-12-06	ABCB	Stock	27.1464	27.2924	26.9908	27.0978	16142.0
2006-12-06	ABCO-DELISTED	Stock	28.03	28.04	27.46	27.47	302762.0
2006-12-06	ABCW-DELISTED	Stock	29.0	29.32	28.82	29.28	21940.0
2006-12-06	ABD-DELISTED	Stock	25.54	25.97	25.43	25.77	177090.0
2006-12-06	ABE-DELISTED	Stock	18.95	18.95	18.25	18.7	54600.0
2006-12-06	ABFS-DELISTED	Stock	36.97	37.55	36.83	37.33	403804.0
2006-12-06	ABG	Stock	23.94	23.97	23.75	23.92	261000.0
2006-12-06	ABK-DELISTED	Stock	85.03	85.83	85.03	85.75	365500.0
2006-12-06	ABM	Stock	20.76	20.95	20.73	20.95	85200.0
2006-12-06	ABMD-DELISTED	Stock	12.96	13.23	12.9	13.01	73679.0
2006-12-06	ABP-DELISTED	Stock	3.94	4.15	3.92	4.01	189400.0
2006-12-06	ABR	Stock	28.9	29.12	28.7	28.76	86400.0
2006-12-06	ABT	Stock	23.3039	23.3327	22.968	23.0352	10342851.0
2006-12-06	ABTL-DELISTED	Stock	15.904	16.3	15.854	16.3	21852.0
2006-12-06	ABV-DELISTED	Stock	47.3	47.5	47.05	47.05	479100.0
2006-12-06	ABVA-DELISTED	Stock	16.06	16.1	16.06	16.0869	3400.0
2006-12-06	ABX-DELISTED	Stock	30.48	31.01	30.36	30.43	3672418.0
2006-12-06	ACAD	Stock	9.1	9.12	9.02	9.07	101600.0
2006-12-06	ACAP-DELISTED	Stock	39.63	39.81	39.3	39.39	27420.0
2006-12-06	ACAS-DELISTED	Stock	44.98	45.27	44.8	44.98	726184.0
2006-12-06	ACAT-DELISTED	Stock	18.13	18.13	17.62	17.91	55353.0
2006-12-06	ACC-DELISTED	Stock	29.65	29.83	29.55	29.71	94800.0
2006-12-06	ACCL-DELISTED	Stock	6.06	6.12	5.9228	6.02	40302.0

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

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