PREVIEW / stock_daily / 2004-07-20

all stock daily files

  file:    by_date/stock_daily/2004/2004-07-20.parquet
  size:    127 KB
  rows:    3,773
  symbols: 2,353

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
2004-07-20	AAPL	Stock	0.5705	0.575	0.5634	0.575	323747200.0
2004-07-20	MSFT	Stock	28.0	28.48	27.85	28.32	89010700.0
2004-07-20	NVDA	Stock	0.1278	0.131	0.1266	0.1305	341544000.0
2004-07-20	AMZN	Stock	2.307	2.3925	2.306	2.3495	152526000.0
2004-07-20	CL	Stock	28.015	28.31	27.945	28.31	4349200.0
2004-07-20	A	Stock	17.9471	18.6624	17.7539	18.4478	4263760.0
2004-07-20	AABA-DELISTED	Stock	28.2000007629395	29.6299991607666	28.1599998474121	29.3899993896484	19513500.0
2004-07-20	AACC-DELISTED	Stock	16.7	17.56	16.13	17.07	56885.0
2004-07-20	AAI-DELISTED	Stock	11.95	12.63	11.9	12.63	1280600.0
2004-07-20	AAIC-DELISTED	Stock	336.0	353.8	334.0	352.0	1888000.0
2004-07-20	AAME	Stock	2.81	2.94	2.81	2.93	4800.0
2004-07-20	AAON	Stock	2.3717	2.4362	2.344	2.4362	180731.0
2004-07-20	AAP	Stock	23.9467	24.6	23.92	24.5533	2110350.0
2004-07-20	AAV-DELISTED	Stock	14.74	14.83	14.62	14.74	17300.0
2004-07-20	AAXN-DELISTED	Stock	17.1200008392334	18.3500003814697	15.125	15.5200004577637	51767000.0
2004-07-20	ABAX-DELISTED	Stock	14.81	15.55	14.81	15.2	175495.0
2004-07-20	ABB-DELISTED	Stock	5.15	5.22	5.11	5.22	321300.0
2004-07-20	ABC-DELISTED	Stock	13.4	13.51	13.36	13.46	3416800.0
2004-07-20	ABCB	Stock	15.157	15.23	14.9139	15.23	17519.0
2004-07-20	ABCO-DELISTED	Stock	15.665	15.69	15.305	15.5	524540.0
2004-07-20	ABCW-DELISTED	Stock	25.22	26.53	25.22	26.53	142020.0
2004-07-20	ABE-DELISTED	Stock	7.84	7.85	7.82	7.84	9000.0
2004-07-20	ABFS-DELISTED	Stock	34.08	34.45	33.0	34.17	1121969.0
2004-07-20	ABG	Stock	12.9	12.9	12.25	12.59	58400.0
2004-07-20	ABK-DELISTED	Stock	70.67	70.67	69.53	70.28	676800.0
2004-07-20	ABM	Stock	18.47	18.54	18.4	18.5	187900.0
2004-07-20	ABMD-DELISTED	Stock	10.92	11.04	10.34	10.88	64043.0
2004-07-20	ABP-DELISTED	Stock	1.38	1.4	1.31	1.34	76900.0
2004-07-20	ABR	Stock	19.55	19.55	19.35	19.43	5700.0
2004-07-20	ABT	Stock	18.7746	18.9329	18.6882	18.8897	4349521.0
2004-07-20	ABTL-DELISTED	Stock	34.5	38.0	33.55	38.0	91100.0
2004-07-20	ABV-DELISTED	Stock	21.62	21.75	21.58	21.63	418900.0
2004-07-20	ABVA-DELISTED	Stock	15.39	15.39	15.25	15.25	300.0
2004-07-20	ABX-DELISTED	Stock	20.13	20.38	19.98	20.29	1488000.0
2004-07-20	ACAD	Stock	6.03	6.2	6.0	6.2	2200.0
2004-07-20	ACAP-DELISTED	Stock	23.65	23.93	23.37	23.79	14587.0
2004-07-20	ACAS-DELISTED	Stock	29.12	29.47	28.95	29.47	722880.0
2004-07-20	ACAT-DELISTED	Stock	26.25	27.61	25.11	27.4	112136.0
2004-07-20	ACCL-DELISTED	Stock	7.4	7.89	7.19	7.6	174924.0
2004-07-20	ACE-DELISTED	Stock	41.4	41.41	39.99	40.3	3125100.0
2004-07-20	ACF-DELISTED	Stock	19.8	20.41	19.59	20.41	1526100.0
2004-07-20	ACG-DELISTED	Stock	8.11	8.14	8.11	8.12	485600.0
2004-07-20	ACGL	Stock	4.46	4.4822	4.2356	4.2533	5132700.0
2004-07-20	ACGN-DELISTED	Stock	634.6712	646.0	634.6712	634.6712	54500.0
2004-07-20	ACH	Stock	16.6867	16.9933	16.4733	16.9867	189600.0
2004-07-20	ACH-DELISTED	Stock	13.625	13.75	13.488	13.74	708000.0
2004-07-20	ACLS	Stock	38.0	39.52	37.84	39.28	226950.0
2004-07-20	ACO-DELISTED	Stock	18.59	19.0	18.59	19.0	129100.0
2004-07-20	ACPW-DELISTED	Stock	14.25	14.75	14.2	14.5	6295.0
2004-07-20	ACS-DELISTED	Stock	51.8	53.42	51.42	53.42	923100.0

> showing 50 of 3,773 rows — these rows as CSV

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