PREVIEW / stock_daily / 2011-11-16

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-16.parquet
  size:    195 KB
  rows:    6,101
  symbols: 3,542

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-16	AAPL	Stock	13.9018	13.9693	13.7257	13.7418	349210400.0
2011-11-16	MSFT	Stock	26.47	26.51	26.04	26.07	53262800.0
2011-11-16	NVDA	Stock	0.365	0.3748	0.3632	0.3645	512420000.0
2011-11-16	AMZN	Stock	10.8135	10.8485	10.5615	10.5995	110188000.0
2011-11-16	TSLA	Stock	2.232	2.3333	2.2267	2.3293	27498000.0
2011-11-16	TLT	Stock	117.96	118.43	117.18	118.42	7469974.0
2011-11-16	ES	Stock	34.62	34.81	34.27	34.32	1929000.0
2011-11-16	CL	Stock	44.165	44.885	44.0	44.32	4620800.0
2011-11-16	A	Stock	26.7096	28.176	26.6023	27.5966	11574182.0
2011-11-16	AABA-DELISTED	Stock	15.79	16.1	15.7	15.73	14050885.0
2011-11-16	AACC-DELISTED	Stock	2.83	3.06	2.81	2.95	45300.0
2011-11-16	AACG	Stock	9.8	9.8	9.74	9.75	2000.0
2011-11-16	AAIC-DELISTED	Stock	22.23	22.93	22.11	22.27	44498.0
2011-11-16	AAME	Stock	1.94	2.0	1.94	1.99	3400.0
2011-11-16	AAON	Stock	6.4059	6.6637	6.237	6.2548	147488.0
2011-11-16	AAP	Stock	68.07	68.09	66.87	67.01	1261000.0
2011-11-16	AAT	Stock	20.48	21.66	20.48	20.88	797200.0
2011-11-16	AATI-DELISTED	Stock	4.19	4.28	4.19	4.26	237196.0
2011-11-16	AAU-DELISTED	Stock	2.67	2.8	2.66	2.77	144935.0
2011-11-16	AAUAF-DELISTED	Stock	2.67	2.8	2.66	2.77	144935.0
2011-11-16	AAV-DELISTED	Stock	5.21	5.3	5.18	5.2	540034.0
2011-11-16	AAWW-DELISTED	Stock	38.63	39.72	38.3539	38.69	322255.0
2011-11-16	AAXJ	Stock	52.08	52.59	51.67	51.68	328105.0
2011-11-16	AAXN-DELISTED	Stock	5.76	5.85	5.7	5.72	299113.0
2011-11-16	AB	Stock	13.27	13.27	13.04	13.15	389800.0
2011-11-16	ABAC-DELISTED	Stock	1.91	2.04	1.9	1.99	52344.0
2011-11-16	ABAX-DELISTED	Stock	27.44	27.98	27.13	27.19	70373.0
2011-11-16	ABB-DELISTED	Stock	18.32	18.53	18.18	18.19	2475495.0
2011-11-16	ABBNY-DELISTED	Stock	18.32	18.53	18.18	18.2	2468267.0
2011-11-16	ABC-DELISTED	Stock	39.07	39.07	38.05	38.1	1783848.0
2011-11-16	ABCB	Stock	10.03	10.16	9.93	10.0	168800.0
2011-11-16	ABCD-DELISTED	Stock	3.11	3.165	3.0	3.06	55525.0
2011-11-16	ABCO-DELISTED	Stock	35.32	36.0	34.91	34.93	212252.0
2011-11-16	ABCW-DELISTED	Stock	0.47	0.49	0.45	0.47	115440.0
2011-11-16	ABD-DELISTED	Stock	7.09	7.27	6.94	6.96	221170.0
2011-11-16	ABE-DELISTED	Stock	17.95	18.0592	17.75	17.86	2699.0
2011-11-16	ABEO	Stock	1625.0	1687.5	1600.0	1687.5	63.0
2011-11-16	ABFS-DELISTED	Stock	20.76	20.94	19.75	20.06	622373.0
2011-11-16	ABG	Stock	18.9	19.24	18.74	18.88	520200.0
2011-11-16	ABH-DELISTED	Stock	15.37	15.6	15.2	15.41	123231.0
2011-11-16	ABM	Stock	20.53	21.0	20.36	20.47	195400.0
2011-11-16	ABMD-DELISTED	Stock	19.04	19.7	18.65	18.74	304651.0
2011-11-16	ABR	Stock	3.7	3.74	3.61	3.71	58600.0
2011-11-16	ABT	Stock	26.0435	26.0915	25.7653	25.7988	11433097.0
2011-11-16	ABTL-DELISTED	Stock	3.85	4.1	3.85	3.9	58566.0
2011-11-16	ABUS	Stock	1.65	1.7	1.65	1.7	13700.0
2011-11-16	ABV-DELISTED	Stock	33.49	34.0147	33.27	33.29	3366136.0
2011-11-16	ABVA-DELISTED	Stock	5.25	5.28	5.15	5.15	13703.0
2011-11-16	ABVT-DELISTED	Stock	59.0	60.14	58.56	58.67	156796.0
2011-11-16	ABX-DELISTED	Stock	51.69	52.43	51.3	51.44	4412230.0

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

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