PREVIEW / stock_daily / 2009-03-16

all stock daily files

  file:    by_date/stock_daily/2009/2009-03-16.parquet
  size:    173 KB
  rows:    5,736
  symbols: 3,426

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-03-16	AAPL	Stock	3.4475	3.4782	3.3636	3.4079	797244000.0
2009-03-16	MSFT	Stock	16.82	16.96	16.24	16.25	67028900.0
2009-03-16	NVDA	Stock	0.2475	0.2478	0.2335	0.2355	699344000.0
2009-03-16	AMZN	Stock	3.428	3.4645	3.334	3.349	188746000.0
2009-03-16	TLT	Stock	100.82	101.45	100.5	101.11	3265568.0
2009-03-16	ES	Stock	19.03	21.11	19.01	20.28	22255600.0
2009-03-16	CL	Stock	29.07	29.265	28.595	28.66	6898400.0
2009-03-16	A	Stock	10.1144	10.1931	9.8426	9.8426	3028348.0
2009-03-16	AABA-DELISTED	Stock	13.62	13.66	13.2	13.23	18268009.0
2009-03-16	AACC-DELISTED	Stock	4.91	4.96	4.87	4.89	36523.0
2009-03-16	AACG	Stock	4.65	4.67	4.63	4.64	15800.0
2009-03-16	AAI-DELISTED	Stock	3.99	4.38	3.99	4.06	3013596.0
2009-03-16	AAIC-DELISTED	Stock	3.2	3.6	2.8	3.4	646150.0
2009-03-16	AAME	Stock	0.55	0.55	0.54	0.54	1100.0
2009-03-16	AAON	Stock	3.6207	3.6385	3.4943	3.524	412087.0
2009-03-16	AAP	Stock	39.82	39.86	38.64	38.87	1548500.0
2009-03-16	AATI-DELISTED	Stock	3.5	3.73	3.28	3.32	163364.0
2009-03-16	AAU-DELISTED	Stock	0.7	0.7001	0.63	0.63	137205.0
2009-03-16	AAUAF-DELISTED	Stock	0.7	0.7001	0.63	0.63	137705.0
2009-03-16	AAV-DELISTED	Stock	2.68	2.96	2.6201	2.73	1333622.0
2009-03-16	AAWW-DELISTED	Stock	13.79	14.59	13.39	13.5	220820.0
2009-03-16	AAXJ	Stock	33.14	33.14	31.2	31.22	68230.0
2009-03-16	AAXN-DELISTED	Stock	4.24	4.31	4.03	4.08	664434.0
2009-03-16	AB	Stock	13.32	14.54	12.89	12.93	915800.0
2009-03-16	ABAX-DELISTED	Stock	18.09	18.25	17.63	17.83	277760.0
2009-03-16	ABB-DELISTED	Stock	13.48	13.81	13.37	13.39	4106898.0
2009-03-16	ABBC-DELISTED	Stock	8.34	8.36	7.85	7.87	39308.0
2009-03-16	ABBNY-DELISTED	Stock	13.48	13.81	13.37	13.37	4140798.0
2009-03-16	ABC-DELISTED	Stock	15.77	15.86	15.27	15.3	3818162.0
2009-03-16	ABCB	Stock	6.0888	6.3124	5.8553	5.9039	22516.0
2009-03-16	ABCO-DELISTED	Stock	7.623	7.723	7.397	7.402	141916.0
2009-03-16	ABCW-DELISTED	Stock	0.73	0.8534	0.73	0.73	112500.0
2009-03-16	ABD-DELISTED	Stock	1.2407	1.261	1.2	1.2	137150.0
2009-03-16	ABE-DELISTED	Stock	11.75	11.89	11.74	11.76	14200.0
2009-03-16	ABEO	Stock	1887.5	2000.0	1687.5	2000.0	3.0
2009-03-16	ABFS-DELISTED	Stock	19.95	20.51	19.29	19.83	635220.0
2009-03-16	ABG	Stock	2.01	3.08	1.6	2.82	1578300.0
2009-03-16	ABII-DELISTED	Stock	53.72	55.96	51.1165	52.11	25598.0
2009-03-16	ABK-DELISTED	Stock	0.65	0.76	0.63	0.65	12119138.0
2009-03-16	ABM	Stock	15.64	16.19	15.46	15.53	581900.0
2009-03-16	ABMD-DELISTED	Stock	5.91	5.93	5.44	5.44	281672.0
2009-03-16	ABR	Stock	1.3	1.35	1.05	1.07	157100.0
2009-03-16	ABT	Stock	22.6849	23.2271	22.6753	22.9584	24044810.0
2009-03-16	ABTL-DELISTED	Stock	1.2	1.7	1.2	1.35	4622.0
2009-03-16	ABV-DELISTED	Stock	44.27	45.22	43.72	43.81	396533.0
2009-03-16	ABVA-DELISTED	Stock	1.75	1.75	1.7	1.74	4300.0
2009-03-16	ABVT-DELISTED	Stock	39.75	45.0	39.75	45.0	26150.0
2009-03-16	ABX-DELISTED	Stock	29.09	29.93	29.05	29.65	9286157.0
2009-03-16	ACAD	Stock	1.01	1.01	0.75	0.98	94800.0
2009-03-16	ACAP-DELISTED	Stock	43.32	44.17	40.93	41.22	67654.0

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

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