PREVIEW / stock_daily / 2011-06-02

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-02.parquet
  size:    198 KB
  rows:    6,103
  symbols: 3,564

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
2011-06-02	AAPL	Stock	12.375	12.4279	12.2964	12.3607	338783200.0
2011-06-02	MSFT	Stock	24.49	24.65	24.18	24.22	51487800.0
2011-06-02	NVDA	Stock	0.4793	0.4828	0.4705	0.4763	607592000.0
2011-06-02	AMZN	Stock	9.614	9.722	9.528	9.6825	60898000.0
2011-06-02	TSLA	Stock	1.9013	1.9547	1.9007	1.9173	14794500.0
2011-06-02	TLT	Stock	96.49	96.91	95.78	95.78	15738781.0
2011-06-02	ES	Stock	34.9	34.94	34.56	34.89	1891800.0
2011-06-02	CL	Stock	43.425	43.425	42.59	42.74	5045600.0
2011-06-02	A	Stock	34.4564	34.7854	34.2346	34.4635	4654921.0
2011-06-02	AABA-DELISTED	Stock	16.0	16.11	15.87	16.02	20807192.0
2011-06-02	AACC-DELISTED	Stock	3.9	4.09	3.64	3.69	57008.0
2011-06-02	AACG	Stock	12.75	12.75	11.75	12.34	158600.0
2011-06-02	AAIC-DELISTED	Stock	27.66	27.85	27.26	27.39	35871.0
2011-06-02	AAME	Stock	2.03	2.05	2.03	2.05	200.0
2011-06-02	AAON	Stock	6.5027	6.5027	6.317	6.3249	188325.0
2011-06-02	AAP	Stock	61.0	61.06	59.77	60.51	2453600.0
2011-06-02	AAT	Stock	21.8	23.34	21.48	21.81	151300.0
2011-06-02	AATI-DELISTED	Stock	6.04	6.04	6.03	6.03	981793.0
2011-06-02	AAU-DELISTED	Stock	3.63	3.66	3.46	3.49	252123.0
2011-06-02	AAUAF-DELISTED	Stock	3.63	3.66	3.46	3.49	252373.0
2011-06-02	AAV-DELISTED	Stock	8.24	8.42	8.2	8.31	417116.0
2011-06-02	AAWW-DELISTED	Stock	60.87	61.74	60.19	61.49	185878.0
2011-06-02	AAXJ	Stock	63.21	63.45	62.834	63.25	155267.0
2011-06-02	AAXN-DELISTED	Stock	4.46	4.5702	4.46	4.49	344478.0
2011-06-02	AB	Stock	20.17	20.19	19.68	19.94	704000.0
2011-06-02	ABAC-DELISTED	Stock	2.74	2.789	2.74	2.789	5394.0
2011-06-02	ABAX-DELISTED	Stock	29.88	30.02	29.23	29.58	68502.0
2011-06-02	ABB-DELISTED	Stock	26.36	26.64	26.16	26.45	2811887.0
2011-06-02	ABBC-DELISTED	Stock	10.79	10.95	10.71	10.84	33678.0
2011-06-02	ABBNY-DELISTED	Stock	26.36	26.64	26.16	26.45	2912387.0
2011-06-02	ABC-DELISTED	Stock	40.68	40.81	40.15	40.74	1679181.0
2011-06-02	ABCB	Stock	8.76	8.88	8.68	8.78	32700.0
2011-06-02	ABCD-DELISTED	Stock	3.31	3.31	3.17	3.22	66924.0
2011-06-02	ABCO-DELISTED	Stock	25.73	25.83	24.91	25.67	44374.0
2011-06-02	ABCW-DELISTED	Stock	0.74	0.78	0.74	0.75	40650.0
2011-06-02	ABD-DELISTED	Stock	8.005	8.175	7.885	8.015	247560.0
2011-06-02	ABE-DELISTED	Stock	18.68	18.83	18.68	18.81	25839.0
2011-06-02	ABEO	Stock	2650.0	2837.5	2587.5	2837.5	13.0
2011-06-02	ABFS-DELISTED	Stock	23.12	23.56	23.07	23.1	192062.0
2011-06-02	ABG	Stock	16.05	16.21	15.74	15.95	398800.0
2011-06-02	ABH-DELISTED	Stock	23.98	24.26	23.66	23.82	438311.0
2011-06-02	ABM	Stock	22.5	22.71	22.31	22.6	283400.0
2011-06-02	ABMD-DELISTED	Stock	18.1	18.27	17.69	17.8	180481.0
2011-06-02	ABR	Stock	4.82	4.9	4.8	4.9	28200.0
2011-06-02	ABT	Stock	24.892	24.892	24.489	24.5898	18527928.0
2011-06-02	ABTL-DELISTED	Stock	5.85	5.9	5.6	5.7	20842.0
2011-06-02	ABUS	Stock	3.3	3.52	3.3	3.3	8900.0
2011-06-02	ABV-DELISTED	Stock	31.15	31.4	30.87	31.26	1425186.0
2011-06-02	ABVA-DELISTED	Stock	5.24	5.452	5.0	5.22	2239.0
2011-06-02	ABVT-DELISTED	Stock	75.63	76.27	75.08	76.06	169589.0

> showing 50 of 6,103 rows — these rows as CSV

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