PREVIEW / stock_daily / 2005-10-27

all stock daily files

  file:    by_date/stock_daily/2005/2005-10-27.parquet
  size:    139 KB
  rows:    4,195
  symbols: 2,635

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-10-27	AAPL	Stock	2.0354	2.0361	1.9789	1.9789	411541200.0
2005-10-27	MSFT	Stock	25.22	25.27	24.85	24.85	61566100.0
2005-10-27	NVDA	Stock	0.2682	0.269	0.2612	0.2621	227784000.0
2005-10-27	AMZN	Stock	1.982	1.995	1.943	1.953	175406000.0
2005-10-27	CL	Stock	26.05	26.14	25.89	26.04	2631000.0
2005-10-27	A	Stock	22.0315	22.1316	21.8312	21.867	1791817.0
2005-10-27	AABA-DELISTED	Stock	35.3400001525879	35.6599998474121	35.2999992370605	35.4500007629395	11605000.0
2005-10-27	AACC-DELISTED	Stock	26.65	26.66	25.58	25.88	242456.0
2005-10-27	AACQW-DELISTED	Stock	0.48	0.48	0.48	0.48	5000.0
2005-10-27	AAI-DELISTED	Stock	14.2	14.28	14.04	14.21	1982400.0
2005-10-27	AAIC-DELISTED	Stock	182.6	184.0	169.8	171.0	2551500.0
2005-10-27	AAME	Stock	2.51	2.62	2.51	2.52	1200.0
2005-10-27	AAON	Stock	2.1742	2.186	2.1228	2.157	546750.0
2005-10-27	AAP	Stock	36.42	36.43	35.4	35.88	1044600.0
2005-10-27	AATI-DELISTED	Stock	12.46	12.59	12.0	12.15	92326.0
2005-10-27	AAV-DELISTED	Stock	16.82	17.19	16.76	16.82	15200.0
2005-10-27	AAXN-DELISTED	Stock	6.42000007629395	6.44000005722046	6.07999992370605	6.1100001335144	2879800.0
2005-10-27	ABAX-DELISTED	Stock	16.9	16.97	16.55	16.78	349773.0
2005-10-27	ABB-DELISTED	Stock	7.09	7.11	6.97	7.01	304400.0
2005-10-27	ABC-DELISTED	Stock	18.37	18.55	18.37	18.4	3674959.0
2005-10-27	ABCB	Stock	18.1689	18.1689	17.809	17.9647	6683.0
2005-10-27	ABCO-DELISTED	Stock	23.38	23.72	22.55	22.92	266710.0
2005-10-27	ABCW-DELISTED	Stock	30.37	31.15	30.37	30.5	44740.0
2005-10-27	ABD-DELISTED	Stock	24.85	24.95	23.9	24.5	209030.0
2005-10-27	ABE-DELISTED	Stock	10.89	10.89	10.71	10.71	6300.0
2005-10-27	ABFS-DELISTED	Stock	38.13	38.26	36.41	36.59	577940.0
2005-10-27	ABG	Stock	16.97	17.04	15.76	15.88	101600.0
2005-10-27	ABK-DELISTED	Stock	68.25	68.88	68.11	68.26	391500.0
2005-10-27	ABM	Stock	19.4	19.51	19.19	19.31	78200.0
2005-10-27	ABMD-DELISTED	Stock	8.02	8.13	7.81	8.13	104676.0
2005-10-27	ABP-DELISTED	Stock	6.26	6.35	5.8	5.91	967400.0
2005-10-27	ABR	Stock	27.48	27.49	26.85	26.85	37000.0
2005-10-27	ABT	Stock	20.6362	20.7178	20.3339	20.3627	5549396.0
2005-10-27	ABTL-DELISTED	Stock	22.0	22.2	21.1	21.1	69712.0
2005-10-27	ABV-DELISTED	Stock	35.0	35.38	34.54	34.93	749600.0
2005-10-27	ABVA-DELISTED	Stock	16.55	16.8	16.55	16.6	2300.0
2005-10-27	ABX-DELISTED	Stock	26.58	26.8	26.13	26.32	1933600.0
2005-10-27	ACAD	Stock	11.01	11.03	10.61	10.62	25800.0
2005-10-27	ACAP-DELISTED	Stock	43.01	43.45	42.25	42.49	30614.0
2005-10-27	ACAS-DELISTED	Stock	36.55	36.992	36.46	36.71	396685.0
2005-10-27	ACAT-DELISTED	Stock	18.72	18.84	18.38	18.5	59632.0
2005-10-27	ACC-DELISTED	Stock	23.74	24.09	23.66	23.71	52900.0
2005-10-27	ACCL-DELISTED	Stock	6.78	6.82	6.22	6.34	141188.0
2005-10-27	ACCO	Stock	24.85	24.95	23.9	24.5	228800.0
2005-10-27	ACE-DELISTED	Stock	50.75	51.0	50.0	50.23	3389700.0
2005-10-27	ACF-DELISTED	Stock	21.83	22.01	21.32	21.44	1594700.0
2005-10-27	ACFC-DELISTED	Stock	69.9	70.66	69.85	70.56	1843.0
2005-10-27	ACG-DELISTED	Stock	8.23	8.24	8.2	8.23	172300.0
2005-10-27	ACGL	Stock	5.4	5.4356	5.2956	5.3444	947700.0
2005-10-27	ACGN-DELISTED	Stock	895.3288	906.6712	838.6712	850.0	135400.0

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

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