PREVIEW / stock_daily / 2011-11-14

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-14.parquet
  size:    195 KB
  rows:    6,102
  symbols: 3,525

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-11-14	AAPL	Stock	13.6971	13.7589	13.5071	13.545	432905200.0
2011-11-14	MSFT	Stock	26.88	27.0	26.65	26.76	34199200.0
2011-11-14	NVDA	Stock	0.3745	0.3783	0.3662	0.3672	500292000.0
2011-11-14	AMZN	Stock	10.7825	11.1175	10.7125	10.9465	130444000.0
2011-11-14	TSLA	Stock	2.2	2.236	2.1747	2.2147	19885500.0
2011-11-14	TLT	Stock	116.39	117.595	116.21	117.51	9252519.0
2011-11-14	ES	Stock	35.02	35.08	34.3	34.45	1257000.0
2011-11-14	CL	Stock	44.335	44.55	44.065	44.325	2543800.0
2011-11-14	A	Stock	26.5594	27.0458	26.4664	26.8598	3645984.0
2011-11-14	AABA-DELISTED	Stock	16.17	16.31	15.93	16.0	12908197.0
2011-11-14	AACC-DELISTED	Stock	3.09	3.17	3.04	3.07	9791.0
2011-11-14	AAIC-DELISTED	Stock	22.0	22.1865	21.42	21.67	27790.0
2011-11-14	AAME	Stock	1.79	1.81	1.76	1.81	14200.0
2011-11-14	AAON	Stock	6.4652	6.563	6.3052	6.3615	155925.0
2011-11-14	AAP	Stock	69.8	70.03	68.78	68.98	1060600.0
2011-11-14	AAT	Stock	20.25	20.27	19.71	19.9	167400.0
2011-11-14	AATI-DELISTED	Stock	4.08	4.195	4.08	4.17	301187.0
2011-11-14	AAU-DELISTED	Stock	2.74	2.78	2.7	2.76	159620.0
2011-11-14	AAUAF-DELISTED	Stock	2.74	2.78	2.7	2.76	160120.0
2011-11-14	AAV-DELISTED	Stock	5.17	5.2	5.07	5.15	192905.0
2011-11-14	AAWW-DELISTED	Stock	38.12	38.24	36.8	37.46	239583.0
2011-11-14	AAXJ	Stock	53.3	53.33	52.57	52.95	380343.0
2011-11-14	AAXN-DELISTED	Stock	5.57	5.87	5.56	5.73	715635.0
2011-11-14	AB	Stock	13.17	13.26	13.01	13.19	383100.0
2011-11-14	ABAC-DELISTED	Stock	2.29	2.38	2.03	2.2	109923.0
2011-11-14	ABAX-DELISTED	Stock	26.93	27.035	26.52	26.69	68900.0
2011-11-14	ABB-DELISTED	Stock	18.44	18.49	18.1898	18.27	1712589.0
2011-11-14	ABBNY-DELISTED	Stock	18.44	18.49	18.1898	18.28	1762889.0
2011-11-14	ABC-DELISTED	Stock	39.46	39.72	39.17	39.1901	1535278.0
2011-11-14	ABCB	Stock	10.18	10.18	9.9	10.05	49300.0
2011-11-14	ABCD-DELISTED	Stock	3.36	3.4	3.03	3.08	89394.0
2011-11-14	ABCO-DELISTED	Stock	35.53	35.69	35.0	35.16	330185.0
2011-11-14	ABCW-DELISTED	Stock	0.4803	0.4997	0.4802	0.4997	6530.0
2011-11-14	ABD-DELISTED	Stock	7.22	7.28	6.95	7.03	243470.0
2011-11-14	ABE-DELISTED	Stock	18.06	18.06	17.73	18.0	13239.0
2011-11-14	ABEO	Stock	1662.5	1662.5	1600.0	1650.0	9.0
2011-11-14	ABFS-DELISTED	Stock	21.27	21.48	20.54	20.86	444197.0
2011-11-14	ABG	Stock	18.8	18.98	18.56	18.79	307300.0
2011-11-14	ABH-DELISTED	Stock	15.85	15.87	15.43	15.61	174783.0
2011-11-14	ABM	Stock	20.52	20.52	19.95	20.13	152100.0
2011-11-14	ABMD-DELISTED	Stock	19.34	19.53	18.46	18.65	321502.0
2011-11-14	ABR	Stock	3.7	3.73	3.64	3.7	12100.0
2011-11-14	ABT	Stock	26.1587	26.1923	25.89	26.0244	9980409.0
2011-11-14	ABTL-DELISTED	Stock	4.25	4.34	4.05	4.15	55609.0
2011-11-14	ABUS	Stock	1.62	1.68	1.62	1.68	3500.0
2011-11-14	ABV-DELISTED	Stock	33.38	33.74	33.24	33.5	2674233.0
2011-11-14	ABVA-DELISTED	Stock	5.23	5.23	5.15	5.15	316.0
2011-11-14	ABVT-DELISTED	Stock	60.82	60.97	59.23	59.74	70942.0
2011-11-14	ABX-DELISTED	Stock	52.73	53.14	51.8	52.22	4710468.0
2011-11-14	ACAD	Stock	1.12	1.12	1.08	1.1	64100.0

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

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