PREVIEW / stock_daily / 2007-02-01

all stock daily files

  file:    by_date/stock_daily/2007/2007-02-01.parquet
  size:    161 KB
  rows:    4,838
  symbols: 3,044

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-02-01	AAPL	Stock	3.0796	3.0811	3.0264	3.0264	664342000.0
2007-02-01	MSFT	Stock	30.84	30.94	30.37	30.56	55355800.0
2007-02-01	NVDA	Stock	0.506	0.52	0.505	0.5173	650898000.0
2007-02-01	AMZN	Stock	1.8975	1.965	1.8925	1.935	522462000.0
2007-02-01	TLT	Stock	87.65	87.76	87.0	87.09	986200.0
2007-02-01	CL	Stock	34.12	34.13	33.845	34.055	5019600.0
2007-02-01	A	Stock	23.0114	23.2475	22.8898	23.0258	3644446.0
2007-02-01	AABA-DELISTED	Stock	28.6800003051758	28.7099990844727	28.1499996185303	28.3500003814697	17905200.0
2007-02-01	AACC-DELISTED	Stock	15.465	15.87	15.38	15.78	123087.0
2007-02-01	AACQ-DELISTED	Stock	5.59	5.59	5.55	5.55	15000.0
2007-02-01	AACQW-DELISTED	Stock	0.78	0.78	0.77	0.77	7200.0
2007-02-01	AAI-DELISTED	Stock	11.08	11.1405	11.0	11.09	1737800.0
2007-02-01	AAIC-DELISTED	Stock	158.0	159.2	153.8	156.4	638100.0
2007-02-01	AAME	Stock	3.38	3.4	3.27	3.4	1900.0
2007-02-01	AAON	Stock	3.628	3.6793	3.628	3.6714	116184.0
2007-02-01	AAP	Stock	37.99	38.17	37.38	37.51	1164800.0
2007-02-01	AATI-DELISTED	Stock	5.7	5.72	5.6	5.61	221017.0
2007-02-01	AAU-DELISTED	Stock	2.42	2.54	2.42	2.49	31700.0
2007-02-01	AAUAF-DELISTED	Stock	2.42	2.54	2.42	2.49	31700.0
2007-02-01	AAV-DELISTED	Stock	10.87	10.9	10.78	10.8	352400.0
2007-02-01	AAWW-DELISTED	Stock	48.15	49.0	48.15	48.9899	53457.0
2007-02-01	AAXN-DELISTED	Stock	7.76000022888184	7.82999992370605	7.67000007629395	7.80000019073486	719900.0
2007-02-01	AB	Stock	90.1	91.4	90.1	91.04	418200.0
2007-02-01	ABAX-DELISTED	Stock	21.59	21.83	21.48	21.81	105811.0
2007-02-01	ABB-DELISTED	Stock	18.01	18.11	17.9	18.0199	975300.0
2007-02-01	ABBC-DELISTED	Stock	18.95	19.33	18.95	19.33	19551.0
2007-02-01	ABC-DELISTED	Stock	26.2	26.27	26.0	26.19	1949000.0
2007-02-01	ABCB	Stock	25.2109	25.6681	25.1234	25.6681	28788.0
2007-02-01	ABCO-DELISTED	Stock	28.2	28.43	28.01	28.32	168929.0
2007-02-01	ABCW-DELISTED	Stock	29.86	29.96	29.63	29.96	30770.0
2007-02-01	ABD-DELISTED	Stock	24.13	24.16	23.56	23.63	873500.0
2007-02-01	ABE-DELISTED	Stock	18.35	18.4699	18.21	18.2201	18700.0
2007-02-01	ABFS-DELISTED	Stock	38.44	38.86	37.74	38.84	476012.0
2007-02-01	ABG	Stock	24.46	24.59	24.26	24.57	136500.0
2007-02-01	ABK-DELISTED	Stock	87.96	89.49	87.96	88.42	620500.0
2007-02-01	ABM	Stock	25.9	26.3	25.84	26.19	301200.0
2007-02-01	ABMD-DELISTED	Stock	14.75	14.75	14.25	14.32	67405.0
2007-02-01	ABP-DELISTED	Stock	3.38	3.43	3.15	3.3	99800.0
2007-02-01	ABR	Stock	31.21	31.87	30.98	31.83	88800.0
2007-02-01	ABT	Stock	25.1895	25.4198	25.06	25.367	11863902.0
2007-02-01	ABTL-DELISTED	Stock	18.123	19.177	18.123	19.027	32683.0
2007-02-01	ABV-DELISTED	Stock	52.1	52.5	51.76	52.45	349300.0
2007-02-01	ABVA-DELISTED	Stock	16.79	16.79	16.61	16.61	9804.0
2007-02-01	ABVT-DELISTED	Stock	58.5	58.5	58.5	58.5	969.0
2007-02-01	ABX-DELISTED	Stock	30.05	30.53	29.95	30.28	5460100.0
2007-02-01	ACAD	Stock	7.15	7.31	7.15	7.3	104200.0
2007-02-01	ACAP-DELISTED	Stock	38.8	38.97	38.58	38.97	19102.0
2007-02-01	ACAS-DELISTED	Stock	48.69	49.5	48.68	49.33	838405.0
2007-02-01	ACAT-DELISTED	Stock	18.42	19.05	18.2	18.88	64901.0
2007-02-01	ACC-DELISTED	Stock	32.09	32.26	31.52	32.03	67782.0

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

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