PREVIEW / stock_daily / 2006-11-01

all stock daily files

  file:    by_date/stock_daily/2006/2006-11-01.parquet
  size:    154 KB
  rows:    4,588
  symbols: 2,908

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-01	AAPL	Stock	2.8964	2.9064	2.7986	2.8271	611192400.0
2006-11-01	MSFT	Stock	28.78	28.99	28.7	28.81	75895900.0
2006-11-01	NVDA	Stock	0.5735	0.5788	0.5283	0.5363	1176540000.0
2006-11-01	AMZN	Stock	1.9065	1.91	1.873	1.878	133378000.0
2006-11-01	CL	Stock	32.11	32.115	31.83	32.005	3078400.0
2006-11-01	A	Stock	24.2489	24.7139	23.9986	24.3848	4555942.0
2006-11-01	AABA-DELISTED	Stock	26.5	26.6200008392334	25.8199996948242	25.9899997711182	26300200.0
2006-11-01	AACC-DELISTED	Stock	17.7	17.91	17.01	17.17	132866.0
2006-11-01	AACQ-DELISTED	Stock	5.48	5.49	5.48	5.48	12644.0
2006-11-01	AACQW-DELISTED	Stock	0.57	0.57	0.56	0.56	33026.0
2006-11-01	AAI-DELISTED	Stock	10.06	10.08	9.72	9.77	1898200.0
2006-11-01	AAIC-DELISTED	Stock	152.0	153.0	148.0	148.0	834100.0
2006-11-01	AAME	Stock	2.53	2.64	2.5	2.58	3000.0
2006-11-01	AAON	Stock	3.0986	3.0986	2.8023	2.8286	343237.0
2006-11-01	AAP	Stock	35.25	35.25	34.14	34.46	1477700.0
2006-11-01	AATI-DELISTED	Stock	6.26	6.27	5.82	6.02	958292.0
2006-11-01	AAU-DELISTED	Stock	2.45	2.6	2.45	2.59	93200.0
2006-11-01	AAUAF-DELISTED	Stock	2.45	2.6	2.45	2.59	93200.0
2006-11-01	AAV-DELISTED	Stock	11.8	12.56	10.86	12.28	2514200.0
2006-11-01	AAWW-DELISTED	Stock	45.73	45.75	44.41	44.64	62352.0
2006-11-01	AAXN-DELISTED	Stock	9.25	9.28999996185303	8.75	8.98999977111816	2166200.0
2006-11-01	AB	Stock	78.25	78.74	77.05	77.08	495600.0
2006-11-01	ABAX-DELISTED	Stock	20.18	20.21	19.29	19.5	275086.0
2006-11-01	ABB-DELISTED	Stock	14.93	15.02	14.73	14.73	1450200.0
2006-11-01	ABBC-DELISTED	Stock	16.18	16.18	15.95	15.96	15652.0
2006-11-01	ABC-DELISTED	Stock	23.62	23.8	23.4	23.55	5696200.0
2006-11-01	ABCB	Stock	27.1464	27.2146	26.2614	26.5628	32386.0
2006-11-01	ABCO-DELISTED	Stock	27.78	28.02	26.46	26.53	382770.0
2006-11-01	ABCW-DELISTED	Stock	29.19	29.38	28.39	28.51	57220.0
2006-11-01	ABD-DELISTED	Stock	24.27	24.63	24.25	24.36	304700.0
2006-11-01	ABE-DELISTED	Stock	16.25	16.74	16.24	16.42	55900.0
2006-11-01	ABFS-DELISTED	Stock	40.9	41.48	40.3979	40.45	621778.0
2006-11-01	ABG	Stock	23.97	24.13	23.5	23.52	397700.0
2006-11-01	ABK-DELISTED	Stock	83.5	83.75	83.3	83.48	709500.0
2006-11-01	ABM	Stock	19.86	19.99	19.72	19.74	158800.0
2006-11-01	ABMD-DELISTED	Stock	14.25	14.37	13.1	13.13	227452.0
2006-11-01	ABP-DELISTED	Stock	3.6	3.66	3.39	3.4	107900.0
2006-11-01	ABR	Stock	27.85	28.36	27.75	27.98	208800.0
2006-11-01	ABT	Stock	22.6466	22.8145	22.6226	22.7521	8368070.0
2006-11-01	ABTL-DELISTED	Stock	16.348	16.348	16.004	16.25	21177.0
2006-11-01	ABV-DELISTED	Stock	44.2	44.94	44.16	44.56	799300.0
2006-11-01	ABVA-DELISTED	Stock	16.5	16.5	16.45	16.5	14125.0
2006-11-01	ABVT-DELISTED	Stock	54.75	64.0	54.75	64.0	967.0
2006-11-01	ABX-DELISTED	Stock	31.2	31.64	30.73	30.92	7765100.0
2006-11-01	ACAD	Stock	9.54	9.58	9.16	9.17	127400.0
2006-11-01	ACAP-DELISTED	Stock	54.89	55.15	53.18	53.2	42346.0
2006-11-01	ACAS-DELISTED	Stock	43.15	43.85	42.57	42.66	1181642.0
2006-11-01	ACAT-DELISTED	Stock	18.05	18.05	17.32	17.36	232167.0
2006-11-01	ACC-DELISTED	Stock	26.68	26.71	26.23	26.23	83200.0
2006-11-01	ACCL-DELISTED	Stock	6.36	6.597	6.3	6.44	62284.0

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

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