PREVIEW / stock_daily / 2007-01-17

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-17.parquet
  size:    160 KB
  rows:    4,833
  symbols: 3,039

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-01-17	AAPL	Stock	3.4843	3.4857	3.3864	3.3911	1646260000.0
2007-01-17	MSFT	Stock	31.26	31.44	31.01	31.1	58519600.0
2007-01-17	NVDA	Stock	0.58	0.5835	0.5737	0.5758	707934000.0
2007-01-17	AMZN	Stock	1.935	1.95	1.889	1.894	100536000.0
2007-01-17	TLT	Stock	88.21	88.27	87.82	87.96	724100.0
2007-01-17	CL	Stock	33.305	33.48	33.11	33.275	5280000.0
2007-01-17	A	Stock	23.9127	23.9485	23.4335	23.5122	3723014.0
2007-01-17	AABA-DELISTED	Stock	29.3999996185303	29.3999996185303	28.8099994659424	29.0499992370605	17796100.0
2007-01-17	AACC-DELISTED	Stock	15.57	16.13	15.57	15.71	47670.0
2007-01-17	AACQ-DELISTED	Stock	5.52	5.52	5.52	5.52	5000.0
2007-01-17	AACQU-DELISTED	Stock	6.7	6.7	6.7	6.7	2500.0
2007-01-17	AACQW-DELISTED	Stock	0.65	0.65	0.63	0.63	24000.0
2007-01-17	AAI-DELISTED	Stock	12.75	12.93	12.4	12.42	3092100.0
2007-01-17	AAIC-DELISTED	Stock	161.6	162.6	159.4	160.4	810200.0
2007-01-17	AAME	Stock	3.49	3.49	3.25	3.43	12800.0
2007-01-17	AAON	Stock	3.6714	3.707	3.6385	3.6464	469294.0
2007-01-17	AAP	Stock	36.21	36.54	36.03	36.35	916900.0
2007-01-17	AATI-DELISTED	Stock	5.65	5.8801	5.65	5.8	426888.0
2007-01-17	AAU-DELISTED	Stock	2.22	2.269	2.21	2.25	25600.0
2007-01-17	AAUAF-DELISTED	Stock	2.22	2.269	2.21	2.25	25600.0
2007-01-17	AAV-DELISTED	Stock	10.62	10.89	10.54	10.89	688800.0
2007-01-17	AAWW-DELISTED	Stock	47.14	47.45	47.12	47.21	136390.0
2007-01-17	AAXN-DELISTED	Stock	8.14999961853027	8.1899995803833	8.02000045776367	8.03999996185303	819800.0
2007-01-17	AB	Stock	86.45	87.87	86.45	87.79	437800.0
2007-01-17	ABAX-DELISTED	Stock	19.1	19.11	18.9	19.09	137375.0
2007-01-17	ABB-DELISTED	Stock	17.47	17.84	17.47	17.74	2254900.0
2007-01-17	ABBC-DELISTED	Stock	19.15	19.15	18.9	18.95	4750.0
2007-01-17	ABC-DELISTED	Stock	23.78	24.2	23.69	24.18	1947800.0
2007-01-17	ABCB	Stock	27.1659	27.4868	26.8254	26.8254	13263.0
2007-01-17	ABCO-DELISTED	Stock	26.73	27.2	26.73	26.96	139210.0
2007-01-17	ABCW-DELISTED	Stock	28.75	28.86	28.72	28.82	47370.0
2007-01-17	ABD-DELISTED	Stock	25.95	26.07	25.51	25.77	224500.0
2007-01-17	ABE-DELISTED	Stock	18.11	18.35	18.1	18.28	20400.0
2007-01-17	ABFS-DELISTED	Stock	40.28	40.39	39.57	39.67	152862.0
2007-01-17	ABG	Stock	23.0	23.59	22.9	23.5	260800.0
2007-01-17	ABK-DELISTED	Stock	88.24	88.5	86.97	87.17	646000.0
2007-01-17	ABM	Stock	24.2	24.79	24.19	24.73	368700.0
2007-01-17	ABMD-DELISTED	Stock	14.66	14.79	14.63	14.72	95765.0
2007-01-17	ABP-DELISTED	Stock	3.13	3.15	3.07	3.09	153300.0
2007-01-17	ABR	Stock	30.2	30.57	30.08	30.52	55900.0
2007-01-17	ABT	Stock	24.2971	24.7577	24.2539	24.7337	16784494.0
2007-01-17	ABTL-DELISTED	Stock	16.2	16.8	16.0	16.8	21554.0
2007-01-17	ABV-DELISTED	Stock	49.96	50.76	49.88	50.4	258200.0
2007-01-17	ABVA-DELISTED	Stock	16.35	16.5	16.35	16.4626	2920.0
2007-01-17	ABVT-DELISTED	Stock	59.0	59.0	58.95	58.95	505.0
2007-01-17	ABX-DELISTED	Stock	28.94	29.32	28.83	28.89	4410100.0
2007-01-17	ACAD	Stock	6.84	7.16	6.82	7.1	287000.0
2007-01-17	ACAP-DELISTED	Stock	38.58	38.73	37.65	37.65	28558.0
2007-01-17	ACAS-DELISTED	Stock	47.16	47.24	46.79	46.96	544328.0
2007-01-17	ACAT-DELISTED	Stock	16.8	16.9	16.65	16.78	93105.0

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

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