PREVIEW / stock_daily / 2014-09-03

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-03.parquet
  size:    222 KB
  rows:    6,644
  symbols: 3,586

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
2014-09-03	AAPL	Stock	25.775	25.8	24.645	24.735	501684000.0
2014-09-03	MSFT	Stock	44.53	45.11	44.53	44.96	33684500.0
2014-09-03	NVDA	Stock	0.49	0.4938	0.4868	0.492	259456000.0
2014-09-03	AMZN	Stock	17.127	17.1635	16.8775	16.95	39874000.0
2014-09-03	GOOGL	Stock	29.5865	29.7245	29.325	29.476	31595580.0
2014-09-03	META	Stock	77.14	77.48	75.6	75.83	32389000.0
2014-09-03	TSLA	Stock	19.178	19.2	18.6733	18.746	101584500.0
2014-09-03	TLT	Stock	116.4	117.38	116.31	117.38	6554847.0
2014-09-03	ES	Stock	45.55	45.91	45.48	45.76	2307400.0
2014-09-03	CL	Stock	64.85	64.89	64.31	64.42	3304200.0
2014-09-03	A	Stock	41.6381	41.8169	41.402	41.5308	2066244.0
2014-09-03	AABA-DELISTED	Stock	39.49	39.6	38.69	38.87	15219007.0
2014-09-03	AACG	Stock	4.65	4.67	4.65	4.67	4500.0
2014-09-03	AAIC-DELISTED	Stock	28.44	28.45	28.25	28.39	191001.0
2014-09-03	AAL	Stock	39.73	39.9	38.67	39.14	9995100.0
2014-09-03	AAMC-DELISTED	Stock	225.5882	225.6206	209.8029	213.8971	49422.0
2014-09-03	AAME	Stock	3.97	4.07	3.94	4.06	4700.0
2014-09-03	AAOI	Stock	20.6	20.74	19.55	19.67	308100.0
2014-09-03	AAON	Stock	12.36	12.7133	12.2133	12.32	1191900.0
2014-09-03	AAP	Stock	138.42	138.97	137.97	138.3	597300.0
2014-09-03	AAT	Stock	35.25	35.48	35.09	35.44	80600.0
2014-09-03	AAU-DELISTED	Stock	1.36	1.38	1.33	1.35	187646.0
2014-09-03	AAUAF-DELISTED	Stock	1.36	1.38	1.33	1.35	189157.0
2014-09-03	AAV-DELISTED	Stock	6.04	6.06	5.93	5.95	397148.0
2014-09-03	AAVL-DELISTED	Stock	30.19	31.1	30.01	30.6	72224.0
2014-09-03	AAWW-DELISTED	Stock	33.92	34.25	33.67	33.9	217077.0
2014-09-03	AAXJ	Stock	66.57	66.57	66.15	66.23	368770.0
2014-09-03	AAXN-DELISTED	Stock	18.06	18.24	16.62	16.74	5034876.0
2014-09-03	AB	Stock	27.67	27.77	27.11	27.22	133400.0
2014-09-03	ABAC-DELISTED	Stock	1.8	1.8144	1.57	1.7	57663.0
2014-09-03	ABAX-DELISTED	Stock	48.76	48.7899	48.104	48.6	88841.0
2014-09-03	ABB-DELISTED	Stock	23.45	23.5	23.27	23.32	1716212.0
2014-09-03	ABBNY-DELISTED	Stock	23.45	23.5	23.27	23.32	1858487.0
2014-09-03	ABBV	Stock	55.16	55.53	54.83	55.51	7562100.0
2014-09-03	ABC-DELISTED	Stock	77.51	77.65	77.19	77.35	538915.0
2014-09-03	ABCB	Stock	23.18	23.3	22.82	22.86	42500.0
2014-09-03	ABCD-DELISTED	Stock	1.65	1.6699	1.6	1.65	20820.0
2014-09-03	ABCO-DELISTED	Stock	49.6	49.68	48.27	48.35	235381.0
2014-09-03	ABDC-DELISTED	Stock	13.63	13.88	13.63	13.77	60897.0
2014-09-03	ABE-DELISTED	Stock	14.83	14.85	14.69	14.84	71440.0
2014-09-03	ABEO	Stock	375.0	375.0	375.0	375.0	2.0
2014-09-03	ABEV	Stock	7.21	7.24	7.11	7.22	10808300.0
2014-09-03	ABG	Stock	71.64	72.37	71.25	71.99	256600.0
2014-09-03	ABGB-DELISTED	Stock	28.74	28.881	28.59	28.8	12063.0
2014-09-03	ABM	Stock	26.89	27.13	26.49	26.57	746500.0
2014-09-03	ABMD-DELISTED	Stock	25.96	26.09	25.26	25.38	127652.0
2014-09-03	ABR	Stock	7.0	7.04	6.95	6.95	207100.0
2014-09-03	ABR.A-DELISTED	Stock	24.78	24.85	24.75	24.8	9113.0
2014-09-03	ABR.B-DELISTED	Stock	24.29	24.44	24.15	24.44	13112.0
2014-09-03	ABR.C-DELISTED	Stock	25.16	25.23	25.1599	25.22	7900.0

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

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