PREVIEW / stock_daily / 2006-12-04

all stock daily files

  file:    by_date/stock_daily/2006/2006-12-04.parquet
  size:    155 KB
  rows:    4,647
  symbols: 2,947

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-04	AAPL	Stock	3.2814	3.2875	3.2321	3.2543	709536800.0
2006-12-04	MSFT	Stock	29.23	29.52	29.17	29.33	55123400.0
2006-12-04	NVDA	Stock	0.6	0.624	0.5978	0.6163	621570000.0
2006-12-04	AMZN	Stock	1.9655	1.974	1.9435	1.955	194414000.0
2006-12-04	CL	Stock	32.75	33.12	32.745	33.12	2777200.0
2006-12-04	A	Stock	22.8898	23.4263	22.8898	23.3333	4452770.0
2006-12-04	AABA-DELISTED	Stock	26.4899997711182	27.2999992370605	26.4899997711182	26.8899993896484	28012700.0
2006-12-04	AACC-DELISTED	Stock	16.49	16.77	16.19	16.73	112102.0
2006-12-04	AACQ-DELISTED	Stock	5.46	5.48	5.46	5.48	71158.0
2006-12-04	AACQU-DELISTED	Stock	6.53	6.53	6.53	6.53	200.0
2006-12-04	AACQW-DELISTED	Stock	0.6	0.62	0.59	0.62	38944.0
2006-12-04	AAI-DELISTED	Stock	12.48	12.7	12.25	12.5	2416400.0
2006-12-04	AAIC-DELISTED	Stock	156.6	159.6	156.2	158.8	1630600.0
2006-12-04	AAON	Stock	3.6846	3.6886	3.6319	3.6872	205791.0
2006-12-04	AAP	Stock	35.3	35.69	35.18	35.19	1132800.0
2006-12-04	AATI-DELISTED	Stock	5.58	5.77	5.57	5.72	236898.0
2006-12-04	AAU-DELISTED	Stock	2.4601	2.54	2.4601	2.48	121900.0
2006-12-04	AAUAF-DELISTED	Stock	2.4601	2.54	2.4601	2.48	121900.0
2006-12-04	AAV-DELISTED	Stock	12.43	12.44	12.0475	12.0599	785800.0
2006-12-04	AAWW-DELISTED	Stock	42.48	43.5	42.33	43.4	377619.0
2006-12-04	AAXN-DELISTED	Stock	8.22999954223633	8.52999973297119	8.21000003814697	8.43000030517578	739000.0
2006-12-04	AB	Stock	76.76	78.91	76.76	78.3	321700.0
2006-12-04	ABAX-DELISTED	Stock	19.12	19.64	19.05	19.33	201591.0
2006-12-04	ABB-DELISTED	Stock	16.28	16.47	16.27	16.4	3806000.0
2006-12-04	ABBC-DELISTED	Stock	19.45	19.5	19.27	19.31	34844.0
2006-12-04	ABC-DELISTED	Stock	22.93	23.4	22.84	23.34	3453600.0
2006-12-04	ABCB	Stock	27.2243	27.7203	27.2243	27.4188	24778.0
2006-12-04	ABCO-DELISTED	Stock	27.36	28.04	27.36	27.94	294720.0
2006-12-04	ABCW-DELISTED	Stock	28.47	29.23	28.47	29.11	34490.0
2006-12-04	ABD-DELISTED	Stock	24.98	25.3	24.88	25.18	209400.0
2006-12-04	ABE-DELISTED	Stock	17.56	17.9	17.4	17.9	69100.0
2006-12-04	ABFS-DELISTED	Stock	36.08	37.25	36.08	37.02	727163.0
2006-12-04	ABG	Stock	23.7	24.0	23.7	23.96	291900.0
2006-12-04	ABK-DELISTED	Stock	84.94	85.13	84.47	84.66	515900.0
2006-12-04	ABM	Stock	20.84	20.94	20.7	20.93	147800.0
2006-12-04	ABMD-DELISTED	Stock	12.46	12.74	12.46	12.65	171284.0
2006-12-04	ABP-DELISTED	Stock	4.1	4.1	3.97	4.0	132000.0
2006-12-04	ABR	Stock	28.35	29.35	28.35	29.2	101900.0
2006-12-04	ABT	Stock	23.0304	23.2367	22.6418	23.0784	20336599.0
2006-12-04	ABTL-DELISTED	Stock	15.625	16.474	15.276	16.025	81805.0
2006-12-04	ABV-DELISTED	Stock	46.0	46.83	45.87	46.66	328000.0
2006-12-04	ABVA-DELISTED	Stock	16.29	16.29	16.29	16.29	103.0
2006-12-04	ABX-DELISTED	Stock	30.92	31.56	30.89	31.5	3092800.0
2006-12-04	ACAD	Stock	9.24	9.35	9.11	9.19	82400.0
2006-12-04	ACAP-DELISTED	Stock	39.5	41.2	39.5	40.69	83191.0
2006-12-04	ACAS-DELISTED	Stock	44.56	44.63	44.04	44.59	683879.0
2006-12-04	ACAT-DELISTED	Stock	16.73	16.99	16.69	16.95	79677.0
2006-12-04	ACC-DELISTED	Stock	29.25	29.88	29.19	29.77	185800.0
2006-12-04	ACCL-DELISTED	Stock	5.98	6.14	5.98	6.1	29583.0
2006-12-04	ACCO	Stock	24.98	25.3	24.88	25.18	221200.0

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

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