PREVIEW / stock_daily / 2007-05-18

all stock daily files

  file:    by_date/stock_daily/2007/2007-05-18.parquet
  size:    175 KB
  rows:    5,356
  symbols: 3,217

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-18	AAPL	Stock	3.9368	3.9514	3.9204	3.9293	621345200.0
2007-05-18	MSFT	Stock	30.97	30.99	30.58	30.83	58453000.0
2007-05-18	NVDA	Stock	0.5767	0.5853	0.5718	0.5837	604266000.0
2007-05-18	AMZN	Stock	3.124	3.165	3.114	3.165	195984000.0
2007-05-18	TLT	Stock	87.35	87.4999	86.88	86.93	856434.0
2007-05-18	CL	Stock	33.745	33.75	33.5	33.65	3574800.0
2007-05-18	A	Stock	26.8813	27.3391	26.8598	27.1817	3824369.0
2007-05-18	AABA-DELISTED	Stock	28.9	29.8	28.7797	29.75	33093827.0
2007-05-18	AACC-DELISTED	Stock	18.69	18.69	18.46	18.6	93216.0
2007-05-18	AAI-DELISTED	Stock	12.19	12.19	11.91	12.02	1345300.0
2007-05-18	AAIC-DELISTED	Stock	111.4	113.2	110.6	111.0	1452300.0
2007-05-18	AAME	Stock	5.02	5.05	4.91	4.97	9300.0
2007-05-18	AAON	Stock	3.6583	3.6899	3.6161	3.6451	284766.0
2007-05-18	AAP	Stock	41.36	41.48	40.87	41.32	1672700.0
2007-05-18	AATI-DELISTED	Stock	7.92	7.95	7.82	7.89	273784.0
2007-05-18	AAU-DELISTED	Stock	2.28	2.4	2.28	2.37	70500.0
2007-05-18	AAUAF-DELISTED	Stock	2.28	2.4	2.28	2.37	70500.0
2007-05-18	AAV-DELISTED	Stock	12.44	12.63	12.44	12.59	1236700.0
2007-05-18	AAWW-DELISTED	Stock	58.7	58.96	58.11	58.53	88760.0
2007-05-18	AAXN-DELISTED	Stock	9.28	9.32	9.14	9.29	1046396.0
2007-05-18	AB	Stock	89.5	90.05	88.52	89.94	302200.0
2007-05-18	ABAX-DELISTED	Stock	20.69	20.86	20.52	20.78	158632.0
2007-05-18	ABB-DELISTED	Stock	20.29	20.46	20.29	20.39	669300.0
2007-05-18	ABBC-DELISTED	Stock	18.27	18.47	18.15	18.32	10290.0
2007-05-18	ABBNY-DELISTED	Stock	20.29	20.46	20.29	20.41	670500.0
2007-05-18	ABC-DELISTED	Stock	25.4	25.7	25.34	25.65	2972158.0
2007-05-18	ABCB	Stock	21.7872	22.4388	21.2716	22.3805	68165.0
2007-05-18	ABCO-DELISTED	Stock	24.52	24.72	24.26	24.6	317999.0
2007-05-18	ABCW-DELISTED	Stock	28.33	28.45	28.07	28.37	56710.0
2007-05-18	ABD-DELISTED	Stock	22.91	23.13	22.9	23.13	1072500.0
2007-05-18	ABE-DELISTED	Stock	20.9	21.16	20.89	21.16	21700.0
2007-05-18	ABEO	Stock	6312.5	6550.0	6300.0	6550.0	3.0
2007-05-18	ABFS-DELISTED	Stock	38.88	39.47	38.44	38.9	241777.0
2007-05-18	ABG	Stock	26.61	27.16	26.61	26.97	351600.0
2007-05-18	ABK-DELISTED	Stock	95.92	96.1	95.28	96.02	830800.0
2007-05-18	ABM	Stock	28.3	28.45	28.08	28.32	117800.0
2007-05-18	ABMD-DELISTED	Stock	11.77	12.21	11.3479	12.14	436039.0
2007-05-18	ABP-DELISTED	Stock	3.95	4.01	3.68	4.0	320400.0
2007-05-18	ABR	Stock	27.74	27.74	26.61	27.55	333700.0
2007-05-18	ABT	Stock	28.2986	28.5481	28.1067	28.5145	9648604.0
2007-05-18	ABTL-DELISTED	Stock	19.449	21.5	19.048	20.5	46994.0
2007-05-18	ABV-DELISTED	Stock	67.13	67.52	65.33	67.27	576360.0
2007-05-18	ABVA-DELISTED	Stock	13.34	13.61	13.34	13.45	18311.0
2007-05-18	ABX-DELISTED	Stock	29.7	30.06	29.45	29.82	4470170.0
2007-05-18	ACAD	Stock	13.35	13.37	13.04	13.28	203600.0
2007-05-18	ACAP-DELISTED	Stock	38.4	38.93	37.94	38.86	66133.0
2007-05-18	ACAS-DELISTED	Stock	46.59	46.64	46.39	46.51	633970.0
2007-05-18	ACAT-DELISTED	Stock	19.25	19.45	18.92	19.4	91670.0
2007-05-18	ACC-DELISTED	Stock	27.77	27.81	27.12	27.45	125900.0
2007-05-18	ACCL-DELISTED	Stock	5.99	6.18	5.99	6.09	35426.0

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

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