PREVIEW / stock_daily / 2011-09-16

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-16.parquet
  size:    197 KB
  rows:    6,127
  symbols: 3,559

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-09-16	AAPL	Stock	14.1264	14.3036	14.1082	14.3036	698513200.0
2011-09-16	MSFT	Stock	27.05	27.27	26.83	27.12	89681500.0
2011-09-16	NVDA	Stock	0.3882	0.4025	0.3845	0.3865	1391588000.0
2011-09-16	AMZN	Stock	11.3785	12.022	11.337	11.965	235060000.0
2011-09-16	TSLA	Stock	1.652	1.7227	1.6327	1.72	21256500.0
2011-09-16	TLT	Stock	111.31	112.5898	111.25	112.24	10053417.0
2011-09-16	ES	Stock	34.61	34.91	34.31	34.45	1840600.0
2011-09-16	CL	Stock	45.885	46.865	45.885	46.82	8423800.0
2011-09-16	A	Stock	26.6023	26.7597	25.5508	26.0086	6992516.0
2011-09-16	AABA-DELISTED	Stock	15.09	15.34	14.94	14.99	53412655.0
2011-09-16	AACC-DELISTED	Stock	3.99	4.1	3.9	3.9	30528.0
2011-09-16	AACG	Stock	9.84	9.98	9.3	9.41	10600.0
2011-09-16	AAIC-DELISTED	Stock	24.46	25.76	24.214	25.69	58989.0
2011-09-16	AAME	Stock	2.0	2.0	1.95	1.95	2400.0
2011-09-16	AAON	Stock	5.2444	5.5585	5.1141	5.1407	745875.0
2011-09-16	AAP	Stock	62.78	63.59	62.54	62.59	1467100.0
2011-09-16	AAT	Stock	19.0	19.88	18.93	19.49	837100.0
2011-09-16	AATI-DELISTED	Stock	4.52	4.69	4.49	4.66	1110101.0
2011-09-16	AAU-DELISTED	Stock	3.23	3.5	3.16	3.5	275758.0
2011-09-16	AAUAF-DELISTED	Stock	3.23	3.5	3.16	3.5	275172.0
2011-09-16	AAV-DELISTED	Stock	5.32	5.34	5.22	5.28	176645.0
2011-09-16	AAWW-DELISTED	Stock	47.41	47.56	46.31	47.08	219217.0
2011-09-16	AAXJ	Stock	53.58	53.81	53.14	53.7	1315610.0
2011-09-16	AAXN-DELISTED	Stock	4.57	4.59	4.35	4.53	373213.0
2011-09-16	AB	Stock	15.97	16.2	15.52	15.75	353300.0
2011-09-16	ABAC-DELISTED	Stock	2.0001	2.05	2.0	2.01	12170.0
2011-09-16	ABAX-DELISTED	Stock	25.25	25.52	24.96	25.52	160283.0
2011-09-16	ABB-DELISTED	Stock	19.05	19.115	18.77	18.96	2280842.0
2011-09-16	ABBC-DELISTED	Stock	8.58	8.58	8.34	8.42	72652.0
2011-09-16	ABBNY-DELISTED	Stock	19.05	19.115	18.77	18.94	2283142.0
2011-09-16	ABC-DELISTED	Stock	38.78	39.93	38.77	39.29	4289025.0
2011-09-16	ABCB	Stock	9.24	9.35	9.07	9.33	86500.0
2011-09-16	ABCD-DELISTED	Stock	3.06	3.11	3.0	3.05	50297.0
2011-09-16	ABCO-DELISTED	Stock	30.33	30.83	29.73	30.8	172014.0
2011-09-16	ABCW-DELISTED	Stock	0.62	0.62	0.55	0.58	27440.0
2011-09-16	ABD-DELISTED	Stock	6.09	6.31	5.85	5.95	317070.0
2011-09-16	ABE-DELISTED	Stock	17.81	18.07	17.81	18.03	6424.0
2011-09-16	ABEO	Stock	2487.5	2625.0	2300.0	2625.0	13.0
2011-09-16	ABFS-DELISTED	Stock	21.29	21.33	20.72	21.1	506138.0
2011-09-16	ABG	Stock	19.21	19.21	18.41	18.98	908700.0
2011-09-16	ABH-DELISTED	Stock	16.45	16.45	15.8	16.0	263297.0
2011-09-16	ABM	Stock	19.72	19.92	19.35	19.35	337700.0
2011-09-16	ABMD-DELISTED	Stock	11.93	12.18	11.68	12.14	335306.0
2011-09-16	ABR	Stock	4.04	4.12	3.99	3.99	41300.0
2011-09-16	ABT	Stock	24.7481	25.036	24.6233	25.0312	21048770.0
2011-09-16	ABTL-DELISTED	Stock	4.6003	4.6003	4.5002	4.5997	5070.0
2011-09-16	ABV-DELISTED	Stock	33.08	33.15	32.6	32.64	3366949.0
2011-09-16	ABVA-DELISTED	Stock	4.74	5.1	4.71	5.0	23233.0
2011-09-16	ABVT-DELISTED	Stock	58.0	58.93	56.86	56.86	221415.0
2011-09-16	ABX-DELISTED	Stock	53.37	53.77	52.85	53.55	9171494.0

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

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