PREVIEW / stock_daily / 2007-03-08

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-08.parquet
  size:    161 KB
  rows:    4,850
  symbols: 3,051

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-03-08	AAPL	Stock	3.1639	3.1686	3.1236	3.1429	511011200.0
2007-03-08	MSFT	Stock	27.72	27.85	26.6	27.32	72175200.0
2007-03-08	NVDA	Stock	0.5037	0.5193	0.5033	0.5137	770622000.0
2007-03-08	AMZN	Stock	1.9385	1.961	1.899	1.905	152586000.0
2007-03-08	TLT	Stock	90.29	90.42	90.11	90.35	574700.0
2007-03-08	CL	Stock	32.9	33.15	32.855	33.115	3590200.0
2007-03-08	A	Stock	22.1745	22.8755	22.1745	22.7039	6290581.0
2007-03-08	AABA-DELISTED	Stock	30.8199996948242	31.0400009155273	30.5799999237061	30.7099990844727	13715100.0
2007-03-08	AACC-DELISTED	Stock	15.6672	15.74	15.25	15.28	102080.0
2007-03-08	AACQ-DELISTED	Stock	4.7	4.84	4.62	4.66	95786.0
2007-03-08	AACQU-DELISTED	Stock	6.0	6.0	5.7	5.7	1750.0
2007-03-08	AACQW-DELISTED	Stock	0.57	0.61	0.57	0.6	48000.0
2007-03-08	AAI-DELISTED	Stock	10.14	10.2	9.97	10.1	1909500.0
2007-03-08	AAIC-DELISTED	Stock	124.0	126.8	120.2	121.2	2657400.0
2007-03-08	AAME	Stock	3.49	3.56	3.49	3.55	3400.0
2007-03-08	AAON	Stock	3.4607	3.5358	3.3817	3.4305	177694.0
2007-03-08	AAP	Stock	38.23	38.74	38.22	38.41	845500.0
2007-03-08	AATI-DELISTED	Stock	6.2	6.42	6.17	6.29	302226.0
2007-03-08	AAU-DELISTED	Stock	2.25	2.31	2.25	2.27	28300.0
2007-03-08	AAUAF-DELISTED	Stock	2.25	2.31	2.25	2.27	28300.0
2007-03-08	AAV-DELISTED	Stock	10.43	10.46	10.1702	10.19	397900.0
2007-03-08	AAWW-DELISTED	Stock	49.99	51.0	49.4	49.43	653595.0
2007-03-08	AAXN-DELISTED	Stock	7.82999992370605	7.94000005722046	7.73999977111816	7.78999996185303	731500.0
2007-03-08	AB	Stock	84.5	85.66	84.0	84.9	279600.0
2007-03-08	ABAX-DELISTED	Stock	22.2	22.43	22.1	22.28	143253.0
2007-03-08	ABB-DELISTED	Stock	16.88	17.05	16.81	16.92	4373400.0
2007-03-08	ABBC-DELISTED	Stock	19.24	19.26	19.05	19.12	10520.0
2007-03-08	ABC-DELISTED	Stock	26.1	26.52	25.96	26.32	2449510.0
2007-03-08	ABCB	Stock	24.0048	24.3841	23.3628	23.4796	44724.0
2007-03-08	ABCO-DELISTED	Stock	25.68	25.86	25.56	25.65	123009.0
2007-03-08	ABCW-DELISTED	Stock	27.99	28.32	27.68	27.91	87440.0
2007-03-08	ABD-DELISTED	Stock	21.17	21.33	20.99	21.06	538860.0
2007-03-08	ABE-DELISTED	Stock	17.33	17.7	17.33	17.68	38400.0
2007-03-08	ABFS-DELISTED	Stock	38.19	38.66	37.94	37.99	369934.0
2007-03-08	ABG	Stock	26.6	27.69	26.6	27.5	417400.0
2007-03-08	ABK-DELISTED	Stock	86.62	89.32	86.62	88.85	1212000.0
2007-03-08	ABM	Stock	27.23	27.4	26.61	26.74	627100.0
2007-03-08	ABMD-DELISTED	Stock	13.3	13.46	13.26	13.4	90621.0
2007-03-08	ABP-DELISTED	Stock	3.1	3.12	3.05	3.08	206700.0
2007-03-08	ABR	Stock	29.76	30.49	29.48	30.26	301500.0
2007-03-08	ABT	Stock	25.2807	25.7029	25.1319	25.6213	16553564.0
2007-03-08	ABTL-DELISTED	Stock	18.475	18.874	17.976	18.225	15618.0
2007-03-08	ABV-DELISTED	Stock	51.76	51.95	51.19	51.46	271600.0
2007-03-08	ABVA-DELISTED	Stock	15.38	15.38	15.3	15.31	1800.0
2007-03-08	ABX-DELISTED	Stock	28.5	28.58	27.91	27.96	5507100.0
2007-03-08	ACAD	Stock	6.89	7.14	6.82	6.86	226900.0
2007-03-08	ACAP-DELISTED	Stock	36.61	36.84	35.39	35.39	95110.0
2007-03-08	ACAS-DELISTED	Stock	43.63	44.1	43.23	43.26	1860984.0
2007-03-08	ACAT-DELISTED	Stock	18.97	19.01	18.78	18.81	66343.0
2007-03-08	ACC-DELISTED	Stock	29.37	29.96	29.34	29.63	91300.0

> showing 50 of 4,850 rows — these rows as CSV

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