PREVIEW / stock_daily / 2006-12-14

all stock daily files

  file:    by_date/stock_daily/2006/2006-12-14.parquet
  size:    156 KB
  rows:    4,654
  symbols: 2,953

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-14	AAPL	Stock	3.1804	3.2143	3.1521	3.1625	832330800.0
2006-12-14	MSFT	Stock	29.54	30.08	29.52	30.07	85866500.0
2006-12-14	NVDA	Stock	0.6083	0.6218	0.6078	0.6142	715380000.0
2006-12-14	AMZN	Stock	1.937	1.977	1.93	1.951	125922000.0
2006-12-14	CL	Stock	32.89	33.01	32.745	32.85	3119200.0
2006-12-14	A	Stock	24.1416	24.5136	24.1416	24.3634	4210776.0
2006-12-14	AABA-DELISTED	Stock	26.6299991607666	26.9699993133545	26.5	26.8700008392334	14400300.0
2006-12-14	AACC-DELISTED	Stock	16.1	16.25	15.9	16.04	77492.0
2006-12-14	AACQ-DELISTED	Stock	5.42	5.42	5.42	5.42	1000.0
2006-12-14	AACQW-DELISTED	Stock	0.56	0.56	0.52	0.53	66600.0
2006-12-14	AAI-DELISTED	Stock	12.77	12.9	12.46	12.51	3037400.0
2006-12-14	AAIC-DELISTED	Stock	149.8	152.2	148.4	151.0	1559000.0
2006-12-14	AAME	Stock	2.89	3.01	2.81	2.99	3200.0
2006-12-14	AAON	Stock	3.4384	3.6214	3.4173	3.5398	232369.0
2006-12-14	AAP	Stock	35.6	36.13	35.5	35.85	567100.0
2006-12-14	AATI-DELISTED	Stock	5.16	5.2	5.11	5.14	186045.0
2006-12-14	AAU-DELISTED	Stock	2.31	2.4	2.31	2.39	40700.0
2006-12-14	AAUAF-DELISTED	Stock	2.31	2.4	2.31	2.39	40700.0
2006-12-14	AAV-DELISTED	Stock	11.53	11.7	11.51	11.68	635700.0
2006-12-14	AAWW-DELISTED	Stock	45.95	46.58	45.86	46.36	171777.0
2006-12-14	AAXN-DELISTED	Stock	8.02000045776367	8.18000030517578	7.98000001907349	8.0	694400.0
2006-12-14	AB	Stock	78.61	79.65	78.11	79.15	115000.0
2006-12-14	ABAX-DELISTED	Stock	19.4	19.66	19.2	19.28	153826.0
2006-12-14	ABB-DELISTED	Stock	16.91	17.11	16.87	17.09	2197600.0
2006-12-14	ABBC-DELISTED	Stock	19.08	19.22	19.08	19.14	23941.0
2006-12-14	ABC-DELISTED	Stock	23.73	23.74	23.16	23.18	3640413.0
2006-12-14	ABCB	Stock	27.3215	27.9537	27.1561	27.623	28788.0
2006-12-14	ABCO-DELISTED	Stock	26.79	27.19	26.66	26.66	135311.0
2006-12-14	ABCW-DELISTED	Stock	28.64	28.85	28.56	28.76	36530.0
2006-12-14	ABD-DELISTED	Stock	26.23	26.6	26.23	26.33	209700.0
2006-12-14	ABE-DELISTED	Stock	18.0	18.32	17.96	18.02	38300.0
2006-12-14	ABFS-DELISTED	Stock	35.71	37.3	35.71	37.07	425730.0
2006-12-14	ABG	Stock	24.0	24.17	23.87	23.92	361000.0
2006-12-14	ABK-DELISTED	Stock	86.5	88.15	86.36	87.63	925100.0
2006-12-14	ABM	Stock	21.52	23.63	21.46	23.19	729700.0
2006-12-14	ABMD-DELISTED	Stock	13.12	13.25	13.1	13.13	53010.0
2006-12-14	ABP-DELISTED	Stock	3.64	3.8	3.61	3.72	185600.0
2006-12-14	ABR	Stock	28.68	29.14	28.56	28.88	54900.0
2006-12-14	ABT	Stock	23.088	23.2175	23.0304	23.0784	8133180.0
2006-12-14	ABTL-DELISTED	Stock	16.951	17.849	16.852	17.4	71452.0
2006-12-14	ABV-DELISTED	Stock	48.55	48.76	48.33	48.66	430200.0
2006-12-14	ABVA-DELISTED	Stock	15.98	15.98	15.88	15.9	3500.0
2006-12-14	ABX-DELISTED	Stock	30.27	30.9	30.1	30.83	5255122.0
2006-12-14	ACAD	Stock	9.19	9.5	9.19	9.25	142200.0
2006-12-14	ACAP-DELISTED	Stock	39.16	40.2	39.02	39.73	37627.0
2006-12-14	ACAS-DELISTED	Stock	44.85	45.18	44.82	45.02	382526.0
2006-12-14	ACAT-DELISTED	Stock	17.93	18.19	17.93	18.06	78940.0
2006-12-14	ACC-DELISTED	Stock	29.33	29.83	29.0	29.06	191100.0
2006-12-14	ACCL-DELISTED	Stock	5.64	5.66	5.57	5.61	43342.0
2006-12-14	ACCO	Stock	26.23	26.6	26.23	26.33	235100.0

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

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