PREVIEW / stock_daily / 2007-03-15

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-15.parquet
  size:    160 KB
  rows:    4,855
  symbols: 3,048

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-15	AAPL	Stock	3.2129	3.2271	3.1896	3.1989	559498800.0
2007-03-15	MSFT	Stock	27.32	27.47	27.2	27.28	51757100.0
2007-03-15	NVDA	Stock	0.4807	0.485	0.4697	0.477	655752000.0
2007-03-15	AMZN	Stock	1.905	1.9145	1.8775	1.889	145314000.0
2007-03-15	TLT	Stock	89.76	89.96	89.67	89.87	394900.0
2007-03-15	CL	Stock	32.69	32.81	32.51	32.63	4366800.0
2007-03-15	A	Stock	22.8112	22.897	22.4964	22.6753	3006119.0
2007-03-15	AABA-DELISTED	Stock	29.8099994659424	30.0699996948242	29.7800006866455	30.0599994659424	15440900.0
2007-03-15	AACC-DELISTED	Stock	15.07	15.49	15.03	15.26	148267.0
2007-03-15	AACQ-DELISTED	Stock	4.51	4.55	4.51	4.55	11125.0
2007-03-15	AACQW-DELISTED	Stock	0.635	0.635	0.635	0.635	8500.0
2007-03-15	AAI-DELISTED	Stock	9.9	10.16	9.85	10.01	2325800.0
2007-03-15	AAIC-DELISTED	Stock	100.8	109.0	100.8	107.2	9619100.0
2007-03-15	AAME	Stock	3.7	3.7	3.64	3.69	3800.0
2007-03-15	AAON	Stock	3.6596	3.7979	3.6596	3.7228	452587.0
2007-03-15	AAP	Stock	37.93	38.38	37.73	37.97	665800.0
2007-03-15	AATI-DELISTED	Stock	6.65	6.98	6.61	6.979	480277.0
2007-03-15	AAU-DELISTED	Stock	2.15	2.2	2.1	2.1342	35800.0
2007-03-15	AAUAF-DELISTED	Stock	2.15	2.2	2.1	2.1342	35800.0
2007-03-15	AAV-DELISTED	Stock	9.87	9.9	9.7678	9.8	730900.0
2007-03-15	AAWW-DELISTED	Stock	51.28	52.25	51.13	51.93	307578.0
2007-03-15	AAXN-DELISTED	Stock	7.90000009536743	7.92999982833862	7.82999992370605	7.8899998664856	521900.0
2007-03-15	AB	Stock	83.0	84.26	82.75	83.47	266100.0
2007-03-15	ABAX-DELISTED	Stock	22.62	22.9	22.59	22.85	108978.0
2007-03-15	ABB-DELISTED	Stock	16.53	16.79	16.52	16.75	2430800.0
2007-03-15	ABBC-DELISTED	Stock	19.14	19.14	18.8	19.11	6404.0
2007-03-15	ABC-DELISTED	Stock	26.0	26.12	25.8	26.1	1657110.0
2007-03-15	ABCB	Stock	23.6546	23.7616	22.9641	23.6255	20151.0
2007-03-15	ABCO-DELISTED	Stock	25.5	25.82	25.5	25.74	118783.0
2007-03-15	ABCW-DELISTED	Stock	27.62	28.07	27.62	28.02	67490.0
2007-03-15	ABD-DELISTED	Stock	21.25	21.46	21.08	21.35	292500.0
2007-03-15	ABE-DELISTED	Stock	16.78	16.93	16.78	16.86	22700.0
2007-03-15	ABFS-DELISTED	Stock	36.73	37.65	36.73	36.97	509996.0
2007-03-15	ABG	Stock	27.55	28.18	27.55	28.13	393700.0
2007-03-15	ABK-DELISTED	Stock	86.56	87.57	85.62	85.86	1539103.0
2007-03-15	ABM	Stock	25.83	26.1	25.47	25.9	476900.0
2007-03-15	ABMD-DELISTED	Stock	12.62	12.69	12.29	12.29	591203.0
2007-03-15	ABP-DELISTED	Stock	3.0	3.1	2.99	3.08	117900.0
2007-03-15	ABR	Stock	28.89	29.55	28.76	29.54	88600.0
2007-03-15	ABT	Stock	25.7509	25.9092	25.5877	25.7317	10464152.0
2007-03-15	ABTL-DELISTED	Stock	17.5	18.45	17.4	18.35	16353.0
2007-03-15	ABV-DELISTED	Stock	52.4	52.8	51.74	52.33	503600.0
2007-03-15	ABVA-DELISTED	Stock	15.05	15.05	15.0109	15.0109	1466.0
2007-03-15	ABX-DELISTED	Stock	27.8	28.37	27.71	28.09	7134293.0
2007-03-15	ACAD	Stock	6.9	7.17	6.63	6.73	388900.0
2007-03-15	ACAP-DELISTED	Stock	37.15	37.25	36.42	36.75	48236.0
2007-03-15	ACAS-DELISTED	Stock	43.14	44.37	43.14	43.98	1165371.0
2007-03-15	ACAT-DELISTED	Stock	18.835	19.135	18.725	19.135	54413.0
2007-03-15	ACC-DELISTED	Stock	30.58	30.9	30.26	30.9	141600.0
2007-03-15	ACCL-DELISTED	Stock	6.27	6.47	6.27	6.34	41680.0

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

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