PREVIEW / stock_daily / 2007-03-16

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-16.parquet
  size:    161 KB
  rows:    4,841
  symbols: 3,034

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
2007-03-16	AAPL	Stock	3.1979	3.2139	3.19	3.1996	571704000.0
2007-03-16	MSFT	Stock	27.35	27.48	27.2	27.33	65055300.0
2007-03-16	NVDA	Stock	0.4773	0.4782	0.4692	0.4725	525648000.0
2007-03-16	AMZN	Stock	1.886	1.904	1.876	1.8925	137310000.0
2007-03-16	TLT	Stock	89.67	89.92	89.65	89.85	623800.0
2007-03-16	CL	Stock	32.71	32.735	32.425	32.55	4823000.0
2007-03-16	A	Stock	22.6681	22.8326	22.5536	22.711	3005560.0
2007-03-16	AABA-DELISTED	Stock	30.0200004577637	30.1100006103516	29.7199993133545	29.8799991607666	19799300.0
2007-03-16	AACC-DELISTED	Stock	15.29	15.37	15.13	15.15	131523.0
2007-03-16	AACQ-DELISTED	Stock	4.54	4.7	4.54	4.55	12300.0
2007-03-16	AACQW-DELISTED	Stock	0.635	0.64	0.6	0.64	33900.0
2007-03-16	AAI-DELISTED	Stock	9.97	10.05	9.84	9.95	1782600.0
2007-03-16	AAIC-DELISTED	Stock	109.2	117.0	100.6	102.8	12269100.0
2007-03-16	AAME	Stock	3.7	3.94	3.63	3.68	22500.0
2007-03-16	AAON	Stock	3.7136	3.7136	3.5213	3.5226	536878.0
2007-03-16	AAP	Stock	37.97	38.14	37.57	37.98	632100.0
2007-03-16	AATI-DELISTED	Stock	6.96	7.09	6.89	7.0	1282739.0
2007-03-16	AAU-DELISTED	Stock	2.18	2.21	2.11	2.16	81800.0
2007-03-16	AAUAF-DELISTED	Stock	2.18	2.21	2.11	2.16	81800.0
2007-03-16	AAV-DELISTED	Stock	9.8	9.85	9.75	9.8	828300.0
2007-03-16	AAWW-DELISTED	Stock	52.01	53.29	51.74	53.21	259292.0
2007-03-16	AAXN-DELISTED	Stock	7.84000015258789	7.90000009536743	7.76000022888184	7.80999994277954	952900.0
2007-03-16	AB	Stock	83.67	83.67	81.89	82.37	258800.0
2007-03-16	ABAX-DELISTED	Stock	22.83	23.12	22.63	23.0	194552.0
2007-03-16	ABB-DELISTED	Stock	16.74	16.91	16.67	16.76	1582800.0
2007-03-16	ABBC-DELISTED	Stock	19.17	20.21	18.93	20.14	75335.0
2007-03-16	ABC-DELISTED	Stock	26.2	26.38	25.68	25.92	2156800.0
2007-03-16	ABCB	Stock	23.6157	23.6644	22.6237	22.7404	90578.0
2007-03-16	ABCO-DELISTED	Stock	25.74	25.95	25.38	25.54	235442.0
2007-03-16	ABCW-DELISTED	Stock	28.03	28.03	27.58	27.77	153970.0
2007-03-16	ABD-DELISTED	Stock	21.35	21.64	21.34	21.61	571870.0
2007-03-16	ABE-DELISTED	Stock	16.86	17.0599	16.86	17.0	33400.0
2007-03-16	ABFS-DELISTED	Stock	36.96	36.96	35.93	36.21	747954.0
2007-03-16	ABG	Stock	28.13	28.13	27.56	28.0	358500.0
2007-03-16	ABK-DELISTED	Stock	85.95	86.78	85.55	85.75	1243800.0
2007-03-16	ABM	Stock	25.95	26.29	25.81	25.97	614300.0
2007-03-16	ABMD-DELISTED	Stock	12.3	12.5	12.15	12.29	294613.0
2007-03-16	ABP-DELISTED	Stock	3.08	3.12	3.0	3.02	79200.0
2007-03-16	ABR	Stock	29.61	30.15	29.18	29.64	183700.0
2007-03-16	ABT	Stock	25.6405	25.6693	25.3334	25.3718	20299291.0
2007-03-16	ABTL-DELISTED	Stock	18.05	18.2	16.8	16.95	32500.0
2007-03-16	ABV-DELISTED	Stock	52.33	52.49	51.67	51.68	428600.0
2007-03-16	ABVA-DELISTED	Stock	15.0	15.35	14.9	14.9	3720.0
2007-03-16	ABX-DELISTED	Stock	28.24	28.53	27.66	28.02	5763000.0
2007-03-16	ACAD	Stock	6.75	6.78	6.63	6.69	350900.0
2007-03-16	ACAP-DELISTED	Stock	36.77	36.91	36.24	36.31	65227.0
2007-03-16	ACAS-DELISTED	Stock	44.19	44.25	43.6	43.86	1068358.0
2007-03-16	ACAT-DELISTED	Stock	19.1	19.1	18.57	18.57	99709.0
2007-03-16	ACC-DELISTED	Stock	30.94	31.0	30.02	30.28	213200.0
2007-03-16	ACCL-DELISTED	Stock	6.3	6.45	6.3	6.39	31289.0

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

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