PREVIEW / stock_daily / 2016-02-19

all stock daily files

  file:    by_date/stock_daily/2016/2016-02-19.parquet
  size:    217 KB
  rows:    6,567
  symbols: 3,338

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
2016-02-19	AAPL	Stock	24.0	24.19	23.95	24.01	141496800.0
2016-02-19	MSFT	Stock	51.97	52.28	51.53	51.82	33559100.0
2016-02-19	NVDA	Stock	0.747	0.7678	0.7412	0.761	525628000.0
2016-02-19	AMZN	Stock	26.0355	26.7975	25.7675	26.745	99494000.0
2016-02-19	GOOGL	Stock	35.795	36.2015	35.656	36.1055	34918800.0
2016-02-19	META	Stock	102.55	105.02	102.06	104.57	32404500.0
2016-02-19	TSLA	Stock	10.9107	11.166	10.8333	11.1053	44391000.0
2016-02-19	TLT	Stock	130.94	131.82	130.73	131.005	8188740.0
2016-02-19	ES	Stock	54.42	54.74	53.83	54.67	2494800.0
2016-02-19	CL	Stock	67.2	67.48	66.36	67.46	3373200.0
2016-02-19	A	Stock	36.98	37.6	36.85	37.44	2339400.0
2016-02-19	AA.B-DELISTED	Stock	28.5	28.5	27.59	28.45	31011.0
2016-02-19	AAAP-DELISTED	Stock	30.11	31.9999	28.3	31.01	149503.0
2016-02-19	AABA-DELISTED	Stock	30.19	30.23	29.7	30.05	19786716.0
2016-02-19	AAC-DELISTED	Stock	21.31	21.5	20.31	21.49	183106.0
2016-02-19	AACG	Stock	5.1	5.16	4.75	4.78	16800.0
2016-02-19	AAIC-DELISTED	Stock	11.71	11.74	11.46	11.65	175710.0
2016-02-19	AAL	Stock	39.16	40.07	39.04	39.76	11052400.0
2016-02-19	AAMC-DELISTED	Stock	5.3382	5.5882	5.1029	5.5735	45356.0
2016-02-19	AAME	Stock	4.0	4.11	3.8	4.05	16800.0
2016-02-19	AAMI	Stock	11.38	11.5	11.22	11.38	73200.0
2016-02-19	AAOI	Stock	16.26	16.47	15.91	15.98	219800.0
2016-02-19	AAON	Stock	13.8667	14.0267	13.7	13.98	224550.0
2016-02-19	AAP	Stock	143.52	145.09	141.35	143.63	948700.0
2016-02-19	AAT	Stock	36.25	37.16	36.01	36.02	127800.0
2016-02-19	AAU-DELISTED	Stock	0.739	0.8	0.7363	0.784	286952.0
2016-02-19	AAUAF-DELISTED	Stock	0.739	0.8	0.7363	0.784	288189.0
2016-02-19	AAV-DELISTED	Stock	5.14	5.33	5.05	5.25	48185.0
2016-02-19	AAVL-DELISTED	Stock	5.2	5.55	4.92	5.51	409641.0
2016-02-19	AAWW-DELISTED	Stock	36.82	36.82	33.37	35.15	488862.0
2016-02-19	AAXJ	Stock	49.11	49.39	48.96	49.15	460535.0
2016-02-19	AAXN-DELISTED	Stock	17.03	17.13	16.71	17.11	879794.0
2016-02-19	AB	Stock	18.99	19.04	18.58	18.7	257500.0
2016-02-19	ABAC-DELISTED	Stock	0.63	0.63	0.601	0.6111	1854.0
2016-02-19	ABAX-DELISTED	Stock	39.12	39.6	38.96	39.36	210667.0
2016-02-19	ABB-DELISTED	Stock	17.78	17.9	17.72	17.86	1416978.0
2016-02-19	ABBNY-DELISTED	Stock	17.78	17.9	17.72	17.86	1484967.0
2016-02-19	ABBV	Stock	54.5	55.0	53.98	54.29	8532500.0
2016-02-19	ABC-DELISTED	Stock	86.74	87.05	86.28	86.84	1429357.0
2016-02-19	ABCB	Stock	25.75	26.62	25.71	26.27	241200.0
2016-02-19	ABCD-DELISTED	Stock	3.97	4.0	3.9356	3.95	10106.0
2016-02-19	ABCO-DELISTED	Stock	37.56	37.91	37.16	37.41	519503.0
2016-02-19	ABCW-DELISTED	Stock	41.55	41.8	41.42	41.7	120853.0
2016-02-19	ABDC-DELISTED	Stock	9.18	9.4899	9.15	9.22	7715.0
2016-02-19	ABE-DELISTED	Stock	10.4	10.44	10.4	10.411	3605.0
2016-02-19	ABEO	Stock	66.25	66.75	65.25	66.0	696.0
2016-02-19	ABEV	Stock	4.46	4.55	4.45	4.5	5138600.0
2016-02-19	ABG	Stock	51.68	52.14	50.38	51.62	259500.0
2016-02-19	ABGB-DELISTED	Stock	0.8332	0.86	0.805	0.86	30030.0
2016-02-19	ABIL-DELISTED	Stock	7.2	7.3	7.12	7.2599	16410.0

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

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