PREVIEW / stock_daily / 2006-03-14

all stock daily files

  file:    by_date/stock_daily/2006/2006-03-14.parquet
  size:    146 KB
  rows:    4,361
  symbols: 2,751

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-14	AAPL	Stock	2.3489	2.4043	2.3393	2.4043	642020400.0
2006-03-14	MSFT	Stock	27.04	27.38	26.99	27.23	39821800.0
2006-03-14	NVDA	Stock	0.4	0.4124	0.3985	0.4107	627792000.0
2006-03-14	AMZN	Stock	1.802	1.85	1.8005	1.8455	83704000.0
2006-03-14	CL	Stock	28.66	28.67	28.21	28.325	9052000.0
2006-03-14	A	Stock	26.3376	26.4306	26.0801	26.3519	4287946.0
2006-03-14	AABA-DELISTED	Stock	30.1000003814697	31.0	30.1000003814697	30.9899997711182	19294700.0
2006-03-14	AACC-DELISTED	Stock	19.82	20.02	19.8	19.96	182155.0
2006-03-14	AACQU-DELISTED	Stock	6.8	6.8	6.8	6.8	2500.0
2006-03-14	AACQW-DELISTED	Stock	0.73	0.75	0.73	0.75	172708.0
2006-03-14	AAI-DELISTED	Stock	17.15	17.3	17.0	17.18	1024500.0
2006-03-14	AAIC-DELISTED	Stock	183.8	189.8	183.8	188.4	1067900.0
2006-03-14	AAME	Stock	2.76	3.0	2.71	3.0	1200.0
2006-03-14	AAON	Stock	2.9261	2.9959	2.9248	2.9946	100237.0
2006-03-14	AAP	Stock	41.13	41.44	40.85	41.21	926400.0
2006-03-14	AATI-DELISTED	Stock	12.37	12.37	11.7	12.08	523850.0
2006-03-14	AAU-DELISTED	Stock	2.65	2.65	2.581	2.64	28700.0
2006-03-14	AAUAF-DELISTED	Stock	2.65	2.65	2.581	2.6399	28700.0
2006-03-14	AAV-DELISTED	Stock	19.2	19.46	19.1	19.4	214500.0
2006-03-14	AAWW-DELISTED	Stock	47.0	47.0	47.0	47.0	13000.0
2006-03-14	AAXN-DELISTED	Stock	9.61999988555908	9.89999961853027	9.5	9.73999977111816	1412300.0
2006-03-14	AB	Stock	64.05	64.85	64.0	64.3	218000.0
2006-03-14	ABAX-DELISTED	Stock	20.65	20.726	19.9	20.39	284212.0
2006-03-14	ABB-DELISTED	Stock	12.33	12.45	12.29	12.43	1634400.0
2006-03-14	ABBC-DELISTED	Stock	13.3084	13.3084	13.28	13.3	20571.0
2006-03-14	ABC-DELISTED	Stock	22.95	23.22	22.76	23.15	2242600.0
2006-03-14	ABCB	Stock	21.6024	22.1665	21.5926	22.0984	13468.0
2006-03-14	ABCO-DELISTED	Stock	26.46	26.69	26.18	26.43	203756.0
2006-03-14	ABCW-DELISTED	Stock	29.76	30.36	29.43	30.33	43010.0
2006-03-14	ABD-DELISTED	Stock	21.98	22.08	21.93	22.0	81100.0
2006-03-14	ABE-DELISTED	Stock	12.7	12.7	12.3	12.51	58100.0
2006-03-14	ABFS-DELISTED	Stock	42.06	42.39	41.86	42.29	216423.0
2006-03-14	ABG	Stock	19.46	19.84	19.35	19.76	52300.0
2006-03-14	ABK-DELISTED	Stock	78.85	79.91	78.77	79.81	308900.0
2006-03-14	ABM	Stock	16.75	17.06	16.35	17.06	795600.0
2006-03-14	ABMD-DELISTED	Stock	10.45	10.73	10.39	10.72	53919.0
2006-03-14	ABP-DELISTED	Stock	5.59	5.92	5.59	5.86	438300.0
2006-03-14	ABR	Stock	26.52	26.8	26.26	26.69	39100.0
2006-03-14	ABT	Stock	21.3991	21.687	21.3847	21.6678	11656732.0
2006-03-14	ABTL-DELISTED	Stock	20.38	20.83	20.12	20.32	32218.0
2006-03-14	ABV-DELISTED	Stock	41.8	42.86	41.8	42.64	234200.0
2006-03-14	ABVA-DELISTED	Stock	18.643	18.709	18.643	18.657	3076.0
2006-03-14	ABX-DELISTED	Stock	26.07	26.53	25.879	26.48	3385859.0
2006-03-14	ACAD	Stock	15.35	16.45	15.26	16.35	940200.0
2006-03-14	ACAP-DELISTED	Stock	49.02	49.69	48.76	49.56	19632.0
2006-03-14	ACAS-DELISTED	Stock	35.37	35.88	35.25	35.7	1047757.0
2006-03-14	ACAT-DELISTED	Stock	22.98	23.16	22.84	22.98	41748.0
2006-03-14	ACC-DELISTED	Stock	25.97	26.59	25.87	26.59	46656.0
2006-03-14	ACCL-DELISTED	Stock	7.12	7.19	7.03	7.13	70044.0
2006-03-14	ACCO	Stock	21.98	22.08	21.93	22.0	83000.0

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

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