PREVIEW / stock_daily / 2007-12-17

all stock daily files

  file:    by_date/stock_daily/2007/2007-12-17.parquet
  size:    180 KB
  rows:    5,630
  symbols: 3,414

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-17	AAPL	Stock	6.8114	6.8804	6.535	6.5857	1024693600.0
2007-12-17	MSFT	Stock	35.03	35.13	34.36	34.39	58121200.0
2007-12-17	NVDA	Stock	0.8675	0.8758	0.83	0.832	507408000.0
2007-12-17	AMZN	Stock	4.4505	4.453	4.2495	4.2545	153954000.0
2007-12-17	TLT	Stock	91.07	91.54	90.93	91.54	2046198.0
2007-12-17	CL	Stock	40.225	40.45	39.47	39.53	6334200.0
2007-12-17	A	Stock	25.8083	26.0801	25.3076	25.3505	2982773.0
2007-12-17	AABA-DELISTED	Stock	23.87	24.03	22.94	23.03	37894157.0
2007-12-17	AACC-DELISTED	Stock	10.39	10.63	10.22	10.5	177708.0
2007-12-17	AAI-DELISTED	Stock	8.13	8.17	7.82	7.83	996400.0
2007-12-17	AAIC-DELISTED	Stock	54.0	56.4	52.2	53.4	1547352.0
2007-12-17	AAME	Stock	1.67	1.71	1.53	1.53	18000.0
2007-12-17	AAON	Stock	3.6741	3.9743	3.6741	3.8321	696600.0
2007-12-17	AAP	Stock	37.79	38.69	37.75	37.8	1452200.0
2007-12-17	AATI-DELISTED	Stock	11.47	11.57	11.22	11.27	524764.0
2007-12-17	AAU-DELISTED	Stock	2.27	2.48	2.27	2.41	35329.0
2007-12-17	AAUAF-DELISTED	Stock	2.27	2.48	2.27	2.41	38158.0
2007-12-17	AAV-DELISTED	Stock	9.76	9.77	9.3	9.34	2441932.0
2007-12-17	AAWW-DELISTED	Stock	52.11	52.87	51.89	52.75	105039.0
2007-12-17	AAXN-DELISTED	Stock	14.3	14.49	13.76	13.86	1161154.0
2007-12-17	AB	Stock	78.41	78.8	76.27	76.3	226800.0
2007-12-17	ABAX-DELISTED	Stock	37.03	37.03	34.82	34.9	210658.0
2007-12-17	ABB-DELISTED	Stock	27.04	27.14	26.51	26.66	5920339.0
2007-12-17	ABBC-DELISTED	Stock	9.02	9.1	8.89	8.94	54669.0
2007-12-17	ABBNY-DELISTED	Stock	27.04	27.14	26.51	26.73	5920339.0
2007-12-17	ABC-DELISTED	Stock	21.36	21.94	21.36	21.82	2460200.0
2007-12-17	ABCB	Stock	16.3988	16.3988	15.3385	15.5039	85232.0
2007-12-17	ABCO-DELISTED	Stock	31.28	31.65	30.91	30.99	162235.0
2007-12-17	ABCW-DELISTED	Stock	23.1	23.78	23.0	23.26	95510.0
2007-12-17	ABD-DELISTED	Stock	15.72	16.05	15.7	15.77	415180.0
2007-12-17	ABE-DELISTED	Stock	26.22	26.5	24.51	24.96	37670.0
2007-12-17	ABEO	Stock	2875.0	3000.0	2875.0	3000.0	8.0
2007-12-17	ABFS-DELISTED	Stock	22.18	22.99	22.11	22.31	453061.0
2007-12-17	ABG	Stock	14.72	15.2	14.49	14.84	566700.0
2007-12-17	ABII-DELISTED	Stock	70.5	71.49	69.27	69.27	36578.0
2007-12-17	ABK-DELISTED	Stock	28.27	28.8	25.5	26.71	17885436.0
2007-12-17	ABM	Stock	19.62	20.24	19.62	19.73	545800.0
2007-12-17	ABMD-DELISTED	Stock	14.56	14.91	14.48	14.53	254875.0
2007-12-17	ABP-DELISTED	Stock	3.22	3.5	3.22	3.25	160004.0
2007-12-17	ABR	Stock	17.48	17.48	16.42	16.46	282500.0
2007-12-17	ABT	Stock	27.5645	27.7996	27.1375	27.2382	10368487.0
2007-12-17	ABTL-DELISTED	Stock	15.607	15.607	14.948	15.1	22130.0
2007-12-17	ABV-DELISTED	Stock	70.5	70.59	69.03	69.58	831885.0
2007-12-17	ABVA-DELISTED	Stock	6.61	6.63	6.54	6.54	5959.0
2007-12-17	ABVT-DELISTED	Stock	76.85	76.85	76.85	76.85	1000.0
2007-12-17	ABX-DELISTED	Stock	37.7	38.62	37.09	37.46	6479324.0
2007-12-17	ACAD	Stock	12.01	12.01	11.22	11.28	279300.0
2007-12-17	ACAP-DELISTED	Stock	43.11	44.67	42.32	43.15	91066.0
2007-12-17	ACAS-DELISTED	Stock	35.4	35.49	34.43	34.44	2373382.0
2007-12-17	ACAT-DELISTED	Stock	11.75	11.99	11.54	11.57	233335.0

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

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