PREVIEW / stock_daily / 2006-03-07

all stock daily files

  file:    by_date/stock_daily/2006/2006-03-07.parquet
  size:    146 KB
  rows:    4,332
  symbols: 2,736

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-03-07	AAPL	Stock	2.3486	2.3893	2.3243	2.3682	872877600.0
2006-03-07	MSFT	Stock	26.9	27.1	26.81	27.06	51613900.0
2006-03-07	NVDA	Stock	0.4089	0.4121	0.3937	0.4018	606204000.0
2006-03-07	AMZN	Stock	1.8355	1.871	1.835	1.8465	94446000.0
2006-03-07	CL	Stock	27.035	27.425	27.01	27.32	2993200.0
2006-03-07	A	Stock	25.7582	26.073	25.6867	26.0014	3846877.0
2006-03-07	AABA-DELISTED	Stock	31.4200000762939	32.2000007629395	31.3099994659424	31.4300003051758	23365100.0
2006-03-07	AACC-DELISTED	Stock	19.51	19.88	19.44	19.46	182390.0
2006-03-07	AACQ-DELISTED	Stock	5.36	5.36	5.36	5.36	20000.0
2006-03-07	AACQW-DELISTED	Stock	0.69	0.69	0.65	0.65	27000.0
2006-03-07	AAI-DELISTED	Stock	17.23	17.6	17.16	17.22	760900.0
2006-03-07	AAIC-DELISTED	Stock	188.0	188.6	181.0	182.8	2309900.0
2006-03-07	AAME	Stock	3.0	3.0	2.58	2.95	17900.0
2006-03-07	AAON	Stock	2.8313	2.8971	2.8049	2.8747	179212.0
2006-03-07	AAP	Stock	42.41	42.7	42.1	42.44	978600.0
2006-03-07	AATI-DELISTED	Stock	12.69	12.69	12.5	12.64	251482.0
2006-03-07	AAU-DELISTED	Stock	2.76	2.76	2.673	2.7	37900.0
2006-03-07	AAUAF-DELISTED	Stock	2.76	2.76	2.673	2.7	37900.0
2006-03-07	AAV-DELISTED	Stock	18.71	18.71	18.3	18.4	493100.0
2006-03-07	AAXN-DELISTED	Stock	9.94999980926514	9.94999980926514	9.55000019073486	9.71000003814697	1414400.0
2006-03-07	AB	Stock	63.7	63.75	62.28	63.0	247200.0
2006-03-07	ABAX-DELISTED	Stock	22.29	22.5	21.5	21.54	173968.0
2006-03-07	ABB-DELISTED	Stock	11.87	11.93	11.75	11.92	3000300.0
2006-03-07	ABBC-DELISTED	Stock	13.3	13.38	13.3	13.38	2100.0
2006-03-07	ABC-DELISTED	Stock	22.56	22.8	22.54	22.78	2395000.0
2006-03-07	ABCB	Stock	21.1938	21.1938	20.6394	20.9118	12235.0
2006-03-07	ABCO-DELISTED	Stock	26.98	27.1	26.48	27.06	92846.0
2006-03-07	ABCW-DELISTED	Stock	29.85	30.03	29.65	29.76	46090.0
2006-03-07	ABD-DELISTED	Stock	22.87	22.95	22.66	22.79	55100.0
2006-03-07	ABE-DELISTED	Stock	13.2	13.34	12.72	12.72	42100.0
2006-03-07	ABFS-DELISTED	Stock	41.4	41.95	41.1	41.74	366566.0
2006-03-07	ABG	Stock	19.6	19.71	19.15	19.3	82500.0
2006-03-07	ABK-DELISTED	Stock	75.46	76.71	75.43	76.59	490100.0
2006-03-07	ABM	Stock	18.75	18.85	18.65	18.85	124100.0
2006-03-07	ABMD-DELISTED	Stock	10.63	10.78	10.38	10.55	114649.0
2006-03-07	ABP-DELISTED	Stock	5.68	5.7	5.27	5.43	842100.0
2006-03-07	ABR	Stock	26.65	26.79	26.29	26.34	47800.0
2006-03-07	ABT	Stock	20.8665	21.0248	20.641	20.8857	7711546.0
2006-03-07	ABTL-DELISTED	Stock	21.62	21.62	20.58	20.93	44314.0
2006-03-07	ABV-DELISTED	Stock	42.71	42.71	41.3801	41.96	334500.0
2006-03-07	ABVA-DELISTED	Stock	18.702	18.702	18.598	18.598	1973.0
2006-03-07	ABX-DELISTED	Stock	27.29	27.32	26.52	27.01	4417000.0
2006-03-07	ACAD	Stock	14.95	15.2	14.55	14.81	269500.0
2006-03-07	ACAP-DELISTED	Stock	49.03	49.12	47.08	47.08	54648.0
2006-03-07	ACAS-DELISTED	Stock	35.64	35.66	34.63	34.94	1733969.0
2006-03-07	ACAT-DELISTED	Stock	24.02	24.15	23.86	23.86	30094.0
2006-03-07	ACC-DELISTED	Stock	25.82	26.04	25.76	26.02	50700.0
2006-03-07	ACCL-DELISTED	Stock	6.75	6.856	6.52	6.75	96513.0
2006-03-07	ACCO	Stock	22.87	22.95	22.66	22.79	55600.0
2006-03-07	ACCP-DELISTED	Stock	2.0	2.05	1.45	1.45	258669.0

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

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