PREVIEW / stock_daily / 2016-02-18

all stock daily files

  file:    by_date/stock_daily/2016/2016-02-18.parquet
  size:    216 KB
  rows:    6,556
  symbols: 3,323

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-02-18	AAPL	Stock	24.71	24.7225	24.0225	24.065	156084000.0
2016-02-18	MSFT	Stock	52.33	52.95	52.1	52.19	27176000.0
2016-02-18	NVDA	Stock	0.7483	0.7745	0.7475	0.751	1068660000.0
2016-02-18	AMZN	Stock	27.0595	27.06	26.1865	26.25	94700000.0
2016-02-18	GOOGL	Stock	36.698	36.8	35.7775	35.8755	47276920.0
2016-02-18	META	Stock	105.8	106.0	103.03	103.47	29593500.0
2016-02-18	TSLA	Stock	11.4947	11.53	10.9847	11.118	58314000.0
2016-02-18	TLT	Stock	129.41	131.0	129.36	130.9	10196700.0
2016-02-18	ES	Stock	53.65	54.74	53.53	54.46	1803900.0
2016-02-18	CL	Stock	66.9	67.34	66.63	67.22	2470100.0
2016-02-18	A	Stock	37.73	37.96	37.09	37.19	2231500.0
2016-02-18	AA.B-DELISTED	Stock	30.4	30.4	28.5024	28.6	18530.0
2016-02-18	AAAP-DELISTED	Stock	27.1	30.75	26.9	30.35	116743.0
2016-02-18	AABA-DELISTED	Stock	29.56	30.14	29.39	29.42	15477871.0
2016-02-18	AAC-DELISTED	Stock	22.53	22.7269	21.04	21.34	214015.0
2016-02-18	AACG	Stock	4.93	5.1	4.93	5.03	13900.0
2016-02-18	AAIC-DELISTED	Stock	11.94	11.965	11.69	11.82	150580.0
2016-02-18	AAL	Stock	39.36	39.68	38.96	39.54	9605800.0
2016-02-18	AAMC-DELISTED	Stock	5.2618	5.6882	5.0235	5.1765	179591.0
2016-02-18	AAME	Stock	4.31	4.38	3.81	3.99	12400.0
2016-02-18	AAMI	Stock	11.62	11.67	11.42	11.43	86800.0
2016-02-18	AAOI	Stock	16.6	16.67	15.73	16.47	184200.0
2016-02-18	AAON	Stock	13.9467	14.0	13.3333	13.9	197550.0
2016-02-18	AAP	Stock	142.35	144.84	140.56	143.32	1068000.0
2016-02-18	AAT	Stock	35.99	36.5	35.49	36.3	224100.0
2016-02-18	AAU-DELISTED	Stock	0.72	0.7375	0.7101	0.7353	149969.0
2016-02-18	AAUAF-DELISTED	Stock	0.72	0.7375	0.7101	0.7353	151446.0
2016-02-18	AAV-DELISTED	Stock	5.52	5.53	5.13	5.21	202471.0
2016-02-18	AAVL-DELISTED	Stock	5.2	5.33	4.97	5.255	339496.0
2016-02-18	AAWW-DELISTED	Stock	39.6	39.93	36.78	37.04	446183.0
2016-02-18	AAXJ	Stock	49.61	49.679	49.16	49.21	857223.0
2016-02-18	AAXN-DELISTED	Stock	17.2	17.39	16.64	17.11	739953.0
2016-02-18	AB	Stock	18.74	19.06	18.63	19.03	460700.0
2016-02-18	ABAC-DELISTED	Stock	0.6201	0.6201	0.6201	0.6201	127.0
2016-02-18	ABAX-DELISTED	Stock	40.0	40.02	38.9	39.14	150217.0
2016-02-18	ABB-DELISTED	Stock	17.96	17.97	17.83	17.87	2053248.0
2016-02-18	ABBNY-DELISTED	Stock	17.97	17.97	17.83	17.87	2095972.0
2016-02-18	ABBV	Stock	55.53	55.53	54.17	54.55	6555000.0
2016-02-18	ABC-DELISTED	Stock	87.03	87.49	86.59	86.71	1968467.0
2016-02-18	ABCB	Stock	26.08	26.18	25.67	25.81	263500.0
2016-02-18	ABCD-DELISTED	Stock	4.02	4.14	3.9	3.98	44713.0
2016-02-18	ABCO-DELISTED	Stock	39.39	39.525	37.42	37.68	357922.0
2016-02-18	ABCW-DELISTED	Stock	41.64	41.78	41.25	41.565	44339.0
2016-02-18	ABDC-DELISTED	Stock	9.4	9.434	9.12	9.39	22758.0
2016-02-18	ABE-DELISTED	Stock	10.3901	10.45	10.3901	10.45	3480.0
2016-02-18	ABEO	Stock	65.75	69.25	65.75	66.25	1304.0
2016-02-18	ABEV	Stock	4.53	4.55	4.47	4.51	9618700.0
2016-02-18	ABG	Stock	52.52	52.95	51.49	51.87	337600.0
2016-02-18	ABGB-DELISTED	Stock	0.85	0.85	0.8	0.8304	3070.0
2016-02-18	ABIL-DELISTED	Stock	7.08	7.34	6.91	7.21	98160.0

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

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