PREVIEW / stock_daily / 2005-07-20

all stock daily files

  file:    by_date/stock_daily/2005/2005-07-20.parquet
  size:    139 KB
  rows:    4,142
  symbols: 2,599

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-20	AAPL	Stock	1.5307	1.5643	1.5232	1.5582	453395600.0
2005-07-20	MSFT	Stock	26.0	26.23	25.88	26.19	71424800.0
2005-07-20	NVDA	Stock	0.2189	0.2257	0.2159	0.2248	526500000.0
2005-07-20	AMZN	Stock	1.8745	1.9125	1.865	1.9085	127368000.0
2005-07-20	CL	Stock	25.675	25.82	25.45	25.715	3046600.0
2005-07-20	A	Stock	18.5193	18.7053	18.3119	18.5408	3281386.0
2005-07-20	AABA-DELISTED	Stock	34.2099990844727	34.3499984741211	33.310001373291	33.4000015258789	82623300.0
2005-07-20	AACC-DELISTED	Stock	25.15	25.16	24.68	24.88	79069.0
2005-07-20	AACQU-DELISTED	Stock	5.8	5.8	5.8	5.8	1434.0
2005-07-20	AACQW-DELISTED	Stock	0.47	0.47	0.46	0.46	19000.0
2005-07-20	AAI-DELISTED	Stock	10.85	10.88	10.5	10.85	2019000.0
2005-07-20	AAIC-DELISTED	Stock	295.6	297.4	294.8	295.2	907100.0
2005-07-20	AAME	Stock	3.02	3.02	3.01	3.01	3800.0
2005-07-20	AAON	Stock	2.4968	2.506	2.4797	2.5021	166303.0
2005-07-20	AAP	Stock	44.4867	44.6667	44.1133	44.46	370200.0
2005-07-20	AAV-DELISTED	Stock	14.93	15.0	14.7	14.93	29800.0
2005-07-20	AAXN-DELISTED	Stock	9.52000045776367	9.89000034332275	9.51000022888184	9.67000007629395	3225400.0
2005-07-20	ABAX-DELISTED	Stock	10.99	11.74	10.99	11.65	104356.0
2005-07-20	ABB-DELISTED	Stock	6.52	6.59	6.45	6.58	566300.0
2005-07-20	ABBC-DELISTED	Stock	12.05	12.13	12.05	12.12	6744.0
2005-07-20	ABC-DELISTED	Stock	17.34	17.79	17.34	17.64	8410000.0
2005-07-20	ABCB	Stock	18.665	19.4529	18.4802	19.2875	10487.0
2005-07-20	ABCO-DELISTED	Stock	23.8	24.13	23.73	24.07	191243.0
2005-07-20	ABCW-DELISTED	Stock	30.0	30.85	29.72	30.72	33793.0
2005-07-20	ABE-DELISTED	Stock	10.2	10.24	10.2	10.24	21400.0
2005-07-20	ABFS-DELISTED	Stock	34.07	35.98	33.96	35.54	462263.0
2005-07-20	ABG	Stock	16.75	17.05	16.71	16.9	131800.0
2005-07-20	ABK-DELISTED	Stock	70.98	72.16	69.77	71.79	1695300.0
2005-07-20	ABM	Stock	19.48	19.8	19.47	19.78	150000.0
2005-07-20	ABMD-DELISTED	Stock	9.0	9.4	9.0	9.39	47202.0
2005-07-20	ABP-DELISTED	Stock	3.6	3.64	3.5	3.55	182800.0
2005-07-20	ABR	Stock	29.98	30.11	29.89	30.0	174300.0
2005-07-20	ABT	Stock	22.3107	22.5026	22.2579	22.4786	7931847.0
2005-07-20	ABTL-DELISTED	Stock	24.0	25.25	24.0	24.25	51222.0
2005-07-20	ABV-DELISTED	Stock	31.14	31.21	30.95	31.17	448300.0
2005-07-20	ABX-DELISTED	Stock	24.09	24.33	23.86	24.1	1660000.0
2005-07-20	ACAD	Stock	9.06	9.57	9.06	9.5	179900.0
2005-07-20	ACAP-DELISTED	Stock	38.62	39.0	38.19	38.9	25380.0
2005-07-20	ACAS-DELISTED	Stock	37.51	37.75	37.48	37.6	529845.0
2005-07-20	ACAT-DELISTED	Stock	20.76	21.19	20.46	20.72	98628.0
2005-07-20	ACC-DELISTED	Stock	23.83	24.0	23.7	23.98	100191.0
2005-07-20	ACCL-DELISTED	Stock	5.38	5.55	5.38	5.54	106802.0
2005-07-20	ACE-DELISTED	Stock	46.2	46.77	45.96	46.6	926400.0
2005-07-20	ACF-DELISTED	Stock	26.75	27.11	26.72	27.02	1081000.0
2005-07-20	ACFC-DELISTED	Stock	67.5	68.51	67.5	67.86	1488.0
2005-07-20	ACG-DELISTED	Stock	8.3	8.33	8.29	8.33	285300.0
2005-07-20	ACGL	Stock	4.9833	5.0	4.83	4.9078	1885500.0
2005-07-20	ACGN-DELISTED	Stock	612.0	623.3288	566.6712	623.3288	99900.0
2005-07-20	ACH	Stock	21.7333	22.1867	21.6733	22.1867	106500.0
2005-07-20	ACH-DELISTED	Stock	14.515	14.712	14.442	14.712	201600.0

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

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