PREVIEW / stock_daily / 2006-11-17

all stock daily files

  file:    by_date/stock_daily/2006/2006-11-17.parquet
  size:    154 KB
  rows:    4,598
  symbols: 2,910

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-11-17	AAPL	Stock	3.0407	3.0693	3.0357	3.0661	466424000.0
2006-11-17	MSFT	Stock	29.31	29.54	29.28	29.4	49356700.0
2006-11-17	NVDA	Stock	0.5995	0.607	0.5958	0.6053	361608000.0
2006-11-17	AMZN	Stock	2.1275	2.1335	2.111	2.1275	130604000.0
2006-11-17	CL	Stock	32.735	33.005	32.645	33.005	3835400.0
2006-11-17	A	Stock	23.9342	24.206	23.8197	24.1416	3484934.0
2006-11-17	AABA-DELISTED	Stock	26.6800003051758	27.0499992370605	26.6299991607666	26.9099998474121	17955200.0
2006-11-17	AACC-DELISTED	Stock	16.73	16.89	16.57	16.74	109397.0
2006-11-17	AACQ-DELISTED	Stock	5.5	5.5	5.48	5.5	84500.0
2006-11-17	AACQU-DELISTED	Stock	6.6	6.6	6.6	6.6	5000.0
2006-11-17	AACQW-DELISTED	Stock	0.68	0.68	0.64	0.67	28700.0
2006-11-17	AAI-DELISTED	Stock	12.75	13.05	12.75	13.02	2672200.0
2006-11-17	AAIC-DELISTED	Stock	145.4	146.8	144.0	144.2	1371600.0
2006-11-17	AAME	Stock	2.84	2.84	2.75	2.81	2400.0
2006-11-17	AAON	Stock	3.736	3.736	3.6253	3.6767	109350.0
2006-11-17	AAP	Stock	38.15	38.21	37.82	38.07	1410800.0
2006-11-17	AATI-DELISTED	Stock	5.92	5.93	5.79	5.84	167450.0
2006-11-17	AAU-DELISTED	Stock	2.49	2.61	2.478	2.55	45700.0
2006-11-17	AAUAF-DELISTED	Stock	2.49	2.61	2.478	2.55	45700.0
2006-11-17	AAV-DELISTED	Stock	11.62	12.0	11.47	11.9751	2108200.0
2006-11-17	AAWW-DELISTED	Stock	37.9	37.97	37.32	37.59	221202.0
2006-11-17	AAXN-DELISTED	Stock	9.0600004196167	9.10999965667725	9.0	9.02000045776367	574700.0
2006-11-17	AB	Stock	78.28	78.28	77.39	77.76	117400.0
2006-11-17	ABAX-DELISTED	Stock	20.3	20.7	20.13	20.26	195718.0
2006-11-17	ABB-DELISTED	Stock	15.56	15.76	15.51	15.76	1950000.0
2006-11-17	ABBC-DELISTED	Stock	16.24	16.3	16.19	16.27	2516.0
2006-11-17	ABC-DELISTED	Stock	23.68	23.8	23.18	23.48	3166600.0
2006-11-17	ABCB	Stock	27.4576	27.7203	27.4576	27.6717	17273.0
2006-11-17	ABCO-DELISTED	Stock	28.78	28.92	28.35	28.86	95132.0
2006-11-17	ABCW-DELISTED	Stock	29.5	29.5	29.08	29.37	18370.0
2006-11-17	ABD-DELISTED	Stock	25.0	25.37	24.97	25.37	291930.0
2006-11-17	ABE-DELISTED	Stock	16.74	16.83	16.6	16.83	33700.0
2006-11-17	ABFS-DELISTED	Stock	40.73	40.97	39.97	40.2	328781.0
2006-11-17	ABG	Stock	24.08	24.16	23.9	24.07	467900.0
2006-11-17	ABK-DELISTED	Stock	85.1	85.8	84.95	85.35	990500.0
2006-11-17	ABM	Stock	20.74	20.79	20.56	20.75	134700.0
2006-11-17	ABMD-DELISTED	Stock	12.94	12.94	12.41	12.45	106356.0
2006-11-17	ABP-DELISTED	Stock	3.53	3.59	3.45	3.56	133400.0
2006-11-17	ABR	Stock	28.7	28.71	28.29	28.71	106900.0
2006-11-17	ABT	Stock	22.6945	22.8913	22.6466	22.8721	9521467.0
2006-11-17	ABTL-DELISTED	Stock	15.397	15.554	15.303	15.403	20569.0
2006-11-17	ABV-DELISTED	Stock	46.8	47.2095	46.56	46.93	897600.0
2006-11-17	ABVA-DELISTED	Stock	15.9	15.9	15.9	15.9	2000.0
2006-11-17	ABX-DELISTED	Stock	28.25	28.7	28.08	28.42	5333500.0
2006-11-17	ACAD	Stock	9.84	9.84	9.5	9.74	98800.0
2006-11-17	ACAP-DELISTED	Stock	38.92	39.14	38.82	39.07	21957.0
2006-11-17	ACAS-DELISTED	Stock	44.08	44.12	43.93	44.08	509472.0
2006-11-17	ACAT-DELISTED	Stock	17.5	17.5	17.366	17.46	71437.0
2006-11-17	ACC-DELISTED	Stock	28.24	28.27	27.94	28.1	469700.0
2006-11-17	ACCL-DELISTED	Stock	6.3	6.36	6.2	6.31	51506.0

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

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