PREVIEW / stock_daily / 2006-03-16

all stock daily files

  file:    by_date/stock_daily/2006/2006-03-16.parquet
  size:    147 KB
  rows:    4,370
  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-16	AAPL	Stock	2.3875	2.3893	2.2964	2.2968	749638400.0
2006-03-16	MSFT	Stock	27.34	27.48	27.22	27.27	73793700.0
2006-03-16	NVDA	Stock	0.4181	0.4186	0.4017	0.4032	568416000.0
2006-03-16	AMZN	Stock	1.854	1.8695	1.837	1.8385	96456000.0
2006-03-16	CL	Stock	28.35	28.54	28.155	28.325	5665800.0
2006-03-16	A	Stock	26.8026	27.1745	26.8026	26.9957	5037274.0
2006-03-16	AABA-DELISTED	Stock	30.7700004577637	30.8799991607666	30.1000003814697	30.1299991607666	17108000.0
2006-03-16	AACC-DELISTED	Stock	19.8	20.0	19.71	19.86	159690.0
2006-03-16	AACQ-DELISTED	Stock	5.36	5.4	5.36	5.4	4000.0
2006-03-16	AACQU-DELISTED	Stock	6.9	6.95	6.8	6.95	15500.0
2006-03-16	AACQW-DELISTED	Stock	0.73	0.76	0.73	0.74	46500.0
2006-03-16	AAI-DELISTED	Stock	17.8	17.8	17.23	17.32	1095400.0
2006-03-16	AAIC-DELISTED	Stock	189.0	198.4	187.8	190.2	1159900.0
2006-03-16	AAME	Stock	3.0	3.0	2.78	2.99	3200.0
2006-03-16	AAON	Stock	2.9366	2.9577	2.8629	2.88	160228.0
2006-03-16	AAP	Stock	41.94	42.48	41.55	41.68	522900.0
2006-03-16	AATI-DELISTED	Stock	11.9	12.05	11.65	11.67	337536.0
2006-03-16	AAU-DELISTED	Stock	2.52	2.6299	2.5008	2.6	52100.0
2006-03-16	AAUAF-DELISTED	Stock	2.52	2.6299	2.5008	2.6	52100.0
2006-03-16	AAV-DELISTED	Stock	19.68	19.95	19.57	19.87	258500.0
2006-03-16	AAWW-DELISTED	Stock	47.0	48.0	47.0	48.0	25700.0
2006-03-16	AAXN-DELISTED	Stock	10.4399995803833	10.4899997711182	10.1000003814697	10.1099996566772	2536900.0
2006-03-16	AB	Stock	65.51	66.07	65.3	65.45	204500.0
2006-03-16	ABAX-DELISTED	Stock	21.08	21.96	21.0	21.65	387972.0
2006-03-16	ABB-DELISTED	Stock	12.28	12.42	12.24	12.32	1078200.0
2006-03-16	ABBC-DELISTED	Stock	13.28	13.33	13.25	13.31	15485.0
2006-03-16	ABC-DELISTED	Stock	23.46	23.8	23.44	23.7	3080400.0
2006-03-16	ABCB	Stock	22.2541	22.3708	22.0887	22.147	17992.0
2006-03-16	ABCO-DELISTED	Stock	27.08	27.43	26.87	27.42	118900.0
2006-03-16	ABCW-DELISTED	Stock	30.36	30.46	30.13	30.2	30940.0
2006-03-16	ABD-DELISTED	Stock	21.86	22.01	21.74	21.84	106270.0
2006-03-16	ABE-DELISTED	Stock	12.63	12.68	12.57	12.65	28700.0
2006-03-16	ABFS-DELISTED	Stock	42.7	42.7	41.21	41.43	413612.0
2006-03-16	ABG	Stock	20.2	20.4	20.0	20.3	110100.0
2006-03-16	ABK-DELISTED	Stock	80.36	81.01	80.16	81.0	501800.0
2006-03-16	ABM	Stock	17.49	17.6	16.98	17.05	290700.0
2006-03-16	ABMD-DELISTED	Stock	10.95	11.03	10.83	11.0	75229.0
2006-03-16	ABP-DELISTED	Stock	5.79	5.94	5.77	5.81	458900.0
2006-03-16	ABR	Stock	26.75	26.95	26.6	26.88	69800.0
2006-03-16	ABT	Stock	21.615	21.639	21.5334	21.591	7409754.0
2006-03-16	ABTL-DELISTED	Stock	20.1	20.75	20.1	20.7	29355.0
2006-03-16	ABV-DELISTED	Stock	44.59	45.24	44.1	44.23	323700.0
2006-03-16	ABVA-DELISTED	Stock	18.675	18.783	18.675	18.745	8533.0
2006-03-16	ABVT-DELISTED	Stock	31.0	35.0	31.0	35.0	1500.0
2006-03-16	ABX-DELISTED	Stock	26.61	26.84	26.35	26.59	4188620.0
2006-03-16	ACAD	Stock	17.1	17.9	16.88	17.8	653000.0
2006-03-16	ACAP-DELISTED	Stock	50.94	51.0	49.38	49.93	34033.0
2006-03-16	ACAS-DELISTED	Stock	36.25	36.32	35.79	35.84	655458.0
2006-03-16	ACAT-DELISTED	Stock	23.42	23.62	23.19	23.27	74825.0
2006-03-16	ACC-DELISTED	Stock	27.0	28.35	26.89	27.81	164400.0

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

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