PREVIEW / stock_daily / 2005-07-18

all stock daily files

  file:    by_date/stock_daily/2005/2005-07-18.parquet
  size:    138 KB
  rows:    4,133
  symbols: 2,583

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-07-18	AAPL	Stock	1.4789	1.5036	1.4775	1.4818	586297600.0
2005-07-18	MSFT	Stock	25.71	25.79	25.55	25.55	39668000.0
2005-07-18	NVDA	Stock	0.2234	0.2235	0.2162	0.2185	1044900000.0
2005-07-18	AMZN	Stock	1.8475	1.8595	1.838	1.8595	59466000.0
2005-07-18	CL	Stock	25.775	25.955	25.73	25.74	3592400.0
2005-07-18	A	Stock	18.3119	18.3619	18.083	18.3619	1994666.0
2005-07-18	AABA-DELISTED	Stock	36.4500007629395	36.7799987792969	36.3699989318848	36.5800018310547	11019300.0
2005-07-18	AACC-DELISTED	Stock	24.51	25.0	24.22	24.74	108821.0
2005-07-18	AAI-DELISTED	Stock	9.99	10.14	9.943	9.99	1001900.0
2005-07-18	AAIC-DELISTED	Stock	296.0	296.0	287.8	293.4	1209300.0
2005-07-18	AAME	Stock	3.0	3.01	3.0	3.01	400.0
2005-07-18	AAON	Stock	2.3691	2.4059	2.3664	2.3835	40247.0
2005-07-18	AAP	Stock	43.38	44.4133	43.3467	44.3333	730950.0
2005-07-18	AAV-DELISTED	Stock	14.2	14.85	14.2	14.2	63200.0
2005-07-18	AAXN-DELISTED	Stock	10.1999998092651	10.1999998092651	10.0100002288818	10.1000003814697	1390400.0
2005-07-18	ABAX-DELISTED	Stock	11.09	11.13	10.9	10.91	50458.0
2005-07-18	ABB-DELISTED	Stock	6.57	6.6	6.51	6.54	375700.0
2005-07-18	ABBC-DELISTED	Stock	12.06	12.1	12.04	12.08	9880.0
2005-07-18	ABC-DELISTED	Stock	17.6	17.74	17.6	17.7	3080800.0
2005-07-18	ABCB	Stock	18.6942	18.9665	18.3343	18.5678	17273.0
2005-07-18	ABCO-DELISTED	Stock	23.87	24.09	23.54	23.73	173302.0
2005-07-18	ABCW-DELISTED	Stock	29.66	30.16	29.62	29.74	35918.0
2005-07-18	ABE-DELISTED	Stock	10.24	10.24	10.2	10.2	7400.0
2005-07-18	ABFS-DELISTED	Stock	34.36	34.46	33.89	33.9	271747.0
2005-07-18	ABG	Stock	16.4	16.7	16.33	16.5	98600.0
2005-07-18	ABK-DELISTED	Stock	72.55	72.84	71.92	72.48	378100.0
2005-07-18	ABM	Stock	19.64	19.69	19.42	19.5	224800.0
2005-07-18	ABMD-DELISTED	Stock	9.24	9.44	8.89	8.89	100958.0
2005-07-18	ABP-DELISTED	Stock	3.77	3.77	3.36	3.6	311300.0
2005-07-18	ABR	Stock	29.45	29.75	29.24	29.73	93100.0
2005-07-18	ABT	Stock	22.5266	22.6514	22.2675	22.2675	8551063.0
2005-07-18	ABTL-DELISTED	Stock	21.93	23.42	21.93	23.07	28918.0
2005-07-18	ABV-DELISTED	Stock	31.15	31.42	31.03	31.17	141700.0
2005-07-18	ABVA-DELISTED	Stock	15.75	15.75	15.5	15.5	3000.0
2005-07-18	ABX-DELISTED	Stock	23.74	23.85	23.53	23.54	1319700.0
2005-07-18	ACAD	Stock	8.89	8.94	8.78	8.83	56600.0
2005-07-18	ACAP-DELISTED	Stock	38.48	38.61	37.61	37.96	34774.0
2005-07-18	ACAS-DELISTED	Stock	37.04	37.54	37.03	37.34	628422.0
2005-07-18	ACAT-DELISTED	Stock	20.23	20.31	20.1	20.19	100237.0
2005-07-18	ACC-DELISTED	Stock	23.5	23.83	23.41	23.7	49257.0
2005-07-18	ACCL-DELISTED	Stock	5.33	5.59	5.29	5.47	118934.0
2005-07-18	ACE-DELISTED	Stock	45.96	45.98	45.63	45.63	524200.0
2005-07-18	ACF-DELISTED	Stock	26.62	26.95	26.59	26.74	1351300.0
2005-07-18	ACFC-DELISTED	Stock	67.86	67.86	66.22	66.68	2402.0
2005-07-18	ACG-DELISTED	Stock	8.31	8.32	8.28	8.3	356700.0
2005-07-18	ACGL	Stock	5.03	5.0344	5.0178	5.03	449100.0
2005-07-18	ACGN-DELISTED	Stock	612.0	623.3288	589.3288	612.0	30500.0
2005-07-18	ACH	Stock	21.2	21.4333	21.0133	21.2067	378000.0
2005-07-18	ACH-DELISTED	Stock	13.957	13.997	13.91	13.932	88800.0
2005-07-18	ACLS	Stock	28.76	28.92	28.0	28.24	154925.0

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

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