PREVIEW / stock_daily / 2007-06-07

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-07.parquet
  size:    175 KB
  rows:    5,376
  symbols: 3,222

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-07	AAPL	Stock	4.4639	4.5575	4.3996	4.4311	1915079600.0
2007-06-07	MSFT	Stock	30.02	30.29	29.59	29.62	71971400.0
2007-06-07	NVDA	Stock	0.6035	0.6125	0.5997	0.5998	791862000.0
2007-06-07	AMZN	Stock	3.6285	3.736	3.544	3.602	482764000.0
2007-06-07	TLT	Stock	84.63	84.71	83.73	83.87	5010374.0
2007-06-07	CL	Stock	33.125	33.245	33.0	33.105	5008600.0
2007-06-07	A	Stock	27.2675	27.4464	26.6524	26.6524	3567416.0
2007-06-07	AABA-DELISTED	Stock	27.34	27.73	26.98	26.98	33581879.0
2007-06-07	AACC-DELISTED	Stock	18.9	18.96	18.64	18.64	142968.0
2007-06-07	AAI-DELISTED	Stock	11.9	12.01	11.64	11.64	2036900.0
2007-06-07	AAIC-DELISTED	Stock	124.2	133.4	123.6	128.2	6376100.0
2007-06-07	AAME	Stock	4.77	4.78	3.46	4.7	15000.0
2007-06-07	AAON	Stock	3.8413	3.8808	3.7465	3.7834	271097.0
2007-06-07	AAP	Stock	41.08	41.51	40.55	40.6	666600.0
2007-06-07	AATI-DELISTED	Stock	9.47	9.51	9.17	9.24	414820.0
2007-06-07	AAU-DELISTED	Stock	2.48	2.51	2.31	2.35	81100.0
2007-06-07	AAUAF-DELISTED	Stock	2.48	2.51	2.31	2.35	81100.0
2007-06-07	AAV-DELISTED	Stock	12.85	13.0	12.49	12.62	747850.0
2007-06-07	AAWW-DELISTED	Stock	56.77	57.3	56.41	56.51	109026.0
2007-06-07	AAXN-DELISTED	Stock	10.56	10.69	10.37	10.65	1389476.0
2007-06-07	AB	Stock	89.11	89.66	87.8	88.19	276900.0
2007-06-07	ABAX-DELISTED	Stock	23.01	23.39	22.67	22.67	183796.0
2007-06-07	ABB-DELISTED	Stock	21.24	21.39	20.78	20.92	2077850.0
2007-06-07	ABBC-DELISTED	Stock	18.07	18.07	17.25	17.5	21637.0
2007-06-07	ABBNY-DELISTED	Stock	21.24	21.39	20.78	20.9	2088850.0
2007-06-07	ABC-DELISTED	Stock	25.06	25.7	25.06	25.52	3115470.0
2007-06-07	ABCB	Stock	21.9234	22.0887	21.4273	21.6802	27347.0
2007-06-07	ABCO-DELISTED	Stock	26.45	26.5	26.19	26.29	362800.0
2007-06-07	ABCW-DELISTED	Stock	28.48	28.95	28.41	28.51	105080.0
2007-06-07	ABD-DELISTED	Stock	24.92	25.06	24.5	24.9	484300.0
2007-06-07	ABE-DELISTED	Stock	21.0	21.55	21.0	21.01	22300.0
2007-06-07	ABEO	Stock	6500.0	6550.0	6262.5	6550.0	5.0
2007-06-07	ABFS-DELISTED	Stock	41.49	41.57	39.2	39.23	647116.0
2007-06-07	ABG	Stock	25.92	25.92	24.89	25.0	768700.0
2007-06-07	ABK-DELISTED	Stock	88.39	88.48	87.33	87.94	1710800.0
2007-06-07	ABM	Stock	28.02	28.33	27.07	27.32	709400.0
2007-06-07	ABMD-DELISTED	Stock	11.72	11.75	11.34	11.54	166879.0
2007-06-07	ABP-DELISTED	Stock	3.88	4.3	3.86	4.04	814300.0
2007-06-07	ABR	Stock	27.65	27.75	27.55	27.55	725500.0
2007-06-07	ABT	Stock	26.1731	26.341	25.8324	25.8996	13723426.0
2007-06-07	ABTL-DELISTED	Stock	21.23	21.58	20.23	20.27	32940.0
2007-06-07	ABV-DELISTED	Stock	68.85	69.88	65.34	66.16	676810.0
2007-06-07	ABVA-DELISTED	Stock	14.37	14.49	14.35	14.35	109988.0
2007-06-07	ABX-DELISTED	Stock	28.58	29.01	28.05	28.15	8743555.0
2007-06-07	ACAD	Stock	14.12	14.2	13.25	13.26	2117600.0
2007-06-07	ACAP-DELISTED	Stock	40.93	41.19	40.13	40.48	67357.0
2007-06-07	ACAS-DELISTED	Stock	46.71	46.74	45.11	45.38	1734786.0
2007-06-07	ACAT-DELISTED	Stock	19.16	19.4	19.16	19.19	72304.0
2007-06-07	ACC-DELISTED	Stock	29.47	29.47	28.7	28.97	131100.0
2007-06-07	ACCL-DELISTED	Stock	6.05	6.13	5.96	6.0	52711.0

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

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