PREVIEW / stock_daily / 2005-09-27

all stock daily files

  file:    by_date/stock_daily/2005/2005-09-27.parquet
  size:    140 KB
  rows:    4,201
  symbols: 2,649

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
2005-09-27	AAPL	Stock	1.9257	1.9371	1.9082	1.9086	341703600.0
2005-09-27	MSFT	Stock	25.37	25.45	25.3	25.34	48797900.0
2005-09-27	NVDA	Stock	0.276	0.2784	0.2737	0.2757	404160000.0
2005-09-27	AMZN	Stock	2.163	2.1865	2.141	2.158	83470000.0
2005-09-27	CL	Stock	25.645	26.065	25.63	25.99	3496200.0
2005-09-27	A	Stock	24.0343	24.1416	23.8984	23.9342	3930197.0
2005-09-27	AABA-DELISTED	Stock	32.1699981689453	32.6100006103516	32.1699981689453	32.4799995422363	12246900.0
2005-09-27	AACC-DELISTED	Stock	28.46	29.71	28.45	29.211	212840.0
2005-09-27	AACQ-DELISTED	Stock	5.1	5.1	5.1	5.1	7000.0
2005-09-27	AACQU-DELISTED	Stock	6.28	6.28	6.28	6.28	2000.0
2005-09-27	AACQW-DELISTED	Stock	0.6	0.6	0.6	0.6	8000.0
2005-09-27	AAI-DELISTED	Stock	11.64	11.93	11.57	11.76	1821400.0
2005-09-27	AAIC-DELISTED	Stock	212.4	214.6	207.2	207.8	1847700.0
2005-09-27	AAME	Stock	2.81	2.96	2.7	2.96	16600.0
2005-09-27	AAON	Stock	2.373	2.4323	2.3546	2.4112	285525.0
2005-09-27	AAP	Stock	39.08	39.08	38.32	38.64	905100.0
2005-09-27	AATI-DELISTED	Stock	12.45	12.49	12.05	12.38	72277.0
2005-09-27	AAV-DELISTED	Stock	17.81	17.84	17.56	17.81	119700.0
2005-09-27	AAXN-DELISTED	Stock	6.67000007629395	6.82000017166138	6.32000017166138	6.34999990463257	7756400.0
2005-09-27	ABAX-DELISTED	Stock	12.88	13.28	12.78	13.06	74942.0
2005-09-27	ABB-DELISTED	Stock	7.12	7.19	7.11	7.18	842600.0
2005-09-27	ABBC-DELISTED	Stock	12.78	12.79	12.65	12.78	4338.0
2005-09-27	ABC-DELISTED	Stock	19.28	19.34	19.1	19.27	3671600.0
2005-09-27	ABCB	Stock	18.6553	18.6553	17.9258	18.5483	44724.0
2005-09-27	ABCO-DELISTED	Stock	24.45	25.46	24.27	25.28	308961.0
2005-09-27	ABCW-DELISTED	Stock	29.16	29.47	29.09	29.2	55640.0
2005-09-27	ABD-DELISTED	Stock	27.97	28.52	27.75	27.86	428990.0
2005-09-27	ABE-DELISTED	Stock	10.93	11.04	10.93	11.03	34900.0
2005-09-27	ABFS-DELISTED	Stock	33.5	33.88	32.98	33.32	319011.0
2005-09-27	ABG	Stock	17.37	17.37	16.59	16.77	97000.0
2005-09-27	ABK-DELISTED	Stock	70.25	70.84	69.93	70.37	434600.0
2005-09-27	ABM	Stock	20.54	20.88	20.2	20.61	144700.0
2005-09-27	ABMD-DELISTED	Stock	9.98	10.63	9.98	10.38	61917.0
2005-09-27	ABP-DELISTED	Stock	5.98	6.8	5.96	6.7	2102000.0
2005-09-27	ABR	Stock	28.14	28.76	28.14	28.35	68800.0
2005-09-27	ABT	Stock	20.5834	20.6554	20.4395	20.5019	12269487.0
2005-09-27	ABTL-DELISTED	Stock	25.18	25.18	24.77	24.82	19020.0
2005-09-27	ABV-DELISTED	Stock	36.15	36.52	35.9	36.15	392800.0
2005-09-27	ABVA-DELISTED	Stock	16.2	16.2	16.2	16.2	5575.0
2005-09-27	ABX-DELISTED	Stock	28.76	28.77	28.0	28.44	3040600.0
2005-09-27	ACAD	Stock	11.07	11.07	10.78	10.95	26700.0
2005-09-27	ACAP-DELISTED	Stock	48.76	49.08	48.5	49.0	112435.0
2005-09-27	ACAS-DELISTED	Stock	36.75	36.77	36.3	36.3	555778.0
2005-09-27	ACAT-DELISTED	Stock	20.08	20.43	19.81	20.2	283624.0
2005-09-27	ACC-DELISTED	Stock	22.95	22.95	22.82	22.95	121300.0
2005-09-27	ACCL-DELISTED	Stock	6.25	6.5	6.19	6.46	84235.0
2005-09-27	ACCO	Stock	27.97	28.52	27.75	27.86	429000.0
2005-09-27	ACE-DELISTED	Stock	46.88	47.0	45.35	45.7	1919200.0
2005-09-27	ACF-DELISTED	Stock	24.07	24.37	24.0	24.16	1055800.0
2005-09-27	ACFC-DELISTED	Stock	70.92	71.22	70.87	70.87	803.0

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

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