PREVIEW / stock_daily / 2014-08-19

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-19.parquet
  size:    221 KB
  rows:    6,615
  symbols: 3,574

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-08-19	AAPL	Stock	24.8525	25.17	24.83	25.1325	277596000.0
2014-08-19	MSFT	Stock	44.97	45.34	44.83	45.33	28139500.0
2014-08-19	NVDA	Stock	0.4805	0.4868	0.4788	0.4843	248260000.0
2014-08-19	AMZN	Stock	16.7435	16.7905	16.6505	16.7565	34276000.0
2014-08-19	GOOGL	Stock	29.7795	29.8905	29.722	29.8555	20905160.0
2014-08-19	META	Stock	74.81	75.58	74.51	75.29	26679000.0
2014-08-19	TSLA	Stock	17.258	17.2887	16.7747	17.1173	80022000.0
2014-08-19	TLT	Stock	117.08	117.15	115.98	116.18	5936871.0
2014-08-19	ES	Stock	44.32	44.76	44.26	44.74	820800.0
2014-08-19	CL	Stock	64.53	64.54	64.04	64.26	3273800.0
2014-08-19	A	Stock	41.8598	42.0243	41.6023	41.8884	1667814.0
2014-08-19	AABA-DELISTED	Stock	37.56	37.94	37.5	37.84	16427376.0
2014-08-19	AACG	Stock	4.66	4.79	4.66	4.76	11300.0
2014-08-19	AAIC-DELISTED	Stock	27.57	27.63	27.49	27.56	147925.0
2014-08-19	AAL	Stock	40.96	41.0	40.26	40.43	5819600.0
2014-08-19	AAMC-DELISTED	Stock	169.2117	172.0588	164.4147	167.6029	23174.0
2014-08-19	AAME	Stock	4.15	4.17	4.09	4.17	6200.0
2014-08-19	AAOI	Stock	19.0	19.75	19.0	19.54	309600.0
2014-08-19	AAON	Stock	12.7467	12.8667	12.6267	12.7333	182700.0
2014-08-19	AAP	Stock	133.41	135.0	133.34	134.02	796700.0
2014-08-19	AAT	Stock	35.32	35.53	35.28	35.32	127400.0
2014-08-19	AAU-DELISTED	Stock	1.49	1.511	1.48	1.5	35763.0
2014-08-19	AAUAF-DELISTED	Stock	1.48	1.5	1.47	1.5	36297.0
2014-08-19	AAV-DELISTED	Stock	5.59	5.76	5.58	5.72	479300.0
2014-08-19	AAVL-DELISTED	Stock	28.0	31.3099	27.8	30.86	99147.0
2014-08-19	AAWW-DELISTED	Stock	33.81	34.19	33.68	33.69	76640.0
2014-08-19	AAXJ	Stock	65.86	66.13	65.86	66.08	493529.0
2014-08-19	AAXN-DELISTED	Stock	15.43	16.12	15.1	16.12	5180025.0
2014-08-19	AB	Stock	25.95	26.48	25.77	26.2	255600.0
2014-08-19	ABAC-DELISTED	Stock	1.8682	1.98	1.8682	1.9108	1400.0
2014-08-19	ABAX-DELISTED	Stock	46.0	46.025	45.78	45.8	75617.0
2014-08-19	ABB-DELISTED	Stock	22.7	22.81	22.67	22.78	1284830.0
2014-08-19	ABBNY-DELISTED	Stock	22.7	22.81	22.67	22.79	1476667.0
2014-08-19	ABBV	Stock	54.48	55.31	54.18	55.29	9159300.0
2014-08-19	ABC-DELISTED	Stock	76.68	77.1	76.63	76.94	613882.0
2014-08-19	ABCB	Stock	22.65	22.77	22.39	22.74	110800.0
2014-08-19	ABCD-DELISTED	Stock	1.85	1.85	1.77	1.77	2600.0
2014-08-19	ABCO-DELISTED	Stock	50.27	51.07	50.26	50.76	359575.0
2014-08-19	ABDC-DELISTED	Stock	13.3899	13.5792	13.2601	13.4805	95181.0
2014-08-19	ABE-DELISTED	Stock	14.6105	14.69	14.6105	14.64	29369.0
2014-08-19	ABEO	Stock	412.5	437.5	412.5	437.5	18.0
2014-08-19	ABEV	Stock	7.07	7.22	7.07	7.19	10539500.0
2014-08-19	ABG	Stock	69.87	70.14	69.25	69.4	187700.0
2014-08-19	ABGB-DELISTED	Stock	25.58	25.6	25.34	25.469	12878.0
2014-08-19	ABM	Stock	25.98	26.11	25.93	26.07	232600.0
2014-08-19	ABMD-DELISTED	Stock	25.43	25.71	25.24	25.65	132393.0
2014-08-19	ABR	Stock	6.98	6.98	6.92	6.94	37000.0
2014-08-19	ABR.A-DELISTED	Stock	24.6	24.7	24.6	24.6001	7123.0
2014-08-19	ABR.B-DELISTED	Stock	24.08	24.1	23.99	24.1	5698.0
2014-08-19	ABR.C-DELISTED	Stock	25.0	25.04	24.93	25.0	5400.0

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

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