PREVIEW / stock_daily / 2006-03-21

all stock daily files

  file:    by_date/stock_daily/2006/2006-03-21.parquet
  size:    147 KB
  rows:    4,366
  symbols: 2,760

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-21	AAPL	Stock	2.2075	2.2979	2.1925	2.2075	1345366400.0
2006-03-21	MSFT	Stock	27.74	28.22	27.68	27.74	73199600.0
2006-03-21	NVDA	Stock	0.4232	0.4308	0.4122	0.4232	1235472000.0
2006-03-21	AMZN	Stock	1.796	1.8365	1.783	1.796	133432000.0
2006-03-21	CL	Stock	28.5	28.945	28.5	28.79	4153600.0
2006-03-21	A	Stock	26.8956	26.9814	26.4664	26.5522	3594817.0
2006-03-21	AABA-DELISTED	Stock	30.1100006103516	30.7800006866455	30.0200004577637	30.1100006103516	18876400.0
2006-03-21	AACC-DELISTED	Stock	19.73	19.8235	19.4	19.59	179966.0
2006-03-21	AACQ-DELISTED	Stock	5.48	5.48	5.48	5.48	500.0
2006-03-21	AACQU-DELISTED	Stock	7.05	7.05	7.05	7.05	2500.0
2006-03-21	AACQW-DELISTED	Stock	0.79	0.79	0.78	0.78	22000.0
2006-03-21	AAI-DELISTED	Stock	18.23	18.45	17.72	17.88	1631200.0
2006-03-21	AAIC-DELISTED	Stock	184.8	186.2	180.6	182.8	833100.0
2006-03-21	AAME	Stock	2.9	2.9	2.9	2.9	1900.0
2006-03-21	AAON	Stock	2.9261	3.0038	2.9221	2.9261	129853.0
2006-03-21	AAP	Stock	41.19	41.63	41.04	41.2	537800.0
2006-03-21	AATI-DELISTED	Stock	11.5	11.65	11.18	11.24	1154514.0
2006-03-21	AAU-DELISTED	Stock	2.65	2.67	2.6	2.6495	45396.0
2006-03-21	AAUAF-DELISTED	Stock	2.65	2.67	2.6	2.6491	45400.0
2006-03-21	AAV-DELISTED	Stock	19.01	19.05	18.73	18.76	411600.0
2006-03-21	AAWW-DELISTED	Stock	47.0	47.5	46.0	47.5	4100.0
2006-03-21	AAXN-DELISTED	Stock	10.5699996948242	10.6099996566772	10.3000001907349	10.3900003433228	2622900.0
2006-03-21	AB	Stock	64.39	64.9	64.22	64.3	205000.0
2006-03-21	ABAX-DELISTED	Stock	24.8	26.0	22.9	23.38	1289271.0
2006-03-21	ABB-DELISTED	Stock	12.14	12.19	12.07	12.08	1269000.0
2006-03-21	ABBC-DELISTED	Stock	13.29	13.4	13.25	13.33	46363.0
2006-03-21	ABC-DELISTED	Stock	23.72	24.02	23.62	23.66	2777200.0
2006-03-21	ABCB	Stock	21.4273	22.2638	21.4176	21.4273	22002.0
2006-03-21	ABCO-DELISTED	Stock	28.08	28.29	27.61	28.18	268986.0
2006-03-21	ABCW-DELISTED	Stock	30.27	30.27	29.32	29.35	33660.0
2006-03-21	ABD-DELISTED	Stock	22.6	22.8	22.42	22.62	254700.0
2006-03-21	ABE-DELISTED	Stock	12.8	12.8	12.69	12.69	29600.0
2006-03-21	ABFS-DELISTED	Stock	42.38	42.38	41.4	41.41	277565.0
2006-03-21	ABG	Stock	20.19	20.19	19.67	19.75	111400.0
2006-03-21	ABK-DELISTED	Stock	81.97	81.99	80.23	80.29	621900.0
2006-03-21	ABM	Stock	17.22	17.48	17.01	17.05	293200.0
2006-03-21	ABMD-DELISTED	Stock	12.17	12.24	11.61	11.78	85199.0
2006-03-21	ABP-DELISTED	Stock	5.73	5.75	5.52	5.56	486800.0
2006-03-21	ABR	Stock	26.75	26.94	26.36	26.51	113600.0
2006-03-21	ABT	Stock	21.3367	21.3799	20.9673	21.0824	8293247.0
2006-03-21	ABTL-DELISTED	Stock	23.66	23.71	22.95	23.05	66470.0
2006-03-21	ABV-DELISTED	Stock	42.74	42.81	41.83	42.04	421700.0
2006-03-21	ABVT-DELISTED	Stock	39.0	39.0	39.0	39.0	100.0
2006-03-21	ABX-DELISTED	Stock	26.49	26.53	26.05	26.19	4249200.0
2006-03-21	ACAD	Stock	15.25	15.83	15.19	15.46	579300.0
2006-03-21	ACAP-DELISTED	Stock	49.91	50.72	47.96	48.0	49615.0
2006-03-21	ACAS-DELISTED	Stock	35.6	35.64	35.24	35.25	614657.0
2006-03-21	ACAT-DELISTED	Stock	24.4	24.4	23.25	23.25	51228.0
2006-03-21	ACC-DELISTED	Stock	26.75	26.75	26.13	26.51	152400.0
2006-03-21	ACCL-DELISTED	Stock	7.42	7.42	7.23	7.25	79160.0

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

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