PREVIEW / stock_daily / 2011-11-03

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-03.parquet
  size:    195 KB
  rows:    6,086
  symbols: 3,526

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-03	AAPL	Stock	14.2525	14.4071	14.12	14.3954	441386400.0
2011-11-03	MSFT	Stock	26.24	26.59	25.98	26.53	65836100.0
2011-11-03	NVDA	Stock	0.3493	0.367	0.34	0.3662	749372000.0
2011-11-03	AMZN	Stock	10.815	10.925	10.651	10.9145	106300000.0
2011-11-03	TSLA	Stock	2.0	2.166	1.9687	2.164	37645500.0
2011-11-03	TLT	Stock	116.34	117.35	115.99	116.34	8386678.0
2011-11-03	ES	Stock	34.42	34.92	34.2	34.77	1975100.0
2011-11-03	CL	Stock	44.11	44.39	43.81	44.26	6782200.0
2011-11-03	A	Stock	26.3305	26.7883	25.7797	26.5594	6497485.0
2011-11-03	AABA-DELISTED	Stock	15.21	15.5	15.03	15.48	16508308.0
2011-11-03	AACC-DELISTED	Stock	3.36	3.42	3.28	3.361	9134.0
2011-11-03	AACG	Stock	9.44	10.0	9.18	9.93	13000.0
2011-11-03	AAIC-DELISTED	Stock	23.03	23.03	22.22	22.34	60241.0
2011-11-03	AAME	Stock	1.74	1.79	1.59	1.79	4200.0
2011-11-03	AAON	Stock	6.4267	6.6281	6.2252	6.6015	372600.0
2011-11-03	AAP	Stock	64.98	66.19	64.25	66.07	647200.0
2011-11-03	AAT	Stock	19.89	20.23	19.36	20.0	140200.0
2011-11-03	AATI-DELISTED	Stock	4.32	4.32	3.25	3.86	2912432.0
2011-11-03	AAU-DELISTED	Stock	2.88	2.9	2.75	2.75	155414.0
2011-11-03	AAUAF-DELISTED	Stock	2.88	2.9	2.75	2.75	155314.0
2011-11-03	AAV-DELISTED	Stock	5.2	5.47	5.08	5.41	433606.0
2011-11-03	AAWW-DELISTED	Stock	38.56	39.36	32.64	39.15	1068393.0
2011-11-03	AAXJ	Stock	54.18	54.9	53.61	54.74	535784.0
2011-11-03	AAXN-DELISTED	Stock	5.2	5.49	5.13	5.47	756031.0
2011-11-03	AB	Stock	13.7	13.78	13.38	13.57	354600.0
2011-11-03	ABAC-DELISTED	Stock	2.0	2.04	1.9492	2.0	8320.0
2011-11-03	ABAX-DELISTED	Stock	27.85	27.99	27.13	27.67	96271.0
2011-11-03	ABB-DELISTED	Stock	18.57	19.09	18.37	19.02	3007952.0
2011-11-03	ABBNY-DELISTED	Stock	18.57	19.09	18.37	19.02	3011052.0
2011-11-03	ABC-DELISTED	Stock	40.21	40.48	39.75	39.91	3129981.0
2011-11-03	ABCB	Stock	10.24	10.6	10.0	10.53	95200.0
2011-11-03	ABCD-DELISTED	Stock	3.32	3.39	3.32	3.37	24527.0
2011-11-03	ABCO-DELISTED	Stock	33.99	36.41	33.37	35.07	1158324.0
2011-11-03	ABCW-DELISTED	Stock	0.4898	0.5176	0.4893	0.5102	58700.0
2011-11-03	ABD-DELISTED	Stock	7.075	7.245	6.8348	7.215	332140.0
2011-11-03	ABE-DELISTED	Stock	18.02	18.13	17.88	18.0701	3428.0
2011-11-03	ABEO	Stock	1725.0	1725.0	1650.0	1700.0	53.0
2011-11-03	ABFS-DELISTED	Stock	20.27	20.42	19.61	20.02	475896.0
2011-11-03	ABG	Stock	18.95	18.97	17.93	18.63	540300.0
2011-11-03	ABH-DELISTED	Stock	16.44	16.79	15.98	16.52	226241.0
2011-11-03	ABM	Stock	19.72	20.38	19.29	20.28	222400.0
2011-11-03	ABMD-DELISTED	Stock	16.08	17.85	15.12	17.81	863955.0
2011-11-03	ABR	Stock	3.61	3.61	3.35	3.47	76300.0
2011-11-03	ABT	Stock	25.487	25.89	25.4822	25.8324	14446644.0
2011-11-03	ABTL-DELISTED	Stock	4.4975	4.6025	4.3529	4.6025	6288.0
2011-11-03	ABUS	Stock	1.62	1.7	1.53	1.7	8700.0
2011-11-03	ABV-DELISTED	Stock	34.07	34.07	33.52	33.79	2647570.0
2011-11-03	ABVA-DELISTED	Stock	5.15	5.2	5.15	5.15	5992.0
2011-11-03	ABVT-DELISTED	Stock	57.5	61.43	57.5	59.77	284444.0
2011-11-03	ABX-DELISTED	Stock	51.38	52.03	50.72	52.03	7097115.0

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

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