PREVIEW / stock_daily / 2017-02-13

all stock daily files

  file:    by_date/stock_daily/2017/2017-02-13.parquet
  size:    216 KB
  rows:    6,493
  symbols: 3,084

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-13	AAPL	Stock	33.27	33.455	33.1875	33.3225	92141600.0
2017-02-13	MSFT	Stock	64.24	64.86	64.13	64.72	22920100.0
2017-02-13	NVDA	Stock	2.8348	2.8495	2.705	2.7095	1180724000.0
2017-02-13	AMZN	Stock	41.581	42.15	41.4275	41.8265	83452000.0
2017-02-13	GOOGL	Stock	41.885	42.0868	41.8123	41.948	25914160.0
2017-02-13	META	Stock	134.7	134.7	133.7	134.05	13526200.0
2017-02-13	TSLA	Stock	18.0493	18.7193	18.034	18.7067	105444000.0
2017-02-13	TLT	Stock	120.25	120.41	119.88	120.38	11536780.0
2017-02-13	ES	Stock	56.34	56.56	56.03	56.49	1003900.0
2017-02-13	CL	Stock	67.86	67.86	67.29	67.71	4798200.0
2017-02-13	A	Stock	50.63	50.89	50.42	50.52	1568300.0
2017-02-13	AA	Stock	38.79	39.78	38.45	38.48	5365800.0
2017-02-13	AAAP-DELISTED	Stock	37.1	37.34	36.28	36.765	184408.0
2017-02-13	AABA-DELISTED	Stock	45.08	45.57	44.94	45.45	7081932.0
2017-02-13	AAC-DELISTED	Stock	7.9	8.06	7.75	7.78	104894.0
2017-02-13	AACG	Stock	3.65	3.88	3.6	3.69	62900.0
2017-02-13	AAIC-DELISTED	Stock	15.0	15.24	14.85	14.9	345170.0
2017-02-13	AAL	Stock	46.56	47.78	46.5	47.41	6158600.0
2017-02-13	AAMC-DELISTED	Stock	22.3235	23.0882	22.0588	22.2059	26503.0
2017-02-13	AAME	Stock	3.71	3.71	3.71	3.71	200.0
2017-02-13	AAMI	Stock	14.97	15.11	14.88	14.98	399300.0
2017-02-13	AAOI	Stock	33.53	35.57	33.12	33.92	1043100.0
2017-02-13	AAON	Stock	23.0	23.3333	23.0	23.3333	219000.0
2017-02-13	AAP	Stock	165.0	165.0	162.15	162.39	986200.0
2017-02-13	AAT	Stock	44.09	44.09	43.36	43.62	126700.0
2017-02-13	AAU-DELISTED	Stock	1.24	1.26	1.2	1.25	269113.0
2017-02-13	AAUAF-DELISTED	Stock	1.24	1.26	1.2	1.26	271202.0
2017-02-13	AAV-DELISTED	Stock	6.5	6.5	6.35	6.45	55037.0
2017-02-13	AAWW-DELISTED	Stock	52.2	53.0	51.8	52.95	131933.0
2017-02-13	AAXJ	Stock	60.27	60.5399	60.25	60.42	691112.0
2017-02-13	AAXN-DELISTED	Stock	27.4	27.56	27.15	27.17	431251.0
2017-02-13	AB	Stock	23.45	23.85	23.45	23.75	392400.0
2017-02-13	ABAC-DELISTED	Stock	3.52	3.68	3.5	3.52	1462.0
2017-02-13	ABAX-DELISTED	Stock	50.2	50.49	49.3	49.32	90566.0
2017-02-13	ABB-DELISTED	Stock	22.94	22.985	22.86	22.94	2157177.0
2017-02-13	ABBNY-DELISTED	Stock	22.94	22.985	22.86	22.94	2427720.0
2017-02-13	ABBV	Stock	60.58	60.86	60.43	60.51	6396000.0
2017-02-13	ABC-DELISTED	Stock	91.42	94.5	89.42	90.48	2751050.0
2017-02-13	ABCB	Stock	46.9	47.9	46.8	47.25	230500.0
2017-02-13	ABCD-DELISTED	Stock	4.94	4.97	4.9201	4.96	26195.0
2017-02-13	ABCO-DELISTED	Stock	47.5	47.5	46.9	46.95	501301.0
2017-02-13	ABDC-DELISTED	Stock	12.29	12.56	12.29	12.51	71804.0
2017-02-13	ABE-DELISTED	Stock	12.12	12.16	12.09	12.1219	17265.0
2017-02-13	ABEO	Stock	130.0	132.5	128.75	130.0	8096.0
2017-02-13	ABEV	Stock	5.48	5.54	5.47	5.47	7303600.0
2017-02-13	ABG	Stock	66.2	66.95	65.35	66.35	466300.0
2017-02-13	ABIL-DELISTED	Stock	3.52	3.52	3.26	3.32	9573.0
2017-02-13	ABM	Stock	40.79	41.14	40.56	40.82	306000.0
2017-02-13	ABMD-DELISTED	Stock	108.04	108.83	107.33	107.35	188885.0
2017-02-13	ABR	Stock	7.33	7.38	7.3	7.33	78600.0

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

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