PREVIEW / stock_daily / 2011-11-23

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-23.parquet
  size:    194 KB
  rows:    6,113
  symbols: 3,546

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-23	AAPL	Stock	13.3754	13.4229	13.1029	13.1068	428271200.0
2011-11-23	MSFT	Stock	24.61	24.79	24.47	24.47	49099700.0
2011-11-23	NVDA	Stock	0.373	0.3758	0.3608	0.361	825340000.0
2011-11-23	AMZN	Stock	9.653	9.73	9.3945	9.4495	160226000.0
2011-11-23	TSLA	Stock	2.1173	2.1367	2.0833	2.0967	6777000.0
2011-11-23	TLT	Stock	121.16	123.05	121.03	122.58	10129292.0
2011-11-23	ES	Stock	33.32	33.34	32.86	32.95	1680400.0
2011-11-23	CL	Stock	43.73	43.93	43.095	43.24	4408600.0
2011-11-23	A	Stock	25.0429	25.1216	24.0343	24.0343	5950447.0
2011-11-23	AABA-DELISTED	Stock	15.2	15.24	14.8314	14.94	20022939.0
2011-11-23	AACC-DELISTED	Stock	3.0	3.14	3.0	3.0	32594.0
2011-11-23	AACG	Stock	9.42	9.45	9.4	9.4	1500.0
2011-11-23	AAIC-DELISTED	Stock	19.76	19.84	19.1	19.18	50591.0
2011-11-23	AAME	Stock	1.96	1.99	1.95	1.99	2300.0
2011-11-23	AAON	Stock	5.8163	5.8163	5.437	5.6474	295988.0
2011-11-23	AAP	Stock	66.57	67.3	66.55	66.85	649400.0
2011-11-23	AAT	Stock	19.99	20.08	19.52	19.85	180200.0
2011-11-23	AATI-DELISTED	Stock	4.25	4.33	4.0	4.31	204834.0
2011-11-23	AAU-DELISTED	Stock	2.52	2.5701	2.4798	2.53	104198.0
2011-11-23	AAUAF-DELISTED	Stock	2.51	2.5599	2.47	2.54	105211.0
2011-11-23	AAV-DELISTED	Stock	4.73	4.7496	4.42	4.52	413923.0
2011-11-23	AAWW-DELISTED	Stock	36.96	36.99	35.12	35.3	105844.0
2011-11-23	AAXJ	Stock	48.77	48.77	48.06	48.14	349866.0
2011-11-23	AAXN-DELISTED	Stock	5.94	5.96	5.65	5.66	553413.0
2011-11-23	AB	Stock	12.95	12.98	12.46	12.64	496100.0
2011-11-23	ABAC-DELISTED	Stock	1.8101	1.94	1.78	1.84	18790.0
2011-11-23	ABAX-DELISTED	Stock	25.66	25.77	24.74	24.92	66960.0
2011-11-23	ABB-DELISTED	Stock	16.9	16.93	16.57	16.68	2882039.0
2011-11-23	ABBNY-DELISTED	Stock	16.9	16.93	16.57	16.7	2882558.0
2011-11-23	ABC-DELISTED	Stock	36.37	36.67	36.07	36.37	1408908.0
2011-11-23	ABCB	Stock	9.43	9.54	9.16	9.18	50900.0
2011-11-23	ABCD-DELISTED	Stock	2.86	2.97	2.79	2.81	74634.0
2011-11-23	ABCO-DELISTED	Stock	33.83	34.04	33.8	33.88	204502.0
2011-11-23	ABCW-DELISTED	Stock	0.3514	0.3715	0.3313	0.3564	394040.0
2011-11-23	ABD-DELISTED	Stock	8.77	8.87	8.51	8.56	456820.0
2011-11-23	ABE-DELISTED	Stock	17.52	17.52	17.3	17.36	8338.0
2011-11-23	ABEO	Stock	1625.0	1687.5	1612.5	1687.5	72.0
2011-11-23	ABFS-DELISTED	Stock	17.64	17.94	16.97	17.26	293470.0
2011-11-23	ABG	Stock	18.61	18.73	18.16	18.22	284900.0
2011-11-23	ABH-DELISTED	Stock	15.17	15.35	14.62	15.1	797936.0
2011-11-23	ABM	Stock	19.84	20.12	19.77	19.82	405200.0
2011-11-23	ABMD-DELISTED	Stock	17.53	17.9	17.35	17.59	174290.0
2011-11-23	ABR	Stock	3.6	3.63	3.54	3.54	25400.0
2011-11-23	ABT	Stock	25.1895	25.3814	25.0983	25.1175	12078158.0
2011-11-23	ABTL-DELISTED	Stock	3.7987	3.9	3.6984	3.9	26451.0
2011-11-23	ABUS	Stock	1.5	1.51	1.43	1.45	17300.0
2011-11-23	ABV-DELISTED	Stock	31.75	31.81	31.31	31.51	2199091.0
2011-11-23	ABVA-DELISTED	Stock	5.15	5.15	5.05	5.05	2225.0
2011-11-23	ABVT-DELISTED	Stock	55.63	55.65	53.39	53.59	216449.0
2011-11-23	ABX-DELISTED	Stock	48.34	48.58	47.52	47.92	5954649.0

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

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