PREVIEW / stock_daily / 2011-09-23

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-23.parquet
  size:    194 KB
  rows:    6,095
  symbols: 3,530

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-09-23	AAPL	Stock	14.2957	14.5264	14.2804	14.4393	546277200.0
2011-09-23	MSFT	Stock	24.9	25.15	24.69	25.06	64768100.0
2011-09-23	NVDA	Stock	0.3358	0.3545	0.3338	0.3448	1011440000.0
2011-09-23	AMZN	Stock	11.0255	11.2245	10.953	11.1805	129362000.0
2011-09-23	TSLA	Stock	1.6993	1.7747	1.69	1.7587	17346000.0
2011-09-23	TLT	Stock	123.12	123.36	120.83	120.83	15173754.0
2011-09-23	ES	Stock	33.48	34.07	33.39	34.01	1552300.0
2011-09-23	CL	Stock	43.685	44.625	43.5	44.46	6220600.0
2011-09-23	A	Stock	22.1745	23.0472	22.0529	22.6609	6071374.0
2011-09-23	AABA-DELISTED	Stock	14.23	14.83	14.1215	14.7	48603487.0
2011-09-23	AACC-DELISTED	Stock	3.7	3.85	3.65	3.7	2173.0
2011-09-23	AACG	Stock	9.0	9.28	8.98	8.98	16100.0
2011-09-23	AAIC-DELISTED	Stock	24.99	26.12	24.86	26.01	47385.0
2011-09-23	AAME	Stock	1.94	1.99	1.81	1.85	9000.0
2011-09-23	AAON	Stock	4.4681	4.8267	4.4681	4.7319	272025.0
2011-09-23	AAP	Stock	58.65	60.24	58.38	59.97	787000.0
2011-09-23	AAT	Stock	18.18	18.26	17.85	18.2	142000.0
2011-09-23	AATI-DELISTED	Stock	4.05	4.2	3.96	4.16	1305825.0
2011-09-23	AAU-DELISTED	Stock	2.94	2.97	2.74	2.84	420063.0
2011-09-23	AAUAF-DELISTED	Stock	2.94	2.97	2.74	2.82	420163.0
2011-09-23	AAV-DELISTED	Stock	4.14	4.43	4.04	4.38	384124.0
2011-09-23	AAWW-DELISTED	Stock	36.16	37.69	35.85	36.09	332651.0
2011-09-23	AAXJ	Stock	47.36	48.13	47.2	47.97	682251.0
2011-09-23	AAXN-DELISTED	Stock	4.21	4.5	4.2	4.28	505166.0
2011-09-23	AB	Stock	13.84	14.26	13.61	14.05	641600.0
2011-09-23	ABAC-DELISTED	Stock	1.6816	1.79	1.65	1.7599	24973.0
2011-09-23	ABAX-DELISTED	Stock	24.13	24.76	23.81	24.14	181187.0
2011-09-23	ABB-DELISTED	Stock	16.34	16.86	16.32	16.78	4495692.0
2011-09-23	ABBC-DELISTED	Stock	7.12	7.29	6.97	7.11	35376.0
2011-09-23	ABBNY-DELISTED	Stock	16.34	16.86	16.32	16.77	4726734.0
2011-09-23	ABC-DELISTED	Stock	37.66	38.1497	37.4	37.76	2359432.0
2011-09-23	ABCB	Stock	8.55	8.69	8.5	8.67	41900.0
2011-09-23	ABCD-DELISTED	Stock	2.99	3.06	2.951	3.03	43110.0
2011-09-23	ABCO-DELISTED	Stock	29.82	30.29	29.61	30.28	140972.0
2011-09-23	ABCW-DELISTED	Stock	0.55	0.5501	0.52	0.53	12420.0
2011-09-23	ABD-DELISTED	Stock	4.81	5.1	4.77	4.97	257510.0
2011-09-23	ABE-DELISTED	Stock	16.89	16.89	16.531	16.74	7398.0
2011-09-23	ABEO	Stock	2250.0	2500.0	2200.0	2375.0	15.0
2011-09-23	ABFS-DELISTED	Stock	16.96	17.46	16.7288	17.31	295144.0
2011-09-23	ABG	Stock	16.02	16.81	15.87	16.42	463900.0
2011-09-23	ABH-DELISTED	Stock	15.0	15.25	14.816	15.06	203470.0
2011-09-23	ABM	Stock	18.07	18.76	17.89	18.63	297900.0
2011-09-23	ABMD-DELISTED	Stock	10.77	10.89	10.38	10.54	168543.0
2011-09-23	ABR	Stock	3.75	3.9	3.75	3.87	56800.0
2011-09-23	ABT	Stock	24.3403	24.5754	24.1771	24.4506	21420800.0
2011-09-23	ABTL-DELISTED	Stock	4.105	4.2652	4.0549	4.145	3746.0
2011-09-23	ABUS	Stock	2.05	2.05	1.8	2.05	14800.0
2011-09-23	ABV-DELISTED	Stock	29.89	31.08	29.89	30.9	3919060.0
2011-09-23	ABVA-DELISTED	Stock	4.81	5.0	4.8	4.89	2056.0
2011-09-23	ABVT-DELISTED	Stock	50.89	53.71	50.55	53.01	271147.0

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

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