PREVIEW / stock_daily / 2017-02-21

all stock daily files

  file:    by_date/stock_daily/2017/2017-02-21.parquet
  size:    216 KB
  rows:    6,516
  symbols: 3,100

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
2017-02-21	AAPL	Stock	34.0575	34.1875	33.995	34.175	98028800.0
2017-02-21	MSFT	Stock	64.61	64.95	64.45	64.49	20655900.0
2017-02-21	NVDA	Stock	2.7058	2.7808	2.7055	2.7768	551952000.0
2017-02-21	AMZN	Stock	42.442	42.899	42.3625	42.822	70154000.0
2017-02-21	GOOGL	Stock	42.3995	42.61	42.3275	42.4635	25221240.0
2017-02-21	META	Stock	133.5	133.91	132.9	133.72	14759100.0
2017-02-21	TSLA	Stock	18.3633	18.76	18.2673	18.4927	85150500.0
2017-02-21	TLT	Stock	119.68	120.61	119.6	120.11	8703755.0
2017-02-21	ES	Stock	56.02	56.92	55.85	56.84	1333300.0
2017-02-21	CL	Stock	72.76	73.9	72.64	73.18	10553800.0
2017-02-21	A	Stock	51.66	51.8	51.17	51.35	2037000.0
2017-02-21	AA	Stock	36.31	37.01	36.23	36.71	3393400.0
2017-02-21	AAAP-DELISTED	Stock	35.83	37.14	35.83	36.79	273714.0
2017-02-21	AABA-DELISTED	Stock	45.22	45.61	45.1	45.5	7416830.0
2017-02-21	AAC-DELISTED	Stock	8.12	8.25	8.06	8.14	74397.0
2017-02-21	AACG	Stock	3.65	3.95	3.65	3.94	8700.0
2017-02-21	AAIC-DELISTED	Stock	14.94	15.049	14.91	15.01	268215.0
2017-02-21	AAL	Stock	47.01	47.27	46.58	46.81	4672000.0
2017-02-21	AAMC-DELISTED	Stock	22.6029	22.6029	22.0147	22.0588	3754.0
2017-02-21	AAME	Stock	3.75	3.95	3.6	3.63	8300.0
2017-02-21	AAMI	Stock	15.12	15.17	14.96	15.02	193600.0
2017-02-21	AAOI	Stock	38.03	38.89	37.18	37.57	974200.0
2017-02-21	AAON	Stock	22.9	23.3	22.8533	23.1	208200.0
2017-02-21	AAP	Stock	164.5	169.55	160.69	161.15	3286400.0
2017-02-21	AAT	Stock	43.63	44.78	43.14	44.57	340500.0
2017-02-21	AAU-DELISTED	Stock	1.2	1.2018	1.16	1.17	246092.0
2017-02-21	AAUAF-DELISTED	Stock	1.2	1.2018	1.16	1.17	246731.0
2017-02-21	AAV-DELISTED	Stock	6.45	6.45	6.319	6.45	111453.0
2017-02-21	AAWW-DELISTED	Stock	53.5	53.65	52.7	53.35	128976.0
2017-02-21	AAXJ	Stock	60.92	61.125	60.81	61.06	323189.0
2017-02-21	AAXN-DELISTED	Stock	26.42	26.7	26.36	26.55	360876.0
2017-02-21	AB	Stock	24.5	25.13	24.35	24.7	990900.0
2017-02-21	ABAC-DELISTED	Stock	2.8	2.84	2.61	2.74	50664.0
2017-02-21	ABAX-DELISTED	Stock	49.89	50.52	49.89	50.11	64878.0
2017-02-21	ABB-DELISTED	Stock	22.8	23.005	22.79	22.975	1805845.0
2017-02-21	ABBNY-DELISTED	Stock	22.8	23.005	22.79	22.97	1849175.0
2017-02-21	ABBV	Stock	61.84	62.11	61.5	61.83	8503500.0
2017-02-21	ABC-DELISTED	Stock	90.74	91.15	89.56	91.01	1548900.0
2017-02-21	ABCB	Stock	49.0	49.13	48.25	48.95	108600.0
2017-02-21	ABCD-DELISTED	Stock	4.84	4.99	4.82	4.83	52789.0
2017-02-21	ABCO-DELISTED	Stock	46.3	47.0	46.3	46.65	413962.0
2017-02-21	ABDC-DELISTED	Stock	12.68	12.88	12.5695	12.85	46727.0
2017-02-21	ABE-DELISTED	Stock	11.94	12.1799	11.94	12.14	23843.0
2017-02-21	ABEO	Stock	150.0	152.5	130.0	131.25	20684.0
2017-02-21	ABEV	Stock	5.76	5.81	5.72	5.8	13108600.0
2017-02-21	ABG	Stock	67.95	69.45	67.5	69.45	221300.0
2017-02-21	ABIL-DELISTED	Stock	2.89	2.92	2.85	2.9	4647.0
2017-02-21	ABM	Stock	40.43	40.83	40.31	40.8	170000.0
2017-02-21	ABMD-DELISTED	Stock	117.15	118.16	116.29	117.85	368342.0
2017-02-21	ABR	Stock	7.33	7.44	7.33	7.38	84000.0

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

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