PREVIEW / stock_daily / 2007-06-19

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-19.parquet
  size:    177 KB
  rows:    5,422
  symbols: 3,258

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-06-19	AAPL	Stock	4.4532	4.4646	4.3896	4.4164	943026000.0
2007-06-19	MSFT	Stock	30.48	30.66	30.38	30.46	46802600.0
2007-06-19	NVDA	Stock	0.6553	0.6652	0.6508	0.6637	491952000.0
2007-06-19	AMZN	Stock	3.5775	3.583	3.484	3.4905	237420000.0
2007-06-19	TLT	Stock	83.82	84.45	83.72	84.3	4620065.0
2007-06-19	CL	Stock	33.09	33.09	32.78	32.86	3822000.0
2007-06-19	A	Stock	27.7611	28.2117	27.7539	28.1187	2306420.0
2007-06-19	AABA-DELISTED	Stock	28.49	28.54	27.54	27.58	54651488.0
2007-06-19	AACC-DELISTED	Stock	17.41	17.45	17.0	17.04	329187.0
2007-06-19	AAI-DELISTED	Stock	11.34	11.63	11.3	11.44	1604700.0
2007-06-19	AAIC-DELISTED	Stock	127.8	128.2	123.6	125.8	1240300.0
2007-06-19	AAME	Stock	3.98	4.0	3.93	3.99	13700.0
2007-06-19	AAON	Stock	3.9006	4.1021	3.8795	4.0823	766969.0
2007-06-19	AAP	Stock	40.84	41.4	40.7	41.18	1173600.0
2007-06-19	AATI-DELISTED	Stock	9.55	9.6	9.36	9.42	245535.0
2007-06-19	AAU-DELISTED	Stock	2.34	2.39	2.28	2.39	36400.0
2007-06-19	AAUAF-DELISTED	Stock	2.34	2.39	2.28	2.39	36400.0
2007-06-19	AAV-DELISTED	Stock	13.9	14.53	13.9	14.49	1894000.0
2007-06-19	AAWW-DELISTED	Stock	58.11	58.6	57.23	58.5	112121.0
2007-06-19	AAXN-DELISTED	Stock	12.53	13.04	12.3905	12.65	4852342.0
2007-06-19	AB	Stock	86.06	88.26	84.12	88.09	921500.0
2007-06-19	ABAX-DELISTED	Stock	22.56	22.7	21.97	22.01	348324.0
2007-06-19	ABB-DELISTED	Stock	22.01	22.18	21.9	22.15	2965100.0
2007-06-19	ABBC-DELISTED	Stock	17.42	17.42	17.27	17.32	18022.0
2007-06-19	ABBNY-DELISTED	Stock	22.01	22.18	21.9	22.15	2966800.0
2007-06-19	ABC-DELISTED	Stock	25.26	25.26	25.0	25.12	2089200.0
2007-06-19	ABCB	Stock	21.8844	22.8863	21.8844	22.8474	40611.0
2007-06-19	ABCO-DELISTED	Stock	27.15	27.29	26.83	26.85	301748.0
2007-06-19	ABCW-DELISTED	Stock	27.3	27.55	27.21	27.49	192460.0
2007-06-19	ABD-DELISTED	Stock	24.71	25.12	24.65	25.03	518250.0
2007-06-19	ABE-DELISTED	Stock	21.85	22.0	21.5	21.89	21700.0
2007-06-19	ABEO	Stock	6250.0	6462.5	6250.0	6462.5	49.0
2007-06-19	ABFS-DELISTED	Stock	39.57	39.79	39.03	39.05	625102.0
2007-06-19	ABG	Stock	26.06	26.06	25.48	25.96	675300.0
2007-06-19	ABK-DELISTED	Stock	87.74	88.44	87.51	87.86	583900.0
2007-06-19	ABM	Stock	26.16	26.16	25.76	25.82	247500.0
2007-06-19	ABMD-DELISTED	Stock	11.7	11.85	11.55	11.82	129514.0
2007-06-19	ABP-DELISTED	Stock	4.22	4.48	4.17	4.35	742400.0
2007-06-19	ABR	Stock	27.5	27.69	27.35	27.68	78200.0
2007-06-19	ABT	Stock	26.0819	26.293	26.0196	26.2355	10111922.0
2007-06-19	ABTL-DELISTED	Stock	21.13	21.23	20.72	20.87	197238.0
2007-06-19	ABV-DELISTED	Stock	74.85	75.49	73.65	74.49	658500.0
2007-06-19	ABVA-DELISTED	Stock	13.8	13.86	13.8	13.86	1335.0
2007-06-19	ABX-DELISTED	Stock	29.04	29.57	28.91	29.53	6887976.0
2007-06-19	ACAD	Stock	14.99	15.23	14.97	15.05	358500.0
2007-06-19	ACAP-DELISTED	Stock	41.77	41.82	41.03	41.39	56872.0
2007-06-19	ACAS-DELISTED	Stock	44.79	44.98	44.7	44.85	12451177.0
2007-06-19	ACAT-DELISTED	Stock	20.42	20.63	20.31	20.55	81877.0
2007-06-19	ACC-DELISTED	Stock	28.53	29.0	28.35	29.0	123300.0
2007-06-19	ACCL-DELISTED	Stock	6.0	6.024	5.93	5.97	71551.0

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

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