PREVIEW / stock_daily / 2007-02-12

all stock daily files

  file:    by_date/stock_daily/2007/2007-02-12.parquet
  size:    161 KB
  rows:    4,848
  symbols: 3,049

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-02-12	AAPL	Stock	3.0154	3.0421	2.9868	3.0314	724071600.0
2007-02-12	MSFT	Stock	28.89	29.09	28.83	28.94	52774400.0
2007-02-12	NVDA	Stock	0.5482	0.568	0.5423	0.5562	789360000.0
2007-02-12	AMZN	Stock	1.9395	1.9495	1.918	1.9425	76714000.0
2007-02-12	TLT	Stock	87.49	87.65	87.33	87.43	467600.0
2007-02-12	CL	Stock	33.585	33.65	33.435	33.455	3046000.0
2007-02-12	A	Stock	23.3333	23.4335	23.2618	23.3119	2040521.0
2007-02-12	AABA-DELISTED	Stock	29.2900009155273	29.7700004577637	29.0499992370605	29.1700000762939	18316200.0
2007-02-12	AACC-DELISTED	Stock	15.65	15.93	15.64	15.69	81996.0
2007-02-12	AACQ-DELISTED	Stock	5.57	5.57	5.53	5.54	27532.0
2007-02-12	AACQU-DELISTED	Stock	6.99	6.99	6.98	6.98	3200.0
2007-02-12	AACQW-DELISTED	Stock	0.75	0.75	0.75	0.75	32010.0
2007-02-12	AAI-DELISTED	Stock	11.66	11.81	11.59	11.63	1208624.0
2007-02-12	AAIC-DELISTED	Stock	146.0	146.6	143.2	146.0	1932123.0
2007-02-12	AAME	Stock	3.59	3.74	3.59	3.7	5200.0
2007-02-12	AAON	Stock	3.6741	3.6807	3.6346	3.6767	184528.0
2007-02-12	AAP	Stock	38.55	38.71	37.44	37.48	1351600.0
2007-02-12	AATI-DELISTED	Stock	5.49	5.68	5.4	5.63	202223.0
2007-02-12	AAU-DELISTED	Stock	2.44	2.5	2.33	2.33	53100.0
2007-02-12	AAUAF-DELISTED	Stock	2.44	2.5	2.33	2.33	53100.0
2007-02-12	AAV-DELISTED	Stock	10.73	10.76	10.56	10.6	456635.0
2007-02-12	AAWW-DELISTED	Stock	49.1	50.02	49.1	49.91	78777.0
2007-02-12	AAXN-DELISTED	Stock	7.71000003814697	7.82999992370605	7.71000003814697	7.78999996185303	466200.0
2007-02-12	AB	Stock	91.2	91.56	89.78	90.92	248500.0
2007-02-12	ABAX-DELISTED	Stock	21.5	21.5	20.99	21.34	238571.0
2007-02-12	ABB-DELISTED	Stock	18.46	18.49	18.29	18.35	1091331.0
2007-02-12	ABBC-DELISTED	Stock	19.41	19.42	19.3	19.42	4323.0
2007-02-12	ABC-DELISTED	Stock	26.76	26.77	26.53	26.77	2317462.0
2007-02-12	ABCB	Stock	23.4991	23.5769	22.9446	23.538	24675.0
2007-02-12	ABCO-DELISTED	Stock	27.03	27.09	26.75	26.93	277122.0
2007-02-12	ABCW-DELISTED	Stock	29.18	29.19	28.66	28.8	87860.0
2007-02-12	ABD-DELISTED	Stock	23.41	23.47	23.2	23.25	382530.0
2007-02-12	ABE-DELISTED	Stock	18.64	18.66	18.0	18.19	29600.0
2007-02-12	ABFS-DELISTED	Stock	39.12	39.19	38.6	39.04	342697.0
2007-02-12	ABG	Stock	25.22	25.43	25.08	25.31	162800.0
2007-02-12	ABK-DELISTED	Stock	88.17	88.54	87.53	87.6	591879.0
2007-02-12	ABM	Stock	26.61	26.73	26.46	26.67	263800.0
2007-02-12	ABMD-DELISTED	Stock	14.36	14.74	14.36	14.74	212542.0
2007-02-12	ABP-DELISTED	Stock	3.25	3.25	3.07	3.15	160733.0
2007-02-12	ABR	Stock	32.7	32.7	31.42	32.38	211300.0
2007-02-12	ABT	Stock	25.1127	25.3238	25.0648	25.2951	9011672.0
2007-02-12	ABTL-DELISTED	Stock	19.15	19.35	18.55	18.7	16105.0
2007-02-12	ABV-DELISTED	Stock	51.55	51.63	51.09	51.21	392500.0
2007-02-12	ABVA-DELISTED	Stock	16.05	16.05	15.8	15.97	22685.0
2007-02-12	ABX-DELISTED	Stock	30.69	30.93	30.23	30.33	3637931.0
2007-02-12	ACAD	Stock	7.02	7.03	6.8	6.93	154000.0
2007-02-12	ACAP-DELISTED	Stock	37.94	38.88	37.94	38.78	37936.0
2007-02-12	ACAS-DELISTED	Stock	44.69	45.08	43.01	45.05	3925302.0
2007-02-12	ACAT-DELISTED	Stock	17.5	17.63	17.07	17.33	70968.0
2007-02-12	ACC-DELISTED	Stock	32.29	32.29	31.22	31.45	130350.0

> showing 50 of 4,848 rows — these rows as CSV

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