PREVIEW / stock_daily / 2011-11-25

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-25.parquet
  size:    186 KB
  rows:    5,878
  symbols: 3,379

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-25	AAPL	Stock	13.1579	13.2554	12.9757	12.9846	254760800.0
2011-11-25	MSFT	Stock	24.38	24.67	24.3	24.3	26164600.0
2011-11-25	NVDA	Stock	0.3562	0.3645	0.35	0.351	406620000.0
2011-11-25	AMZN	Stock	9.5205	9.5415	9.0755	9.12	99440000.0
2011-11-25	TSLA	Stock	2.1033	2.1607	2.072	2.1107	3594000.0
2011-11-25	TLT	Stock	121.8	121.87	120.74	120.8	4311861.0
2011-11-25	ES	Stock	32.91	33.3	32.88	33.18	693100.0
2011-11-25	CL	Stock	43.295	43.705	43.215	43.365	1153200.0
2011-11-25	A	Stock	23.9056	24.5923	23.7625	24.1989	3196247.0
2011-11-25	AABA-DELISTED	Stock	15.0	15.25	14.9	15.1	10454439.0
2011-11-25	AACC-DELISTED	Stock	2.99	3.1486	2.99	3.02	3959.0
2011-11-25	AACG	Stock	9.49	9.7	9.4	9.67	3000.0
2011-11-25	AAIC-DELISTED	Stock	19.05	19.4	19.0	19.0	17970.0
2011-11-25	AAME	Stock	1.99	1.99	1.99	1.99	100.0
2011-11-25	AAON	Stock	5.6296	5.68	5.6119	5.6296	169763.0
2011-11-25	AAP	Stock	66.5	67.53	66.04	67.14	474200.0
2011-11-25	AAT	Stock	19.85	20.36	19.75	19.75	82100.0
2011-11-25	AATI-DELISTED	Stock	4.29	4.43	4.27	4.41	371362.0
2011-11-25	AAU-DELISTED	Stock	2.54	2.56	2.45	2.45	64166.0
2011-11-25	AAUAF-DELISTED	Stock	2.54	2.56	2.45	2.45	64366.0
2011-11-25	AAV-DELISTED	Stock	4.34	4.46	4.22	4.27	225833.0
2011-11-25	AAWW-DELISTED	Stock	35.16	36.46	34.6529	34.68	62445.0
2011-11-25	AAXJ	Stock	48.34	48.7	48.07	48.07	106494.0
2011-11-25	AAXN-DELISTED	Stock	5.64	5.7989	5.54	5.57	221163.0
2011-11-25	AB	Stock	12.7	13.0	12.63	12.75	145600.0
2011-11-25	ABAC-DELISTED	Stock	1.84	1.92	1.75	1.84	4500.0
2011-11-25	ABAX-DELISTED	Stock	24.82	24.88	24.43	24.52	34290.0
2011-11-25	ABB-DELISTED	Stock	16.82	17.048	16.66	16.67	1361733.0
2011-11-25	ABBNY-DELISTED	Stock	16.82	17.048	16.66	16.68	1362155.0
2011-11-25	ABC-DELISTED	Stock	36.38	36.51	35.75	35.9	1314694.0
2011-11-25	ABCB	Stock	9.16	9.33	9.14	9.14	25700.0
2011-11-25	ABCD-DELISTED	Stock	2.8	2.8	2.69	2.69	25076.0
2011-11-25	ABCO-DELISTED	Stock	33.76	33.76	33.1	33.25	85692.0
2011-11-25	ABCW-DELISTED	Stock	0.3615	0.3615	0.3313	0.3615	15270.0
2011-11-25	ABD-DELISTED	Stock	8.39	8.73	8.371	8.42	148810.0
2011-11-25	ABE-DELISTED	Stock	17.42	17.42	17.34	17.34	664.0
2011-11-25	ABEO	Stock	1687.5	1687.5	1687.5	1687.5	5.0
2011-11-25	ABFS-DELISTED	Stock	17.17	17.54	16.85	16.9	140540.0
2011-11-25	ABG	Stock	18.1	18.49	17.84	18.22	225300.0
2011-11-25	ABH-DELISTED	Stock	14.92	15.24	14.79	14.985	178151.0
2011-11-25	ABM	Stock	19.71	20.07	19.61	19.63	213800.0
2011-11-25	ABMD-DELISTED	Stock	17.5	17.76	17.34	17.35	146498.0
2011-11-25	ABR	Stock	3.52	3.54	3.51	3.52	14200.0
2011-11-25	ABT	Stock	25.0456	25.1847	24.9736	24.9736	4614840.0
2011-11-25	ABTL-DELISTED	Stock	3.9495	3.9495	3.819	3.8505	1402.0
2011-11-25	ABUS	Stock	1.29	1.4	1.29	1.4	1300.0
2011-11-25	ABV-DELISTED	Stock	31.34	31.8	31.33	31.5	1283810.0
2011-11-25	ABVA-DELISTED	Stock	5.15	5.15	5.05	5.05	3700.0
2011-11-25	ABVT-DELISTED	Stock	53.44	54.29	53.05	53.93	82934.0
2011-11-25	ABX-DELISTED	Stock	47.4	48.58	47.4	47.6	2418309.0

> showing 50 of 5,878 rows — these rows as CSV

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