PREVIEW / stock_daily / 2007-05-04

all stock daily files

  file:    by_date/stock_daily/2007/2007-05-04.parquet
  size:    167 KB
  rows:    5,064
  symbols: 3,123

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-04	AAPL	Stock	3.6	3.6286	3.5893	3.6004	381987200.0
2007-05-04	MSFT	Stock	30.68	30.7	30.29	30.56	104385900.0
2007-05-04	NVDA	Stock	0.5608	0.5647	0.5555	0.5618	405246000.0
2007-05-04	AMZN	Stock	3.1195	3.1875	3.1175	3.1615	285986000.0
2007-05-04	TLT	Stock	88.52	88.64	88.5	88.6	262000.0
2007-05-04	CL	Stock	33.75	34.095	33.62	34.075	5560600.0
2007-05-04	A	Stock	26.073	26.4735	25.9728	26.4664	4257609.0
2007-05-04	AABA-DELISTED	Stock	33.27	33.61	29.58	31.0	190306868.0
2007-05-04	AACC-DELISTED	Stock	18.58	18.69	18.5	18.64	160095.0
2007-05-04	AAI-DELISTED	Stock	11.55	11.85	11.55	11.81	1766392.0
2007-05-04	AAIC-DELISTED	Stock	110.8	111.2	109.8	110.6	1439600.0
2007-05-04	AAME	Stock	5.2	5.31	5.08	5.25	15200.0
2007-05-04	AAON	Stock	3.4278	3.4278	3.3422	3.4107	57712.0
2007-05-04	AAP	Stock	40.75	40.75	40.28	40.35	600800.0
2007-05-04	AATI-DELISTED	Stock	8.02	8.15	7.96	8.0	395854.0
2007-05-04	AAU-DELISTED	Stock	2.47	2.48	2.41	2.46	71300.0
2007-05-04	AAUAF-DELISTED	Stock	2.47	2.48	2.41	2.46	71300.0
2007-05-04	AAV-DELISTED	Stock	11.55	11.69	11.53	11.6	618600.0
2007-05-04	AAWW-DELISTED	Stock	58.65	59.24	58.43	59.24	113126.0
2007-05-04	AAXN-DELISTED	Stock	9.55	9.63	9.41	9.53	2546064.0
2007-05-04	AB	Stock	92.8	93.05	91.97	92.27	303900.0
2007-05-04	ABAX-DELISTED	Stock	23.15	23.21	22.88	23.12	214454.0
2007-05-04	ABB-DELISTED	Stock	19.91	20.07	19.81	20.02	1230225.0
2007-05-04	ABBC-DELISTED	Stock	18.6	18.78	18.55	18.73	17105.0
2007-05-04	ABBNY-DELISTED	Stock	19.91	20.07	19.81	20.01	1232325.0
2007-05-04	ABC-DELISTED	Stock	25.89	25.89	25.54	25.65	2014400.0
2007-05-04	ABCB	Stock	24.0631	24.0728	23.4406	23.7033	8225.0
2007-05-04	ABCO-DELISTED	Stock	23.86	23.86	23.49	23.63	242635.0
2007-05-04	ABCW-DELISTED	Stock	28.21	28.51	28.0	28.44	85150.0
2007-05-04	ABD-DELISTED	Stock	22.62	22.67	22.0	22.34	488060.0
2007-05-04	ABE-DELISTED	Stock	20.9	21.0	20.9	20.95	24700.0
2007-05-04	ABFS-DELISTED	Stock	39.75	39.91	39.24	39.7	209779.0
2007-05-04	ABG	Stock	28.49	28.75	28.47	28.7	245000.0
2007-05-04	ABK-DELISTED	Stock	94.48	94.68	93.67	94.33	1048800.0
2007-05-04	ABM	Stock	28.79	28.96	28.57	28.88	217200.0
2007-05-04	ABMD-DELISTED	Stock	12.93	12.94	12.72	12.91	149997.0
2007-05-04	ABP-DELISTED	Stock	3.51	3.85	3.46	3.83	455700.0
2007-05-04	ABR	Stock	30.64	30.87	30.49	30.71	68700.0
2007-05-04	ABT	Stock	27.6077	28.0107	27.5261	27.9723	10452897.0
2007-05-04	ABTL-DELISTED	Stock	18.375	18.525	17.724	18.125	18113.0
2007-05-04	ABV-DELISTED	Stock	62.9	62.9	61.06	61.25	489500.0
2007-05-04	ABVA-DELISTED	Stock	14.27	14.29	14.25	14.25	2200.0
2007-05-04	ABX-DELISTED	Stock	30.85	31.11	30.32	30.51	7732631.0
2007-05-04	ACAD	Stock	13.4	13.49	13.05	13.49	305300.0
2007-05-04	ACAP-DELISTED	Stock	40.77	40.83	40.08	40.4	50600.0
2007-05-04	ACAS-DELISTED	Stock	46.34	46.34	45.52	45.83	1812016.0
2007-05-04	ACAT-DELISTED	Stock	18.48	18.52	18.25	18.32	90176.0
2007-05-04	ACC-DELISTED	Stock	29.7	29.7	29.3	29.45	120600.0
2007-05-04	ACCL-DELISTED	Stock	6.53	6.54	6.45	6.52	12168.0
2007-05-04	ACCO	Stock	22.62	22.67	22.0	22.34	498900.0

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

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