PREVIEW / stock_daily / 2006-11-14

all stock daily files

  file:    by_date/stock_daily/2006/2006-11-14.parquet
  size:    154 KB
  rows:    4,600
  symbols: 2,918

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-14	AAPL	Stock	3.0286	3.0357	2.9964	3.0357	588954800.0
2006-11-14	MSFT	Stock	29.28	29.42	29.07	29.23	63012500.0
2006-11-14	NVDA	Stock	0.5978	0.6072	0.585	0.606	628530000.0
2006-11-14	AMZN	Stock	2.0055	2.0835	1.981	2.0755	219026000.0
2006-11-14	CL	Stock	32.5	32.555	32.15	32.365	4229000.0
2006-11-14	A	Stock	23.5336	23.9127	23.0687	23.6052	16887980.0
2006-11-14	AABA-DELISTED	Stock	27.3999996185303	27.5	27.1100006103516	27.2399997711182	20145700.0
2006-11-14	AACC-DELISTED	Stock	16.95	16.95	16.68	16.74	222572.0
2006-11-14	AACQ-DELISTED	Stock	5.45	5.48	5.45	5.45	9427.0
2006-11-14	AACQW-DELISTED	Stock	0.61	0.64	0.61	0.64	513500.0
2006-11-14	AAI-DELISTED	Stock	10.85	11.08	10.52	11.08	2296800.0
2006-11-14	AAIC-DELISTED	Stock	145.6	147.0	143.2	146.6	1158000.0
2006-11-14	AAME	Stock	2.58	2.85	2.58	2.85	2300.0
2006-11-14	AAON	Stock	3.6214	3.8018	3.5371	3.7992	192881.0
2006-11-14	AAP	Stock	37.21	37.79	37.16	37.69	819300.0
2006-11-14	AATI-DELISTED	Stock	5.71	5.84	5.63	5.83	294720.0
2006-11-14	AAU-DELISTED	Stock	2.6	2.65	2.51	2.51	35200.0
2006-11-14	AAUAF-DELISTED	Stock	2.6	2.65	2.51	2.51	35200.0
2006-11-14	AAV-DELISTED	Stock	10.85	10.96	10.45	10.81	2107000.0
2006-11-14	AAWW-DELISTED	Stock	38.49	38.8	36.8	37.28	202888.0
2006-11-14	AAXN-DELISTED	Stock	9.23999977111816	9.27999973297119	9.05000019073486	9.27999973297119	719700.0
2006-11-14	AB	Stock	75.56	76.85	75.3	76.75	124400.0
2006-11-14	ABAX-DELISTED	Stock	20.56	20.77	20.2	20.7	106143.0
2006-11-14	ABB-DELISTED	Stock	15.84	15.88	15.65	15.8525	1382300.0
2006-11-14	ABBC-DELISTED	Stock	16.04	16.2	15.88	16.19	7344.0
2006-11-14	ABC-DELISTED	Stock	22.5	23.3	22.5	23.16	4358400.0
2006-11-14	ABCB	Stock	26.7379	27.234	26.6407	27.234	35162.0
2006-11-14	ABCO-DELISTED	Stock	28.27	28.9	28.11	28.9	183766.0
2006-11-14	ABCW-DELISTED	Stock	28.82	29.45	28.59	29.44	50810.0
2006-11-14	ABD-DELISTED	Stock	24.5	25.29	24.15	25.21	333700.0
2006-11-14	ABE-DELISTED	Stock	16.31	16.67	16.31	16.6375	54700.0
2006-11-14	ABFS-DELISTED	Stock	39.97	40.14	39.09	40.12	352648.0
2006-11-14	ABG	Stock	25.22	26.08	25.22	25.98	600700.0
2006-11-14	ABK-DELISTED	Stock	84.12	84.35	83.38	83.97	709500.0
2006-11-14	ABM	Stock	20.5	20.6	20.0	20.59	176200.0
2006-11-14	ABMD-DELISTED	Stock	12.51	13.15	12.25	13.14	136727.0
2006-11-14	ABP-DELISTED	Stock	3.63	3.65	3.49	3.6	111400.0
2006-11-14	ABR	Stock	28.47	28.6	28.22	28.6	56500.0
2006-11-14	ABT	Stock	21.8357	22.2531	21.8309	22.1572	14630263.0
2006-11-14	ABTL-DELISTED	Stock	16.9	17.35	16.25	16.35	60331.0
2006-11-14	ABV-DELISTED	Stock	46.3	47.05	45.98	46.82	681600.0
2006-11-14	ABVA-DELISTED	Stock	16.0	16.0	15.62	15.88	2638.0
2006-11-14	ABX-DELISTED	Stock	29.77	29.8	29.09	29.2	3699608.0
2006-11-14	ACAD	Stock	9.17	9.6	9.12	9.6	129500.0
2006-11-14	ACAP-DELISTED	Stock	38.33	39.27	37.89	39.26	32252.0
2006-11-14	ACAS-DELISTED	Stock	43.5	43.83	43.199	43.68	691192.0
2006-11-14	ACAT-DELISTED	Stock	17.27	17.91	17.14	17.88	64362.0
2006-11-14	ACC-DELISTED	Stock	28.1	28.43	27.74	27.85	1043649.0
2006-11-14	ACCL-DELISTED	Stock	6.07	6.24	6.05	6.24	50215.0
2006-11-14	ACCO	Stock	24.5	25.29	24.15	25.21	369200.0

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

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