PREVIEW / stock_daily / 2009-01-23

all stock daily files

  file:    by_date/stock_daily/2009/2009-01-23.parquet
  size:    174 KB
  rows:    5,725
  symbols: 3,425

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
2009-01-23	AAPL	Stock	3.1007	3.2096	3.0893	3.1557	763770000.0
2009-01-23	MSFT	Stock	16.97	17.49	16.75	17.2	117020600.0
2009-01-23	NVDA	Stock	0.1803	0.1985	0.18	0.1928	633616000.0
2009-01-23	AMZN	Stock	2.445	2.571	2.4225	2.5315	115866000.0
2009-01-23	TLT	Stock	107.92	108.32	106.69	107.69	2676196.0
2009-01-23	CL	Stock	30.945	31.07	30.3	30.84	7613200.0
2009-01-23	A	Stock	13.2833	13.6266	12.8827	13.3333	6208099.0
2009-01-23	AABA-DELISTED	Stock	10.9	11.55	10.86	11.31	15817587.0
2009-01-23	AACC-DELISTED	Stock	3.94	3.96	3.56	3.84	55327.0
2009-01-23	AACG	Stock	4.05	4.05	3.4	3.62	6800.0
2009-01-23	AAI-DELISTED	Stock	4.32	4.85	4.24	4.38	3404765.0
2009-01-23	AAIC-DELISTED	Stock	3.2	3.6	3.2	3.2	261290.0
2009-01-23	AAON	Stock	3.3798	3.4963	3.3323	3.3857	349819.0
2009-01-23	AAP	Stock	32.09	33.59	31.43	32.84	1393600.0
2009-01-23	AATI-DELISTED	Stock	2.91	3.06	2.73	3.01	215473.0
2009-01-23	AAU-DELISTED	Stock	0.6	0.7201	0.59	0.72	90168.0
2009-01-23	AAUAF-DELISTED	Stock	0.6	0.72	0.59	0.7199	90669.0
2009-01-23	AAV-DELISTED	Stock	4.2	4.38	4.18	4.3074	596668.0
2009-01-23	AAWW-DELISTED	Stock	16.49	16.85	16.05	16.2	230940.0
2009-01-23	AAXJ	Stock	29.73	30.19	29.0	30.16	53759.0
2009-01-23	AAXN-DELISTED	Stock	4.78	5.05	4.77	4.91	477581.0
2009-01-23	AB	Stock	15.63	17.23	15.51	17.05	348800.0
2009-01-23	ABAX-DELISTED	Stock	13.72	13.95	13.2401	13.49	275548.0
2009-01-23	ABB-DELISTED	Stock	11.75	12.3501	11.7	12.2	3981483.0
2009-01-23	ABBC-DELISTED	Stock	7.15	7.4	6.95	6.95	124323.0
2009-01-23	ABBNY-DELISTED	Stock	11.75	12.3501	11.7	12.21	3983195.0
2009-01-23	ABC-DELISTED	Stock	18.27	18.7	17.88	18.04	7277416.0
2009-01-23	ABCB	Stock	7.5185	8.5397	7.5185	7.5671	12646.0
2009-01-23	ABCO-DELISTED	Stock	9.507	9.552	9.068	9.123	240160.0
2009-01-23	ABCW-DELISTED	Stock	2.17	2.45	2.12	2.38	83800.0
2009-01-23	ABD-DELISTED	Stock	1.96	1.96	1.69	1.79	345820.0
2009-01-23	ABE-DELISTED	Stock	11.8	11.92	11.15	11.92	7757.0
2009-01-23	ABEO	Stock	1012.5	1250.0	1012.5	1012.5	12.0
2009-01-23	ABFS-DELISTED	Stock	23.12	23.38	22.51	22.73	442367.0
2009-01-23	ABG	Stock	3.37	3.59	2.89	3.46	178300.0
2009-01-23	ABII-DELISTED	Stock	68.3882	69.42	68.3882	69.07	5464.0
2009-01-23	ABK-DELISTED	Stock	1.0	1.15	0.9999	1.12	10390319.0
2009-01-23	ABM	Stock	15.93	16.31	15.72	16.3	477600.0
2009-01-23	ABMD-DELISTED	Stock	12.43	13.12	12.39	12.9	252085.0
2009-01-23	ABR	Stock	2.21	2.21	2.12	2.15	111500.0
2009-01-23	ABT	Stock	25.1703	25.4678	24.9496	25.3382	17841392.0
2009-01-23	ABTL-DELISTED	Stock	1.9003	2.0497	1.9003	1.9997	2597.0
2009-01-23	ABV-DELISTED	Stock	40.09	41.88	39.77	40.95	947983.0
2009-01-23	ABVA-DELISTED	Stock	1.45	1.45	1.45	1.45	1500.0
2009-01-23	ABX-DELISTED	Stock	36.59	39.99	36.59	39.58	21552364.0
2009-01-23	ACAD	Stock	1.01	1.18	1.0	1.08	26300.0
2009-01-23	ACAP-DELISTED	Stock	40.31	40.77	39.185	39.72	80663.0
2009-01-23	ACAS-DELISTED	Stock	3.8	4.35	3.7	4.17	4255812.0
2009-01-23	ACAT-DELISTED	Stock	4.86	4.87	4.59	4.63	44426.0
2009-01-23	ACC-DELISTED	Stock	20.22	21.07	19.5086	21.0	833012.0

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

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