PREVIEW / stock_daily / 2013-08-27

all stock daily files

  file:    by_date/stock_daily/2013/2013-08-27.parquet
  size:    211 KB
  rows:    6,380
  symbols: 3,532

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
2013-08-27	AAPL	Stock	17.7857	17.9468	17.3679	17.4496	424188800.0
2013-08-27	MSFT	Stock	33.52	34.1	33.15	33.26	58522300.0
2013-08-27	NVDA	Stock	0.3713	0.3738	0.3688	0.37	277464000.0
2013-08-27	AMZN	Stock	14.1935	14.264	13.987	14.0465	49520000.0
2013-08-27	META	Stock	40.68	41.2	39.42	39.64	72695100.0
2013-08-27	TSLA	Stock	10.82	11.2533	10.73	11.134	263503500.0
2013-08-27	TLT	Stock	105.29	106.25	105.04	106.13	11573243.0
2013-08-27	ES	Stock	40.93	41.45	40.93	41.29	1448500.0
2013-08-27	CL	Stock	57.56	57.9	57.41	57.64	2780300.0
2013-08-27	A	Stock	33.6767	33.8984	33.4764	33.598	2982214.0
2013-08-27	AABA-DELISTED	Stock	27.23	27.46	26.75	26.98	14313907.0
2013-08-27	AACG	Stock	5.12	5.12	5.1	5.1	1900.0
2013-08-27	AAIC-DELISTED	Stock	23.64	23.8491	23.31	23.32	105330.0
2013-08-27	AAME	Stock	3.89	3.9	3.77	3.82	8300.0
2013-08-27	AAMRQ-DELISTED	Stock	3.195	3.2	3.08	3.11	10229377.0
2013-08-27	AAON	Stock	10.7467	10.8178	10.3333	10.4	111825.0
2013-08-27	AAP	Stock	82.32	82.61	81.53	81.53	582000.0
2013-08-27	AAT	Stock	29.7	30.1	29.7	29.93	446000.0
2013-08-27	AAU-DELISTED	Stock	1.81	1.9099	1.74	1.75	138355.0
2013-08-27	AAUAF-DELISTED	Stock	1.81	1.9099	1.74	1.76	138655.0
2013-08-27	AAV-DELISTED	Stock	3.74	3.74	3.635	3.64	120111.0
2013-08-27	AAWW-DELISTED	Stock	47.75	48.0	47.3	47.49	175698.0
2013-08-27	AAXJ	Stock	53.72	53.789	53.3	53.37	477265.0
2013-08-27	AAXN-DELISTED	Stock	11.47	12.17	11.3627	11.85	2753992.0
2013-08-27	AB	Stock	19.62	19.8	19.27	19.29	459800.0
2013-08-27	ABAC-DELISTED	Stock	0.95	0.9901	0.808	0.812	117196.0
2013-08-27	ABAX-DELISTED	Stock	40.76	41.32	40.42	40.61	75251.0
2013-08-27	ABB-DELISTED	Stock	22.19	22.282	22.01	22.035	883310.0
2013-08-27	ABBNY-DELISTED	Stock	22.2	22.282	22.01	22.03	906892.0
2013-08-27	ABBV	Stock	43.02	43.09	42.6	42.63	4473000.0
2013-08-27	ABC-DELISTED	Stock	57.04	57.12	56.592	56.88	1360232.0
2013-08-27	ABCB	Stock	19.18	19.4	18.94	19.25	233400.0
2013-08-27	ABCD-DELISTED	Stock	1.65	1.75	1.61	1.75	42774.0
2013-08-27	ABCO-DELISTED	Stock	57.53	58.25	56.98	57.38	115421.0
2013-08-27	ABE-DELISTED	Stock	18.85	18.85	18.5491	18.69	5404.0
2013-08-27	ABEO	Stock	450.0	450.0	400.0	425.0	5.0
2013-08-27	ABFS-DELISTED	Stock	27.03	27.3	26.285	26.29	553509.0
2013-08-27	ABG	Stock	48.77	49.13	48.1	48.62	263400.0
2013-08-27	ABM	Stock	25.45	25.55	24.96	25.03	167800.0
2013-08-27	ABMD-DELISTED	Stock	22.96	23.14	22.1	22.43	285936.0
2013-08-27	ABR	Stock	6.95	6.98	6.81	6.87	84500.0
2013-08-27	ABR.A-DELISTED	Stock	24.4199	24.4199	24.4199	24.4199	100.0
2013-08-27	ABR.B-DELISTED	Stock	23.37	23.4	23.37	23.4	1693.0
2013-08-27	ABT	Stock	34.32	34.33	33.99	34.01	5300700.0
2013-08-27	ABTL-DELISTED	Stock	5.97	6.049	5.89	5.91	24922.0
2013-08-27	ABUS	Stock	5.16	5.2	5.1	5.1	45000.0
2013-08-27	ABV-DELISTED	Stock	33.48	34.11	33.25	34.06	3194558.0
2013-08-27	ABX-DELISTED	Stock	20.98	21.2	19.67	19.72	21603397.0
2013-08-27	ACAD	Stock	20.71	20.74	19.9	19.96	1844400.0
2013-08-27	ACAS-DELISTED	Stock	12.74	12.8	12.58	12.605	2262597.0

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

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