PREVIEW / stock_daily / 2016-02-16

all stock daily files

  file:    by_date/stock_daily/2016/2016-02-16.parquet
  size:    217 KB
  rows:    6,593
  symbols: 3,349

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-16	AAPL	Stock	23.755	24.2125	23.6525	24.16	196231600.0
2016-02-16	MSFT	Stock	50.9	51.09	50.13	51.09	37291200.0
2016-02-16	NVDA	Stock	0.6525	0.6758	0.6505	0.6748	485352000.0
2016-02-16	AMZN	Stock	25.974	26.2225	25.583	26.055	102370000.0
2016-02-16	GOOGL	Stock	35.9325	36.1439	35.509	35.882	43444260.0
2016-02-16	META	Stock	103.8	103.93	100.24	101.61	45687200.0
2016-02-16	TSLA	Stock	10.58	10.8633	10.274	10.3447	83907000.0
2016-02-16	TLT	Stock	130.72	130.75	129.805	130.11	11766006.0
2016-02-16	ES	Stock	53.85	53.98	53.12	53.86	1781800.0
2016-02-16	CL	Stock	66.52	66.7	65.52	65.81	3481200.0
2016-02-16	A	Stock	36.72	37.17	36.4	37.08	2903600.0
2016-02-16	AA.B-DELISTED	Stock	27.01	28.78	26.95	28.78	70080.0
2016-02-16	AAAP-DELISTED	Stock	25.98	27.98	25.12	26.59	21688.0
2016-02-16	AABA-DELISTED	Stock	27.98	29.44	27.94	29.27	19251362.0
2016-02-16	AAC-DELISTED	Stock	20.25	22.185	20.035	20.98	191787.0
2016-02-16	AACG	Stock	5.33	5.33	5.02	5.15	6900.0
2016-02-16	AAIC-DELISTED	Stock	11.05	11.445	11.0	11.41	320912.0
2016-02-16	AAL	Stock	38.13	38.77	37.53	38.61	7147500.0
2016-02-16	AAMC-DELISTED	Stock	4.5735	5.1176	4.4824	4.9853	135993.0
2016-02-16	AAME	Stock	4.3	4.4	4.0	4.19	14100.0
2016-02-16	AAMI	Stock	11.33	11.54	11.19	11.39	158600.0
2016-02-16	AAOI	Stock	15.52	16.089	15.31	15.98	220400.0
2016-02-16	AAON	Stock	13.9133	14.0667	13.7467	13.96	147300.0
2016-02-16	AAP	Stock	142.04	148.97	141.18	146.0	1315400.0
2016-02-16	AAT	Stock	35.24	35.29	34.79	35.25	261400.0
2016-02-16	AAU-DELISTED	Stock	0.67	0.72	0.66	0.6869	113581.0
2016-02-16	AAUAF-DELISTED	Stock	0.67	0.72	0.66	0.6869	114896.0
2016-02-16	AAV-DELISTED	Stock	5.54	5.58	5.29	5.46	99442.0
2016-02-16	AAVL-DELISTED	Stock	4.84	4.995	4.67	4.955	441750.0
2016-02-16	AAWW-DELISTED	Stock	36.52	37.5	36.1	37.1	400953.0
2016-02-16	AAXJ	Stock	48.58	48.95	48.51	48.91	1871723.0
2016-02-16	AAXN-DELISTED	Stock	15.63	16.35	15.41	16.32	979675.0
2016-02-16	AB	Stock	17.63	18.67	17.48	18.5	572000.0
2016-02-16	ABAC-DELISTED	Stock	0.649	0.659	0.649	0.659	400.0
2016-02-16	ABAX-DELISTED	Stock	39.3	39.96	38.8	38.9	199003.0
2016-02-16	ABB-DELISTED	Stock	17.41	17.51	17.227	17.47	2321287.0
2016-02-16	ABBNY-DELISTED	Stock	17.41	17.51	17.227	17.48	2383813.0
2016-02-16	ABBV	Stock	53.44	53.87	52.73	53.51	8313000.0
2016-02-16	ABC-DELISTED	Stock	86.11	86.23	85.0	85.595	1972462.0
2016-02-16	ABCB	Stock	26.04	26.6	25.79	26.36	425000.0
2016-02-16	ABCD-DELISTED	Stock	3.93	4.05	3.87	3.91	24278.0
2016-02-16	ABCO-DELISTED	Stock	40.65	40.95	39.93	40.16	125883.0
2016-02-16	ABCW-DELISTED	Stock	40.82	41.846	40.8	41.57	101891.0
2016-02-16	ABDC-DELISTED	Stock	9.44	9.68	9.08	9.1	38726.0
2016-02-16	ABE-DELISTED	Stock	10.229	11.0	10.22	10.62	25730.0
2016-02-16	ABEO	Stock	61.75	63.75	59.25	62.25	2252.0
2016-02-16	ABEOW-DELISTED	Stock	0.921	0.921	0.921	0.921	325.0
2016-02-16	ABEV	Stock	4.46	4.48	4.38	4.42	14423400.0
2016-02-16	ABG	Stock	49.62	51.0	49.09	50.81	376500.0
2016-02-16	ABGB-DELISTED	Stock	0.7557	0.91	0.7557	0.85	42692.0

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

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