PREVIEW / stock_daily / 2007-11-07

all stock daily files

  file:    by_date/stock_daily/2007/2007-11-07.parquet
  size:    181 KB
  rows:    5,600
  symbols: 3,401

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-11-07	AAPL	Stock	6.8075	6.8814	6.6475	6.6536	994327600.0
2007-11-07	MSFT	Stock	36.04	36.16	35.45	35.52	74897800.0
2007-11-07	NVDA	Stock	0.947	0.9508	0.895	0.9025	546768000.0
2007-11-07	AMZN	Stock	4.3205	4.458	4.308	4.352	167956000.0
2007-11-07	TLT	Stock	90.54	90.76	90.32	90.72	1456100.0
2007-11-07	CL	Stock	37.725	37.995	37.225	37.66	6666200.0
2007-11-07	A	Stock	25.4864	25.8727	25.0572	25.1001	2974944.0
2007-11-07	AABA-DELISTED	Stock	29.29	29.3	27.56	27.61	57148799.0
2007-11-07	AACC-DELISTED	Stock	10.05	10.3	9.7	10.08	722237.0
2007-11-07	AAI-DELISTED	Stock	9.5	9.5	9.16	9.24	1814750.0
2007-11-07	AAIC-DELISTED	Stock	80.0	81.0	75.2	75.2	1353801.0
2007-11-07	AAME	Stock	2.25	2.3	2.13	2.3	2500.0
2007-11-07	AAON	Stock	3.3185	3.3877	3.1605	3.3027	831262.0
2007-11-07	AAP	Stock	36.3	36.75	35.95	36.19	2015300.0
2007-11-07	AATI-DELISTED	Stock	11.51	11.62	11.3999	11.43	515405.0
2007-11-07	AAU-DELISTED	Stock	3.3	3.31	3.16	3.2	129100.0
2007-11-07	AAUAF-DELISTED	Stock	3.3	3.31	3.16	3.2	130100.0
2007-11-07	AAV-DELISTED	Stock	12.55	12.62	12.33	12.34	538970.0
2007-11-07	AAWW-DELISTED	Stock	56.45	56.8	56.16	56.16	58906.0
2007-11-07	AAXN-DELISTED	Stock	15.38	15.6482	15.06	15.24	1646137.0
2007-11-07	AB	Stock	76.8	77.59	75.22	75.47	381400.0
2007-11-07	ABAX-DELISTED	Stock	31.68	32.94	31.68	32.17	776443.0
2007-11-07	ABB-DELISTED	Stock	31.83	32.08	31.3	31.3	4343304.0
2007-11-07	ABBC-DELISTED	Stock	8.9	9.01	8.82	8.92	51656.0
2007-11-07	ABBNY-DELISTED	Stock	31.83	32.08	31.3	31.32	4343304.0
2007-11-07	ABC-DELISTED	Stock	21.72	21.92	21.5	21.58	2966002.0
2007-11-07	ABCB	Stock	14.1909	14.3465	13.4419	13.4516	56650.0
2007-11-07	ABCO-DELISTED	Stock	32.44	32.75	31.92	32.04	223909.0
2007-11-07	ABCW-DELISTED	Stock	22.8	23.11	21.7	21.73	121350.0
2007-11-07	ABD-DELISTED	Stock	19.51	20.72	18.35	18.86	773760.0
2007-11-07	ABE-DELISTED	Stock	28.29	28.29	25.1	25.11	29509.0
2007-11-07	ABEO	Stock	4000.0	4562.5	4000.0	4562.5	8.0
2007-11-07	ABFS-DELISTED	Stock	25.6	25.8	24.53	24.56	877423.0
2007-11-07	ABG	Stock	16.7	16.72	16.41	16.63	536300.0
2007-11-07	ABK-DELISTED	Stock	26.5	27.66	24.44	25.28	16743246.0
2007-11-07	ABM	Stock	21.91	22.37	21.87	21.93	538100.0
2007-11-07	ABMD-DELISTED	Stock	13.01	13.07	12.0	12.0	321412.0
2007-11-07	ABP-DELISTED	Stock	4.65	4.65	4.52	4.6	233138.0
2007-11-07	ABR	Stock	17.75	17.75	16.51	16.51	352500.0
2007-11-07	ABT	Stock	25.7269	26.2834	25.7269	25.7892	11356815.0
2007-11-07	ABTL-DELISTED	Stock	10.85	12.0	10.5	11.35	10757.0
2007-11-07	ABV-DELISTED	Stock	78.42	81.86	78.42	79.33	760165.0
2007-11-07	ABVA-DELISTED	Stock	8.18	8.18	7.84	7.974	8518.0
2007-11-07	ABVT-DELISTED	Stock	89.75	89.75	89.75	89.75	10000.0
2007-11-07	ABX-DELISTED	Stock	47.5	47.72	46.07	46.17	11968228.0
2007-11-07	ACAD	Stock	13.02	13.44	12.91	12.95	574200.0
2007-11-07	ACAP-DELISTED	Stock	42.01	42.6799	40.48	40.48	43249.0
2007-11-07	ACAS-DELISTED	Stock	41.0	41.18	38.65	38.77	3297025.0
2007-11-07	ACAT-DELISTED	Stock	13.09	13.1	12.8	12.87	128054.0
2007-11-07	ACC-DELISTED	Stock	26.58	26.84	26.24	26.39	285586.0

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

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