PREVIEW / stock_daily / 2005-11-23

all stock daily files

  file:    by_date/stock_daily/2005/2005-11-23.parquet
  size:    142 KB
  rows:    4,266
  symbols: 2,687

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-11-23	AAPL	Stock	2.3886	2.4279	2.3818	2.3968	485853200.0
2005-11-23	MSFT	Stock	27.92	28.09	27.74	27.92	70541300.0
2005-11-23	NVDA	Stock	0.3154	0.3187	0.3125	0.3142	411948000.0
2005-11-23	AMZN	Stock	2.4385	2.448	2.4045	2.412	149664000.0
2005-11-23	CL	Stock	26.995	27.05	26.825	27.0	2126600.0
2005-11-23	A	Stock	25.3577	25.6009	25.3577	25.5007	3512195.0
2005-11-23	AABA-DELISTED	Stock	42.2099990844727	43.4500007629395	42.1699981689453	42.5	21471000.0
2005-11-23	AACC-DELISTED	Stock	20.33	20.34	20.03	20.15	225816.0
2005-11-23	AAI-DELISTED	Stock	15.24	15.59	15.16	15.48	1336800.0
2005-11-23	AAIC-DELISTED	Stock	212.0	227.0	211.0	220.0	3705600.0
2005-11-23	AAME	Stock	2.51	2.68	2.51	2.64	2100.0
2005-11-23	AAON	Stock	2.19	2.211	2.19	2.2058	61509.0
2005-11-23	AAP	Stock	42.75	43.0	42.57	42.82	648000.0
2005-11-23	AATI-DELISTED	Stock	12.85	12.9	12.48	12.79	45062.0
2005-11-23	AAV-DELISTED	Stock	17.95	17.95	17.54	17.95	70300.0
2005-11-23	AAWW-DELISTED	Stock	33.0	33.25	32.5	32.75	156300.0
2005-11-23	AAXN-DELISTED	Stock	7.11999988555908	7.5	7.07000017166138	7.40000009536743	3303100.0
2005-11-23	ABAX-DELISTED	Stock	17.9	17.92	17.6	17.68	191880.0
2005-11-23	ABB-DELISTED	Stock	8.81	8.91	8.76	8.8	2565000.0
2005-11-23	ABBC-DELISTED	Stock	12.4585	12.75	12.43	12.722	5635.0
2005-11-23	ABC-DELISTED	Stock	19.81	19.93	19.76	19.83	2010400.0
2005-11-23	ABCB	Stock	19.9489	20.0364	19.6571	19.7544	26731.0
2005-11-23	ABCO-DELISTED	Stock	23.98	24.12	23.76	23.85	68565.0
2005-11-23	ABCW-DELISTED	Stock	30.65	31.23	30.6	30.99	32040.0
2005-11-23	ABD-DELISTED	Stock	23.3	23.85	23.3	23.75	947700.0
2005-11-23	ABE-DELISTED	Stock	11.51	11.68	11.51	11.61	35400.0
2005-11-23	ABFS-DELISTED	Stock	42.02	42.24	41.89	42.09	301996.0
2005-11-23	ABG	Stock	16.47	16.59	16.17	16.4	38700.0
2005-11-23	ABK-DELISTED	Stock	76.28	77.73	76.07	77.54	291200.0
2005-11-23	ABM	Stock	20.96	21.15	20.8	20.86	114300.0
2005-11-23	ABMD-DELISTED	Stock	8.91	9.0	8.85	8.85	36978.0
2005-11-23	ABP-DELISTED	Stock	7.15	7.24	6.99	7.12	743400.0
2005-11-23	ABR	Stock	27.29	27.39	26.99	27.25	55700.0
2005-11-23	ABT	Stock	18.8226	18.9425	18.6258	18.7074	15497082.0
2005-11-23	ABTL-DELISTED	Stock	26.97	27.78	26.57	27.53	50132.0
2005-11-23	ABV-DELISTED	Stock	37.5	38.26	37.5	37.9	422100.0
2005-11-23	ABVA-DELISTED	Stock	16.7	16.7	16.66	16.7	4300.0
2005-11-23	ABX-DELISTED	Stock	27.51	27.63	27.11	27.15	2561100.0
2005-11-23	ACAD	Stock	9.55	9.55	9.31	9.35	9600.0
2005-11-23	ACAP-DELISTED	Stock	44.7	44.8	44.15	44.39	34601.0
2005-11-23	ACAS-DELISTED	Stock	38.64	38.9	38.42	38.88	909070.0
2005-11-23	ACAT-DELISTED	Stock	20.3	21.88	20.3	21.77	47933.0
2005-11-23	ACC-DELISTED	Stock	25.64	25.65	25.18	25.34	69000.0
2005-11-23	ACCL-DELISTED	Stock	8.5	8.53	8.15	8.27	155209.0
2005-11-23	ACCO	Stock	23.3	23.85	23.3	23.75	947700.0
2005-11-23	ACE-DELISTED	Stock	55.2	56.6	55.2	56.23	675000.0
2005-11-23	ACF-DELISTED	Stock	24.75	25.24	24.75	25.15	1820100.0
2005-11-23	ACFC-DELISTED	Stock	74.74	75.66	74.74	75.66	4220.0
2005-11-23	ACG-DELISTED	Stock	8.2	8.24	8.2	8.22	341600.0
2005-11-23	ACGL	Stock	6.0444	6.1389	6.0344	6.1111	2450700.0

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

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