PREVIEW / stock_daily / 2007-01-25

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-25.parquet
  size:    160 KB
  rows:    4,824
  symbols: 3,027

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-01-25	AAPL	Stock	3.1111	3.1607	3.0725	3.0804	905973600.0
2007-01-25	MSFT	Stock	31.08	31.48	30.45	30.45	97378700.0
2007-01-25	NVDA	Stock	0.553	0.555	0.5262	0.5288	616284000.0
2007-01-25	AMZN	Stock	1.904	1.9115	1.839	1.854	134952000.0
2007-01-25	TLT	Stock	87.45	87.47	86.88	86.98	1397000.0
2007-01-25	CL	Stock	33.05	33.17	32.905	33.0	5411600.0
2007-01-25	A	Stock	23.3119	23.5122	22.897	22.9328	2600560.0
2007-01-25	AABA-DELISTED	Stock	28.6800003051758	29.0499992370605	28.1299991607666	28.2099990844727	28356200.0
2007-01-25	AACC-DELISTED	Stock	15.38	15.56	15.34	15.43	78812.0
2007-01-25	AACQ-DELISTED	Stock	5.59	5.68	5.59	5.6	17629.0
2007-01-25	AACQU-DELISTED	Stock	7.0	7.19	7.0	7.0	8680.0
2007-01-25	AACQW-DELISTED	Stock	0.73	0.79	0.73	0.75	217300.0
2007-01-25	AAI-DELISTED	Stock	11.14	11.14	10.64	10.8	2628800.0
2007-01-25	AAIC-DELISTED	Stock	158.0	159.6	153.0	153.8	1101400.0
2007-01-25	AAME	Stock	3.39	3.39	3.33	3.35	3300.0
2007-01-25	AAON	Stock	3.6741	3.6859	3.628	3.6649	302231.0
2007-01-25	AAP	Stock	37.6	37.7	37.13	37.26	726500.0
2007-01-25	AATI-DELISTED	Stock	5.9	6.15	5.85	6.01	297321.0
2007-01-25	AAU-DELISTED	Stock	2.35	2.41	2.27	2.34	98200.0
2007-01-25	AAUAF-DELISTED	Stock	2.35	2.41	2.27	2.34	98200.0
2007-01-25	AAV-DELISTED	Stock	10.96	10.97	10.85	10.89	560100.0
2007-01-25	AAWW-DELISTED	Stock	47.49	47.74	46.95	47.45	107540.0
2007-01-25	AAXN-DELISTED	Stock	7.75	7.76000022888184	7.53999996185303	7.6100001335144	943700.0
2007-01-25	AB	Stock	93.39	94.4	89.69	90.44	553800.0
2007-01-25	ABAX-DELISTED	Stock	17.66	17.8	16.94	17.0	373274.0
2007-01-25	ABB-DELISTED	Stock	17.82	17.85	17.61	17.65	1703800.0
2007-01-25	ABBC-DELISTED	Stock	18.95	19.04	18.95	19.0	9995.0
2007-01-25	ABC-DELISTED	Stock	25.94	27.2	25.94	26.54	6617400.0
2007-01-25	ABCB	Stock	26.2614	26.5628	25.6389	25.6486	21693.0
2007-01-25	ABCO-DELISTED	Stock	27.58	27.58	26.88	27.02	239709.0
2007-01-25	ABCW-DELISTED	Stock	28.94	28.96	28.45	28.64	49750.0
2007-01-25	ABD-DELISTED	Stock	25.0	25.07	24.68	24.82	519690.0
2007-01-25	ABE-DELISTED	Stock	18.4	18.4	18.01	18.141	34700.0
2007-01-25	ABFS-DELISTED	Stock	38.26	38.34	37.0	37.05	672487.0
2007-01-25	ABG	Stock	23.99	23.99	23.56	23.63	150000.0
2007-01-25	ABK-DELISTED	Stock	88.55	88.57	86.83	86.97	458100.0
2007-01-25	ABM	Stock	24.39	24.56	24.21	24.43	348100.0
2007-01-25	ABMD-DELISTED	Stock	14.37	14.37	14.1	14.3	60854.0
2007-01-25	ABP-DELISTED	Stock	3.2	3.2	3.13	3.14	100300.0
2007-01-25	ABR	Stock	31.41	31.54	30.9	31.2	100400.0
2007-01-25	ABT	Stock	25.4774	25.6693	25.1511	25.2327	18078783.0
2007-01-25	ABTL-DELISTED	Stock	19.25	19.25	18.25	18.8	29017.0
2007-01-25	ABV-DELISTED	Stock	52.15	52.25	50.58	50.9	240500.0
2007-01-25	ABVA-DELISTED	Stock	16.5	16.5	16.5	16.5	500.0
2007-01-25	ABVT-DELISTED	Stock	58.5	58.5	58.0	58.0	18641.0
2007-01-25	ABX-DELISTED	Stock	29.95	30.1	29.16	29.37	4479800.0
2007-01-25	ACAD	Stock	7.04	7.08	7.02	7.05	128400.0
2007-01-25	ACAP-DELISTED	Stock	37.17	37.41	36.55	36.75	23910.0
2007-01-25	ACAS-DELISTED	Stock	48.13	48.17	47.24	47.29	635799.0
2007-01-25	ACAT-DELISTED	Stock	18.07	18.37	17.95	18.18	122642.0

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

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