PREVIEW / stock_daily / 2011-02-09

all stock daily files

  file:    by_date/stock_daily/2011/2011-02-09.parquet
  size:    196 KB
  rows:    6,068
  symbols: 3,553

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-09	AAPL	Stock	12.6854	12.8214	12.6739	12.7914	482745200.0
2011-02-09	MSFT	Stock	28.19	28.26	27.91	27.97	52905100.0
2011-02-09	NVDA	Stock	0.599	0.605	0.5715	0.5822	1277520000.0
2011-02-09	AMZN	Stock	9.1575	9.3235	9.113	9.265	166254000.0
2011-02-09	TSLA	Stock	1.6087	1.612	1.5193	1.5473	39534000.0
2011-02-09	TLT	Stock	88.69	89.66	88.14	89.22	13081570.0
2011-02-09	ES	Stock	33.73	33.8	33.52	33.8	1587400.0
2011-02-09	CL	Stock	39.17	39.355	38.9	39.16	5434200.0
2011-02-09	A	Stock	31.4807	31.5951	30.8727	31.0658	5283601.0
2011-02-09	AABA-DELISTED	Stock	16.55	16.7	16.35	16.435	16713938.0
2011-02-09	AACC-DELISTED	Stock	6.25	6.25	6.011	6.2	16449.0
2011-02-09	AACG	Stock	4.11	4.19	4.05	4.19	6800.0
2011-02-09	AAI-DELISTED	Stock	7.4	7.42	7.4	7.41	1563339.0
2011-02-09	AAIC-DELISTED	Stock	25.51	25.789	25.51	25.58	22590.0
2011-02-09	AAME	Stock	2.18	2.18	2.18	2.18	300.0
2011-02-09	AAON	Stock	5.4163	5.4736	5.4064	5.4499	98719.0
2011-02-09	AAP	Stock	64.9	66.8	64.9	66.0	2097200.0
2011-02-09	AAT	Stock	20.8	21.2	20.61	21.14	423900.0
2011-02-09	AATI-DELISTED	Stock	4.01	4.06	3.98	4.06	267345.0
2011-02-09	AAU-DELISTED	Stock	4.04	4.06	3.88	3.925	368166.0
2011-02-09	AAUAF-DELISTED	Stock	4.04	4.06	3.88	3.925	368766.0
2011-02-09	AAV-DELISTED	Stock	7.46	7.5399	7.37	7.38	319792.0
2011-02-09	AAWW-DELISTED	Stock	53.93	54.25	53.22	53.88	121059.0
2011-02-09	AAXJ	Stock	61.27	61.51	60.68	60.92	2090128.0
2011-02-09	AAXN-DELISTED	Stock	4.15	4.15	4.11	4.12	199795.0
2011-02-09	AB	Stock	21.73	21.73	21.12	21.33	279000.0
2011-02-09	ABAC-DELISTED	Stock	4.32	4.32	4.06	4.12	110339.0
2011-02-09	ABAX-DELISTED	Stock	26.38	26.43	26.0	26.19	47435.0
2011-02-09	ABB-DELISTED	Stock	23.58	23.7	23.4999	23.67	2372811.0
2011-02-09	ABBC-DELISTED	Stock	12.85	12.96	12.63	12.79	117562.0
2011-02-09	ABBNY-DELISTED	Stock	23.58	23.7	23.4999	23.68	2324931.0
2011-02-09	ABC-DELISTED	Stock	36.45	36.7	36.3	36.66	1694848.0
2011-02-09	ABCB	Stock	9.71	9.98	9.71	9.85	57600.0
2011-02-09	ABCD-DELISTED	Stock	3.6	3.75	3.57	3.74	39105.0
2011-02-09	ABCO-DELISTED	Stock	24.74	24.74	24.46	24.51	139746.0
2011-02-09	ABCW-DELISTED	Stock	1.28	1.34	1.25	1.32	191700.0
2011-02-09	ABD-DELISTED	Stock	8.61	8.85	8.35	8.72	636120.0
2011-02-09	ABE-DELISTED	Stock	18.44	18.5	18.18	18.25	9561.0
2011-02-09	ABEO	Stock	3000.0	3062.5	3000.0	3012.5	7.0
2011-02-09	ABFS-DELISTED	Stock	24.35	24.88	24.3	24.69	140460.0
2011-02-09	ABG	Stock	19.81	19.89	19.49	19.59	100600.0
2011-02-09	ABH-DELISTED	Stock	28.93	29.25	28.7	29.14	1143887.0
2011-02-09	ABM	Stock	26.58	26.77	26.31	26.43	111800.0
2011-02-09	ABMD-DELISTED	Stock	13.52	13.77	13.28	13.56	215841.0
2011-02-09	ABR	Stock	6.7	6.74	6.49	6.74	58400.0
2011-02-09	ABT	Stock	21.8117	21.9652	21.7589	21.8501	15826594.0
2011-02-09	ABTL-DELISTED	Stock	4.652	4.7005	4.3128	4.7	24790.0
2011-02-09	ABUS	Stock	5.0	5.33	5.0	5.33	4300.0
2011-02-09	ABV-DELISTED	Stock	26.75	26.85	25.94	26.13	3913567.0
2011-02-09	ABVA-DELISTED	Stock	4.84	4.88	4.66	4.68	1300.0

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

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