PREVIEW / etf_daily / 2017-02-13

all etf daily files

  file:    by_date/etf_daily/2017/2017-02-13.parquet
  size:    54 KB
  rows:    1,370

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	SPY	ETF	232.08	233.07	232.05	232.77	55182100.0
2017-02-13	QQQ	ETF	127.76	128.26	127.7199	128.1	19120150.0
2017-02-13	IWM	ETF	138.77	139.21	138.09	138.3	23245100.0
2017-02-13	DIA	ETF	203.32	204.47	203.32	204.2	2637400.0
2017-02-13	GLD	ETF	116.73	116.95	116.15	116.8	7354900.0
2017-02-13	TLT	ETF	120.25	120.41	119.88	120.38	11536800.0
2017-02-13	AADR	ETF	45.8	45.8	45.38	45.62	30300.0
2017-02-13	AAXJ	ETF	60.27	60.54	60.25	60.42	691100.0
2017-02-13	ACSI	ETF	27.72	27.77	27.6899	27.77	4389.0
2017-02-13	ACTX	ETF	145.6723	160.4814	144.5513	145.9673	5540.0
2017-02-13	ACWF	ETF	25.29	25.395	25.29	25.395	1485.0
2017-02-13	ACWI	ETF	61.95	62.14	61.93	62.02	2759100.0
2017-02-13	ACWV	ETF	75.01	75.17	74.95	75.12	165000.0
2017-02-13	ACWX	ETF	42.44	42.56	42.44	42.48	757781.0
2017-02-13	ADRE	ETF	36.06	36.32	36.06	36.2327	7157.0
2017-02-13	AFK	ETF	21.76	21.76	21.5127	21.67	11371.0
2017-02-13	AGG	ETF	108.34	108.35	108.23	108.3	2189800.0
2017-02-13	AGGY	ETF	49.728	49.82	49.715	49.82	4900.0
2017-02-13	AGQ	ETF	40.3	40.3	39.6	39.85	176900.0
2017-02-13	AGZ	ETF	112.8	113.03	112.75	112.81	116459.0
2017-02-13	AGZD	ETF	24.06	24.08	24.005	24.005	7000.0
2017-02-13	AIA	ETF	50.33	50.4954	50.2724	50.43	27514.0
2017-02-13	AIQ	ETF	10.3	10.4	10.3	10.3	8403.0
2017-02-13	AIRR	ETF	24.68	24.68	24.188	24.24	113700.0
2017-02-13	AIVI	ETF	38.86	38.86	38.76	38.82	12800.0
2017-02-13	ALTY	ETF	15.52	15.56	15.5	15.5	4000.0
2017-02-13	AMJ	ETF	33.96	34.17	33.705	33.95	784871.0
2017-02-13	AMLP	ETF	65.25	65.3	64.8	65.15	1893060.0
2017-02-13	AMUB	ETF	21.2888	21.3831	21.2888	21.3831	390.0
2017-02-13	AMZA	ETF	113.5	113.5	112.5	113.3	40980.0
2017-02-13	ANGL	ETF	29.43	29.47	29.41	29.46	249100.0
2017-02-13	AOA	ETF	48.98	49.06	48.95	48.99	132800.0
2017-02-13	AOK	ETF	32.9	33.01	32.9	32.96	125127.0
2017-02-13	AOM	ETF	35.95	35.96	35.9001	35.91	56790.0
2017-02-13	AOR	ETF	41.65	41.74	41.65	41.7	73574.0
2017-02-13	ARGT	ETF	27.0	27.15	26.89	26.89	111500.0
2017-02-13	ARKG	ETF	18.98	18.98	18.83	18.83	1900.0
2017-02-13	ARKK	ETF	23.11	23.13	23.0	23.05	7000.0
2017-02-13	ARKQ	ETF	24.72	24.72	24.503	24.59	21100.0
2017-02-13	ARKW	ETF	28.5	28.5	28.291	28.305	13400.0
2017-02-13	ASEA	ETF	13.64	13.72	13.64	13.72	5300.0
2017-02-13	ASET	ETF	26.19	26.248	26.19	26.248	1215.0
2017-02-13	ASHR	ETF	25.02	25.05	24.91	25.01	611900.0
2017-02-13	ASHS	ETF	33.56	33.77	33.56	33.73	17700.0
2017-02-13	ASHX	ETF	19.52	19.52	19.51	19.51	770.0
2017-02-13	ATMP	ETF	24.8	25.13	24.48	24.69	82800.0
2017-02-13	BAB	ETF	29.27	29.35	29.2184	29.34	180644.0
2017-02-13	BAL	ETF	50.85	51.048	50.43	50.87	11619.0
2017-02-13	BBC	ETF	21.0	21.0	20.7	20.7	3365.0
2017-02-13	BBH	ETF	116.94	117.73	116.94	117.37	70700.0

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

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