PREVIEW / stock_daily / 2011-04-13

all stock daily files

  file:    by_date/stock_daily/2011/2011-04-13.parquet
  size:    197 KB
  rows:    6,082
  symbols: 3,546

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-04-13	AAPL	Stock	11.965	12.005	11.8757	12.0046	346220000.0
2011-04-13	MSFT	Stock	25.65	25.87	25.56	25.63	38144700.0
2011-04-13	NVDA	Stock	0.4388	0.4468	0.4332	0.444	749588000.0
2011-04-13	AMZN	Stock	9.0415	9.144	8.99	9.1145	84326000.0
2011-04-13	TSLA	Stock	1.6753	1.7127	1.654	1.662	18172500.0
2011-04-13	TLT	Stock	90.54	91.5	90.44	91.5	7962543.0
2011-04-13	ES	Stock	34.17	34.26	33.78	33.88	1685900.0
2011-04-13	CL	Stock	41.29	41.335	40.795	40.805	5330800.0
2011-04-13	A	Stock	32.3391	33.4263	32.3319	33.3262	7127423.0
2011-04-13	AABA-DELISTED	Stock	16.43	16.69	16.43	16.63	16392499.0
2011-04-13	AACC-DELISTED	Stock	5.23	5.28	5.2	5.23	24361.0
2011-04-13	AACG	Stock	8.0	8.0	7.85	7.97	22000.0
2011-04-13	AAI-DELISTED	Stock	7.38	7.4	7.34	7.38	3417173.0
2011-04-13	AAIC-DELISTED	Stock	28.55	29.749	28.32	28.87	95494.0
2011-04-13	AAME	Stock	2.1	2.1	2.1	2.1	100.0
2011-04-13	AAON	Stock	6.3249	6.3249	6.1669	6.2025	88087.0
2011-04-13	AAP	Stock	64.28	64.65	63.36	64.0	1928500.0
2011-04-13	AAT	Stock	21.23	21.41	21.16	21.38	210400.0
2011-04-13	AATI-DELISTED	Stock	3.99	4.07	3.88	3.97	187963.0
2011-04-13	AAU-DELISTED	Stock	4.49	4.63	4.36	4.51	427259.0
2011-04-13	AAUAF-DELISTED	Stock	4.49	4.63	4.36	4.51	428259.0
2011-04-13	AAV-DELISTED	Stock	8.39	8.59	8.32	8.43	400461.0
2011-04-13	AAWW-DELISTED	Stock	64.64	65.07	62.39	63.28	142037.0
2011-04-13	AAXJ	Stock	64.38	64.38	63.61	63.8	314175.0
2011-04-13	AAXN-DELISTED	Stock	3.9	3.9	3.79	3.8	282351.0
2011-04-13	AB	Stock	21.78	21.91	21.57	21.68	425100.0
2011-04-13	ABAC-DELISTED	Stock	3.67	3.691	3.51	3.51	63401.0
2011-04-13	ABAX-DELISTED	Stock	29.07	29.29	28.47	28.63	55291.0
2011-04-13	ABB-DELISTED	Stock	24.5	24.52	24.17	24.26	1465808.0
2011-04-13	ABBC-DELISTED	Stock	12.35	12.41	11.87	12.05	83849.0
2011-04-13	ABBNY-DELISTED	Stock	24.51	24.52	24.17	24.24	1466808.0
2011-04-13	ABC-DELISTED	Stock	39.78	39.97	39.39	39.64	1825970.0
2011-04-13	ABCB	Stock	9.78	9.85	9.61	9.63	215400.0
2011-04-13	ABCD-DELISTED	Stock	3.35	3.36	3.32	3.33	27291.0
2011-04-13	ABCO-DELISTED	Stock	24.48	24.48	24.2	24.37	100318.0
2011-04-13	ABCW-DELISTED	Stock	0.9	0.9333	0.86	0.93	50720.0
2011-04-13	ABD-DELISTED	Stock	9.54	9.54	9.229	9.36	213300.0
2011-04-13	ABE-DELISTED	Stock	18.8	18.86	18.65	18.722	12056.0
2011-04-13	ABEO	Stock	2725.0	2725.0	2575.0	2687.5	23.0
2011-04-13	ABFS-DELISTED	Stock	25.09	25.28	24.9	25.08	347064.0
2011-04-13	ABG	Stock	17.7	17.79	17.35	17.59	310400.0
2011-04-13	ABH-DELISTED	Stock	25.9	26.15	25.8	26.08	431604.0
2011-04-13	ABM	Stock	24.32	24.38	23.85	24.09	224400.0
2011-04-13	ABMD-DELISTED	Stock	16.11	16.4	15.85	15.9	655951.0
2011-04-13	ABR	Stock	5.32	5.36	5.31	5.33	53000.0
2011-04-13	ABT	Stock	24.2587	24.4842	24.1435	24.2059	15226136.0
2011-04-13	ABTL-DELISTED	Stock	6.3252	6.4746	5.7773	6.4248	87331.0
2011-04-13	ABUS	Stock	3.1	3.13	3.01	3.08	6500.0
2011-04-13	ABV-DELISTED	Stock	29.13	29.28	28.71	28.85	1563072.0
2011-04-13	ABVT-DELISTED	Stock	65.5	65.5	64.5	65.0	84266.0

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

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