PREVIEW / stock_daily / 2010-03-02

all stock daily files

  file:    by_date/stock_daily/2010/2010-03-02.parquet
  size:    192 KB
  rows:    5,946
  symbols: 3,516

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
2010-03-02	AAPL	Stock	7.4975	7.5296	7.4193	7.4589	566546400.0
2010-03-02	MSFT	Stock	29.08	29.3	28.24	28.46	93123900.0
2010-03-02	NVDA	Stock	0.425	0.4302	0.418	0.421	538648000.0
2010-03-02	AMZN	Stock	6.2505	6.3675	6.24	6.2765	241950000.0
2010-03-02	TLT	Stock	90.88	91.275	90.7	91.22	2260576.0
2010-03-02	ES	Stock	26.23	26.38	26.17	26.23	1153100.0
2010-03-02	CL	Stock	42.075	42.125	41.795	41.93	5687800.0
2010-03-02	A	Stock	22.8898	23.2761	22.7825	23.1474	6018250.0
2010-03-02	AABA-DELISTED	Stock	15.86	15.96	15.67	15.73	19238129.0
2010-03-02	AACC-DELISTED	Stock	5.74	5.79	5.69	5.73	20618.0
2010-03-02	AACG	Stock	3.94	3.97	3.65	3.78	39500.0
2010-03-02	AAI-DELISTED	Stock	5.12	5.14	4.97	5.01	2896682.0
2010-03-02	AAIC-DELISTED	Stock	18.2	18.4399	18.14	18.15	21629.0
2010-03-02	AAME	Stock	1.39	1.39	1.39	1.39	2700.0
2010-03-02	AAON	Stock	4.2864	4.2884	4.2351	4.2706	549281.0
2010-03-02	AAP	Stock	41.42	41.71	41.14	41.34	1221000.0
2010-03-02	AATI-DELISTED	Stock	3.45	3.48	3.39	3.44	273845.0
2010-03-02	AAU-DELISTED	Stock	0.95	1.0	0.9	0.91	98841.0
2010-03-02	AAUAF-DELISTED	Stock	0.95	1.0	0.9	0.91	99441.0
2010-03-02	AAV-DELISTED	Stock	6.96	7.12	6.96	7.07	457958.0
2010-03-02	AAWW-DELISTED	Stock	46.85	47.51	46.44	46.86	388090.0
2010-03-02	AAXJ	Stock	54.25	54.25	53.836	53.97	119646.0
2010-03-02	AAXN-DELISTED	Stock	7.05	7.1	6.79	7.02	1369075.0
2010-03-02	AB	Stock	27.66	28.29	27.46	28.1	509700.0
2010-03-02	ABAX-DELISTED	Stock	25.9	26.48	25.63	26.35	58020.0
2010-03-02	ABB-DELISTED	Stock	20.48	20.65	20.4	20.53	2125339.0
2010-03-02	ABBC-DELISTED	Stock	7.74	7.88	7.66	7.88	30961.0
2010-03-02	ABBNY-DELISTED	Stock	20.48	20.65	20.4	20.57	2126171.0
2010-03-02	ABC-DELISTED	Stock	28.2	28.5	28.08	28.46	2336841.0
2010-03-02	ABCB	Stock	9.61	9.9655	9.5804	9.9458	47992.0
2010-03-02	ABCD-DELISTED	Stock	3.75	3.76	3.73	3.73	13904.0
2010-03-02	ABCO-DELISTED	Stock	15.98	16.22	15.97	16.095	161076.0
2010-03-02	ABCW-DELISTED	Stock	1.2	1.24	1.19	1.2	145520.0
2010-03-02	ABD-DELISTED	Stock	7.95	8.08	7.63	7.68	363570.0
2010-03-02	ABE-DELISTED	Stock	16.39	16.39	16.19	16.24	8970.0
2010-03-02	ABEO	Stock	3375.0	3375.0	3250.0	3375.0	11.0
2010-03-02	ABFS-DELISTED	Stock	26.8	27.25	26.37	26.75	737726.0
2010-03-02	ABG	Stock	12.04	12.12	11.81	11.96	370000.0
2010-03-02	ABII-DELISTED	Stock	32.93	35.01	32.5	34.83	129189.0
2010-03-02	ABK-DELISTED	Stock	0.7	0.709	0.67	0.6725	4627903.0
2010-03-02	ABM	Stock	20.6	20.6	19.21	19.7	558000.0
2010-03-02	ABMD-DELISTED	Stock	10.15	10.57	10.05	10.48	195871.0
2010-03-02	ABR	Stock	2.27	2.38	2.25	2.35	135600.0
2010-03-02	ABT	Stock	26.0148	26.2451	25.9716	26.1875	10419341.0
2010-03-02	ABTL-DELISTED	Stock	5.3	5.45	5.25	5.25	13629.0
2010-03-02	ABV-DELISTED	Stock	99.62	100.38	98.51	99.69	498032.0
2010-03-02	ABVT-DELISTED	Stock	63.97	64.42	62.84	63.4	156722.0
2010-03-02	ABX-DELISTED	Stock	38.96	40.11	38.71	39.49	13998387.0
2010-03-02	ACAD	Stock	1.29	1.33	1.27	1.33	221200.0
2010-03-02	ACAP-DELISTED	Stock	29.15	29.83	29.05	29.82	27753.0

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

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