PREVIEW / stock_daily / 2007-12-07

all stock daily files

  file:    by_date/stock_daily/2007/2007-12-07.parquet
  size:    182 KB
  rows:    5,638
  symbols: 3,418

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-12-07	AAPL	Stock	6.805	6.9639	6.7157	6.9393	1066066400.0
2007-12-07	MSFT	Stock	34.61	34.7	34.22	34.53	40771000.0
2007-12-07	NVDA	Stock	0.8612	0.8622	0.8382	0.847	320292000.0
2007-12-07	AMZN	Stock	4.728	4.734	4.6455	4.7155	78696000.0
2007-12-07	TLT	Stock	92.18	92.35	91.38	91.75	2170931.0
2007-12-07	CL	Stock	39.875	40.135	39.845	39.905	4236400.0
2007-12-07	A	Stock	27.1388	27.3534	27.0029	27.1888	1711432.0
2007-12-07	AABA-DELISTED	Stock	25.86	26.11	25.5	25.63	11446821.0
2007-12-07	AACC-DELISTED	Stock	11.99	11.99	11.61	11.75	226763.0
2007-12-07	AAI-DELISTED	Stock	8.45	8.57	8.43	8.5	1444203.0
2007-12-07	AAIC-DELISTED	Stock	57.2	61.4	56.0	59.0	1827102.0
2007-12-07	AAME	Stock	1.68	1.87	1.63	1.69	25200.0
2007-12-07	AAON	Stock	3.9111	3.9111	3.7057	3.7788	625725.0
2007-12-07	AAP	Stock	40.0	40.3	39.06	39.5	2479800.0
2007-12-07	AATI-DELISTED	Stock	10.79	11.32	10.57	11.32	313382.0
2007-12-07	AAU-DELISTED	Stock	2.5	2.53	2.45	2.5	65500.0
2007-12-07	AAUAF-DELISTED	Stock	2.5	2.53	2.45	2.5	65600.0
2007-12-07	AAV-DELISTED	Stock	10.24	10.24	10.12	10.12	522120.0
2007-12-07	AAWW-DELISTED	Stock	54.09	54.3	53.86	54.12	94311.0
2007-12-07	AAXN-DELISTED	Stock	16.0	16.0	15.5	15.65	1153598.0
2007-12-07	AB	Stock	79.8	81.73	79.09	80.46	200100.0
2007-12-07	ABAX-DELISTED	Stock	34.9	35.25	34.39	34.7	255622.0
2007-12-07	ABB-DELISTED	Stock	29.49	29.61	29.37	29.54	2512990.0
2007-12-07	ABBC-DELISTED	Stock	9.02	9.02	8.94	8.95	95544.0
2007-12-07	ABBNY-DELISTED	Stock	29.49	29.61	29.37	29.5	2512990.0
2007-12-07	ABC-DELISTED	Stock	22.7	23.06	22.57	22.96	2239400.0
2007-12-07	ABCB	Stock	16.817	17.2157	16.4474	17.1671	45649.0
2007-12-07	ABCO-DELISTED	Stock	33.42	33.47	32.69	33.17	121830.0
2007-12-07	ABCW-DELISTED	Stock	26.21	26.21	25.16	25.42	61980.0
2007-12-07	ABD-DELISTED	Stock	17.65	18.04	17.5	17.73	458750.0
2007-12-07	ABE-DELISTED	Stock	28.0	28.3	27.51	27.83	42400.0
2007-12-07	ABEO	Stock	3312.5	3362.5	3125.0	3212.5	30.0
2007-12-07	ABFS-DELISTED	Stock	24.22	25.44	24.1	25.08	1104857.0
2007-12-07	ABG	Stock	16.94	17.22	16.74	17.12	173800.0
2007-12-07	ABII-DELISTED	Stock	66.0	69.5	66.0	68.2201	77738.0
2007-12-07	ABK-DELISTED	Stock	26.31	27.84	25.04	26.84	6071455.0
2007-12-07	ABM	Stock	21.4	21.77	21.2	21.33	146300.0
2007-12-07	ABMD-DELISTED	Stock	13.47	14.3	13.47	14.05	269483.0
2007-12-07	ABP-DELISTED	Stock	3.65	3.68	3.5	3.53	127830.0
2007-12-07	ABR	Stock	17.81	18.11	17.75	17.76	245400.0
2007-12-07	ABT	Stock	27.8956	28.0683	27.79	27.934	8170905.0
2007-12-07	ABTL-DELISTED	Stock	15.2	15.301	14.5	15.3	28515.0
2007-12-07	ABV-DELISTED	Stock	77.86	77.86	75.09	76.01	526006.0
2007-12-07	ABVA-DELISTED	Stock	7.11	7.11	6.64	6.81	2604.0
2007-12-07	ABX-DELISTED	Stock	40.38	40.38	38.9	39.76	6510585.0
2007-12-07	ACAD	Stock	12.65	12.74	12.02	12.35	363100.0
2007-12-07	ACAP-DELISTED	Stock	44.01	44.9	43.13	44.53	64270.0
2007-12-07	ACAS-DELISTED	Stock	37.61	37.68	36.69	36.83	1468464.0
2007-12-07	ACAT-DELISTED	Stock	11.91	12.22	11.8001	12.21	148569.0
2007-12-07	ACC-DELISTED	Stock	26.62	26.86	26.34	26.68	84401.0

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

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