PREVIEW / etf_daily / 2016-02-12

all etf daily files

  file:    by_date/etf_daily/2016/2016-02-12.parquet
  size:    50 KB
  rows:    1,239

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-12	SPY	ETF	184.96	186.65	183.96	186.63	127632400.0
2016-02-12	QQQ	ETF	97.68	98.12	96.73	98.02	49186494.0
2016-02-12	IWM	ETF	95.66	96.79	95.19	96.59	40097300.0
2016-02-12	DIA	ETF	158.16	159.98	157.66	159.98	7073000.0
2016-02-12	GLD	ETF	118.12	118.74	117.88	118.36	16981200.0
2016-02-12	TLT	ETF	132.64	133.13	130.93	131.5	13888400.0
2016-02-12	AADR	ETF	34.71	34.96	34.71	34.96	1000.0
2016-02-12	AAXJ	ETF	47.36	47.8	47.16	47.79	747700.0
2016-02-12	ACTX	ETF	4.72	5.31	4.72	5.31	124.0
2016-02-12	ACWI	ETF	49.93	50.42	49.66	50.39	2246700.0
2016-02-12	ACWV	ETF	67.14	67.59	66.86	67.56	196700.0
2016-02-12	ACWX	ETF	34.95	35.44	34.87	35.42	1403666.0
2016-02-12	ADRE	ETF	25.56	25.75	25.45	25.75	4985.0
2016-02-12	AFK	ETF	16.3	16.7093	16.3	16.7093	14920.0
2016-02-12	AGG	ETF	109.92	109.96	109.55	109.77	2968800.0
2016-02-12	AGGY	ETF	49.66	49.765	49.62	49.702	2100.0
2016-02-12	AGQ	ETF	34.47	34.9	34.16	34.56	169900.0
2016-02-12	AGZ	ETF	114.99	115.1674	114.6301	114.86	18133.0
2016-02-12	AGZD	ETF	23.465	23.535	23.465	23.495	2400.0
2016-02-12	AIA	ETF	37.32	37.71	37.27	37.69	31959.0
2016-02-12	AIQ	ETF	6.55	6.79	6.55	6.78	11050.0
2016-02-12	AIRR	ETF	14.42	14.51	14.24	14.39	13800.0
2016-02-12	AIVI	ETF	35.05	35.5	34.95	35.5	9900.0
2016-02-12	ALTY	ETF	12.48	12.55	12.225	12.5	14100.0
2016-02-12	AMJ	ETF	21.34	22.2	21.105	22.05	5220145.0
2016-02-12	AMLP	ETF	40.9	42.85	40.35	42.65	2068280.0
2016-02-12	AMZA	ETF	65.0	69.2	65.0	67.3	2870.0
2016-02-12	ANGL	ETF	23.35	23.66	23.35	23.59	103300.0
2016-02-12	AOA	ETF	41.25	41.45	41.01	41.44	39500.0
2016-02-12	AOK	ETF	30.91	30.95	30.78	30.95	43544.0
2016-02-12	AOM	ETF	32.97	32.97	32.7983	32.97	62842.0
2016-02-12	AOR	ETF	36.57	36.72	36.4101	36.72	225025.0
2016-02-12	ARGT	ETF	16.43	16.94	16.43	16.78	27000.0
2016-02-12	ARKG	ETF	15.58	15.58	15.102	15.102	400.0
2016-02-12	ARKK	ETF	14.79	14.99	14.79	14.95	4200.0
2016-02-12	ARKQ	ETF	14.85	14.85	14.609	14.789	1500.0
2016-02-12	ARKW	ETF	16.82	16.82	16.78	16.78	400.0
2016-02-12	ASEA	ETF	11.95	12.03	11.94	12.03	2800.0
2016-02-12	ASHR	ETF	21.3	21.52	21.11	21.5	1390600.0
2016-02-12	ASHS	ETF	29.29	29.64	29.02	29.47	29500.0
2016-02-12	ASHX	ETF	18.67	18.89	18.67	18.88	1916.0
2016-02-12	ATMP	ETF	14.35	14.69	14.04	14.06	145200.0
2016-02-12	BAB	ETF	30.27	30.336	30.1	30.18	222371.0
2016-02-12	BAL	ETF	38.39	38.429	38.26	38.4	5930.0
2016-02-12	BBC	ETF	16.57	17.2501	16.56	17.2501	22916.0
2016-02-12	BBH	ETF	96.67	98.9	95.19	98.86	95200.0
2016-02-12	BBP	ETF	22.47	22.47	21.581	22.34	4800.0
2016-02-12	BCM	ETF	22.97	23.063	22.97	23.063	2102.0
2016-02-12	BFOR	ETF	6.555	6.6475	6.5375	6.645	100000.0
2016-02-12	BIB	ETF	37.48	38.5499	35.64	38.43	1025982.0

> showing 50 of 1,239 rows — these rows as CSV

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