PREVIEW / stock_daily / 2007-10-29

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-29.parquet
  size:    179 KB
  rows:    5,572
  symbols: 3,369

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-10-29	AAPL	Stock	6.6232	6.6639	6.5964	6.6104	540554000.0
2007-10-29	MSFT	Stock	34.85	35.29	34.45	34.57	114655600.0
2007-10-29	NVDA	Stock	0.8305	0.8438	0.814	0.8398	813896000.0
2007-10-29	AMZN	Stock	4.5205	4.5735	4.474	4.505	141944000.0
2007-10-29	TLT	Stock	90.5	90.99	90.48	90.91	881000.0
2007-10-29	CL	Stock	37.005	37.35	36.805	37.13	5138600.0
2007-10-29	A	Stock	25.9227	26.1016	25.6724	25.7725	2029337.0
2007-10-29	AABA-DELISTED	Stock	34.07	34.08	31.18	31.79	84313974.0
2007-10-29	AACC-DELISTED	Stock	10.8	11.21	10.59	10.99	431871.0
2007-10-29	AAI-DELISTED	Stock	9.64	9.83	9.41	9.68	1968800.0
2007-10-29	AAIC-DELISTED	Stock	86.4	86.8	84.0	84.4	2180700.0
2007-10-29	AAME	Stock	2.41	2.53	2.3	2.3	6500.0
2007-10-29	AAON	Stock	3.5556	3.6365	3.5022	3.518	227306.0
2007-10-29	AAP	Stock	34.01	34.39	33.78	34.1	1066900.0
2007-10-29	AATI-DELISTED	Stock	11.57	11.7	10.74	10.9799	1801085.0
2007-10-29	AAU-DELISTED	Stock	2.88	3.1	2.88	3.1	107700.0
2007-10-29	AAUAF-DELISTED	Stock	2.88	3.1	2.88	3.1	107700.0
2007-10-29	AAV-DELISTED	Stock	12.79	12.82	12.55	12.56	733200.0
2007-10-29	AAWW-DELISTED	Stock	58.56	58.56	57.85	58.14	138843.0
2007-10-29	AAXN-DELISTED	Stock	16.52	16.865	16.28	16.41	1851088.0
2007-10-29	AB	Stock	83.67	84.34	82.4	83.87	240000.0
2007-10-29	ABAX-DELISTED	Stock	29.92	30.0	28.86	29.27	288615.0
2007-10-29	ABB-DELISTED	Stock	30.06	30.18	29.91	30.05	3120500.0
2007-10-29	ABBC-DELISTED	Stock	9.54	9.59	9.41	9.44	74019.0
2007-10-29	ABBNY-DELISTED	Stock	30.06	30.18	29.91	30.05	3020500.0
2007-10-29	ABC-DELISTED	Stock	22.46	22.96	22.32	22.34	1343200.0
2007-10-29	ABCB	Stock	17.2254	17.4103	16.8267	17.099	41948.0
2007-10-29	ABCO-DELISTED	Stock	31.07	31.5	30.61	31.15	119243.0
2007-10-29	ABCW-DELISTED	Stock	25.39	25.59	24.56	24.98	89000.0
2007-10-29	ABD-DELISTED	Stock	21.25	21.26	20.65	21.06	546960.0
2007-10-29	ABE-DELISTED	Stock	27.87	27.9	27.15	27.81	52500.0
2007-10-29	ABEO	Stock	4462.5	4625.0	4262.5	4437.5	14.0
2007-10-29	ABFS-DELISTED	Stock	31.11	31.11	28.82	28.87	1022818.0
2007-10-29	ABG	Stock	19.25	19.59	19.05	19.45	269800.0
2007-10-29	ABK-DELISTED	Stock	44.06	44.53	40.76	41.85	5602400.0
2007-10-29	ABM	Stock	23.4	23.85	23.22	23.72	301000.0
2007-10-29	ABMD-DELISTED	Stock	13.51	13.95	13.49	13.69	150509.0
2007-10-29	ABP-DELISTED	Stock	4.43	4.6	4.4	4.54	165200.0
2007-10-29	ABR	Stock	18.81	19.18	18.5	18.75	332200.0
2007-10-29	ABT	Stock	25.9716	26.1827	25.9716	26.1251	8145269.0
2007-10-29	ABTL-DELISTED	Stock	12.55	15.05	12.5	12.8	8261.0
2007-10-29	ABV-DELISTED	Stock	80.03	80.86	79.45	80.29	635700.0
2007-10-29	ABVT-DELISTED	Stock	85.0	86.1	85.0	86.0	15774.0
2007-10-29	ABX-DELISTED	Stock	43.49	44.8	43.42	44.01	9103100.0
2007-10-29	ACAD	Stock	15.49	15.49	15.15	15.26	133300.0
2007-10-29	ACAP-DELISTED	Stock	44.52	45.22	42.27	42.52	211970.0
2007-10-29	ACAS-DELISTED	Stock	42.73	42.73	41.07	41.79	1304596.0
2007-10-29	ACAT-DELISTED	Stock	15.08	15.2	14.39	14.78	143833.0
2007-10-29	ACC-DELISTED	Stock	28.5	28.72	27.68	28.5	153944.0
2007-10-29	ACCL-DELISTED	Stock	7.34	7.75	7.2806	7.73	145863.0

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

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