PREVIEW / stock_daily / 2009-01-12

all stock daily files

  file:    by_date/stock_daily/2009/2009-01-12.parquet
  size:    175 KB
  rows:    5,703
  symbols: 3,412

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-12	AAPL	Stock	3.2307	3.2496	3.1268	3.1664	617716400.0
2009-01-12	MSFT	Stock	19.71	19.79	19.3	19.47	52163500.0
2009-01-12	NVDA	Stock	0.1982	0.1992	0.1875	0.1903	645532000.0
2009-01-12	AMZN	Stock	2.706	2.715	2.5435	2.596	191126000.0
2009-01-12	TLT	Stock	111.57	114.05	111.57	113.9	2462793.0
2009-01-12	CL	Stock	32.59	32.93	32.4	32.795	6264000.0
2009-01-12	A	Stock	13.4907	13.6767	13.1402	13.2475	8631392.0
2009-01-12	AABA-DELISTED	Stock	13.05	13.1	12.08	12.22	18159503.0
2009-01-12	AACC-DELISTED	Stock	4.96	5.16	4.62	4.68	156321.0
2009-01-12	AACG	Stock	4.6	4.6	4.31	4.6	21500.0
2009-01-12	AAI-DELISTED	Stock	4.54	4.54	3.91	4.37	3867816.0
2009-01-12	AAIC-DELISTED	Stock	5.2	5.4	5.0	5.0	312270.0
2009-01-12	AAON	Stock	3.9546	3.9763	3.8795	3.9091	727987.0
2009-01-12	AAP	Stock	31.58	31.79	30.51	30.83	825600.0
2009-01-12	AATI-DELISTED	Stock	2.93	3.09	2.93	2.98	241736.0
2009-01-12	AAU-DELISTED	Stock	0.72	0.72	0.65	0.66	96013.0
2009-01-12	AAUAF-DELISTED	Stock	0.72	0.72	0.65	0.66	99013.0
2009-01-12	AAV-DELISTED	Stock	4.68	4.69	4.45	4.54	739457.0
2009-01-12	AAWW-DELISTED	Stock	23.13	23.2	21.18	21.46	222821.0
2009-01-12	AAXJ	Stock	32.56	32.56	31.43	31.49	43294.0
2009-01-12	AAXN-DELISTED	Stock	5.45	5.55	5.16	5.19	770648.0
2009-01-12	AB	Stock	20.93	20.96	19.76	19.98	501600.0
2009-01-12	ABAX-DELISTED	Stock	14.62	14.93	14.32	14.6	193762.0
2009-01-12	ABB-DELISTED	Stock	13.88	13.91	13.36	13.4899	3128525.0
2009-01-12	ABBC-DELISTED	Stock	8.66	8.66	8.45	8.51	80446.0
2009-01-12	ABBNY-DELISTED	Stock	13.89	13.91	13.36	13.48	3128840.0
2009-01-12	ABC-DELISTED	Stock	17.9	18.04	17.8	17.91	3224384.0
2009-01-12	ABCB	Stock	10.4072	10.738	9.8918	9.8918	13057.0
2009-01-12	ABCO-DELISTED	Stock	10.63	10.709	10.345	10.39	155866.0
2009-01-12	ABCW-DELISTED	Stock	2.9	2.95	2.56	2.7	158690.0
2009-01-12	ABD-DELISTED	Stock	3.95	3.95	3.1	3.4	357520.0
2009-01-12	ABE-DELISTED	Stock	12.76	13.25	12.3	12.5	14754.0
2009-01-12	ABEO	Stock	1062.5	1062.5	937.5	1050.0	15.0
2009-01-12	ABFS-DELISTED	Stock	26.58	26.6	25.04	25.25	520074.0
2009-01-12	ABG	Stock	4.97	5.01	4.37	4.37	266700.0
2009-01-12	ABII-DELISTED	Stock	65.99	67.24	65.99	66.55	14859.0
2009-01-12	ABK-DELISTED	Stock	1.52	1.53	1.29	1.3	10595578.0
2009-01-12	ABM	Stock	18.07	18.26	17.8	17.9	275900.0
2009-01-12	ABMD-DELISTED	Stock	14.1	14.1	13.05	13.13	303390.0
2009-01-12	ABR	Stock	2.89	3.02	2.74	2.75	157000.0
2009-01-12	ABT	Stock	24.6233	24.6233	23.7501	24.0188	24832847.0
2009-01-12	ABTL-DELISTED	Stock	2.5	2.5	2.3505	2.5	344530.0
2009-01-12	ABV-DELISTED	Stock	43.27	43.81	42.82	43.28	588638.0
2009-01-12	ABVA-DELISTED	Stock	1.5	1.5	1.5	1.5	2120.0
2009-01-12	ABVT-DELISTED	Stock	30.26	30.26	30.25	30.25	4000.0
2009-01-12	ABX-DELISTED	Stock	31.75	32.18	30.82	31.17	12872483.0
2009-01-12	ACAD	Stock	1.11	1.22	1.11	1.17	48700.0
2009-01-12	ACAP-DELISTED	Stock	44.68	45.42	43.21	43.81	57416.0
2009-01-12	ACAS-DELISTED	Stock	5.75	5.75	4.98	5.12	5808192.0
2009-01-12	ACAT-DELISTED	Stock	5.27	5.37	5.06	5.06	28156.0

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

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