PREVIEW / stock_daily / 2016-04-27

all stock daily files

  file:    by_date/stock_daily/2016/2016-04-27.parquet
  size:    220 KB
  rows:    6,565
  symbols: 3,311

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-27	AAPL	Stock	24.0	24.6775	23.92	24.455	458408400.0
2016-04-27	MSFT	Stock	51.48	51.5	50.55	50.94	43369300.0
2016-04-27	NVDA	Stock	0.9098	0.9332	0.908	0.9328	352396000.0
2016-04-27	AMZN	Stock	30.59	30.7975	30.064	30.3285	81376000.0
2016-04-27	GOOGL	Stock	36.266	36.3575	35.454	36.073	66262740.0
2016-04-27	META	Stock	107.94	108.94	106.31	108.89	52213100.0
2016-04-27	TSLA	Stock	16.85	17.0	16.6267	16.7647	48087000.0
2016-04-27	TLT	Stock	127.92	128.82	127.62	128.52	8380065.0
2016-04-27	ES	Stock	55.46	56.27	55.14	56.05	1662900.0
2016-04-27	CL	Stock	69.11	69.74	68.87	69.31	4470900.0
2016-04-27	A	Stock	41.35	41.75	41.04	41.58	1189300.0
2016-04-27	AA.B-DELISTED	Stock	37.95	38.54	37.215	38.4	84224.0
2016-04-27	AAAP-DELISTED	Stock	34.7	34.8	33.47	33.78	15507.0
2016-04-27	AABA-DELISTED	Stock	37.52	37.59	36.63	36.95	15679495.0
2016-04-27	AAC-DELISTED	Stock	20.07	20.51	19.93	20.455	82714.0
2016-04-27	AACG	Stock	5.67	5.82	5.55	5.57	16200.0
2016-04-27	AAIC-DELISTED	Stock	13.03	13.18	13.0	13.05	169539.0
2016-04-27	AAL	Stock	36.79	37.29	36.52	36.71	12305000.0
2016-04-27	AAMC-DELISTED	Stock	4.4324	4.6735	4.4147	4.4735	39651.0
2016-04-27	AAME	Stock	4.4	4.4	4.17	4.24	1600.0
2016-04-27	AAMI	Stock	13.78	13.9	13.61	13.84	132900.0
2016-04-27	AAOI	Stock	10.9	11.5	10.82	11.44	330400.0
2016-04-27	AAON	Stock	17.9867	18.2933	17.8933	18.14	334650.0
2016-04-27	AAP	Stock	158.07	160.07	156.95	159.27	371200.0
2016-04-27	AAT	Stock	38.5	39.9	38.5	39.76	272400.0
2016-04-27	AAU-DELISTED	Stock	1.18	1.19	1.08	1.08	492429.0
2016-04-27	AAUAF-DELISTED	Stock	1.18	1.19	1.08	1.08	493709.0
2016-04-27	AAV-DELISTED	Stock	5.53	5.64	5.41	5.54	51686.0
2016-04-27	AAVL-DELISTED	Stock	6.11	6.12	5.71	5.745	406509.0
2016-04-27	AAWW-DELISTED	Stock	41.02	42.22	40.2	41.9299	139458.0
2016-04-27	AAXJ	Stock	54.75	55.37	54.71	55.23	1009283.0
2016-04-27	AAXN-DELISTED	Stock	18.36	18.71	18.22	18.6	646094.0
2016-04-27	AB	Stock	24.27	24.56	24.0	24.47	177200.0
2016-04-27	ABAC-DELISTED	Stock	0.739	0.739	0.64	0.71	11955.0
2016-04-27	ABAX-DELISTED	Stock	45.8	45.9	44.93	45.6	299685.0
2016-04-27	ABB-DELISTED	Stock	20.98	21.13	20.9	21.09	1193093.0
2016-04-27	ABBNY-DELISTED	Stock	20.98	21.13	20.9	21.08	1226884.0
2016-04-27	ABBV	Stock	60.93	61.48	60.25	60.7	6679200.0
2016-04-27	ABC-DELISTED	Stock	91.32	91.65	90.29	90.66	1539714.0
2016-04-27	ABCB	Stock	31.69	31.84	31.35	31.73	164800.0
2016-04-27	ABCD-DELISTED	Stock	4.67	4.76	4.61	4.69	21516.0
2016-04-27	ABCO-DELISTED	Stock	31.62	32.095	31.217	31.44	266395.0
2016-04-27	ABCW-DELISTED	Stock	47.15	47.55	46.81	47.4	36449.0
2016-04-27	ABDC-DELISTED	Stock	11.53	12.11	11.4605	11.78	57544.0
2016-04-27	ABE-DELISTED	Stock	12.0555	12.144	12.0555	12.144	2353.0
2016-04-27	ABEO	Stock	68.5	70.25	66.25	68.75	1164.0
2016-04-27	ABEOW-DELISTED	Stock	0.9	0.9	0.8	0.8	850.0
2016-04-27	ABEV	Stock	5.43	5.48	5.38	5.45	14812900.0
2016-04-27	ABG	Stock	62.47	63.37	61.79	62.61	413700.0
2016-04-27	ABGB-DELISTED	Stock	1.38	1.43	1.36	1.4	71092.0

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

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