PREVIEW / stock_daily / 2007-10-31

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-31.parquet
  size:    180 KB
  rows:    5,577
  symbols: 3,372

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-10-31	AAPL	Stock	6.7011	6.79	6.6054	6.7839	833310800.0
2007-10-31	MSFT	Stock	35.52	37.0	35.51	36.81	185635800.0
2007-10-31	NVDA	Stock	0.8758	0.885	0.8485	0.8845	455188000.0
2007-10-31	AMZN	Stock	4.4025	4.48	4.35	4.4575	140896000.0
2007-10-31	TLT	Stock	90.5	90.7	89.7501	89.98	2498481.0
2007-10-31	CL	Stock	37.69	38.135	37.375	38.135	6567800.0
2007-10-31	A	Stock	25.8512	26.3877	25.6366	26.3591	2400646.0
2007-10-31	AABA-DELISTED	Stock	31.48	31.75	30.5	31.09	34868236.0
2007-10-31	AACC-DELISTED	Stock	10.94	10.95	10.62	10.78	373089.0
2007-10-31	AAI-DELISTED	Stock	10.24	10.45	10.08	10.44	2471300.0
2007-10-31	AAIC-DELISTED	Stock	83.0	87.8	82.8	86.0	1585000.0
2007-10-31	AAME	Stock	2.34	2.34	2.16	2.16	3800.0
2007-10-31	AAON	Stock	3.5121	3.6247	3.4825	3.6069	249581.0
2007-10-31	AAP	Stock	34.54	34.93	33.45	34.12	1570900.0
2007-10-31	AATI-DELISTED	Stock	11.98	12.2	11.75	12.08	607214.0
2007-10-31	AAU-DELISTED	Stock	3.02	3.1	3.0	3.1	72914.0
2007-10-31	AAUAF-DELISTED	Stock	3.02	3.1	3.0	3.09	72800.0
2007-10-31	AAV-DELISTED	Stock	12.45	12.67	12.4	12.67	732200.0
2007-10-31	AAWW-DELISTED	Stock	58.35	58.66	57.47	58.57	114262.0
2007-10-31	AAXN-DELISTED	Stock	16.23	16.73	15.91	16.64	2053442.0
2007-10-31	AB	Stock	84.25	85.72	82.56	85.43	274800.0
2007-10-31	ABAX-DELISTED	Stock	28.17	29.5	28.09	29.31	224677.0
2007-10-31	ABB-DELISTED	Stock	29.88	30.33	29.74	30.16	2544900.0
2007-10-31	ABBC-DELISTED	Stock	9.43	9.44	9.28	9.28	62581.0
2007-10-31	ABBNY-DELISTED	Stock	29.88	30.33	29.74	30.22	2544900.0
2007-10-31	ABC-DELISTED	Stock	22.99	24.03	22.62	23.56	5515800.0
2007-10-31	ABCB	Stock	16.4668	17.1866	16.2917	16.3988	46677.0
2007-10-31	ABCO-DELISTED	Stock	31.77	32.22	31.11	32.1	289006.0
2007-10-31	ABCW-DELISTED	Stock	24.68	24.88	24.06	24.57	101170.0
2007-10-31	ABD-DELISTED	Stock	20.95	21.44	20.59	21.44	460210.0
2007-10-31	ABE-DELISTED	Stock	27.89	28.09	27.45	28.08	19900.0
2007-10-31	ABEO	Stock	3875.0	4075.0	3812.5	3812.5	7.0
2007-10-31	ABFS-DELISTED	Stock	27.0	27.94	27.0	27.45	1407009.0
2007-10-31	ABG	Stock	18.08	18.61	17.8	18.33	1030400.0
2007-10-31	ABK-DELISTED	Stock	40.24	41.77	36.12	36.73	11161400.0
2007-10-31	ABM	Stock	23.26	23.82	23.08	23.52	302800.0
2007-10-31	ABMD-DELISTED	Stock	13.6	13.82	13.37	13.67	166962.0
2007-10-31	ABP-DELISTED	Stock	4.41	4.48	4.31	4.47	126000.0
2007-10-31	ABR	Stock	18.36	18.88	18.09	18.88	254500.0
2007-10-31	ABT	Stock	26.2211	26.2643	25.8804	26.2067	13141309.0
2007-10-31	ABTL-DELISTED	Stock	12.95	13.15	12.45	12.9	13452.0
2007-10-31	ABV-DELISTED	Stock	81.4	83.09	80.83	81.83	928604.0
2007-10-31	ABVA-DELISTED	Stock	9.56	9.57	9.01	9.01	1059.0
2007-10-31	ABVT-DELISTED	Stock	86.125	87.0	84.75	87.0	14598.0
2007-10-31	ABX-DELISTED	Stock	42.95	44.75	42.61	44.03	10496800.0
2007-10-31	ACAD	Stock	15.16	15.52	15.03	15.38	246400.0
2007-10-31	ACAP-DELISTED	Stock	44.17	44.17	42.95	43.51	120633.0
2007-10-31	ACAS-DELISTED	Stock	42.94	43.94	42.02	43.4	2977662.0
2007-10-31	ACAT-DELISTED	Stock	14.37	14.55	14.26	14.42	159140.0
2007-10-31	ACC-DELISTED	Stock	28.7	28.93	28.48	28.48	336700.0

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

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