PREVIEW / stock_daily / 2007-11-09

all stock daily files

  file:    by_date/stock_daily/2007/2007-11-09.parquet
  size:    179 KB
  rows:    5,568
  symbols: 3,374

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-11-09	AAPL	Stock	6.1125	6.2543	5.9004	5.9061	1526380800.0
2007-11-09	MSFT	Stock	34.18	34.54	33.65	33.73	125136900.0
2007-11-09	NVDA	Stock	0.8638	0.87	0.8162	0.834	871056000.0
2007-11-09	AMZN	Stock	4.121	4.121	3.942	3.9445	232404000.0
2007-11-09	TLT	Stock	91.04	91.59	90.93	91.33	887179.0
2007-11-09	CL	Stock	37.715	38.55	37.525	38.255	6883200.0
2007-11-09	A	Stock	24.6423	24.6781	23.8054	23.8841	4467728.0
2007-11-09	AABA-DELISTED	Stock	26.03	26.38	25.4	25.7763	45324575.0
2007-11-09	AACC-DELISTED	Stock	9.92	10.43	9.75	10.35	328700.0
2007-11-09	AAI-DELISTED	Stock	8.93	8.93	8.55	8.61	1996300.0
2007-11-09	AAIC-DELISTED	Stock	74.8	74.8	71.0	72.8	2821370.0
2007-11-09	AAME	Stock	2.3	2.31	2.25	2.29	7400.0
2007-11-09	AAON	Stock	3.3679	3.5575	3.3679	3.516	657619.0
2007-11-09	AAP	Stock	35.63	35.83	34.99	35.16	1472700.0
2007-11-09	AATI-DELISTED	Stock	11.2	11.29	10.91	11.05	418150.0
2007-11-09	AAU-DELISTED	Stock	3.1	3.1	2.9	2.91	102000.0
2007-11-09	AAUAF-DELISTED	Stock	3.1	3.1	2.9	2.91	103500.0
2007-11-09	AAV-DELISTED	Stock	12.07	12.07	11.63	11.78	884650.0
2007-11-09	AAWW-DELISTED	Stock	56.0	56.112	55.0	55.07	232403.0
2007-11-09	AAXN-DELISTED	Stock	14.36	14.57	13.89	14.1	2327619.0
2007-11-09	AB	Stock	74.78	76.15	73.5	74.55	519000.0
2007-11-09	ABAX-DELISTED	Stock	31.58	32.53	31.53	31.87	311633.0
2007-11-09	ABB-DELISTED	Stock	30.11	30.44	29.71	29.95	3906745.0
2007-11-09	ABBC-DELISTED	Stock	8.88	9.0	8.85	8.94	57128.0
2007-11-09	ABBNY-DELISTED	Stock	30.11	30.44	29.71	29.94	3906745.0
2007-11-09	ABC-DELISTED	Stock	22.21	22.38	21.86	21.86	3358400.0
2007-11-09	ABCB	Stock	13.9574	14.2687	13.6462	13.9866	56444.0
2007-11-09	ABCO-DELISTED	Stock	31.67	32.49	31.01	31.89	271148.0
2007-11-09	ABCW-DELISTED	Stock	22.6	23.63	22.07	23.62	142700.0
2007-11-09	ABD-DELISTED	Stock	19.42	20.06	18.9	19.81	337000.0
2007-11-09	ABE-DELISTED	Stock	23.94	24.59	23.67	24.2	33480.0
2007-11-09	ABEO	Stock	3875.0	3925.0	3875.0	3887.5	2.0
2007-11-09	ABFS-DELISTED	Stock	24.45	25.3	23.94	25.1	682555.0
2007-11-09	ABG	Stock	17.26	17.56	16.74	17.36	733200.0
2007-11-09	ABK-DELISTED	Stock	23.26	28.89	23.25	26.22	13542911.0
2007-11-09	ABM	Stock	21.82	22.02	20.95	21.3	344400.0
2007-11-09	ABMD-DELISTED	Stock	12.0	12.22	11.79	12.11	319873.0
2007-11-09	ABP-DELISTED	Stock	4.5	4.5	3.96	4.09	549280.0
2007-11-09	ABR	Stock	17.35	18.43	16.9	17.83	794000.0
2007-11-09	ABT	Stock	25.5829	26.2738	25.5829	25.9668	13231346.0
2007-11-09	ABTL-DELISTED	Stock	11.75	14.1	11.6	13.65	101989.0
2007-11-09	ABV-DELISTED	Stock	74.0	75.4	72.77	73.56	1345607.0
2007-11-09	ABVA-DELISTED	Stock	8.24	8.68	8.11	8.54	2848.0
2007-11-09	ABVT-DELISTED	Stock	89.8	89.83	85.0	89.0	2045.0
2007-11-09	ABX-DELISTED	Stock	45.85	46.31	45.13	45.49	8306475.0
2007-11-09	ACAD	Stock	11.45	11.45	10.61	11.27	557200.0
2007-11-09	ACAP-DELISTED	Stock	41.15	41.59	40.03	41.47	53856.0
2007-11-09	ACAS-DELISTED	Stock	37.21	39.35	36.74	38.38	3339705.0
2007-11-09	ACAT-DELISTED	Stock	12.62	13.16	12.62	13.02	100172.0
2007-11-09	ACC-DELISTED	Stock	25.77	26.96	25.66	26.54	203712.0

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

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