PREVIEW / stock_daily / 2007-01-10

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-10.parquet
  size:    159 KB
  rows:    4,786
  symbols: 2,997

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-10	AAPL	Stock	3.3839	3.4929	3.3375	3.4643	2952880000.0
2007-01-10	MSFT	Stock	29.8	29.89	29.43	29.66	55017400.0
2007-01-10	NVDA	Stock	0.5483	0.5867	0.54	0.5815	1108746000.0
2007-01-10	AMZN	Stock	1.8745	1.885	1.8535	1.8575	130550000.0
2007-01-10	TLT	Stock	89.07	89.13	88.88	88.97	519600.0
2007-01-10	CL	Stock	32.775	33.11	32.7	33.02	3155800.0
2007-01-10	A	Stock	24.3491	24.3491	23.8698	24.1059	3016045.0
2007-01-10	AABA-DELISTED	Stock	27.4799995422363	28.9200000762939	27.4400005340576	28.7000007629395	40240000.0
2007-01-10	AACC-DELISTED	Stock	16.1	16.29	15.71	15.86	69921.0
2007-01-10	AACQ-DELISTED	Stock	5.45	5.45	5.45	5.45	7000.0
2007-01-10	AAI-DELISTED	Stock	11.81	12.08	11.59	11.9299	3283300.0
2007-01-10	AAIC-DELISTED	Stock	160.4	167.4	159.8	167.4	1089900.0
2007-01-10	AAME	Stock	3.63	3.75	3.63	3.71	22900.0
2007-01-10	AAON	Stock	3.4739	3.5081	3.4594	3.491	120741.0
2007-01-10	AAP	Stock	35.23	35.64	35.05	35.49	335700.0
2007-01-10	AATI-DELISTED	Stock	5.16	5.4	5.15	5.33	400863.0
2007-01-10	AAU-DELISTED	Stock	2.24	2.3002	2.2003	2.2998	24699.0
2007-01-10	AAUAF-DELISTED	Stock	2.24	2.3	2.2001	2.2995	24700.0
2007-01-10	AAV-DELISTED	Stock	10.37	10.37	10.06	10.18	448800.0
2007-01-10	AAWW-DELISTED	Stock	45.84	46.56	45.76	45.95	227345.0
2007-01-10	AAXN-DELISTED	Stock	8.43000030517578	8.44999980926514	8.26000022888184	8.32999992370605	1318000.0
2007-01-10	AB	Stock	83.91	85.09	82.9	84.68	344700.0
2007-01-10	ABAX-DELISTED	Stock	19.18	19.18	18.8	19.09	95607.0
2007-01-10	ABB-DELISTED	Stock	17.15	17.19	17.03	17.16	2003200.0
2007-01-10	ABBC-DELISTED	Stock	18.85	19.17	18.85	19.17	4456.0
2007-01-10	ABC-DELISTED	Stock	23.14	23.33	23.11	23.26	1380000.0
2007-01-10	ABCB	Stock	27.3896	27.623	27.1367	27.5647	34545.0
2007-01-10	ABCO-DELISTED	Stock	26.93	27.14	26.74	26.87	249451.0
2007-01-10	ABCW-DELISTED	Stock	28.37	28.93	28.33	28.84	77390.0
2007-01-10	ABD-DELISTED	Stock	26.07	26.25	25.8	25.99	111090.0
2007-01-10	ABE-DELISTED	Stock	17.5	17.5	16.7	17.17	79200.0
2007-01-10	ABFS-DELISTED	Stock	39.42	39.55	38.77	38.85	240856.0
2007-01-10	ABG	Stock	23.05	23.16	22.9	23.03	160000.0
2007-01-10	ABK-DELISTED	Stock	88.06	88.42	87.7	88.33	523100.0
2007-01-10	ABM	Stock	23.0	23.54	22.97	23.47	295900.0
2007-01-10	ABMD-DELISTED	Stock	13.73	13.98	13.19	13.93	306976.0
2007-01-10	ABP-DELISTED	Stock	3.14	3.21	3.08	3.18	173300.0
2007-01-10	ABR	Stock	29.75	30.15	29.65	29.95	687600.0
2007-01-10	ABT	Stock	24.0956	24.2011	23.99	24.1771	13823885.0
2007-01-10	ABTL-DELISTED	Stock	17.646	17.646	16.751	16.95	21601.0
2007-01-10	ABV-DELISTED	Stock	47.49	48.28	47.47	48.2	482200.0
2007-01-10	ABVA-DELISTED	Stock	16.01	16.25	16.01	16.25	4606.0
2007-01-10	ABX-DELISTED	Stock	29.09	29.34	28.7	28.96	5047600.0
2007-01-10	ACAD	Stock	7.88	7.94	7.81	7.89	108900.0
2007-01-10	ACAP-DELISTED	Stock	38.52	39.12	38.52	39.05	29495.0
2007-01-10	ACAS-DELISTED	Stock	46.43	46.92	46.11	46.83	861663.0
2007-01-10	ACAT-DELISTED	Stock	17.14	17.16	16.84	16.93	85083.0
2007-01-10	ACC-DELISTED	Stock	29.48	29.48	29.26	29.39	145100.0
2007-01-10	ACCL-DELISTED	Stock	6.2	6.25	6.14	6.14	28631.0
2007-01-10	ACCO	Stock	26.07	26.25	25.8	25.99	128900.0

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

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