PREVIEW / stock_daily / 2007-08-09

all stock daily files

  file:    by_date/stock_daily/2007/2007-08-09.parquet
  size:    177 KB
  rows:    5,469
  symbols: 3,286

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-09	AAPL	Stock	4.6825	4.75	4.4675	4.5139	1125395600.0
2007-08-09	MSFT	Stock	29.64	30.1	28.92	29.3	72964500.0
2007-08-09	NVDA	Stock	0.765	0.79	0.7475	0.7688	1251834000.0
2007-08-09	AMZN	Stock	3.82	3.863	3.7055	3.7055	166968000.0
2007-08-09	TLT	Stock	86.75	86.86	85.72	86.28	2637423.0
2007-08-09	CL	Stock	33.335	33.925	33.235	33.25	8344800.0
2007-08-09	A	Stock	27.8255	28.1617	25.4506	25.6724	7472310.0
2007-08-09	AABA-DELISTED	Stock	23.67	24.45	23.51	23.82	22893492.0
2007-08-09	AACC-DELISTED	Stock	9.4	9.45	8.49	8.51	550810.0
2007-08-09	AAI-DELISTED	Stock	10.55	11.17	10.44	11.02	3921900.0
2007-08-09	AAIC-DELISTED	Stock	97.0	102.0	93.0	99.2	4370869.0
2007-08-09	AAME	Stock	3.2	3.21	3.17	3.21	1900.0
2007-08-09	AAON	Stock	4.3944	4.5906	4.322	4.426	1457241.0
2007-08-09	AAP	Stock	31.23	31.69	29.98	30.31	10636500.0
2007-08-09	AATI-DELISTED	Stock	7.64	8.3	7.6	8.25	740042.0
2007-08-09	AAU-DELISTED	Stock	2.72	2.72	2.56	2.56	71200.0
2007-08-09	AAUAF-DELISTED	Stock	2.72	2.72	2.56	2.56	71200.0
2007-08-09	AAV-DELISTED	Stock	11.95	12.17	11.7	11.99	671300.0
2007-08-09	AAWW-DELISTED	Stock	53.4	54.73	50.21	53.1	451599.0
2007-08-09	AAXN-DELISTED	Stock	15.06	16.35	14.97	16.18	4822894.0
2007-08-09	AB	Stock	85.63	86.69	80.75	82.26	1144400.0
2007-08-09	ABAX-DELISTED	Stock	20.53	22.26	20.53	22.2	539960.0
2007-08-09	ABB-DELISTED	Stock	23.12	23.48	23.03	23.11	2970800.0
2007-08-09	ABBC-DELISTED	Stock	8.96	9.18	8.9	9.08	85526.0
2007-08-09	ABBNY-DELISTED	Stock	23.12	23.4848	23.03	23.11	3246400.0
2007-08-09	ABC-DELISTED	Stock	22.1	22.31	21.34	21.8	7126400.0
2007-08-09	ABCB	Stock	19.0443	20.0364	19.0443	19.4918	131292.0
2007-08-09	ABCO-DELISTED	Stock	29.15	30.31	28.86	30.1	929830.0
2007-08-09	ABCW-DELISTED	Stock	23.14	23.94	22.69	22.92	234800.0
2007-08-09	ABD-DELISTED	Stock	24.53	26.02	23.5	24.75	1295100.0
2007-08-09	ABE-DELISTED	Stock	20.6	20.7228	19.76	20.15	47500.0
2007-08-09	ABEO	Stock	4875.0	4937.5	4375.0	4750.0	26.0
2007-08-09	ABFS-DELISTED	Stock	35.0	35.49	34.46	35.19	992274.0
2007-08-09	ABG	Stock	19.6	20.13	19.2	19.87	1307100.0
2007-08-09	ABK-DELISTED	Stock	67.87	73.04	66.0	69.5	7436300.0
2007-08-09	ABM	Stock	19.5	21.5	19.04	20.85	1252800.0
2007-08-09	ABMD-DELISTED	Stock	12.5	14.31	12.44	13.51	1280389.0
2007-08-09	ABP-DELISTED	Stock	3.85	3.85	3.65	3.8	369200.0
2007-08-09	ABR	Stock	19.0	20.5	18.66	19.12	651500.0
2007-08-09	ABT	Stock	27.3054	27.3054	26.3074	26.3554	19760108.0
2007-08-09	ABTL-DELISTED	Stock	14.528	14.922	13.051	13.1	57734.0
2007-08-09	ABV-DELISTED	Stock	68.0	69.49	66.55	66.55	722400.0
2007-08-09	ABVA-DELISTED	Stock	10.04	10.17	9.91	10.09	48401.0
2007-08-09	ABVT-DELISTED	Stock	83.0	83.0	83.0	83.0	600.0
2007-08-09	ABX-DELISTED	Stock	33.29	34.06	32.96	33.82	6364000.0
2007-08-09	ACAD	Stock	16.51	17.16	16.5	16.53	1513600.0
2007-08-09	ACAP-DELISTED	Stock	34.0	34.0	31.31	31.86	272507.0
2007-08-09	ACAS-DELISTED	Stock	42.0	43.28	39.65	42.72	3394760.0
2007-08-09	ACAT-DELISTED	Stock	17.53	17.85	16.8	16.86	368921.0
2007-08-09	ACC-DELISTED	Stock	28.31	28.36	26.63	26.65	244745.0

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

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