PREVIEW / stock_daily / 2007-06-05

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-05.parquet
  size:    176 KB
  rows:    5,366
  symbols: 3,218

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-05	AAPL	Stock	4.3361	4.3818	4.3036	4.3811	920785600.0
2007-06-05	MSFT	Stock	30.62	30.63	30.33	30.58	44265000.0
2007-06-05	NVDA	Stock	0.5862	0.6028	0.5852	0.6018	698586000.0
2007-06-05	AMZN	Stock	3.555	3.712	3.543	3.6825	608850000.0
2007-06-05	TLT	Stock	85.89	85.94	85.38	85.44	1145400.0
2007-06-05	CL	Stock	33.74	33.775	33.425	33.45	4644400.0
2007-06-05	A	Stock	27.3319	27.5823	27.3176	27.5179	2744274.0
2007-06-05	AABA-DELISTED	Stock	28.4	28.59	28.1	28.2	19343947.0
2007-06-05	AACC-DELISTED	Stock	19.0	19.04	18.93	19.04	162564.0
2007-06-05	AAI-DELISTED	Stock	12.17	12.29	11.99	12.01	1741600.0
2007-06-05	AAIC-DELISTED	Stock	128.0	128.2	124.8	125.0	2691600.0
2007-06-05	AAME	Stock	4.79	4.96	4.63	4.73	24000.0
2007-06-05	AAON	Stock	3.9506	3.9506	3.8914	3.9427	313622.0
2007-06-05	AAP	Stock	42.25	42.6	41.66	41.9	1188900.0
2007-06-05	AATI-DELISTED	Stock	9.19	9.95	9.18	9.94	1335055.0
2007-06-05	AAU-DELISTED	Stock	2.51	2.55	2.45	2.55	103900.0
2007-06-05	AAUAF-DELISTED	Stock	2.51	2.55	2.45	2.55	103800.0
2007-06-05	AAV-DELISTED	Stock	13.0	13.06	12.8	12.91	545700.0
2007-06-05	AAWW-DELISTED	Stock	58.12	58.44	57.51	57.65	126510.0
2007-06-05	AAXN-DELISTED	Stock	10.49	10.59	10.33	10.378	1475372.0
2007-06-05	AB	Stock	90.25	91.95	90.04	90.2	279100.0
2007-06-05	ABAX-DELISTED	Stock	23.26	24.17	23.04	23.61	386720.0
2007-06-05	ABB-DELISTED	Stock	22.15	22.17	21.85	21.97	1418550.0
2007-06-05	ABBC-DELISTED	Stock	18.22	18.22	17.89	17.99	9650.0
2007-06-05	ABBNY-DELISTED	Stock	22.15	22.1656	21.85	21.93	1418550.0
2007-06-05	ABC-DELISTED	Stock	25.64	25.69	25.52	25.64	1887400.0
2007-06-05	ABCB	Stock	23.0905	23.0905	22.5166	22.5945	50584.0
2007-06-05	ABCO-DELISTED	Stock	26.24	26.6	26.17	26.55	240702.0
2007-06-05	ABCW-DELISTED	Stock	28.33	28.6	28.32	28.55	143630.0
2007-06-05	ABD-DELISTED	Stock	25.28	25.5	24.94	25.27	375400.0
2007-06-05	ABE-DELISTED	Stock	22.0	22.07	21.42	21.5	23600.0
2007-06-05	ABEO	Stock	6525.0	6550.0	6525.0	6550.0	2.0
2007-06-05	ABFS-DELISTED	Stock	40.21	41.06	40.09	40.84	421143.0
2007-06-05	ABG	Stock	27.5	27.5	27.06	27.09	196200.0
2007-06-05	ABK-DELISTED	Stock	88.51	88.82	87.5	87.93	1790000.0
2007-06-05	ABM	Stock	30.5	30.5	29.67	30.43	343100.0
2007-06-05	ABMD-DELISTED	Stock	11.75	11.81	11.596	11.72	184085.0
2007-06-05	ABP-DELISTED	Stock	3.94	4.0	3.85	3.86	269300.0
2007-06-05	ABR	Stock	28.85	29.02	28.31	28.43	147000.0
2007-06-05	ABT	Stock	26.768	26.768	26.3554	26.6241	13826178.0
2007-06-05	ABTL-DELISTED	Stock	21.4	21.85	21.35	21.55	19033.0
2007-06-05	ABV-DELISTED	Stock	70.23	70.35	69.23	69.61	425160.0
2007-06-05	ABVA-DELISTED	Stock	14.5	14.64	14.44	14.47	12300.0
2007-06-05	ABX-DELISTED	Stock	29.19	29.42	29.0	29.02	5109754.0
2007-06-05	ACAD	Stock	12.5	12.57	12.2	12.43	281200.0
2007-06-05	ACAP-DELISTED	Stock	41.11	41.2	40.5	41.12	47740.0
2007-06-05	ACAS-DELISTED	Stock	48.33	48.33	47.78	48.01	1224737.0
2007-06-05	ACAT-DELISTED	Stock	19.25	19.48	19.04	19.15	136012.0
2007-06-05	ACC-DELISTED	Stock	29.62	29.62	29.26	29.56	228200.0
2007-06-05	ACCL-DELISTED	Stock	6.2	6.3	6.11	6.26	37147.0

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

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