PREVIEW / stock_daily / 2011-02-04

all stock daily files

  file:    by_date/stock_daily/2011/2011-02-04.parquet
  size:    196 KB
  rows:    6,060
  symbols: 3,539

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-04	AAPL	Stock	12.2729	12.3821	12.2682	12.375	321840400.0
2011-02-04	MSFT	Stock	27.7	27.84	27.51	27.77	40412200.0
2011-02-04	NVDA	Stock	0.6362	0.6468	0.6338	0.6418	872900000.0
2011-02-04	AMZN	Stock	8.7	8.8595	8.6875	8.7965	86956000.0
2011-02-04	TSLA	Stock	1.5627	1.578	1.548	1.564	8160000.0
2011-02-04	TLT	Stock	89.5	89.65	88.77	88.81	17172135.0
2011-02-04	ES	Stock	33.77	33.86	33.45	33.74	1654100.0
2011-02-04	CL	Stock	37.965	38.155	37.875	38.12	6769800.0
2011-02-04	A	Stock	29.4063	30.8512	29.2847	30.7511	7265126.0
2011-02-04	AABA-DELISTED	Stock	16.75	16.9	16.45	16.9	18874308.0
2011-02-04	AACC-DELISTED	Stock	6.11	6.21	6.05	6.08	18638.0
2011-02-04	AACG	Stock	4.2	4.2	4.02	4.06	2500.0
2011-02-04	AAI-DELISTED	Stock	7.38	7.39	7.35	7.37	1041062.0
2011-02-04	AAIC-DELISTED	Stock	25.4	25.51	25.31	25.36	28107.0
2011-02-04	AAME	Stock	2.21	2.23	2.21	2.21	1100.0
2011-02-04	AAON	Stock	5.2879	5.3669	5.2286	5.3254	119475.0
2011-02-04	AAP	Stock	62.48	64.12	62.2	63.98	843800.0
2011-02-04	AAT	Stock	21.1	21.28	21.0	21.06	219600.0
2011-02-04	AATI-DELISTED	Stock	4.04	4.07	3.96	4.07	206047.0
2011-02-04	AAU-DELISTED	Stock	3.9199	3.92	3.8003	3.83	257148.0
2011-02-04	AAUAF-DELISTED	Stock	3.93	3.93	3.8101	3.82	256986.0
2011-02-04	AAV-DELISTED	Stock	7.72	7.73	7.57	7.66	256103.0
2011-02-04	AAWW-DELISTED	Stock	53.58	54.48	53.46	53.48	252467.0
2011-02-04	AAXJ	Stock	62.68	62.77	62.2	62.66	516741.0
2011-02-04	AAXN-DELISTED	Stock	4.13	4.17	4.07	4.11	457386.0
2011-02-04	AB	Stock	20.84	21.31	20.58	21.26	576200.0
2011-02-04	ABAC-DELISTED	Stock	4.89	4.89	4.4	4.48	188726.0
2011-02-04	ABAX-DELISTED	Stock	25.611	26.06	25.6	25.68	93003.0
2011-02-04	ABB-DELISTED	Stock	23.22	23.39	23.088	23.37	1951782.0
2011-02-04	ABBC-DELISTED	Stock	12.57	12.57	12.26	12.47	65811.0
2011-02-04	ABBNY-DELISTED	Stock	23.22	23.39	23.088	23.39	2002081.0
2011-02-04	ABC-DELISTED	Stock	35.38	36.71	34.4	36.55	4272400.0
2011-02-04	ABCB	Stock	10.17	10.24	9.86	10.02	35800.0
2011-02-04	ABCD-DELISTED	Stock	3.2	3.25	3.1	3.21	32663.0
2011-02-04	ABCO-DELISTED	Stock	24.84	24.84	23.77	24.55	167538.0
2011-02-04	ABCW-DELISTED	Stock	1.7548	1.7548	1.5953	1.6152	258520.0
2011-02-04	ABD-DELISTED	Stock	8.44	8.559	8.39	8.51	155150.0
2011-02-04	ABE-DELISTED	Stock	18.74	18.76	18.58	18.76	27420.0
2011-02-04	ABEO	Stock	3000.0	3162.5	2937.5	3087.5	25.0
2011-02-04	ABFS-DELISTED	Stock	25.0	25.28	24.0	24.04	785500.0
2011-02-04	ABG	Stock	18.69	18.92	18.48	18.78	108100.0
2011-02-04	ABH-DELISTED	Stock	26.95	27.7	26.95	27.38	770010.0
2011-02-04	ABM	Stock	26.13	26.13	25.72	25.97	130800.0
2011-02-04	ABMD-DELISTED	Stock	12.58	13.5	12.31	13.13	786955.0
2011-02-04	ABR	Stock	6.08	6.08	6.0	6.0	28300.0
2011-02-04	ABT	Stock	22.0852	22.1668	21.9413	22.1284	20698416.0
2011-02-04	ABTL-DELISTED	Stock	4.75	5.0	4.75	5.0	12208.0
2011-02-04	ABUS	Stock	5.57	5.64	5.44	5.49	16200.0
2011-02-04	ABV-DELISTED	Stock	26.78	26.8	26.18	26.56	2474724.0
2011-02-04	ABVA-DELISTED	Stock	5.25	5.26	5.02	5.02	785.0

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

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