PREVIEW / stock_daily / 2014-09-05

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-05.parquet
  size:    222 KB
  rows:    6,634
  symbols: 3,589

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-05	AAPL	Stock	24.7	24.8475	24.5775	24.7425	233828000.0
2014-09-05	MSFT	Stock	45.11	45.93	45.11	45.91	36939400.0
2014-09-05	NVDA	Stock	0.5003	0.5025	0.496	0.4992	253792000.0
2014-09-05	AMZN	Stock	17.315	17.3415	17.125	17.319	42140000.0
2014-09-05	GOOGL	Stock	29.7565	29.925	29.6775	29.889	35997100.0
2014-09-05	META	Stock	76.1	77.38	75.6	77.26	29476000.0
2014-09-05	TSLA	Stock	18.8367	18.86	18.1673	18.4927	167548500.0
2014-09-05	TLT	Stock	116.44	116.6	115.44	115.73	6886317.0
2014-09-05	ES	Stock	45.89	46.57	45.82	46.57	1407800.0
2014-09-05	CL	Stock	64.27	64.88	64.12	64.86	3441700.0
2014-09-05	A	Stock	41.1874	41.5236	40.9871	41.4306	1268405.0
2014-09-05	AABA-DELISTED	Stock	39.05	39.8	39.05	39.58	24547433.0
2014-09-05	AACG	Stock	4.65	4.67	4.64	4.67	5500.0
2014-09-05	AAIC-DELISTED	Stock	27.21	27.67	27.2	27.62	1312676.0
2014-09-05	AAL	Stock	38.51	38.71	37.71	37.85	12067600.0
2014-09-05	AAMC-DELISTED	Stock	211.7647	218.8235	209.8118	215.5853	35136.0
2014-09-05	AAME	Stock	3.96	4.07	3.96	4.07	1900.0
2014-09-05	AAOI	Stock	20.4	20.47	19.734	20.3	155300.0
2014-09-05	AAON	Stock	12.5467	12.7733	12.4067	12.7467	207000.0
2014-09-05	AAP	Stock	138.01	138.55	137.05	137.76	532800.0
2014-09-05	AAT	Stock	35.05	35.48	35.05	35.34	93800.0
2014-09-05	AAU-DELISTED	Stock	1.45	1.53	1.45	1.51	247824.0
2014-09-05	AAUAF-DELISTED	Stock	1.45	1.53	1.45	1.51	248666.0
2014-09-05	AAV-DELISTED	Stock	5.66	5.76	5.59	5.71	370640.0
2014-09-05	AAVL-DELISTED	Stock	30.32	31.6	30.29	31.05	46443.0
2014-09-05	AAWW-DELISTED	Stock	34.3	35.28	34.3	35.04	359654.0
2014-09-05	AAXJ	Stock	66.22	66.51	66.01	66.51	447603.0
2014-09-05	AAXN-DELISTED	Stock	18.62	18.76	17.93	18.275	8127108.0
2014-09-05	AB	Stock	27.13	27.23	26.83	26.89	149900.0
2014-09-05	ABAC-DELISTED	Stock	1.52	1.58	1.37	1.48	151434.0
2014-09-05	ABAX-DELISTED	Stock	48.12	48.63	47.79	48.24	43689.0
2014-09-05	ABB-DELISTED	Stock	23.09	23.13	22.97	23.11	584359.0
2014-09-05	ABBNY-DELISTED	Stock	23.09	23.13	22.97	23.1	685861.0
2014-09-05	ABBV	Stock	55.49	55.94	54.87	55.94	9914300.0
2014-09-05	ABC-DELISTED	Stock	77.18	78.26	76.98	78.14	1075473.0
2014-09-05	ABCB	Stock	22.59	22.8	22.49	22.72	63400.0
2014-09-05	ABCD-DELISTED	Stock	1.5601	1.6399	1.5601	1.6399	5345.0
2014-09-05	ABCO-DELISTED	Stock	47.99	48.34	47.65	48.02	218679.0
2014-09-05	ABDC-DELISTED	Stock	13.6	13.88	13.6	13.79	23734.0
2014-09-05	ABE-DELISTED	Stock	14.82	14.9	14.81	14.9	6805.0
2014-09-05	ABEO	Stock	412.5	412.5	375.0	412.5	35.0
2014-09-05	ABEV	Stock	7.24	7.24	7.09	7.12	5450400.0
2014-09-05	ABG	Stock	71.57	72.37	71.03	71.94	151100.0
2014-09-05	ABGB-DELISTED	Stock	29.05	29.31	28.88	29.26	23380.0
2014-09-05	ABIL-DELISTED	Stock	9.76	9.8	9.76	9.79	500.0
2014-09-05	ABM	Stock	27.98	28.42	27.86	28.25	256900.0
2014-09-05	ABMD-DELISTED	Stock	24.89	25.15	24.8	24.96	134117.0
2014-09-05	ABR	Stock	6.92	6.97	6.91	6.94	53900.0
2014-09-05	ABR.A-DELISTED	Stock	24.88	24.9	24.8	24.8	6736.0
2014-09-05	ABR.B-DELISTED	Stock	24.4	24.4	24.36	24.4	1226.0

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

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