PREVIEW / stock_daily / 2005-11-09

all stock daily files

  file:    by_date/stock_daily/2005/2005-11-09.parquet
  size:    142 KB
  rows:    4,235
  symbols: 2,672

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-09	AAPL	Stock	2.1429	2.1861	2.1429	2.1468	552930000.0
2005-11-09	MSFT	Stock	26.98	27.15	26.94	26.96	59562100.0
2005-11-09	NVDA	Stock	0.2779	0.2917	0.2747	0.2898	818880000.0
2005-11-09	AMZN	Stock	2.0895	2.1	2.064	2.07	69432000.0
2005-11-09	CL	Stock	26.41	26.64	26.35	26.58	4498200.0
2005-11-09	A	Stock	23.5336	23.7339	23.4692	23.6266	4411808.0
2005-11-09	AABA-DELISTED	Stock	37.7599983215332	38.0400009155273	37.4300003051758	37.75	12217600.0
2005-11-09	AACC-DELISTED	Stock	18.5	18.6	18.36	18.45	178100.0
2005-11-09	AACQU-DELISTED	Stock	5.95	5.95	5.95	5.95	1000.0
2005-11-09	AACQW-DELISTED	Stock	0.42	0.42	0.415	0.42	103000.0
2005-11-09	AAI-DELISTED	Stock	14.94	15.28	14.65	15.23	1865400.0
2005-11-09	AAIC-DELISTED	Stock	175.0	181.2	173.2	178.4	1166300.0
2005-11-09	AAON	Stock	2.2453	2.2821	2.236	2.2466	45562.0
2005-11-09	AAP	Stock	39.45	40.0	39.31	39.78	842200.0
2005-11-09	AATI-DELISTED	Stock	11.46	11.8	11.31	11.39	234275.0
2005-11-09	AAV-DELISTED	Stock	16.18	16.36	16.12	16.18	35800.0
2005-11-09	AAWW-DELISTED	Stock	30.0	31.0	30.0	31.0	130500.0
2005-11-09	AAXN-DELISTED	Stock	7.6399998664856	7.80000019073486	7.21000003814697	7.65000009536743	3237000.0
2005-11-09	ABAX-DELISTED	Stock	17.45	18.34	17.3	18.26	282599.0
2005-11-09	ABB-DELISTED	Stock	7.77	7.88	7.77	7.83	900000.0
2005-11-09	ABBC-DELISTED	Stock	12.05	12.14	12.03	12.14	1100.0
2005-11-09	ABC-DELISTED	Stock	19.26	19.28	19.12	19.22	3665600.0
2005-11-09	ABCB	Stock	18.8596	19.3944	18.6164	19.3458	8019.0
2005-11-09	ABCO-DELISTED	Stock	23.86	24.6	23.85	24.31	926318.0
2005-11-09	ABCW-DELISTED	Stock	32.25	32.36	31.44	31.87	59580.0
2005-11-09	ABD-DELISTED	Stock	23.65	23.65	21.7	22.25	1041940.0
2005-11-09	ABE-DELISTED	Stock	11.35	11.35	11.28	11.3	32700.0
2005-11-09	ABFS-DELISTED	Stock	41.31	41.99	40.94	41.83	274998.0
2005-11-09	ABG	Stock	17.09	17.56	16.89	17.22	58300.0
2005-11-09	ABK-DELISTED	Stock	74.0	74.08	72.85	73.72	985900.0
2005-11-09	ABM	Stock	20.26	20.6	20.12	20.45	81200.0
2005-11-09	ABMD-DELISTED	Stock	9.23	9.66	9.12	9.63	163100.0
2005-11-09	ABP-DELISTED	Stock	6.32	6.78	6.28	6.52	915600.0
2005-11-09	ABR	Stock	26.55	27.08	26.16	26.93	154700.0
2005-11-09	ABT	Stock	20.3483	20.6698	20.2284	20.4875	11058774.0
2005-11-09	ABTL-DELISTED	Stock	22.17	22.53	22.12	22.28	27265.0
2005-11-09	ABV-DELISTED	Stock	37.12	37.29	36.69	36.91	928800.0
2005-11-09	ABVA-DELISTED	Stock	16.55	16.55	16.51	16.51	500.0
2005-11-09	ABX-DELISTED	Stock	25.3	25.9	25.2	25.839	5007800.0
2005-11-09	ACAD	Stock	10.44	10.55	10.12	10.47	102400.0
2005-11-09	ACAP-DELISTED	Stock	45.11	45.11	44.41	44.89	41777.0
2005-11-09	ACAS-DELISTED	Stock	38.5	39.0	38.49	38.88	475861.0
2005-11-09	ACAT-DELISTED	Stock	19.28	19.66	19.28	19.65	55269.0
2005-11-09	ACC-DELISTED	Stock	24.85	25.43	24.8	25.35	42200.0
2005-11-09	ACCL-DELISTED	Stock	6.97	7.15	6.88	7.11	79235.0
2005-11-09	ACCO	Stock	23.65	23.65	21.7	22.25	1061800.0
2005-11-09	ACE-DELISTED	Stock	53.7	54.28	53.28	53.76	1160700.0
2005-11-09	ACF-DELISTED	Stock	22.5	22.76	22.38	22.67	1149900.0
2005-11-09	ACFC-DELISTED	Stock	74.12	74.14	73.28	73.28	1976.0
2005-11-09	ACG-DELISTED	Stock	8.26	8.3	8.23	8.26	315400.0

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

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