PREVIEW / stock_daily / 2016-04-19

all stock daily files

  file:    by_date/stock_daily/2016/2016-04-19.parquet
  size:    219 KB
  rows:    6,580
  symbols: 3,314

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-19	AAPL	Stock	26.97	27.0	26.5575	26.7275	129539600.0
2016-04-19	MSFT	Stock	56.63	56.77	55.68	56.39	29596800.0
2016-04-19	NVDA	Stock	0.9278	0.9295	0.902	0.9078	309152000.0
2016-04-19	AMZN	Stock	31.857	31.9005	31.04	31.395	81118000.0
2016-04-19	GOOGL	Stock	39.525	39.5475	38.5135	38.8125	43952300.0
2016-04-19	META	Stock	111.1	112.45	109.16	112.29	30210500.0
2016-04-19	TSLA	Stock	16.8747	16.958	16.0833	16.4913	95362500.0
2016-04-19	TLT	Stock	131.08	131.305	130.29	130.9	5212335.0
2016-04-19	ES	Stock	57.23	57.33	56.7	57.04	1477600.0
2016-04-19	CL	Stock	71.47	71.79	71.05	71.66	3609900.0
2016-04-19	A	Stock	41.18	41.74	41.13	41.4	1640600.0
2016-04-19	AA.B-DELISTED	Stock	35.85	36.4	35.4	36.4	50295.0
2016-04-19	AAAP-DELISTED	Stock	34.55	35.0	34.1435	35.0	9409.0
2016-04-19	AABA-DELISTED	Stock	36.49	36.73	36.11	36.34	19198009.0
2016-04-19	AAC-DELISTED	Stock	19.35	19.69	18.99	19.56	94529.0
2016-04-19	AACG	Stock	5.26	5.5	5.26	5.35	4100.0
2016-04-19	AAIC-DELISTED	Stock	12.69	12.892	12.69	12.83	150854.0
2016-04-19	AAL	Stock	40.99	41.76	40.97	41.34	6650200.0
2016-04-19	AAMC-DELISTED	Stock	6.4706	6.6618	5.9441	6.0	178242.0
2016-04-19	AAME	Stock	4.43	4.56	4.35	4.41	3500.0
2016-04-19	AAMI	Stock	13.85	13.85	13.59	13.77	134600.0
2016-04-19	AAOI	Stock	12.74	12.86	11.61	11.72	5064100.0
2016-04-19	AAON	Stock	18.2733	18.3533	17.9267	17.9267	242400.0
2016-04-19	AAP	Stock	161.87	162.72	160.3	160.79	529400.0
2016-04-19	AAT	Stock	38.89	38.9	38.49	38.55	107700.0
2016-04-19	AAU-DELISTED	Stock	1.2	1.35	1.16	1.33	1285520.0
2016-04-19	AAUAF-DELISTED	Stock	1.2	1.35	1.16	1.35	1293732.0
2016-04-19	AAV-DELISTED	Stock	5.36	5.47	5.35	5.43	82794.0
2016-04-19	AAVL-DELISTED	Stock	5.65	5.74	5.27	5.54	274995.0
2016-04-19	AAWW-DELISTED	Stock	40.95	41.85	40.39	41.62	134673.0
2016-04-19	AAXJ	Stock	55.78	56.135	55.69	56.07	566918.0
2016-04-19	AAXN-DELISTED	Stock	18.51	18.93	18.29	18.63	794359.0
2016-04-19	AB	Stock	23.48	24.13	23.41	24.05	249500.0
2016-04-19	ABAC-DELISTED	Stock	0.62	0.66	0.62	0.63	3760.0
2016-04-19	ABAX-DELISTED	Stock	45.97	46.12	44.93	45.43	231894.0
2016-04-19	ABB-DELISTED	Stock	20.28	20.3735	20.205	20.24	1784295.0
2016-04-19	ABBNY-DELISTED	Stock	20.28	20.3735	20.205	20.26	1827894.0
2016-04-19	ABBV	Stock	60.09	61.23	59.67	60.17	6149300.0
2016-04-19	ABC-DELISTED	Stock	89.41	90.24	89.22	89.49	1841154.0
2016-04-19	ABCB	Stock	31.0	31.19	30.81	31.08	208200.0
2016-04-19	ABCD-DELISTED	Stock	4.44	4.54	4.42	4.47	14062.0
2016-04-19	ABCO-DELISTED	Stock	32.56	32.58	31.67	31.7	418306.0
2016-04-19	ABCW-DELISTED	Stock	46.45	46.91	46.45	46.76	38961.0
2016-04-19	ABDC-DELISTED	Stock	11.7	11.79	11.605	11.63	20659.0
2016-04-19	ABE-DELISTED	Stock	12.2	12.24	12.195	12.2399	3829.0
2016-04-19	ABEO	Stock	71.25	71.25	66.75	68.25	1780.0
2016-04-19	ABEOW-DELISTED	Stock	0.75	0.75	0.75	0.75	1300.0
2016-04-19	ABEV	Stock	5.26	5.39	5.25	5.38	11581100.0
2016-04-19	ABG	Stock	59.98	60.69	59.38	60.0	269900.0
2016-04-19	ABGB-DELISTED	Stock	1.41	1.45	1.38	1.39	18114.0

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

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