PREVIEW / stock_daily / 2011-09-28

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-28.parquet
  size:    192 KB
  rows:    6,043
  symbols: 3,505

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-28	AAPL	Stock	14.2925	14.4193	14.1611	14.1789	429637600.0
2011-09-28	MSFT	Stock	25.93	26.37	25.51	25.58	60736200.0
2011-09-28	NVDA	Stock	0.3468	0.3555	0.33	0.3355	1236532000.0
2011-09-28	AMZN	Stock	11.3175	11.7905	11.28	11.4855	288738000.0
2011-09-28	TSLA	Stock	1.7333	1.7667	1.634	1.6393	10849500.0
2011-09-28	TLT	Stock	116.9	117.11	115.76	117.03	12642847.0
2011-09-28	ES	Stock	34.51	34.73	33.72	33.73	2039100.0
2011-09-28	CL	Stock	45.12	45.5	44.315	44.365	7382200.0
2011-09-28	A	Stock	24.0701	24.1059	22.5894	22.6323	6491194.0
2011-09-28	AABA-DELISTED	Stock	14.61	14.62	14.15	14.18	20470561.0
2011-09-28	AACC-DELISTED	Stock	3.79	3.79	3.34	3.52	20225.0
2011-09-28	AACG	Stock	9.0	9.32	8.54	8.92	5400.0
2011-09-28	AAIC-DELISTED	Stock	25.23	25.34	24.16	24.16	44097.0
2011-09-28	AAME	Stock	1.87	1.89	1.87	1.89	200.0
2011-09-28	AAON	Stock	5.0044	5.0904	4.6904	4.6904	160313.0
2011-09-28	AAP	Stock	60.53	60.94	59.6	59.66	643900.0
2011-09-28	AAT	Stock	18.63	18.74	17.86	17.86	247500.0
2011-09-28	AATI-DELISTED	Stock	4.46	4.5	4.38	4.38	369380.0
2011-09-28	AAU-DELISTED	Stock	2.98	2.98	2.6707	2.73	258142.0
2011-09-28	AAUAF-DELISTED	Stock	3.01	3.01	2.7	2.73	255553.0
2011-09-28	AAV-DELISTED	Stock	4.48	4.49	4.22	4.25	385833.0
2011-09-28	AAWW-DELISTED	Stock	38.03	38.58	35.48	35.48	175739.0
2011-09-28	AAXJ	Stock	48.9401	49.34	48.16	48.18	534304.0
2011-09-28	AAXN-DELISTED	Stock	4.49	4.54	4.33	4.33	414943.0
2011-09-28	AB	Stock	14.79	14.87	14.01	14.03	183700.0
2011-09-28	ABAC-DELISTED	Stock	1.61	1.67	1.33	1.45	38798.0
2011-09-28	ABAX-DELISTED	Stock	25.38	25.38	23.93	23.98	97011.0
2011-09-28	ABB-DELISTED	Stock	17.72	17.9	17.18	17.2	4225481.0
2011-09-28	ABBC-DELISTED	Stock	7.65	7.73	7.2	7.2	33499.0
2011-09-28	ABBNY-DELISTED	Stock	17.72	17.9	17.18	17.22	5113600.0
2011-09-28	ABC-DELISTED	Stock	39.22	39.35	38.57	38.63	2233527.0
2011-09-28	ABCB	Stock	8.89	8.93	8.64	8.64	57100.0
2011-09-28	ABCD-DELISTED	Stock	3.1	3.1	2.95	2.97	32594.0
2011-09-28	ABCO-DELISTED	Stock	33.3	33.48	31.56	31.57	240016.0
2011-09-28	ABCW-DELISTED	Stock	0.49	0.53	0.49	0.52	28480.0
2011-09-28	ABD-DELISTED	Stock	5.21	5.24	4.89	4.89	413820.0
2011-09-28	ABE-DELISTED	Stock	17.35	17.83	17.34	17.53	4631.0
2011-09-28	ABFS-DELISTED	Stock	18.08	18.26	17.1	17.13	262734.0
2011-09-28	ABG	Stock	17.83	18.14	16.97	17.07	362200.0
2011-09-28	ABH-DELISTED	Stock	16.08	16.36	15.48	15.72	273942.0
2011-09-28	ABM	Stock	19.9	20.02	19.0	19.02	295900.0
2011-09-28	ABMD-DELISTED	Stock	11.58	11.6	11.02	11.03	147081.0
2011-09-28	ABR	Stock	3.76	3.77	3.69	3.72	153400.0
2011-09-28	ABT	Stock	24.6713	24.9256	24.3882	24.4266	12245727.0
2011-09-28	ABTL-DELISTED	Stock	4.3497	4.3997	4.1493	4.1503	23405.0
2011-09-28	ABUS	Stock	2.01	2.01	1.97	1.97	2500.0
2011-09-28	ABV-DELISTED	Stock	31.24	31.7	30.93	31.02	3434049.0
2011-09-28	ABVT-DELISTED	Stock	54.85	55.16	53.46	53.83	197241.0
2011-09-28	ABX-DELISTED	Stock	48.0	48.33	45.73	45.86	7458504.0
2011-09-28	ACAD	Stock	1.25	1.27	1.2	1.2	113600.0

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

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