PREVIEW / stock_daily / 2006-04-20

all stock daily files

  file:    by_date/stock_daily/2006/2006-04-20.parquet
  size:    148 KB
  rows:    4,403
  symbols: 2,782

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
2006-04-20	AAPL	Stock	2.4825	2.5	2.3643	2.4154	1666982800.0
2006-04-20	MSFT	Stock	27.05	27.19	26.7	27.03	45648300.0
2006-04-20	NVDA	Stock	0.4817	0.494	0.4737	0.4853	552684000.0
2006-04-20	AMZN	Stock	1.835	1.86	1.8115	1.817	107752000.0
2006-04-20	CL	Stock	28.305	28.725	28.305	28.47	3480800.0
2006-04-20	A	Stock	27.6681	28.2189	27.6323	27.8755	4884752.0
2006-04-20	AABA-DELISTED	Stock	33.4799995422363	33.7000007629395	32.9300003051758	33.3699989318848	23403900.0
2006-04-20	AACC-DELISTED	Stock	21.23	21.42	20.66	20.91	42048.0
2006-04-20	AACQU-DELISTED	Stock	6.71	6.73	6.71	6.71	10000.0
2006-04-20	AACQW-DELISTED	Stock	0.72	0.73	0.71	0.73	45000.0
2006-04-20	AAI-DELISTED	Stock	15.01	15.35	14.95	15.01	1455800.0
2006-04-20	AAIC-DELISTED	Stock	184.0	187.2	183.0	187.0	597000.0
2006-04-20	AAME	Stock	2.82	2.82	2.82	2.82	500.0
2006-04-20	AAON	Stock	3.2198	3.2263	3.2053	3.2092	53156.0
2006-04-20	AAP	Stock	38.77	39.88	38.75	39.5	2196400.0
2006-04-20	AATI-DELISTED	Stock	12.07	12.07	11.95	12.05	536724.0
2006-04-20	AAU-DELISTED	Stock	2.93	2.93	2.68	2.71	129500.0
2006-04-20	AAUAF-DELISTED	Stock	2.93	2.93	2.68	2.71	129500.0
2006-04-20	AAV-DELISTED	Stock	20.42	20.45	20.04	20.15	332400.0
2006-04-20	AAWW-DELISTED	Stock	45.75	46.0	45.0	46.0	171800.0
2006-04-20	AAXN-DELISTED	Stock	10.6400003433228	10.8800001144409	10.4499998092651	10.7600002288818	1215900.0
2006-04-20	AB	Stock	71.45	71.6	70.35	71.55	140500.0
2006-04-20	ABAX-DELISTED	Stock	25.41	26.16	25.41	25.993	257622.0
2006-04-20	ABB-DELISTED	Stock	13.38	13.42	13.3	13.38	1449200.0
2006-04-20	ABBC-DELISTED	Stock	13.38	13.38	13.38	13.38	1100.0
2006-04-20	ABC-DELISTED	Stock	23.72	23.89	23.4	23.76	2530600.0
2006-04-20	ABCB	Stock	22.7598	22.7598	22.079	22.4097	16347.0
2006-04-20	ABCO-DELISTED	Stock	28.2	28.41	27.38	27.9	54914.0
2006-04-20	ABCW-DELISTED	Stock	29.44	29.52	28.62	28.83	26180.0
2006-04-20	ABD-DELISTED	Stock	21.7	21.99	21.2	21.54	393510.0
2006-04-20	ABE-DELISTED	Stock	13.18	13.27	13.1301	13.19	16700.0
2006-04-20	ABFS-DELISTED	Stock	41.55	43.76	41.55	42.68	519121.0
2006-04-20	ABG	Stock	18.5	18.78	18.38	18.64	40200.0
2006-04-20	ABK-DELISTED	Stock	78.3	79.24	78.04	78.83	559900.0
2006-04-20	ABM	Stock	17.31	17.54	17.15	17.41	216200.0
2006-04-20	ABMD-DELISTED	Stock	13.69	13.98	13.4281	13.96	73509.0
2006-04-20	ABP-DELISTED	Stock	6.24	6.25	6.02	6.06	676800.0
2006-04-20	ABR	Stock	25.88	25.88	25.52	25.53	52500.0
2006-04-20	ABT	Stock	19.8349	20.1372	19.6238	20.1084	13190288.0
2006-04-20	ABTL-DELISTED	Stock	22.9	23.25	22.65	22.95	37077.0
2006-04-20	ABV-DELISTED	Stock	47.01	47.59	46.768	47.2	435900.0
2006-04-20	ABVA-DELISTED	Stock	18.706	18.714	18.614	18.614	71312.0
2006-04-20	ABVT-DELISTED	Stock	40.0	40.0	40.0	40.0	1500.0
2006-04-20	ABX-DELISTED	Stock	30.91	30.92	29.46	29.4774	6674400.0
2006-04-20	ACAD	Stock	15.2	15.23	15.05	15.11	188300.0
2006-04-20	ACAP-DELISTED	Stock	47.96	48.09	47.02	48.09	12243.0
2006-04-20	ACAS-DELISTED	Stock	34.67	34.7	34.23	34.46	854087.0
2006-04-20	ACAT-DELISTED	Stock	20.87	21.19	20.67	21.17	27642.0
2006-04-20	ACC-DELISTED	Stock	25.69	25.69	24.99	25.14	84800.0
2006-04-20	ACCL-DELISTED	Stock	7.35	7.39	7.2	7.34	52841.0

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

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