PREVIEW / stock_daily / 2006-10-19

all stock daily files

  file:    by_date/stock_daily/2006/2006-10-19.parquet
  size:    152 KB
  rows:    4,550
  symbols: 2,870

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-10-19	AAPL	Stock	2.8307	2.8554	2.7914	2.8211	1512977200.0
2006-10-19	MSFT	Stock	28.35	28.45	28.12	28.29	44730800.0
2006-10-19	NVDA	Stock	0.524	0.54	0.5198	0.536	473040000.0
2006-10-19	AMZN	Stock	1.6085	1.642	1.605	1.627	80752000.0
2006-10-19	CL	Stock	30.175	30.34	30.11	30.115	5113200.0
2006-10-19	A	Stock	24.9285	25.1073	24.7854	24.9785	3005560.0
2006-10-19	AABA-DELISTED	Stock	23.0200004577637	23.5900001525879	23.0	23.1399993896484	42280400.0
2006-10-19	AACC-DELISTED	Stock	17.61	17.8	17.49	17.51	112056.0
2006-10-19	AACQ-DELISTED	Stock	5.32	5.32	5.31	5.32	51000.0
2006-10-19	AACQU-DELISTED	Stock	6.08	6.08	6.08	6.08	10000.0
2006-10-19	AACQW-DELISTED	Stock	0.41	0.41	0.4	0.4	41000.0
2006-10-19	AAI-DELISTED	Stock	10.55	10.63	10.45	10.59	1501600.0
2006-10-19	AAIC-DELISTED	Stock	163.6	165.4	159.8	160.4	1423400.0
2006-10-19	AAME	Stock	2.62	2.68	2.51	2.68	1100.0
2006-10-19	AAON	Stock	3.1263	3.1644	3.1144	3.1552	132891.0
2006-10-19	AAP	Stock	34.92	35.7	34.84	35.66	1020200.0
2006-10-19	AATI-DELISTED	Stock	5.45	5.53	5.37	5.41	240674.0
2006-10-19	AAU-DELISTED	Stock	2.42	2.48	2.4	2.46	82700.0
2006-10-19	AAUAF-DELISTED	Stock	2.42	2.48	2.4	2.46	82700.0
2006-10-19	AAV-DELISTED	Stock	13.61	14.0	13.5	13.99	850500.0
2006-10-19	AAWW-DELISTED	Stock	47.7	48.49	47.5	47.98	130116.0
2006-10-19	AAXN-DELISTED	Stock	9.42000007629395	9.59000015258789	9.40999984741211	9.40999984741211	401100.0
2006-10-19	AB	Stock	76.9	76.9	75.0	75.83	346500.0
2006-10-19	ABAX-DELISTED	Stock	22.23	22.66	21.93	22.0	232808.0
2006-10-19	ABB-DELISTED	Stock	13.94	14.15	13.93	14.15	1788100.0
2006-10-19	ABBC-DELISTED	Stock	15.77	16.11	15.77	16.0	15457.0
2006-10-19	ABC-DELISTED	Stock	23.18	23.47	23.14	23.25	1032800.0
2006-10-19	ABCB	Stock	26.8936	27.3021	26.8936	27.2243	19020.0
2006-10-19	ABCO-DELISTED	Stock	27.52	27.64	27.23	27.63	157497.0
2006-10-19	ABCW-DELISTED	Stock	29.09	29.5	28.91	29.3	31670.0
2006-10-19	ABD-DELISTED	Stock	23.23	23.96	23.22	23.94	442200.0
2006-10-19	ABE-DELISTED	Stock	15.11	15.59	15.11	15.55	22900.0
2006-10-19	ABFS-DELISTED	Stock	44.32	46.17	44.12	45.19	785983.0
2006-10-19	ABG	Stock	23.33	23.86	23.29	23.78	486700.0
2006-10-19	ABK-DELISTED	Stock	84.9	84.9	83.8	84.4	1070300.0
2006-10-19	ABM	Stock	19.56	19.73	19.5	19.67	156900.0
2006-10-19	ABMD-DELISTED	Stock	13.86	14.51	13.75	14.1	83601.0
2006-10-19	ABP-DELISTED	Stock	3.71	3.75	3.65	3.68	149200.0
2006-10-19	ABR	Stock	27.08	27.17	26.87	26.89	50400.0
2006-10-19	ABT	Stock	23.0448	23.2175	22.8817	22.992	11896207.0
2006-10-19	ABTL-DELISTED	Stock	16.15	16.4	16.15	16.3	10438.0
2006-10-19	ABV-DELISTED	Stock	45.86	45.86	45.4632	45.5	371300.0
2006-10-19	ABVA-DELISTED	Stock	17.4	17.4	17.3	17.3	2900.0
2006-10-19	ABX-DELISTED	Stock	30.18	30.7	29.94	30.6452	4108625.0
2006-10-19	ACAD	Stock	10.41	10.55	10.27	10.4	103600.0
2006-10-19	ACAP-DELISTED	Stock	51.64	51.99	51.58	51.99	18852.0
2006-10-19	ACAS-DELISTED	Stock	41.98	42.08	41.57	41.66	689276.0
2006-10-19	ACAT-DELISTED	Stock	17.02	17.09	16.77	16.9	42089.0
2006-10-19	ACC-DELISTED	Stock	26.56	26.97	26.5	26.88	114800.0
2006-10-19	ACCL-DELISTED	Stock	6.17	6.42	6.17	6.41	41028.0

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

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