PREVIEW / stock_daily / 2016-04-20

all stock daily files

  file:    by_date/stock_daily/2016/2016-04-20.parquet
  size:    220 KB
  rows:    6,567
  symbols: 3,304

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-20	AAPL	Stock	26.66	27.0225	26.515	26.7825	122444000.0
2016-04-20	MSFT	Stock	56.29	56.5	55.49	55.59	36195700.0
2016-04-20	NVDA	Stock	0.9062	0.9168	0.9053	0.9113	200172000.0
2016-04-20	AMZN	Stock	31.5	31.8275	31.15	31.6495	52188000.0
2016-04-20	GOOGL	Stock	38.958	38.983	38.5635	38.746	34261760.0
2016-04-20	META	Stock	112.43	113.27	111.56	112.42	21027900.0
2016-04-20	TSLA	Stock	16.4173	16.9107	16.1	16.6647	77911500.0
2016-04-20	TLT	Stock	131.16	131.65	129.27	129.46	10920713.0
2016-04-20	ES	Stock	57.14	57.33	55.56	55.64	1668200.0
2016-04-20	CL	Stock	71.34	71.53	70.3	70.31	3467800.0
2016-04-20	A	Stock	41.42	41.68	41.3	41.52	1243900.0
2016-04-20	AA.B-DELISTED	Stock	36.11	36.8399	35.57	36.4805	27599.0
2016-04-20	AAAP-DELISTED	Stock	34.93	35.0	34.3	34.99	14255.0
2016-04-20	AABA-DELISTED	Stock	36.94	38.185	36.94	37.84	28469705.0
2016-04-20	AAC-DELISTED	Stock	19.52	20.9	19.45	20.55	188352.0
2016-04-20	AACG	Stock	5.5	5.77	5.5	5.75	23200.0
2016-04-20	AAIC-DELISTED	Stock	12.86	13.05	12.82	13.0	230374.0
2016-04-20	AAL	Stock	41.36	41.71	41.11	41.26	5018200.0
2016-04-20	AAMC-DELISTED	Stock	6.0294	6.0294	5.3147	5.3765	54757.0
2016-04-20	AAME	Stock	4.25	4.48	4.22	4.48	1100.0
2016-04-20	AAMI	Stock	13.76	14.04	13.76	13.8	152200.0
2016-04-20	AAOI	Stock	11.7	11.82	11.25	11.38	1118100.0
2016-04-20	AAON	Stock	17.98	18.2	17.8333	18.0933	182850.0
2016-04-20	AAP	Stock	161.02	161.34	158.39	158.39	682300.0
2016-04-20	AAT	Stock	38.54	38.58	38.01	38.01	60100.0
2016-04-20	AAU-DELISTED	Stock	1.4	1.42	1.2113	1.22	983046.0
2016-04-20	AAUAF-DELISTED	Stock	1.4	1.42	1.2113	1.22	986676.0
2016-04-20	AAV-DELISTED	Stock	5.38	5.64	5.37	5.5	73935.0
2016-04-20	AAVL-DELISTED	Stock	5.56	5.71	5.52	5.66	179658.0
2016-04-20	AAWW-DELISTED	Stock	41.48	41.71	40.75	40.77	100124.0
2016-04-20	AAXJ	Stock	55.42	55.82	55.27	55.55	396262.0
2016-04-20	AAXN-DELISTED	Stock	18.68	18.9	18.43	18.54	644691.0
2016-04-20	AB	Stock	24.05	24.62	23.94	24.42	192500.0
2016-04-20	ABAC-DELISTED	Stock	0.63	0.6495	0.59	0.6284	6193.0
2016-04-20	ABAX-DELISTED	Stock	45.64	45.85	44.9	45.43	244808.0
2016-04-20	ABB-DELISTED	Stock	20.85	21.03	20.81	20.87	2937017.0
2016-04-20	ABBNY-DELISTED	Stock	20.85	21.03	20.81	20.88	3170325.0
2016-04-20	ABBV	Stock	60.17	61.11	59.96	60.48	4443600.0
2016-04-20	ABC-DELISTED	Stock	89.92	91.97	89.64	91.87	2866727.0
2016-04-20	ABCB	Stock	31.06	31.15	30.4	31.01	240100.0
2016-04-20	ABCD-DELISTED	Stock	4.331	4.52	4.331	4.42	14020.0
2016-04-20	ABCO-DELISTED	Stock	31.63	32.24	31.44	31.7	346573.0
2016-04-20	ABCW-DELISTED	Stock	46.71	47.015	46.45	46.89	80133.0
2016-04-20	ABDC-DELISTED	Stock	11.69	11.8	11.65	11.65	17423.0
2016-04-20	ABE-DELISTED	Stock	12.48	12.48	12.17	12.18	9326.0
2016-04-20	ABEO	Stock	71.5	71.5	66.25	67.25	2156.0
2016-04-20	ABEV	Stock	5.34	5.41	5.31	5.39	17188600.0
2016-04-20	ABG	Stock	60.28	60.63	59.82	60.39	229300.0
2016-04-20	ABGB-DELISTED	Stock	1.37	1.43	1.37	1.4	37472.0
2016-04-20	ABIL-DELISTED	Stock	6.9499	7.5	6.84	7.1601	35906.0

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

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