PREVIEW / stock_daily / 2011-06-06

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-06.parquet
  size:    199 KB
  rows:    6,144
  symbols: 3,580

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-06	AAPL	Stock	12.3464	12.3946	12.0646	12.0729	461941200.0
2011-06-06	MSFT	Stock	23.89	24.25	23.77	24.01	54778700.0
2011-06-06	NVDA	Stock	0.4608	0.465	0.4512	0.4518	435988000.0
2011-06-06	AMZN	Stock	9.4005	9.4925	9.259	9.2845	74320000.0
2011-06-06	TSLA	Stock	2.0067	2.0087	1.884	1.9133	34966500.0
2011-06-06	TLT	Stock	95.47	95.99	95.21	95.6	8776818.0
2011-06-06	ES	Stock	34.2	34.26	33.87	33.88	1630600.0
2011-06-06	CL	Stock	42.055	42.395	41.925	42.215	4025800.0
2011-06-06	A	Stock	33.7983	33.9771	33.6123	33.6624	2882117.0
2011-06-06	AABA-DELISTED	Stock	15.65	15.85	15.41	15.45	17936787.0
2011-06-06	AACC-DELISTED	Stock	3.64	3.64	3.52	3.55	48323.0
2011-06-06	AACG	Stock	12.25	12.25	11.69	11.85	60800.0
2011-06-06	AAIC-DELISTED	Stock	27.19	27.87	27.13	27.51	42447.0
2011-06-06	AAME	Stock	1.99	2.04	1.95	2.04	1900.0
2011-06-06	AAON	Stock	6.2775	6.3289	6.2341	6.319	159975.0
2011-06-06	AAP	Stock	59.49	59.91	58.86	58.89	1019100.0
2011-06-06	AAT	Stock	21.83	22.03	21.64	21.72	227200.0
2011-06-06	AATI-DELISTED	Stock	6.04	6.043	6.02	6.04	5039855.0
2011-06-06	AAU-DELISTED	Stock	3.4	3.41	3.2	3.25	610186.0
2011-06-06	AAUAF-DELISTED	Stock	3.4	3.41	3.2	3.27	610586.0
2011-06-06	AAV-DELISTED	Stock	8.4	8.68	8.15	8.18	733059.0
2011-06-06	AAWW-DELISTED	Stock	59.33	60.72	58.55	58.68	121037.0
2011-06-06	AAXJ	Stock	62.68	62.74	62.22	62.27	463282.0
2011-06-06	AAXN-DELISTED	Stock	4.43	4.52	4.43	4.46	397606.0
2011-06-06	AB	Stock	19.59	20.0	19.24	19.35	901300.0
2011-06-06	ABAC-DELISTED	Stock	2.55	2.6099	2.51	2.56	13166.0
2011-06-06	ABAX-DELISTED	Stock	28.99	28.99	28.08	28.1	94232.0
2011-06-06	ABB-DELISTED	Stock	26.43	26.5	26.0	26.09	3134837.0
2011-06-06	ABBC-DELISTED	Stock	10.57	10.69	10.41	10.52	57533.0
2011-06-06	ABBNY-DELISTED	Stock	26.43	26.5	26.0	26.08	3135725.0
2011-06-06	ABC-DELISTED	Stock	40.22	40.59	40.18	40.46	1744880.0
2011-06-06	ABCB	Stock	8.63	8.82	8.58	8.68	52200.0
2011-06-06	ABCD-DELISTED	Stock	2.92	3.13	2.92	3.03	53185.0
2011-06-06	ABCO-DELISTED	Stock	25.07	25.26	25.0	25.2	82632.0
2011-06-06	ABCW-DELISTED	Stock	0.7415	0.7415	0.7315	0.7385	50020.0
2011-06-06	ABD-DELISTED	Stock	7.78	7.85	7.47	7.51	312700.0
2011-06-06	ABE-DELISTED	Stock	18.83	18.83	18.59	18.69	17751.0
2011-06-06	ABEO	Stock	2650.0	2750.0	2637.5	2750.0	3.0
2011-06-06	ABFS-DELISTED	Stock	21.91	22.17	21.26	21.4	405888.0
2011-06-06	ABG	Stock	15.64	15.73	15.22	15.24	231500.0
2011-06-06	ABH-DELISTED	Stock	23.59	23.8986	23.29	23.54	273393.0
2011-06-06	ABM	Stock	22.09	22.36	22.0	22.25	355000.0
2011-06-06	ABMD-DELISTED	Stock	17.25	17.25	16.84	16.88	201345.0
2011-06-06	ABR	Stock	5.03	5.1	4.82	5.06	48600.0
2011-06-06	ABT	Stock	24.513	24.5802	24.4122	24.4794	12280742.0
2011-06-06	ABTL-DELISTED	Stock	5.75	5.85	5.55	5.6	22441.0
2011-06-06	ABUS	Stock	3.24	3.24	3.22	3.22	1400.0
2011-06-06	ABV-DELISTED	Stock	31.83	32.01	31.36	31.39	1490994.0
2011-06-06	ABVA-DELISTED	Stock	4.77	4.91	4.76	4.84	5400.0
2011-06-06	ABVT-DELISTED	Stock	74.33	74.75	72.35	72.71	320167.0

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

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