PREVIEW / stock_daily / 2011-07-05

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-05.parquet
  size:    197 KB
  rows:    6,105
  symbols: 3,544

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-07-05	AAPL	Stock	12.25	12.4939	12.2321	12.4796	355054000.0
2011-07-05	MSFT	Stock	26.1	26.15	25.9	26.03	37805300.0
2011-07-05	NVDA	Stock	0.4032	0.407	0.3935	0.397	535296000.0
2011-07-05	AMZN	Stock	10.438	10.7225	10.4365	10.6595	71704000.0
2011-07-05	TSLA	Stock	1.9347	1.968	1.914	1.9427	14940000.0
2011-07-05	TLT	Stock	94.04	94.17	93.69	93.84	4615755.0
2011-07-05	ES	Stock	35.7	35.87	35.49	35.67	1224400.0
2011-07-05	CL	Stock	44.29	44.34	43.82	43.99	4290600.0
2011-07-05	A	Stock	37.1459	37.196	36.6881	36.9528	2608668.0
2011-07-05	AABA-DELISTED	Stock	15.4	15.67	15.25	15.5	19751661.0
2011-07-05	AACC-DELISTED	Stock	4.01	4.07	3.79	3.91	19262.0
2011-07-05	AACG	Stock	10.4	11.81	10.4	10.55	49200.0
2011-07-05	AAIC-DELISTED	Stock	31.54	31.54	30.9	31.11	45965.0
2011-07-05	AAME	Stock	2.05	2.11	2.05	2.11	4700.0
2011-07-05	AAON	Stock	6.5985	6.6252	6.4948	6.6193	153900.0
2011-07-05	AAP	Stock	59.15	59.26	57.95	58.42	1013000.0
2011-07-05	AAT	Stock	22.53	22.68	22.35	22.65	162300.0
2011-07-05	AATI-DELISTED	Stock	6.06	6.07	6.05	6.06	647559.0
2011-07-05	AAU-DELISTED	Stock	3.3695	3.48	3.31	3.4	253519.0
2011-07-05	AAUAF-DELISTED	Stock	3.3695	3.48	3.31	3.4	254519.0
2011-07-05	AAV-DELISTED	Stock	7.9	8.17	7.9	8.08	361372.0
2011-07-05	AAWW-DELISTED	Stock	60.83	61.15	60.27	60.61	127080.0
2011-07-05	AAXJ	Stock	62.86	62.98	62.54	62.68	773783.0
2011-07-05	AAXN-DELISTED	Stock	4.55	4.58	4.46	4.5	182202.0
2011-07-05	AB	Stock	20.38	20.38	19.17	19.27	420400.0
2011-07-05	ABAC-DELISTED	Stock	2.5	2.68	2.47	2.49	20050.0
2011-07-05	ABAX-DELISTED	Stock	27.82	28.96	27.82	28.81	108598.0
2011-07-05	ABB-DELISTED	Stock	26.14	26.27	25.94	26.27	2264231.0
2011-07-05	ABBC-DELISTED	Stock	10.57	10.57	10.28	10.39	21627.0
2011-07-05	ABBNY-DELISTED	Stock	26.14	26.27	25.94	26.25	2325131.0
2011-07-05	ABC-DELISTED	Stock	42.02	42.3594	41.92	42.27	1302686.0
2011-07-05	ABCB	Stock	8.81	8.88	8.74	8.79	55600.0
2011-07-05	ABCD-DELISTED	Stock	3.32	3.37	3.31	3.36	25150.0
2011-07-05	ABCO-DELISTED	Stock	28.44	28.89	28.19	28.63	117869.0
2011-07-05	ABCW-DELISTED	Stock	0.69	0.72	0.68	0.72	20390.0
2011-07-05	ABD-DELISTED	Stock	8.13	8.3	7.99	8.27	219600.0
2011-07-05	ABE-DELISTED	Stock	18.91	19.03	18.91	18.95	6597.0
2011-07-05	ABEO	Stock	2425.0	2500.0	2375.0	2375.0	6.0
2011-07-05	ABFS-DELISTED	Stock	24.4	24.53	24.17	24.35	140988.0
2011-07-05	ABG	Stock	18.72	18.83	18.32	18.81	270900.0
2011-07-05	ABH-DELISTED	Stock	20.58	20.79	20.37	20.52	197617.0
2011-07-05	ABM	Stock	23.53	23.59	23.25	23.49	231600.0
2011-07-05	ABMD-DELISTED	Stock	16.75	16.86	16.48	16.69	85929.0
2011-07-05	ABR	Stock	4.75	4.8	4.69	4.77	31500.0
2011-07-05	ABT	Stock	25.4774	25.5733	25.3958	25.5062	10492497.0
2011-07-05	ABTL-DELISTED	Stock	5.85	5.948	5.61	5.65	32769.0
2011-07-05	ABUS	Stock	2.43	2.54	2.4	2.46	8900.0
2011-07-05	ABV-DELISTED	Stock	34.15	34.58	33.86	34.49	2875610.0
2011-07-05	ABVA-DELISTED	Stock	4.82	4.82	4.79	4.8	1300.0
2011-07-05	ABVT-DELISTED	Stock	70.08	70.7	69.54	69.78	187888.0

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

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