PREVIEW / stock_daily / 2014-07-02

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-02.parquet
  size:    221 KB
  rows:    6,597
  symbols: 3,571

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-07-02	AAPL	Stock	23.4675	23.515	23.2725	23.37	113860000.0
2014-07-02	MSFT	Stock	41.73	41.9	41.53	41.9	20208100.0
2014-07-02	NVDA	Stock	0.467	0.469	0.4643	0.467	179284000.0
2014-07-02	AMZN	Stock	16.66	16.838	16.583	16.6425	53626000.0
2014-07-02	GOOGL	Stock	29.613	29.7075	29.4555	29.539	23940100.0
2014-07-02	META	Stock	68.04	68.3	65.79	66.45	41895000.0
2014-07-02	TSLA	Stock	16.044	16.1553	15.138	15.2953	120411000.0
2014-07-02	TLT	Stock	111.63	111.67	110.97	111.08	9383047.0
2014-07-02	ES	Stock	46.6	46.6	45.96	46.14	2632400.0
2014-07-02	CL	Stock	68.36	68.75	68.3	68.47	1194200.0
2014-07-02	A	Stock	41.5808	41.9099	41.3305	41.5236	1978170.0
2014-07-02	AABA-DELISTED	Stock	35.62	35.91	35.4	35.89	15729517.0
2014-07-02	AACG	Stock	4.51	4.69	4.34	4.41	14600.0
2014-07-02	AAIC-DELISTED	Stock	27.24	27.322	26.915	26.96	221419.0
2014-07-02	AAL	Stock	42.89	42.95	41.42	41.95	19744600.0
2014-07-02	AAMC-DELISTED	Stock	191.1809	202.9412	191.1765	199.1206	81359.0
2014-07-02	AAME	Stock	3.96	3.97	3.94	3.96	1400.0
2014-07-02	AAOI	Stock	23.35	23.51	23.05	23.2	129700.0
2014-07-02	AAON	Stock	15.1556	15.3956	14.8756	15.0178	205875.0
2014-07-02	AAP	Stock	134.27	135.19	133.6	134.25	522300.0
2014-07-02	AAT	Stock	34.86	35.04	34.7	34.93	156000.0
2014-07-02	AAU-DELISTED	Stock	1.44	1.5	1.4	1.42	94297.0
2014-07-02	AAUAF-DELISTED	Stock	1.41	1.47	1.39	1.42	98044.0
2014-07-02	AAV-DELISTED	Stock	6.6	6.73	6.6	6.68	278568.0
2014-07-02	AAWW-DELISTED	Stock	36.99	37.63	36.945	37.37	98327.0
2014-07-02	AAXJ	Stock	62.86	63.87	62.86	63.83	471421.0
2014-07-02	AAXN-DELISTED	Stock	13.48	13.69	13.22	13.28	466782.0
2014-07-02	AB	Stock	26.12	26.25	25.86	26.18	185900.0
2014-07-02	ABAC-DELISTED	Stock	2.04	2.12	2.03	2.1	32886.0
2014-07-02	ABAX-DELISTED	Stock	45.93	45.982	45.13	45.36	126178.0
2014-07-02	ABB-DELISTED	Stock	22.95	23.0103	22.86	22.93	1448763.0
2014-07-02	ABBNY-DELISTED	Stock	22.95	23.0103	22.86	22.93	1637448.0
2014-07-02	ABBV	Stock	57.46	58.11	56.92	58.11	6198500.0
2014-07-02	ABC-DELISTED	Stock	72.83	73.18	72.72	73.05	1160476.0
2014-07-02	ABCB	Stock	22.12	22.3	21.89	21.99	66700.0
2014-07-02	ABCD-DELISTED	Stock	2.12	2.1499	2.1	2.1	10426.0
2014-07-02	ABCO-DELISTED	Stock	51.72	52.18	51.16	51.87	114933.0
2014-07-02	ABDC-DELISTED	Stock	14.81	15.0	14.7601	15.0	27964.0
2014-07-02	ABE-DELISTED	Stock	14.54	14.555	14.441	14.55	17323.0
2014-07-02	ABEO	Stock	400.0	400.0	350.0	375.0	37.0
2014-07-02	ABEV	Stock	7.16	7.19	7.1	7.14	15025000.0
2014-07-02	ABG	Stock	69.45	70.22	69.08	70.19	150000.0
2014-07-02	ABGB-DELISTED	Stock	27.05	27.27	27.05	27.215	3869.0
2014-07-02	ABM	Stock	27.11	27.39	26.77	26.85	189300.0
2014-07-02	ABMD-DELISTED	Stock	25.5	25.8	25.2	25.51	429298.0
2014-07-02	ABR	Stock	7.02	7.08	6.96	7.03	144100.0
2014-07-02	ABR.A-DELISTED	Stock	24.6799	24.6799	24.5	24.5799	10400.0
2014-07-02	ABR.B-DELISTED	Stock	24.48	24.6	24.48	24.6	2168.0
2014-07-02	ABR.C-DELISTED	Stock	25.09	25.1201	25.09	25.1199	10000.0
2014-07-02	ABRN-DELISTED	Stock	24.97	24.97	24.91	24.9274	3315.0

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

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