PREVIEW / stock_daily / 2007-05-02

all stock daily files

  file:    by_date/stock_daily/2007/2007-05-02.parquet
  size:    167 KB
  rows:    5,067
  symbols: 3,142

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-05-02	AAPL	Stock	3.5589	3.5907	3.5525	3.5854	505145200.0
2007-05-02	MSFT	Stock	30.39	30.69	30.3	30.61	80686700.0
2007-05-02	NVDA	Stock	0.5568	0.5592	0.5447	0.5475	659658000.0
2007-05-02	AMZN	Stock	3.084	3.1125	3.045	3.059	288544000.0
2007-05-02	TLT	Stock	88.44	88.48	88.29	88.44	443901.0
2007-05-02	CL	Stock	34.125	34.375	33.87	34.0	4722000.0
2007-05-02	A	Stock	25.6724	26.1516	25.608	26.0229	4481848.0
2007-05-02	AABA-DELISTED	Stock	27.72	28.26	27.72	28.13	16653926.0
2007-05-02	AACC-DELISTED	Stock	18.62	19.04	18.5	18.58	328417.0
2007-05-02	AAI-DELISTED	Stock	11.05	11.61	10.99	11.47	2671384.0
2007-05-02	AAIC-DELISTED	Stock	111.0	112.194	109.6	110.6	2233110.0
2007-05-02	AAME	Stock	5.17	5.26	4.98	5.21	10300.0
2007-05-02	AAON	Stock	3.3857	3.4568	3.3212	3.4344	173137.0
2007-05-02	AAP	Stock	41.05	41.6	40.96	41.3	428600.0
2007-05-02	AATI-DELISTED	Stock	8.0	8.15	7.99	8.06	407733.0
2007-05-02	AAU-DELISTED	Stock	2.54	2.54	2.48	2.51	25900.0
2007-05-02	AAUAF-DELISTED	Stock	2.54	2.54	2.48	2.51	25900.0
2007-05-02	AAV-DELISTED	Stock	11.29	11.39	11.27	11.34	391400.0
2007-05-02	AAWW-DELISTED	Stock	57.42	59.15	57.42	58.59	107190.0
2007-05-02	AAXN-DELISTED	Stock	9.17	9.24	8.86	9.16	2442960.0
2007-05-02	AB	Stock	91.22	92.28	90.94	92.28	215900.0
2007-05-02	ABAX-DELISTED	Stock	23.18	23.51	23.18	23.45	248778.0
2007-05-02	ABB-DELISTED	Stock	20.2	20.34	20.15	20.33	1690840.0
2007-05-02	ABBC-DELISTED	Stock	18.48	18.99	18.48	18.78	7905.0
2007-05-02	ABBNY-DELISTED	Stock	20.2	20.34	20.15	20.33	1691040.0
2007-05-02	ABC-DELISTED	Stock	25.19	25.62	25.08	25.57	2926352.0
2007-05-02	ABCB	Stock	22.896	23.5963	22.8181	23.4796	28788.0
2007-05-02	ABCO-DELISTED	Stock	23.65	24.0	23.65	23.91	268736.0
2007-05-02	ABCW-DELISTED	Stock	27.59	28.42	27.59	28.3	88000.0
2007-05-02	ABD-DELISTED	Stock	23.5	23.51	22.38	22.58	1897040.0
2007-05-02	ABE-DELISTED	Stock	21.0	21.0	20.22	20.71	28200.0
2007-05-02	ABFS-DELISTED	Stock	39.5	40.21	39.48	39.82	471403.0
2007-05-02	ABG	Stock	29.63	29.63	28.45	28.51	403100.0
2007-05-02	ABK-DELISTED	Stock	92.73	93.9	92.36	93.37	932900.0
2007-05-02	ABM	Stock	28.38	29.0	28.38	28.86	270400.0
2007-05-02	ABMD-DELISTED	Stock	12.97	13.25	12.81	13.25	129813.0
2007-05-02	ABP-DELISTED	Stock	3.49	3.5	3.38	3.5	59300.0
2007-05-02	ABR	Stock	30.87	31.25	30.75	30.99	43000.0
2007-05-02	ABT	Stock	27.3822	27.5069	27.2047	27.4398	8968945.0
2007-05-02	ABTL-DELISTED	Stock	17.748	18.652	17.748	18.652	25767.0
2007-05-02	ABV-DELISTED	Stock	59.19	60.49	59.16	60.12	375800.0
2007-05-02	ABVA-DELISTED	Stock	14.26	14.39	14.26	14.31	3910.0
2007-05-02	ABX-DELISTED	Stock	28.24	29.74	28.1	29.53	10676354.0
2007-05-02	ACAD	Stock	13.46	13.8	13.21	13.7	469200.0
2007-05-02	ACAP-DELISTED	Stock	40.02	41.17	39.93	40.27	48513.0
2007-05-02	ACAS-DELISTED	Stock	45.97	46.42	44.6	45.61	4549401.0
2007-05-02	ACAT-DELISTED	Stock	18.15	18.71	17.96	18.52	64148.0
2007-05-02	ACC-DELISTED	Stock	29.38	29.97	29.38	29.65	251400.0
2007-05-02	ACCL-DELISTED	Stock	6.49	6.52	6.42	6.46	30937.0
2007-05-02	ACCO	Stock	23.5	23.51	22.38	22.58	1935800.0

> showing 50 of 5,067 rows — these rows as CSV

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