PREVIEW / stock_daily / 2007-06-20

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-20.parquet
  size:    176 KB
  rows:    5,391
  symbols: 3,239

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-20	AAPL	Stock	4.4239	4.4521	4.3393	4.3411	897512000.0
2007-06-20	MSFT	Stock	30.44	30.51	29.96	30.01	46861600.0
2007-06-20	NVDA	Stock	0.6667	0.67	0.6598	0.6643	822792000.0
2007-06-20	AMZN	Stock	3.5125	3.525	3.4525	3.455	183452000.0
2007-06-20	TLT	Stock	84.02	84.08	83.59	83.62	3031700.0
2007-06-20	CL	Stock	33.345	33.52	33.2	33.2	7606800.0
2007-06-20	A	Stock	28.1187	28.1831	27.6252	27.711	2708206.0
2007-06-20	AABA-DELISTED	Stock	27.89	28.17	27.66	27.7	31810572.0
2007-06-20	AACC-DELISTED	Stock	17.4	17.48	16.82	16.89	169883.0
2007-06-20	AAI-DELISTED	Stock	11.55	11.83	11.47	11.57	1218900.0
2007-06-20	AAIC-DELISTED	Stock	126.8	126.8	120.8	121.0	1783800.0
2007-06-20	AAME	Stock	4.04	4.18	4.04	4.12	21600.0
2007-06-20	AAON	Stock	4.1007	4.1007	4.0033	4.0283	545991.0
2007-06-20	AAP	Stock	41.11	41.58	40.97	41.01	1612200.0
2007-06-20	AATI-DELISTED	Stock	9.42	9.49	9.09	9.1	260953.0
2007-06-20	AAU-DELISTED	Stock	2.35	2.39	2.29	2.33	41400.0
2007-06-20	AAUAF-DELISTED	Stock	2.35	2.39	2.29	2.3299	41400.0
2007-06-20	AAV-DELISTED	Stock	14.74	14.95	14.51	14.51	2826400.0
2007-06-20	AAWW-DELISTED	Stock	58.73	59.01	57.86	58.47	128147.0
2007-06-20	AAXN-DELISTED	Stock	12.78	12.78	12.22	12.42	2217050.0
2007-06-20	AB	Stock	90.05	90.05	87.23	87.23	418600.0
2007-06-20	ABAX-DELISTED	Stock	22.07	22.56	21.96	21.98	310701.0
2007-06-20	ABB-DELISTED	Stock	22.67	22.7	22.15	22.17	1699600.0
2007-06-20	ABBC-DELISTED	Stock	17.35	17.4	16.92	16.93	23547.0
2007-06-20	ABBNY-DELISTED	Stock	22.67	22.7	22.15	22.19	1700600.0
2007-06-20	ABC-DELISTED	Stock	25.14	25.2	24.93	24.93	2107208.0
2007-06-20	ABCB	Stock	22.9252	22.9252	21.6219	21.758	38863.0
2007-06-20	ABCO-DELISTED	Stock	26.88	26.96	26.68	26.72	265690.0
2007-06-20	ABCW-DELISTED	Stock	27.48	27.5	27.2	27.24	145990.0
2007-06-20	ABD-DELISTED	Stock	25.09	25.1	24.79	24.79	264900.0
2007-06-20	ABE-DELISTED	Stock	21.9	22.2	21.71	21.7662	12300.0
2007-06-20	ABEO	Stock	6475.0	6475.0	6437.5	6475.0	2.0
2007-06-20	ABFS-DELISTED	Stock	39.11	39.35	38.85	38.95	637334.0
2007-06-20	ABG	Stock	26.08	26.33	25.92	25.94	504800.0
2007-06-20	ABK-DELISTED	Stock	88.06	88.06	86.02	86.08	771600.0
2007-06-20	ABM	Stock	25.82	26.32	25.65	25.97	290100.0
2007-06-20	ABMD-DELISTED	Stock	11.85	11.91	11.61	11.71	143798.0
2007-06-20	ABP-DELISTED	Stock	4.38	4.45	4.22	4.3	466400.0
2007-06-20	ABR	Stock	27.71	27.73	26.79	26.84	171400.0
2007-06-20	ABT	Stock	26.3554	26.4946	26.0292	26.0435	16294289.0
2007-06-20	ABTL-DELISTED	Stock	20.8	21.15	20.7	21.05	18717.0
2007-06-20	ABV-DELISTED	Stock	74.83	74.85	71.05	71.26	644900.0
2007-06-20	ABVA-DELISTED	Stock	13.75	13.75	13.25	13.25	50845.0
2007-06-20	ABX-DELISTED	Stock	29.22	29.62	29.21	29.31	6345600.0
2007-06-20	ACAD	Stock	15.02	15.42	14.8	14.85	662100.0
2007-06-20	ACAP-DELISTED	Stock	41.74	41.74	40.45	40.48	36839.0
2007-06-20	ACAS-DELISTED	Stock	44.76	44.88	43.86	44.0	4119485.0
2007-06-20	ACAT-DELISTED	Stock	20.55	20.77	20.03	20.23	41684.0
2007-06-20	ACC-DELISTED	Stock	29.13	29.13	28.23	28.3	86600.0
2007-06-20	ACCL-DELISTED	Stock	5.95	5.9601	5.81	5.86	70390.0

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

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