PREVIEW / stock_daily / 2006-09-11

all stock daily files

  file:    by_date/stock_daily/2006/2006-09-11.parquet
  size:    149 KB
  rows:    4,493
  symbols: 2,832

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-11	AAPL	Stock	2.5868	2.6332	2.5507	2.5893	949124400.0
2006-09-11	MSFT	Stock	25.43	25.95	25.42	25.91	55608200.0
2006-09-11	NVDA	Stock	0.4513	0.4742	0.4462	0.4688	598266000.0
2006-09-11	AMZN	Stock	1.5115	1.5565	1.486	1.5395	148076000.0
2006-09-11	CL	Stock	30.35	31.03	30.35	31.025	5047600.0
2006-09-11	A	Stock	21.8526	22.4464	21.8526	22.2389	6983849.0
2006-09-11	AABA-DELISTED	Stock	28.0499992370605	28.7299995422363	27.6700000762939	28.6100006103516	12936000.0
2006-09-11	AACC-DELISTED	Stock	14.31	14.49	14.25	14.46	70442.0
2006-09-11	AACQW-DELISTED	Stock	0.39	0.39	0.39	0.39	2500.0
2006-09-11	AAI-DELISTED	Stock	9.44	9.46	9.15	9.4	2405200.0
2006-09-11	AAIC-DELISTED	Stock	158.6	162.6	158.2	162.2	757200.0
2006-09-11	AAME	Stock	2.87	2.87	2.87	2.87	200.0
2006-09-11	AAON	Stock	2.8155	3.013	2.8155	2.9287	157191.0
2006-09-11	AAP	Stock	31.3	31.53	30.82	31.47	1625100.0
2006-09-11	AATI-DELISTED	Stock	8.39	8.43	8.0	8.04	112111.0
2006-09-11	AAU-DELISTED	Stock	2.52	2.59	2.29	2.36	100200.0
2006-09-11	AAUAF-DELISTED	Stock	2.52	2.59	2.29	2.36	100200.0
2006-09-11	AAV-DELISTED	Stock	14.55	14.55	13.79	14.09	997500.0
2006-09-11	AAWW-DELISTED	Stock	42.75	42.75	42.04	42.67	38755.0
2006-09-11	AAXN-DELISTED	Stock	7.40999984741211	7.76000022888184	7.40000009536743	7.59000015258789	557300.0
2006-09-11	AB	Stock	66.47	66.97	66.32	66.73	138200.0
2006-09-11	ABAX-DELISTED	Stock	22.18	22.65	21.72	22.49	88365.0
2006-09-11	ABB-DELISTED	Stock	13.18	13.2	13.04	13.19	2052200.0
2006-09-11	ABBC-DELISTED	Stock	14.97	15.09	14.96	15.01	1567.0
2006-09-11	ABC-DELISTED	Stock	22.48	22.72	22.4	22.58	1286000.0
2006-09-11	ABCB	Stock	25.2109	25.3763	24.744	24.8899	15216.0
2006-09-11	ABCO-DELISTED	Stock	24.25	25.1	24.16	25.0	134665.0
2006-09-11	ABCW-DELISTED	Stock	28.49	28.64	28.34	28.64	133650.0
2006-09-11	ABD-DELISTED	Stock	21.06	21.06	20.5	20.52	196800.0
2006-09-11	ABE-DELISTED	Stock	13.6	13.6684	13.6	13.65	12200.0
2006-09-11	ABFS-DELISTED	Stock	42.8	44.358	42.8	44.25	411517.0
2006-09-11	ABG	Stock	19.75	20.27	19.72	20.12	106200.0
2006-09-11	ABK-DELISTED	Stock	85.2	85.2	84.13	84.42	575200.0
2006-09-11	ABM	Stock	18.15	18.65	18.04	18.46	231600.0
2006-09-11	ABMD-DELISTED	Stock	14.69	14.86	14.27	14.62	117225.0
2006-09-11	ABP-DELISTED	Stock	3.99	3.99	3.85	3.96	224700.0
2006-09-11	ABR	Stock	24.94	25.18	24.75	25.14	34600.0
2006-09-11	ABT	Stock	23.3471	23.4622	23.2943	23.3375	12104419.0
2006-09-11	ABTL-DELISTED	Stock	15.799	16.351	15.298	16.301	58033.0
2006-09-11	ABV-DELISTED	Stock	44.25	44.26	43.65	43.72	365200.0
2006-09-11	ABVA-DELISTED	Stock	16.9	16.9	16.9	16.9	1740.0
2006-09-11	ABX-DELISTED	Stock	30.72	30.82	29.57	29.6055	7054325.0
2006-09-11	ACAD	Stock	7.63	8.03	7.6	7.98	157900.0
2006-09-11	ACAP-DELISTED	Stock	46.66	47.21	46.41	47.03	11632.0
2006-09-11	ACAS-DELISTED	Stock	37.18	37.5	37.05	37.4	679065.0
2006-09-11	ACAT-DELISTED	Stock	16.05	16.13	15.7	15.85	56777.0
2006-09-11	ACC-DELISTED	Stock	24.67	24.78	24.55	24.58	71900.0
2006-09-11	ACCL-DELISTED	Stock	5.34	5.34	5.26	5.3	27751.0
2006-09-11	ACCO	Stock	21.07	21.07	20.5	20.51	213400.0
2006-09-11	ACCP-DELISTED	Stock	0.75	0.84	0.75	0.84	1100.0

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

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