PREVIEW / stock_daily / 2011-09-26

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-26.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-09-26	AAPL	Stock	14.2807	14.4279	13.975	14.3989	812876400.0
2011-09-26	MSFT	Stock	25.19	25.52	24.73	25.44	51057600.0
2011-09-26	NVDA	Stock	0.349	0.35	0.33	0.3455	972124000.0
2011-09-26	AMZN	Stock	11.374	11.512	11.07	11.4925	115882000.0
2011-09-26	TSLA	Stock	1.768	1.768	1.66	1.7013	14022000.0
2011-09-26	TLT	Stock	120.12	120.57	118.58	118.89	15111436.0
2011-09-26	ES	Stock	34.25	34.29	33.87	34.08	2108700.0
2011-09-26	CL	Stock	44.795	45.66	44.775	45.445	6402400.0
2011-09-26	A	Stock	22.9185	23.2618	22.4392	23.1688	7663836.0
2011-09-26	AABA-DELISTED	Stock	14.79	14.8	14.23	14.76	24219165.0
2011-09-26	AACC-DELISTED	Stock	3.8	3.8	3.67	3.7	6366.0
2011-09-26	AACG	Stock	9.0	9.0	8.8	8.85	8200.0
2011-09-26	AAIC-DELISTED	Stock	26.44	26.44	25.1	25.98	60831.0
2011-09-26	AAME	Stock	1.85	1.88	1.85	1.88	400.0
2011-09-26	AAON	Stock	4.7852	4.957	4.7081	4.9393	171113.0
2011-09-26	AAP	Stock	60.23	61.02	59.63	60.83	792400.0
2011-09-26	AAT	Stock	18.28	18.28	17.73	17.95	217700.0
2011-09-26	AATI-DELISTED	Stock	4.18	4.37	4.15	4.37	731151.0
2011-09-26	AAU-DELISTED	Stock	2.9	2.94	2.74	2.94	311280.0
2011-09-26	AAUAF-DELISTED	Stock	2.9	2.94	2.74	2.94	312880.0
2011-09-26	AAV-DELISTED	Stock	4.41	4.56	4.33	4.5	595860.0
2011-09-26	AAWW-DELISTED	Stock	36.53	36.7479	35.28	36.29	283960.0
2011-09-26	AAXJ	Stock	47.07	48.05	46.56	48.05	458574.0
2011-09-26	AAXN-DELISTED	Stock	4.35	4.47	4.29	4.46	371644.0
2011-09-26	AB	Stock	14.11	14.29	14.0	14.26	423800.0
2011-09-26	ABAC-DELISTED	Stock	1.64	1.82	1.61	1.61	24550.0
2011-09-26	ABAX-DELISTED	Stock	24.45	24.84	24.0	24.81	99646.0
2011-09-26	ABB-DELISTED	Stock	16.8	17.12	16.45	17.11	2852595.0
2011-09-26	ABBC-DELISTED	Stock	7.09	7.42	6.94	7.42	18607.0
2011-09-26	ABBNY-DELISTED	Stock	16.8	17.12	16.45	17.1	2853395.0
2011-09-26	ABC-DELISTED	Stock	37.95	38.96	37.28	38.9	2953765.0
2011-09-26	ABCB	Stock	8.73	8.82	8.6	8.76	29800.0
2011-09-26	ABCD-DELISTED	Stock	3.02	3.06	2.96	3.06	28992.0
2011-09-26	ABCO-DELISTED	Stock	30.53	31.75	30.13	31.68	257578.0
2011-09-26	ABCW-DELISTED	Stock	0.5495	0.5495	0.4995	0.5005	12570.0
2011-09-26	ABD-DELISTED	Stock	5.15	5.5883	4.8352	5.11	164780.0
2011-09-26	ABE-DELISTED	Stock	16.92	16.92	16.5	16.62	1600.0
2011-09-26	ABEO	Stock	2225.0	2437.5	2225.0	2437.5	22.0
2011-09-26	ABFS-DELISTED	Stock	17.36	17.8	17.08	17.74	260773.0
2011-09-26	ABG	Stock	16.65	17.13	16.04	17.1	365800.0
2011-09-26	ABH-DELISTED	Stock	15.2	15.52	14.94	15.48	132716.0
2011-09-26	ABM	Stock	18.84	19.19	18.35	19.18	319000.0
2011-09-26	ABMD-DELISTED	Stock	10.61	10.88	10.44	10.87	121328.0
2011-09-26	ABR	Stock	3.92	3.92	3.79	3.79	33500.0
2011-09-26	ABT	Stock	24.5418	24.5993	24.0908	24.3498	20730930.0
2011-09-26	ABTL-DELISTED	Stock	4.0878	4.3869	4.0878	4.1122	2804.0
2011-09-26	ABUS	Stock	1.93	2.04	1.9	1.9	3200.0
2011-09-26	ABV-DELISTED	Stock	31.05	31.21	30.05	31.09	2535381.0
2011-09-26	ABVA-DELISTED	Stock	5.0	5.0	4.66	4.81	31404.0
2011-09-26	ABVT-DELISTED	Stock	54.3	55.99	54.0	54.88	246156.0

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

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