PREVIEW / stock_daily / 2014-09-02

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-02.parquet
  size:    223 KB
  rows:    6,647
  symbols: 3,584

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-02	AAPL	Stock	25.765	25.935	25.68	25.825	214256000.0
2014-09-02	MSFT	Stock	45.43	45.46	44.85	45.09	22976800.0
2014-09-02	NVDA	Stock	0.4875	0.4875	0.483	0.4875	192636000.0
2014-09-02	AMZN	Stock	16.999	17.125	16.858	17.119	46520000.0
2014-09-02	GOOGL	Stock	29.1475	29.465	29.12	29.4315	31705540.0
2014-09-02	META	Stock	75.01	76.7	74.82	76.68	34979000.0
2014-09-02	TSLA	Stock	18.3667	18.9927	18.2867	18.9413	147786000.0
2014-09-02	TLT	Stock	117.28	117.3799	116.7	116.73	10506576.0
2014-09-02	ES	Stock	45.74	45.94	45.28	45.44	2522100.0
2014-09-02	CL	Stock	64.44	64.7	64.16	64.42	3045400.0
2014-09-02	A	Stock	40.9371	41.5594	40.9371	41.5379	2817809.0
2014-09-02	AABA-DELISTED	Stock	38.91	39.3	38.79	39.27	18828490.0
2014-09-02	AACG	Stock	4.7	4.7	4.48	4.58	20800.0
2014-09-02	AAIC-DELISTED	Stock	28.47	28.66	28.24	28.34	276922.0
2014-09-02	AAL	Stock	39.0	40.54	38.89	40.5	10932800.0
2014-09-02	AAMC-DELISTED	Stock	217.9765	224.6324	217.9765	224.6324	37529.0
2014-09-02	AAME	Stock	4.05	4.09	3.97	4.02	7300.0
2014-09-02	AAOI	Stock	21.2	21.2	20.0	20.51	345100.0
2014-09-02	AAON	Stock	12.38	12.46	12.1133	12.28	511200.0
2014-09-02	AAP	Stock	137.14	138.75	137.01	137.88	1040100.0
2014-09-02	AAT	Stock	35.13	35.26	35.01	35.19	283200.0
2014-09-02	AAU-DELISTED	Stock	1.4605	1.47	1.388	1.4	210754.0
2014-09-02	AAUAF-DELISTED	Stock	1.41	1.42	1.34	1.4	218700.0
2014-09-02	AAV-DELISTED	Stock	6.17	6.17	5.9	6.0	209751.0
2014-09-02	AAVL-DELISTED	Stock	29.7	31.49	29.31	30.3	89334.0
2014-09-02	AAWW-DELISTED	Stock	33.57	34.05	33.26	33.85	231353.0
2014-09-02	AAXJ	Stock	65.65	65.76	65.33	65.43	406548.0
2014-09-02	AAXN-DELISTED	Stock	16.1	17.697	15.85	17.54	5746628.0
2014-09-02	AB	Stock	27.69	27.81	27.32	27.51	231700.0
2014-09-02	ABAC-DELISTED	Stock	1.85	1.8746	1.79	1.8	18104.0
2014-09-02	ABAX-DELISTED	Stock	47.97	48.62	47.58	48.6	97865.0
2014-09-02	ABB-DELISTED	Stock	22.92	22.995	22.86	22.96	2387507.0
2014-09-02	ABBNY-DELISTED	Stock	22.92	22.995	22.86	22.97	2527288.0
2014-09-02	ABBV	Stock	55.43	55.53	54.96	55.07	7354900.0
2014-09-02	ABC-DELISTED	Stock	77.51	77.69	77.05	77.15	925006.0
2014-09-02	ABCB	Stock	22.9	23.32	22.81	23.15	58500.0
2014-09-02	ABCD-DELISTED	Stock	1.61	1.6554	1.61	1.62	8543.0
2014-09-02	ABCO-DELISTED	Stock	49.89	50.28	49.246	49.33	228581.0
2014-09-02	ABDC-DELISTED	Stock	13.7	13.9812	13.68	13.785	40565.0
2014-09-02	ABE-DELISTED	Stock	14.76	14.76	14.68	14.74	8539.0
2014-09-02	ABEO	Stock	375.0	412.5	375.0	412.5	39.0
2014-09-02	ABEV	Stock	7.01	7.1	7.01	7.08	15993800.0
2014-09-02	ABG	Stock	70.03	71.43	70.03	71.14	170900.0
2014-09-02	ABGB-DELISTED	Stock	29.2	29.48	29.15	29.29	6448.0
2014-09-02	ABIL-DELISTED	Stock	9.75	9.75	9.75	9.75	160.0
2014-09-02	ABM	Stock	26.65	26.8	26.47	26.75	149200.0
2014-09-02	ABMD-DELISTED	Stock	26.24	26.24	25.72	25.88	119787.0
2014-09-02	ABR	Stock	7.0	7.01	6.98	6.99	61300.0
2014-09-02	ABR.A-DELISTED	Stock	24.74	24.8599	24.7	24.78	13398.0
2014-09-02	ABR.B-DELISTED	Stock	24.16	24.57	24.1401	24.57	8045.0

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

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