PREVIEW / stock_daily / 2006-11-07

all stock daily files

  file:    by_date/stock_daily/2006/2006-11-07.parquet
  size:    153 KB
  rows:    4,574
  symbols: 2,894

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-07	AAPL	Stock	2.8732	2.8929	2.8618	2.8754	525932400.0
2006-11-07	MSFT	Stock	28.86	29.07	28.8	28.95	56511200.0
2006-11-07	NVDA	Stock	0.564	0.5743	0.5608	0.5683	553254000.0
2006-11-07	AMZN	Stock	1.91	1.95	1.902	1.9385	154902000.0
2006-11-07	CL	Stock	32.1	32.5	32.025	32.5	4441600.0
2006-11-07	A	Stock	24.3276	24.5064	24.0558	24.0558	2615798.0
2006-11-07	AABA-DELISTED	Stock	26.6900005340576	27.1499996185303	26.5799999237061	26.6100006103516	28442700.0
2006-11-07	AACC-DELISTED	Stock	16.52	16.98	16.52	16.91	106955.0
2006-11-07	AACQ-DELISTED	Stock	5.44	5.44	5.44	5.44	16300.0
2006-11-07	AACQU-DELISTED	Stock	6.55	6.55	6.55	6.55	18230.0
2006-11-07	AACQW-DELISTED	Stock	0.56	0.59	0.56	0.57	79430.0
2006-11-07	AAI-DELISTED	Stock	10.05	10.26	10.05	10.2	1301900.0
2006-11-07	AAIC-DELISTED	Stock	151.4	152.4	148.2	149.0	1169800.0
2006-11-07	AAME	Stock	2.5	2.52	2.48	2.5	9200.0
2006-11-07	AAON	Stock	2.8313	3.0077	2.8313	2.9709	328809.0
2006-11-07	AAP	Stock	36.19	36.4	35.96	36.04	735900.0
2006-11-07	AATI-DELISTED	Stock	5.67	5.84	5.65	5.66	253315.0
2006-11-07	AAU-DELISTED	Stock	2.68	2.68	2.62	2.63	23800.0
2006-11-07	AAUAF-DELISTED	Stock	2.68	2.68	2.62	2.63	23800.0
2006-11-07	AAV-DELISTED	Stock	12.0	12.0	11.31	11.4	1580500.0
2006-11-07	AAWW-DELISTED	Stock	43.21	43.75	43.06	43.3	201494.0
2006-11-07	AAXN-DELISTED	Stock	9.18000030517578	9.3100004196167	9.06999969482422	9.11999988555908	1181000.0
2006-11-07	AB	Stock	76.97	79.13	76.75	78.56	527100.0
2006-11-07	ABAX-DELISTED	Stock	20.28	20.7	19.94	20.0	199411.0
2006-11-07	ABB-DELISTED	Stock	15.32	15.46	15.25	15.28	2152800.0
2006-11-07	ABBC-DELISTED	Stock	16.09	16.18	15.85	15.88	6874.0
2006-11-07	ABC-DELISTED	Stock	23.0	23.18	22.82	22.9	2244800.0
2006-11-07	ABCB	Stock	26.3781	27.234	26.2614	26.3683	20151.0
2006-11-07	ABCO-DELISTED	Stock	27.82	28.4	27.61	27.83	175554.0
2006-11-07	ABCW-DELISTED	Stock	28.98	29.43	28.79	28.95	17800.0
2006-11-07	ABD-DELISTED	Stock	24.96	25.13	24.72	24.9	456300.0
2006-11-07	ABE-DELISTED	Stock	17.49	17.49	16.75	17.1	56600.0
2006-11-07	ABFS-DELISTED	Stock	39.66	40.05	39.13	39.93	490996.0
2006-11-07	ABG	Stock	23.63	23.99	23.63	23.83	294900.0
2006-11-07	ABK-DELISTED	Stock	85.24	85.4	84.8	84.91	1039600.0
2006-11-07	ABM	Stock	20.0	20.28	20.0	20.15	146400.0
2006-11-07	ABMD-DELISTED	Stock	13.47	13.7	13.05	13.1	82203.0
2006-11-07	ABP-DELISTED	Stock	3.46	3.55	3.36	3.44	107400.0
2006-11-07	ABR	Stock	27.36	28.13	27.36	27.9	193800.0
2006-11-07	ABT	Stock	22.7185	23.1839	22.6993	22.9632	11477074.0
2006-11-07	ABTL-DELISTED	Stock	16.775	16.775	16.124	16.275	73920.0
2006-11-07	ABV-DELISTED	Stock	45.01	45.49	44.95	45.14	924600.0
2006-11-07	ABVA-DELISTED	Stock	15.95	16.2	15.95	16.04	2255.0
2006-11-07	ABVT-DELISTED	Stock	55.0	62.5	55.0	62.5	345.0
2006-11-07	ABX-DELISTED	Stock	30.17	30.33	29.73	30.13	5273900.0
2006-11-07	ACAD	Stock	10.44	10.44	9.76	9.93	272600.0
2006-11-07	ACAP-DELISTED	Stock	36.24	36.75	36.08	36.6	127201.0
2006-11-07	ACAS-DELISTED	Stock	42.59	42.64	42.25	42.36	968033.0
2006-11-07	ACAT-DELISTED	Stock	17.665	17.885	17.375	17.415	83541.0
2006-11-07	ACC-DELISTED	Stock	27.24	27.66	27.16	27.3	157400.0

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

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