PREVIEW / stock_daily / 2006-08-01

all stock daily files

  file:    by_date/stock_daily/2006/2006-08-01.parquet
  size:    147 KB
  rows:    4,443
  symbols: 2,796

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-08-01	AAPL	Stock	2.4007	2.4261	2.355	2.3993	711765600.0
2006-08-01	MSFT	Stock	24.02	24.2	23.85	23.99	49168700.0
2006-08-01	NVDA	Stock	0.3645	0.3652	0.3475	0.3542	600966000.0
2006-08-01	AMZN	Stock	1.3275	1.332	1.292	1.316	262576000.0
2006-08-01	CL	Stock	29.56	29.59	29.11	29.265	4370400.0
2006-08-01	A	Stock	20.2575	20.2718	19.8498	20.0644	3743564.0
2006-08-01	AABA-DELISTED	Stock	27.0599994659424	27.1200008392334	26.7399997711182	26.9400005340576	18613100.0
2006-08-01	AACC-DELISTED	Stock	18.08	18.49	17.92	18.27	75238.0
2006-08-01	AACQ-DELISTED	Stock	5.34	5.34	5.34	5.34	12000.0
2006-08-01	AACQU-DELISTED	Stock	6.09	6.09	6.09	6.09	1000.0
2006-08-01	AAI-DELISTED	Stock	12.44	12.49	12.1	12.23	1333900.0
2006-08-01	AAIC-DELISTED	Stock	181.8	183.0	179.0	182.6	2248500.0
2006-08-01	AAME	Stock	2.76	2.76	2.76	2.76	700.0
2006-08-01	AAON	Stock	3.0354	3.0354	2.9419	2.9656	364500.0
2006-08-01	AAP	Stock	30.26	30.27	29.59	30.06	826500.0
2006-08-01	AATI-DELISTED	Stock	9.23	9.23	8.35	8.82	254583.0
2006-08-01	AAU-DELISTED	Stock	2.52	2.55	2.45	2.55	51900.0
2006-08-01	AAUAF-DELISTED	Stock	2.52	2.55	2.45	2.55	51900.0
2006-08-01	AAV-DELISTED	Stock	16.5	16.53	16.16	16.31	327300.0
2006-08-01	AAWW-DELISTED	Stock	42.05	42.05	40.0	40.94	66069.0
2006-08-01	AAXN-DELISTED	Stock	7.19999980926514	7.21000003814697	6.94999980926514	7.0	1169800.0
2006-08-01	AB	Stock	65.0	65.22	64.11	65.02	136800.0
2006-08-01	ABAX-DELISTED	Stock	22.55	22.83	21.65	22.06	221396.0
2006-08-01	ABB-DELISTED	Stock	12.79	12.89	12.6	12.86	1922100.0
2006-08-01	ABBC-DELISTED	Stock	14.57	14.88	14.38	14.84	30567.0
2006-08-01	ABC-DELISTED	Stock	21.48	21.54	21.41	21.49	1841200.0
2006-08-01	ABCB	Stock	24.9871	25.0456	24.5106	24.8899	110729.0
2006-08-01	ABCO-DELISTED	Stock	23.04	23.78	22.6	22.75	218982.0
2006-08-01	ABCW-DELISTED	Stock	29.52	29.77	29.34	29.48	14000.0
2006-08-01	ABD-DELISTED	Stock	19.58	19.58	18.98	18.99	316300.0
2006-08-01	ABE-DELISTED	Stock	12.96	12.96	12.76	12.8	6000.0
2006-08-01	ABFS-DELISTED	Stock	44.0	44.24	43.62	43.92	477291.0
2006-08-01	ABG	Stock	20.0	20.0	19.43	19.54	261500.0
2006-08-01	ABK-DELISTED	Stock	82.9	83.08	81.75	82.25	698500.0
2006-08-01	ABM	Stock	16.5	16.5	16.2	16.33	132400.0
2006-08-01	ABMD-DELISTED	Stock	13.51	13.58	13.09	13.45	42848.0
2006-08-01	ABP-DELISTED	Stock	4.5	4.56	4.26	4.39	248700.0
2006-08-01	ABR	Stock	25.55	25.75	25.39	25.72	129200.0
2006-08-01	ABT	Stock	22.7665	22.8529	22.5794	22.7953	10192163.0
2006-08-01	ABTL-DELISTED	Stock	16.356	16.406	15.755	15.794	21510.0
2006-08-01	ABV-DELISTED	Stock	40.0	40.26	39.52	39.72	342100.0
2006-08-01	ABVA-DELISTED	Stock	15.53	16.5	15.53	16.39	27240.0
2006-08-01	ABX-DELISTED	Stock	30.7	31.51	30.5	31.47	4243400.0
2006-08-01	ACAD	Stock	6.41	6.48	6.2	6.2	81600.0
2006-08-01	ACAP-DELISTED	Stock	46.44	46.74	45.44	45.49	58728.0
2006-08-01	ACAS-DELISTED	Stock	35.04	35.13	34.75	34.96	890916.0
2006-08-01	ACAT-DELISTED	Stock	17.63	17.78	17.39	17.41	127395.0
2006-08-01	ACC-DELISTED	Stock	25.34	25.53	24.95	25.43	28400.0
2006-08-01	ACCL-DELISTED	Stock	6.07	6.67	6.07	6.33	41354.0
2006-08-01	ACCO	Stock	19.58	19.58	18.98	18.99	327400.0

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

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