PREVIEW / stock_daily / 2006-09-21

all stock daily files

  file:    by_date/stock_daily/2006/2006-09-21.parquet
  size:    150 KB
  rows:    4,481
  symbols: 2,825

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-09-21	AAPL	Stock	2.6875	2.7164	2.6436	2.6661	794124800.0
2006-09-21	MSFT	Stock	27.24	27.25	26.85	26.9	58495100.0
2006-09-21	NVDA	Stock	0.5157	0.5208	0.5072	0.512	539106000.0
2006-09-21	AMZN	Stock	1.612	1.628	1.5035	1.511	311074000.0
2006-09-21	CL	Stock	31.07	31.22	30.755	30.875	3024600.0
2006-09-21	A	Stock	23.5765	23.8913	23.4835	23.6624	5134994.0
2006-09-21	AABA-DELISTED	Stock	25.5300006866455	25.9500007629395	25.2099990844727	25.3400001525879	28584500.0
2006-09-21	AACC-DELISTED	Stock	15.04	15.14	14.9	15.01	99236.0
2006-09-21	AACQW-DELISTED	Stock	0.42	0.42	0.39	0.39	25000.0
2006-09-21	AAI-DELISTED	Stock	10.16	10.3	10.0	10.03	1582300.0
2006-09-21	AAIC-DELISTED	Stock	167.4	169.0	163.0	165.4	1128000.0
2006-09-21	AAON	Stock	3.0143	3.0459	2.9182	2.9577	69862.0
2006-09-21	AAP	Stock	33.19	33.24	32.71	32.82	1380000.0
2006-09-21	AATI-DELISTED	Stock	7.44	7.5	7.06	7.1	239458.0
2006-09-21	AAU-DELISTED	Stock	2.31	2.32	2.25	2.26	47100.0
2006-09-21	AAUAF-DELISTED	Stock	2.31	2.32	2.25	2.26	47100.0
2006-09-21	AAV-DELISTED	Stock	13.8	14.03	13.48	13.5	675900.0
2006-09-21	AAWW-DELISTED	Stock	44.3	44.45	43.86	44.16	98306.0
2006-09-21	AAXN-DELISTED	Stock	7.3899998664856	7.5	7.28000020980835	7.28999996185303	447000.0
2006-09-21	AB	Stock	67.43	68.26	67.16	67.65	218100.0
2006-09-21	ABAX-DELISTED	Stock	23.75	23.99	23.19	23.19	102573.0
2006-09-21	ABB-DELISTED	Stock	13.32	13.33	13.18	13.26	2422500.0
2006-09-21	ABBC-DELISTED	Stock	15.3	15.3	15.06	15.06	9201.0
2006-09-21	ABC-DELISTED	Stock	23.04	23.04	22.0	22.1	5158600.0
2006-09-21	ABCB	Stock	26.2614	27.4771	26.2614	26.9811	39994.0
2006-09-21	ABCO-DELISTED	Stock	25.72	25.72	25.02	25.21	105119.0
2006-09-21	ABCW-DELISTED	Stock	29.5	29.5	28.59	28.69	50150.0
2006-09-21	ABD-DELISTED	Stock	20.41	21.08	20.27	21.0	459820.0
2006-09-21	ABE-DELISTED	Stock	14.18	14.27	13.6801	13.6801	19800.0
2006-09-21	ABFS-DELISTED	Stock	44.23	44.71	42.87	42.99	447570.0
2006-09-21	ABG	Stock	19.5	19.69	19.14	19.63	894300.0
2006-09-21	ABK-DELISTED	Stock	83.81	83.87	82.41	82.58	668100.0
2006-09-21	ABM	Stock	18.87	18.94	18.64	18.88	212700.0
2006-09-21	ABMD-DELISTED	Stock	15.17	15.45	15.07	15.3	127167.0
2006-09-21	ABP-DELISTED	Stock	3.57	3.58	3.36	3.54	300900.0
2006-09-21	ABR	Stock	25.75	25.85	25.56	25.78	61200.0
2006-09-21	ABT	Stock	23.2703	23.3471	23.0256	23.1264	9654023.0
2006-09-21	ABTL-DELISTED	Stock	15.25	15.7	15.05	15.35	44655.0
2006-09-21	ABV-DELISTED	Stock	44.5	44.85	42.5	42.61	530100.0
2006-09-21	ABVA-DELISTED	Stock	16.76	16.8	16.652	16.72	990.0
2006-09-21	ABVT-DELISTED	Stock	47.5	47.5	47.5	47.5	2200.0
2006-09-21	ABX-DELISTED	Stock	28.52	29.31	28.3	29.02	4136400.0
2006-09-21	ACAD	Stock	8.29	8.36	8.02	8.05	72700.0
2006-09-21	ACAP-DELISTED	Stock	50.57	51.37	50.05	50.44	25663.0
2006-09-21	ACAS-DELISTED	Stock	38.52	38.71	38.33	38.43	653175.0
2006-09-21	ACAT-DELISTED	Stock	16.7	17.04	16.16	16.3	40674.0
2006-09-21	ACC-DELISTED	Stock	25.8	25.9	25.36	25.45	255700.0
2006-09-21	ACCL-DELISTED	Stock	5.46	5.65	5.46	5.6	43857.0
2006-09-21	ACCO	Stock	20.4	21.06	20.25	21.01	481300.0
2006-09-21	ACCP-DELISTED	Stock	0.8	0.85	0.8	0.85	3700.0

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

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