PREVIEW / stock_daily / 2016-04-28

all stock daily files

  file:    by_date/stock_daily/2016/2016-04-28.parquet
  size:    219 KB
  rows:    6,561
  symbols: 3,310

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-04-28	AAPL	Stock	24.4025	24.47	23.5625	23.7075	328970800.0
2016-04-28	MSFT	Stock	50.62	50.77	49.56	49.9	43134800.0
2016-04-28	NVDA	Stock	0.927	0.9325	0.9028	0.905	381224000.0
2016-04-28	AMZN	Stock	30.777	31.34	29.96	30.1	157452000.0
2016-04-28	GOOGL	Stock	36.1645	36.463	35.16	35.253	62590040.0
2016-04-28	META	Stock	119.58	120.79	116.23	116.73	87110100.0
2016-04-28	TSLA	Stock	16.6567	16.8953	16.496	16.514	37785000.0
2016-04-28	TLT	Stock	128.21	129.14	128.04	129.05	7974606.0
2016-04-28	ES	Stock	55.42	56.33	55.3	56.06	1486300.0
2016-04-28	CL	Stock	69.4	71.59	69.39	71.16	6293900.0
2016-04-28	A	Stock	41.25	41.78	41.06	41.18	1549800.0
2016-04-28	AA.B-DELISTED	Stock	38.25	38.621	37.89	37.988	65874.0
2016-04-28	AAAP-DELISTED	Stock	34.65	35.98	34.04	34.99	33793.0
2016-04-28	AABA-DELISTED	Stock	36.84	37.44	36.51	36.59	11967688.0
2016-04-28	AAC-DELISTED	Stock	20.52	21.03	20.51	20.75	203208.0
2016-04-28	AACG	Stock	5.57	5.67	5.55	5.6	8800.0
2016-04-28	AAIC-DELISTED	Stock	12.94	13.05	12.82	12.84	133283.0
2016-04-28	AAL	Stock	37.04	37.09	35.89	35.97	9836800.0
2016-04-28	AAMC-DELISTED	Stock	4.5235	4.6059	4.3324	4.4235	11302.0
2016-04-28	AAME	Stock	4.28	4.31	4.17	4.31	3700.0
2016-04-28	AAMI	Stock	13.69	13.95	13.62	13.71	167200.0
2016-04-28	AAOI	Stock	11.31	11.78	11.22	11.34	588000.0
2016-04-28	AAON	Stock	18.0067	18.1933	17.62	17.6667	172500.0
2016-04-28	AAP	Stock	157.58	158.43	155.43	155.87	635700.0
2016-04-28	AAT	Stock	39.61	39.79	39.36	39.48	184700.0
2016-04-28	AAU-DELISTED	Stock	1.08	1.1801	1.08	1.1699	449858.0
2016-04-28	AAUAF-DELISTED	Stock	1.08	1.1801	1.08	1.16	456727.0
2016-04-28	AAV-DELISTED	Stock	5.53	5.63	5.49	5.54	65411.0
2016-04-28	AAVL-DELISTED	Stock	5.75	5.79	5.61	5.68	327620.0
2016-04-28	AAWW-DELISTED	Stock	41.38	41.7	40.6	40.67	129569.0
2016-04-28	AAXJ	Stock	54.57	55.01	54.51	54.58	1445365.0
2016-04-28	AAXN-DELISTED	Stock	18.41	18.69	18.085	18.1	754772.0
2016-04-28	AB	Stock	24.18	24.22	23.4	23.55	269700.0
2016-04-28	ABAC-DELISTED	Stock	0.6879	0.6914	0.68	0.68	3699.0
2016-04-28	ABAX-DELISTED	Stock	45.57	45.99	44.41	44.66	211651.0
2016-04-28	ABB-DELISTED	Stock	20.94	21.12	20.87	20.9	1316000.0
2016-04-28	ABBNY-DELISTED	Stock	20.94	21.12	20.87	20.92	1368117.0
2016-04-28	ABBV	Stock	58.56	62.1	57.53	61.2	16235400.0
2016-04-28	ABC-DELISTED	Stock	89.61	89.61	86.18	86.5	4987378.0
2016-04-28	ABCB	Stock	31.72	31.87	31.31	31.4	102800.0
2016-04-28	ABCD-DELISTED	Stock	4.5765	4.63	4.57	4.58	17429.0
2016-04-28	ABCO-DELISTED	Stock	31.41	32.29	31.26	31.73	303887.0
2016-04-28	ABCW-DELISTED	Stock	47.29	47.3	46.45	46.84	35942.0
2016-04-28	ABDC-DELISTED	Stock	11.65	11.85	11.5501	11.77	31562.0
2016-04-28	ABE-DELISTED	Stock	12.15	12.15	11.9864	12.12	1999.0
2016-04-28	ABEO	Stock	68.0	70.5	67.75	69.5	1480.0
2016-04-28	ABEOW-DELISTED	Stock	0.75	0.75	0.75	0.75	166.0
2016-04-28	ABEV	Stock	5.45	5.55	5.45	5.53	13196000.0
2016-04-28	ABG	Stock	62.08	62.47	60.72	60.92	328900.0
2016-04-28	ABIL-DELISTED	Stock	7.4999	7.58	7.2	7.41	31292.0

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

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