PREVIEW / stock_daily / 2007-12-31

all stock daily files

  file:    by_date/stock_daily/2007/2007-12-31.parquet
  size:    184 KB
  rows:    5,719
  symbols: 3,469

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-31	AAPL	Stock	7.125	7.1607	7.0625	7.0743	539333200.0
2007-12-31	MSFT	Stock	35.9	35.99	35.52	35.6	35229700.0
2007-12-31	NVDA	Stock	0.8628	0.8785	0.8502	0.8505	276236000.0
2007-12-31	AMZN	Stock	4.6905	4.7185	4.6225	4.632	115104000.0
2007-12-31	TLT	Stock	92.78	93.28	92.6	93.045	1647529.0
2007-12-31	CL	Stock	39.215	39.57	38.98	38.98	2375000.0
2007-12-31	A	Stock	26.681	26.7167	26.1874	26.2804	2844790.0
2007-12-31	AABA-DELISTED	Stock	23.23	23.43	23.11	23.24	14814602.0
2007-12-31	AACC-DELISTED	Stock	10.65	10.8	10.04	10.41	203407.0
2007-12-31	AAI-DELISTED	Stock	7.22	7.34	7.13	7.16	1448275.0
2007-12-31	AAIC-DELISTED	Stock	60.4	64.2	57.4	62.8	3359306.0
2007-12-31	AAME	Stock	1.46	1.5	1.25	1.4	146000.0
2007-12-31	AAON	Stock	3.9802	4.077	3.8815	3.9151	482962.0
2007-12-31	AAP	Stock	38.16	38.24	37.85	37.99	1051400.0
2007-12-31	AATI-DELISTED	Stock	11.43	11.63	11.03	11.25	317988.0
2007-12-31	AAU-DELISTED	Stock	2.51	2.55	2.48	2.51	28900.0
2007-12-31	AAUAF-DELISTED	Stock	2.51	2.55	2.48	2.51	30600.0
2007-12-31	AAV-DELISTED	Stock	8.69	8.8	8.68	8.79	1699423.0
2007-12-31	AAWW-DELISTED	Stock	53.37	54.54	52.44	54.29	91986.0
2007-12-31	AAXN-DELISTED	Stock	14.56	14.68	14.32	14.32	828221.0
2007-12-31	AB	Stock	77.3	77.3	74.79	75.25	521100.0
2007-12-31	ABAX-DELISTED	Stock	36.9	37.16	35.09	35.86	202611.0
2007-12-31	ABB-DELISTED	Stock	29.15	29.23	28.8	28.8	2462690.0
2007-12-31	ABBC-DELISTED	Stock	9.41	9.51	9.41	9.47	51251.0
2007-12-31	ABBNY-DELISTED	Stock	29.15	29.23	28.8	28.8	2462690.0
2007-12-31	ABC-DELISTED	Stock	22.64	22.71	22.34	22.4	1586498.0
2007-12-31	ABCB	Stock	15.9999	16.5641	15.8541	16.389	42359.0
2007-12-31	ABCO-DELISTED	Stock	32.89	33.07	31.75	32.11	199622.0
2007-12-31	ABCW-DELISTED	Stock	23.68	24.2	23.45	23.52	115020.0
2007-12-31	ABD-DELISTED	Stock	15.935	16.205	15.476	16.065	294370.0
2007-12-31	ABE-DELISTED	Stock	26.86	27.5	26.3	27.194	19975.0
2007-12-31	ABEO	Stock	3437.5	4125.0	3437.5	4062.5	28.0
2007-12-31	ABFS-DELISTED	Stock	21.97	22.17	21.57	21.95	367548.0
2007-12-31	ABG	Stock	15.03	15.26	14.88	15.05	158700.0
2007-12-31	ABII-DELISTED	Stock	68.43	70.0	68.37	68.37	64824.0
2007-12-31	ABK-DELISTED	Stock	25.09	26.41	24.21	25.78	4093951.0
2007-12-31	ABM	Stock	20.72	20.72	20.35	20.39	276000.0
2007-12-31	ABMD-DELISTED	Stock	15.5	15.6	15.13	15.5	147449.0
2007-12-31	ABP-DELISTED	Stock	4.04	4.1	3.83	3.84	221902.0
2007-12-31	ABR	Stock	16.39	16.39	16.0	16.11	462700.0
2007-12-31	ABT	Stock	27.3198	27.3966	26.8736	26.9408	10434973.0
2007-12-31	ABTL-DELISTED	Stock	14.005	14.056	13.495	13.75	41676.0
2007-12-31	ABV-DELISTED	Stock	72.24	72.89	71.03	71.11	388420.0
2007-12-31	ABVA-DELISTED	Stock	6.61	6.61	6.5	6.52	9975.0
2007-12-31	ABVT-DELISTED	Stock	75.0	80.0	55.0	78.0	10026.0
2007-12-31	ABX-DELISTED	Stock	42.79	43.41	41.86	41.99	5571578.0
2007-12-31	ACAD	Stock	11.0	11.16	10.9	11.07	273400.0
2007-12-31	ACAP-DELISTED	Stock	42.25	42.74	41.13	41.56	94041.0
2007-12-31	ACAS-DELISTED	Stock	32.85	33.41	32.36	33.01	3197511.0
2007-12-31	ACAT-DELISTED	Stock	12.0	12.57	11.89	11.94	74886.0

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

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