PREVIEW / stock_daily / 2007-05-16

all stock daily files

  file:    by_date/stock_daily/2007/2007-05-16.parquet
  size:    173 KB
  rows:    5,265
  symbols: 3,226

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-05-16	AAPL	Stock	3.8761	3.8868	3.6936	3.8336	1126767600.0
2007-05-16	MSFT	Stock	31.0	31.09	30.81	31.07	45833600.0
2007-05-16	NVDA	Stock	0.5752	0.582	0.5642	0.582	523104000.0
2007-05-16	AMZN	Stock	3.051	3.167	3.005	3.161	289708000.0
2007-05-16	TLT	Stock	87.86	88.0	87.83	87.87	599440.0
2007-05-16	CL	Stock	33.225	33.76	33.165	33.76	4973000.0
2007-05-16	A	Stock	26.8026	27.0815	26.731	27.0529	3787462.0
2007-05-16	AABA-DELISTED	Stock	28.89	29.37	28.25	29.18	31821686.0
2007-05-16	AACC-DELISTED	Stock	18.63	18.75	18.56	18.66	205826.0
2007-05-16	AAI-DELISTED	Stock	11.48	11.87	11.4	11.79	2026827.0
2007-05-16	AAIC-DELISTED	Stock	110.2	113.6	110.2	112.4	1520200.0
2007-05-16	AAME	Stock	4.94	4.96	4.94	4.95	18700.0
2007-05-16	AAON	Stock	3.7426	3.7742	3.6477	3.6886	418416.0
2007-05-16	AAP	Stock	40.5	40.79	40.23	40.51	953000.0
2007-05-16	AATI-DELISTED	Stock	7.61	7.8	7.554	7.8	276837.0
2007-05-16	AAU-DELISTED	Stock	2.37	2.37	2.25	2.25	46500.0
2007-05-16	AAUAF-DELISTED	Stock	2.37	2.37	2.25	2.25	45500.0
2007-05-16	AAV-DELISTED	Stock	12.03	12.18	11.94	12.08	1091410.0
2007-05-16	AAWW-DELISTED	Stock	58.62	59.05	57.33	59.05	75734.0
2007-05-16	AAXN-DELISTED	Stock	9.14	9.34	9.0	9.31	1819666.0
2007-05-16	AB	Stock	87.8	87.85	85.55	86.73	578800.0
2007-05-16	ABAX-DELISTED	Stock	21.24	21.28	20.72	21.02	103038.0
2007-05-16	ABB-DELISTED	Stock	20.19	20.26	20.02	20.26	1884600.0
2007-05-16	ABBC-DELISTED	Stock	18.41	18.42	18.12	18.27	11901.0
2007-05-16	ABBNY-DELISTED	Stock	20.19	20.26	20.02	20.25	1884800.0
2007-05-16	ABC-DELISTED	Stock	24.4	25.66	24.4	25.52	3693668.0
2007-05-16	ABCB	Stock	22.1081	22.2249	21.3495	22.1956	55725.0
2007-05-16	ABCO-DELISTED	Stock	24.58	24.74	24.28	24.59	218118.0
2007-05-16	ABCW-DELISTED	Stock	28.05	28.44	28.05	28.34	41000.0
2007-05-16	ABD-DELISTED	Stock	22.37	22.67	22.28	22.61	354780.0
2007-05-16	ABE-DELISTED	Stock	20.7	20.926	20.01	20.73	51800.0
2007-05-16	ABFS-DELISTED	Stock	38.42	39.0	37.94	39.0	489037.0
2007-05-16	ABG	Stock	26.73	27.11	26.6	26.83	256100.0
2007-05-16	ABK-DELISTED	Stock	94.79	95.0	94.6	94.77	739700.0
2007-05-16	ABM	Stock	27.79	28.63	27.79	28.62	259900.0
2007-05-16	ABMD-DELISTED	Stock	11.87	12.2	11.82	12.084	181977.0
2007-05-16	ABP-DELISTED	Stock	3.9	4.02	3.82	4.0	638400.0
2007-05-16	ABR	Stock	27.86	28.59	27.86	28.55	99500.0
2007-05-16	ABT	Stock	28.3082	28.4665	28.1067	28.3514	9468529.0
2007-05-16	ABTL-DELISTED	Stock	18.55	19.95	18.55	19.5	73960.0
2007-05-16	ABV-DELISTED	Stock	62.94	64.69	62.85	64.62	581100.0
2007-05-16	ABVA-DELISTED	Stock	12.91	13.5	12.91	13.19	227480.0
2007-05-16	ABX-DELISTED	Stock	29.92	30.03	29.39	29.74	5641232.0
2007-05-16	ACAD	Stock	13.04	13.09	12.82	13.02	270400.0
2007-05-16	ACAP-DELISTED	Stock	39.65	39.75	38.81	39.02	52679.0
2007-05-16	ACAS-DELISTED	Stock	46.16	46.35	45.75	46.3	1038216.0
2007-05-16	ACAT-DELISTED	Stock	18.28	18.87	18.11	18.8	115743.0
2007-05-16	ACC-DELISTED	Stock	28.86	28.95	28.43	28.51	192800.0
2007-05-16	ACCL-DELISTED	Stock	5.85	6.23	5.85	6.14	67805.0
2007-05-16	ACCO	Stock	22.37	22.67	22.28	22.61	355500.0

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

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