PREVIEW / stock_daily / 2016-02-12

all stock daily files

  file:    by_date/stock_daily/2016/2016-02-12.parquet
  size:    216 KB
  rows:    6,546
  symbols: 3,325

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-12	AAPL	Stock	23.5475	23.625	23.2525	23.4975	161405600.0
2016-02-12	MSFT	Stock	50.25	50.68	49.75	50.5	34243300.0
2016-02-12	NVDA	Stock	0.6425	0.6445	0.6188	0.6433	340816000.0
2016-02-12	AMZN	Stock	25.535	25.8375	25.0745	25.354	107696000.0
2016-02-12	GOOGL	Stock	35.6105	35.8	35.079	35.3445	46537780.0
2016-02-12	META	Stock	103.74	104.24	101.09	102.01	36176800.0
2016-02-12	TSLA	Stock	10.3333	10.4673	9.58	10.0693	108537000.0
2016-02-12	TLT	Stock	132.64	133.13	130.93	131.5	13888427.0
2016-02-12	ES	Stock	53.88	54.07	52.93	53.51	2236500.0
2016-02-12	CL	Stock	64.78	65.75	64.54	65.7	2579100.0
2016-02-12	A	Stock	35.84	36.23	35.52	36.22	3923600.0
2016-02-12	AA.B-DELISTED	Stock	26.08	27.0439	26.08	26.97	22605.0
2016-02-12	AAAP-DELISTED	Stock	24.64	25.7296	24.3	25.08	35428.0
2016-02-12	AABA-DELISTED	Stock	27.12	27.321	26.715	27.04	12138789.0
2016-02-12	AAC-DELISTED	Stock	19.98	20.92	19.868	20.11	260196.0
2016-02-12	AACG	Stock	5.01	5.28	5.01	5.01	3600.0
2016-02-12	AAIC-DELISTED	Stock	10.89	11.02	10.61	10.92	315435.0
2016-02-12	AAL	Stock	36.92	37.98	36.42	37.82	9412800.0
2016-02-12	AAMC-DELISTED	Stock	4.3956	4.6353	4.3941	4.6265	27322.0
2016-02-12	AAME	Stock	4.48	4.49	4.01	4.3	10700.0
2016-02-12	AAMI	Stock	10.93	11.35	10.82	11.15	108700.0
2016-02-12	AAOI	Stock	14.65	15.34	14.44	15.3	149100.0
2016-02-12	AAON	Stock	13.8133	13.9267	13.5667	13.76	122100.0
2016-02-12	AAP	Stock	139.54	141.4	137.19	140.77	974800.0
2016-02-12	AAT	Stock	34.84	35.1	34.61	34.94	137000.0
2016-02-12	AAU-DELISTED	Stock	0.66	0.7	0.6556	0.6792	118327.0
2016-02-12	AAUAF-DELISTED	Stock	0.66	0.7	0.6556	0.6792	120056.0
2016-02-12	AAV-DELISTED	Stock	5.45	5.52	5.31	5.4	63235.0
2016-02-12	AAVL-DELISTED	Stock	4.8	4.9	4.64	4.79	330907.0
2016-02-12	AAWW-DELISTED	Stock	35.82	37.09	35.78	36.31	403820.0
2016-02-12	AAXJ	Stock	47.36	47.8	47.16	47.79	747651.0
2016-02-12	AAXN-DELISTED	Stock	15.55	15.68	15.0	15.42	754447.0
2016-02-12	AB	Stock	17.06	17.47	16.11	17.31	695200.0
2016-02-12	ABAC-DELISTED	Stock	0.6	0.649	0.6	0.6272	9310.0
2016-02-12	ABAX-DELISTED	Stock	39.47	39.83	38.45	38.76	264687.0
2016-02-12	ABB-DELISTED	Stock	16.8	17.06	16.71	17.04	2229400.0
2016-02-12	ABBNY-DELISTED	Stock	16.8	17.06	16.71	17.03	2286694.0
2016-02-12	ABBV	Stock	52.53	52.97	51.6	52.58	9976200.0
2016-02-12	ABC-DELISTED	Stock	84.6	85.61	84.49	85.6	1662679.0
2016-02-12	ABCB	Stock	25.5	25.91	25.2	25.71	314200.0
2016-02-12	ABCD-DELISTED	Stock	3.68	3.94	3.68	3.92	16765.0
2016-02-12	ABCO-DELISTED	Stock	39.53	40.87	39.09	40.23	236433.0
2016-02-12	ABCW-DELISTED	Stock	41.05	41.05	40.39	40.55	197310.0
2016-02-12	ABDC-DELISTED	Stock	9.04	9.285	9.04	9.23	26457.0
2016-02-12	ABEO	Stock	58.0	60.25	56.25	60.0	1444.0
2016-02-12	ABEOW-DELISTED	Stock	1.09	1.09	0.921	0.921	380.0
2016-02-12	ABEV	Stock	4.45	4.51	4.44	4.49	8256500.0
2016-02-12	ABG	Stock	49.6	50.22	48.8	49.05	552700.0
2016-02-12	ABGB-DELISTED	Stock	0.74	0.74	0.6801	0.7	25073.0
2016-02-12	ABIL-DELISTED	Stock	5.92	6.03	5.8	6.02	4661.0

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

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