PREVIEW / stock_daily / 2016-07-28

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-28.parquet
  size:    219 KB
  rows:    6,541
  symbols: 3,243

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-07-28	AAPL	Stock	25.7075	26.1125	25.705	26.085	159479200.0
2016-07-28	MSFT	Stock	56.0	56.37	55.72	56.21	37550400.0
2016-07-28	NVDA	Stock	1.4048	1.415	1.4002	1.4045	221916000.0
2016-07-28	AMZN	Stock	37.299	37.668	36.985	37.6305	152352000.0
2016-07-28	GOOGL	Stock	38.442	38.4485	37.9545	38.292	73464420.0
2016-07-28	META	Stock	127.52	128.33	123.63	125.0	78955800.0
2016-07-28	TSLA	Stock	15.1967	15.384	15.1067	15.374	36286500.0
2016-07-28	TLT	Stock	139.8	140.835	139.71	140.39	7336072.0
2016-07-28	ES	Stock	57.58	58.26	57.58	57.97	1337800.0
2016-07-28	CL	Stock	74.75	74.75	73.06	73.25	4066300.0
2016-07-28	A	Stock	47.19	47.75	47.02	47.51	1944800.0
2016-07-28	AA.B-DELISTED	Stock	36.8076	36.8076	36.065	36.5	30594.0
2016-07-28	AAAP-DELISTED	Stock	30.84	31.02	30.84	31.0	122172.0
2016-07-28	AABA-DELISTED	Stock	38.58	38.64	38.23	38.51	7001308.0
2016-07-28	AAC-DELISTED	Stock	23.38	23.53	22.61	22.64	108006.0
2016-07-28	AACG	Stock	3.81	3.81	3.8	3.8	13900.0
2016-07-28	AAIC-DELISTED	Stock	13.61	13.75	13.56	13.75	234101.0
2016-07-28	AAL	Stock	36.07	36.53	35.75	36.34	6518800.0
2016-07-28	AAMC-DELISTED	Stock	3.9176	3.9911	3.8235	3.8471	43119.0
2016-07-28	AAME	Stock	4.3	4.3	4.2	4.2	700.0
2016-07-28	AAMI	Stock	14.0	14.06	13.8	13.97	98000.0
2016-07-28	AAOI	Stock	12.6	12.78	12.22	12.23	185100.0
2016-07-28	AAON	Stock	17.6467	17.86	17.6267	17.7333	148500.0
2016-07-28	AAP	Stock	164.67	172.87	164.41	170.34	1756200.0
2016-07-28	AAT	Stock	44.59	45.36	44.59	45.11	125100.0
2016-07-28	AAU-DELISTED	Stock	1.48	1.5061	1.43	1.46	348422.0
2016-07-28	AAUAF-DELISTED	Stock	1.48	1.5061	1.43	1.46	351713.0
2016-07-28	AAV-DELISTED	Stock	6.29	6.33	6.2117	6.25	64421.0
2016-07-28	AAWW-DELISTED	Stock	42.3	42.74	41.64	42.53	92867.0
2016-07-28	AAXJ	Stock	57.59	57.62	57.35	57.56	504672.0
2016-07-28	AAXN-DELISTED	Stock	28.8	28.85	28.42	28.48	754226.0
2016-07-28	AB	Stock	24.56	24.56	23.75	23.93	349000.0
2016-07-28	ABAC-DELISTED	Stock	0.7259	0.7259	0.691	0.72	14800.0
2016-07-28	ABAX-DELISTED	Stock	48.8	50.29	48.8	49.75	129026.0
2016-07-28	ABB-DELISTED	Stock	21.05	21.12	20.975	21.07	1811288.0
2016-07-28	ABBNY-DELISTED	Stock	21.04	21.12	20.975	21.07	1853487.0
2016-07-28	ABBV	Stock	64.79	65.06	63.93	64.72	6556100.0
2016-07-28	ABC-DELISTED	Stock	85.05	85.06	84.24	84.82	2154655.0
2016-07-28	ABCB	Stock	33.61	33.65	33.21	33.4	156000.0
2016-07-28	ABCD-DELISTED	Stock	4.83	4.98	4.83	4.92	9088.0
2016-07-28	ABCO-DELISTED	Stock	45.19	48.86	41.03	41.46	1700731.0
2016-07-28	ABDC-DELISTED	Stock	12.24	12.29	12.15	12.16	34575.0
2016-07-28	ABE-DELISTED	Stock	12.61	12.7	12.61	12.7	1086.0
2016-07-28	ABEO	Stock	62.75	65.25	62.5	64.0	744.0
2016-07-28	ABEV	Stock	5.86	5.9	5.84	5.87	4703700.0
2016-07-28	ABG	Stock	59.99	60.37	58.44	59.12	402700.0
2016-07-28	ABIL-DELISTED	Stock	4.5	4.62	4.4865	4.56	27105.0
2016-07-28	ABM	Stock	37.45	37.54	37.08	37.24	148200.0
2016-07-28	ABMD-DELISTED	Stock	116.0	116.0	112.05	115.0	731126.0
2016-07-28	ABR	Stock	7.15	7.2	7.1	7.18	29500.0

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

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