PREVIEW / stock_daily / 2007-08-31

all stock daily files

  file:    by_date/stock_daily/2007/2007-08-31.parquet
  size:    176 KB
  rows:    5,481
  symbols: 3,308

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-08-31	AAPL	Stock	4.9818	4.9875	4.9075	4.9457	876887200.0
2007-08-31	MSFT	Stock	28.7	28.92	28.36	28.73	42511900.0
2007-08-31	NVDA	Stock	0.8283	0.8558	0.8238	0.8527	720834000.0
2007-08-31	AMZN	Stock	4.0	4.0265	3.985	3.9955	123148000.0
2007-08-31	TLT	Stock	88.59	89.2	88.54	88.88	2763200.0
2007-08-31	CL	Stock	33.14	33.385	32.915	33.16	3417200.0
2007-08-31	A	Stock	25.9657	26.1373	25.8011	26.0372	3166889.0
2007-08-31	AABA-DELISTED	Stock	22.81	22.83	22.51	22.7	10299240.0
2007-08-31	AACC-DELISTED	Stock	10.99	11.33	10.77	11.33	203006.0
2007-08-31	AAI-DELISTED	Stock	10.5	10.6	10.16	10.53	1650900.0
2007-08-31	AAIC-DELISTED	Stock	92.4	96.0	90.8	93.8	2090900.0
2007-08-31	AAME	Stock	2.84	3.04	2.81	3.02	2700.0
2007-08-31	AAON	Stock	4.083	4.1679	3.9822	4.1363	221231.0
2007-08-31	AAP	Stock	34.88	35.63	34.7	35.56	732400.0
2007-08-31	AATI-DELISTED	Stock	9.17	9.22	9.03	9.09	253462.0
2007-08-31	AAU-DELISTED	Stock	2.15	2.16	2.1	2.12	81900.0
2007-08-31	AAUAF-DELISTED	Stock	2.15	2.16	2.1	2.12	81900.0
2007-08-31	AAV-DELISTED	Stock	11.5	11.62	11.37	11.41	480700.0
2007-08-31	AAWW-DELISTED	Stock	50.91	51.15	50.33	50.72	97529.0
2007-08-31	AAXN-DELISTED	Stock	14.62	14.63	14.18	14.27	1753429.0
2007-08-31	AB	Stock	82.0	84.05	81.81	82.61	188200.0
2007-08-31	ABAX-DELISTED	Stock	19.63	19.74	19.34	19.42	55256.0
2007-08-31	ABB-DELISTED	Stock	24.6	24.88	24.37	24.66	1676900.0
2007-08-31	ABBC-DELISTED	Stock	9.7	9.7	9.26	9.57	35678.0
2007-08-31	ABBNY-DELISTED	Stock	24.6	24.88	24.37	24.66	1695900.0
2007-08-31	ABC-DELISTED	Stock	23.54	24.05	23.5	23.88	2202800.0
2007-08-31	ABCB	Stock	19.6668	20.9215	19.0249	19.2194	19946.0
2007-08-31	ABCO-DELISTED	Stock	28.78	28.98	28.53	28.74	150188.0
2007-08-31	ABCW-DELISTED	Stock	26.87	27.26	26.34	26.34	70960.0
2007-08-31	ABD-DELISTED	Stock	23.0	23.0	22.51	22.67	249070.0
2007-08-31	ABE-DELISTED	Stock	21.88	22.0	21.8375	21.9	22100.0
2007-08-31	ABEO	Stock	4287.5	4450.0	4287.5	4312.5	2.0
2007-08-31	ABFS-DELISTED	Stock	35.83	36.03	35.22	35.82	259597.0
2007-08-31	ABG	Stock	21.66	21.83	21.41	21.62	243700.0
2007-08-31	ABK-DELISTED	Stock	63.67	66.72	62.81	62.82	3573800.0
2007-08-31	ABM	Stock	23.33	23.58	23.0	23.38	178200.0
2007-08-31	ABMD-DELISTED	Stock	12.37	12.49	11.84	12.31	154059.0
2007-08-31	ABP-DELISTED	Stock	3.65	3.7	3.55	3.63	73000.0
2007-08-31	ABR	Stock	19.57	20.07	19.32	20.02	267000.0
2007-08-31	ABT	Stock	24.7097	25.0024	24.5274	24.9064	10318258.0
2007-08-31	ABTL-DELISTED	Stock	15.975	16.275	15.875	16.225	7926.0
2007-08-31	ABV-DELISTED	Stock	69.5	70.29	68.7	69.86	487200.0
2007-08-31	ABVA-DELISTED	Stock	9.95	9.98	9.92	9.96	13300.0
2007-08-31	ABVT-DELISTED	Stock	85.0	85.0	76.0	80.0	26300.0
2007-08-31	ABX-DELISTED	Stock	32.1	32.64	32.1	32.55	4607200.0
2007-08-31	ACAD	Stock	14.36	14.49	14.3	14.39	145900.0
2007-08-31	ACAP-DELISTED	Stock	39.56	40.45	39.03	39.72	78183.0
2007-08-31	ACAS-DELISTED	Stock	40.68	41.69	40.47	41.36	2399668.0
2007-08-31	ACAT-DELISTED	Stock	16.89	17.09	16.6	16.87	54245.0
2007-08-31	ACC-DELISTED	Stock	27.99	28.81	27.42	28.39	183000.0

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

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