PREVIEW / stock_daily / 2011-02-16

all stock daily files

  file:    by_date/stock_daily/2011/2011-02-16.parquet
  size:    199 KB
  rows:    6,132
  symbols: 3,586

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-02-16	AAPL	Stock	12.8857	13.0321	12.875	12.9689	481157600.0
2011-02-16	MSFT	Stock	27.05	27.07	26.6	27.02	70817900.0
2011-02-16	NVDA	Stock	0.5712	0.5928	0.5692	0.5845	1318364000.0
2011-02-16	AMZN	Stock	9.4885	9.5	9.3175	9.331	92564000.0
2011-02-16	TSLA	Stock	1.54	1.6647	1.538	1.6487	61726500.0
2011-02-16	TLT	Stock	89.87	90.32	89.34	89.63	8446771.0
2011-02-16	ES	Stock	33.49	33.75	33.23	33.47	966900.0
2011-02-16	CL	Stock	39.075	39.31	38.98	39.27	4828400.0
2011-02-16	A	Stock	30.6867	31.1874	30.5436	31.166	5815400.0
2011-02-16	AABA-DELISTED	Stock	17.22	17.82	17.21	17.77	40949030.0
2011-02-16	AACC-DELISTED	Stock	5.87	5.87	5.5	5.53	33821.0
2011-02-16	AACG	Stock	4.26	4.38	4.26	4.38	4400.0
2011-02-16	AAI-DELISTED	Stock	7.43	7.43	7.4	7.41	925020.0
2011-02-16	AAIC-DELISTED	Stock	26.75	27.89	26.75	27.89	39999.0
2011-02-16	AAME	Stock	2.15	2.15	2.08	2.13	500.0
2011-02-16	AAON	Stock	5.922	5.9951	5.8469	5.9714	215156.0
2011-02-16	AAP	Stock	63.72	65.0	63.72	64.41	1247700.0
2011-02-16	AAT	Stock	21.39	21.39	21.18	21.3	56200.0
2011-02-16	AATI-DELISTED	Stock	4.24	4.26	4.15	4.25	219312.0
2011-02-16	AAU-DELISTED	Stock	4.35	4.45	4.31	4.3264	365553.0
2011-02-16	AAUAF-DELISTED	Stock	4.35	4.45	4.31	4.3264	366253.0
2011-02-16	AAV-DELISTED	Stock	7.8	7.94	7.79	7.87	316220.0
2011-02-16	AAWW-DELISTED	Stock	68.01	70.0	68.01	69.34	767924.0
2011-02-16	AAXJ	Stock	61.07	61.26	60.83	61.05	776784.0
2011-02-16	AAXN-DELISTED	Stock	4.13	4.34	4.13	4.24	859181.0
2011-02-16	AB	Stock	22.67	22.83	22.55	22.74	659400.0
2011-02-16	ABAC-DELISTED	Stock	4.02	4.1	4.02	4.065	139677.0
2011-02-16	ABAX-DELISTED	Stock	27.21	27.43	27.03	27.2	28256.0
2011-02-16	ABB-DELISTED	Stock	23.57	24.09	23.56	24.05	3320671.0
2011-02-16	ABBC-DELISTED	Stock	12.93	13.2	12.93	13.1	120309.0
2011-02-16	ABBNY-DELISTED	Stock	23.56	24.09	23.56	24.07	3471098.0
2011-02-16	ABC-DELISTED	Stock	36.6	36.65	35.99	36.34	2330509.0
2011-02-16	ABCB	Stock	9.97	10.06	9.88	9.91	13800.0
2011-02-16	ABCD-DELISTED	Stock	3.81	3.91	3.81	3.9	4310.0
2011-02-16	ABCO-DELISTED	Stock	26.16	26.26	25.91	26.09	209796.0
2011-02-16	ABCW-DELISTED	Stock	1.25	1.25	1.15	1.17	278230.0
2011-02-16	ABD-DELISTED	Stock	9.0	9.3	9.0	9.18	203870.0
2011-02-16	ABE-DELISTED	Stock	18.06	18.35	17.96	18.24	12458.0
2011-02-16	ABEO	Stock	3000.0	3087.5	3000.0	3087.5	13.0
2011-02-16	ABFS-DELISTED	Stock	25.61	25.91	25.43	25.53	176971.0
2011-02-16	ABG	Stock	19.19	19.27	18.82	18.82	428400.0
2011-02-16	ABH-DELISTED	Stock	29.47	29.845	29.3	29.43	764919.0
2011-02-16	ABM	Stock	26.54	26.69	26.4	26.61	84000.0
2011-02-16	ABMD-DELISTED	Stock	13.39	13.55	13.24	13.27	123973.0
2011-02-16	ABR	Stock	6.58	6.64	6.53	6.62	23600.0
2011-02-16	ABT	Stock	22.4402	22.4738	22.1476	22.1955	19071697.0
2011-02-16	ABTL-DELISTED	Stock	5.0	5.5	4.9505	5.5	77513.0
2011-02-16	ABUS	Stock	5.23	5.25	5.1	5.22	6900.0
2011-02-16	ABV-DELISTED	Stock	26.93	27.43	26.86	27.23	2605382.0
2011-02-16	ABVA-DELISTED	Stock	4.75	4.75	4.63	4.65	2909.0

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

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