PREVIEW / etf_daily / 2017-06-14

all etf daily files

  file:    by_date/etf_daily/2017/2017-06-14.parquet
  size:    55 KB
  rows:    1,400

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-06-14	SPY	ETF	244.86	244.87	243.29	244.24	78602300.0
2017-06-14	QQQ	ETF	140.92	140.93	138.62	139.75	60093764.0
2017-06-14	IWM	ETF	142.03	142.04	140.45	141.26	33021900.0
2017-06-14	DIA	ETF	213.78	214.0	212.98	213.84	5423100.0
2017-06-14	GLD	ETF	121.51	121.88	119.57	119.82	21124800.0
2017-06-14	TLT	ETF	125.92	126.71	125.73	126.3	20212300.0
2017-06-14	AADR	ETF	47.49	47.49	46.59	46.65	4500.0
2017-06-14	AAXJ	ETF	68.12	68.16	67.55	67.74	1209400.0
2017-06-14	ACSI	ETF	28.97	29.05	28.9504	29.05	6902.0
2017-06-14	ACTX	ETF	97.9409	101.4809	94.2828	94.2828	645.0
2017-06-14	ACWF	ETF	27.45	27.45	27.45	27.45	117.0
2017-06-14	ACWI	ETF	66.71	66.72	66.18	66.39	1955100.0
2017-06-14	ACWV	ETF	80.9	81.03	80.52	80.75	181200.0
2017-06-14	ACWX	ETF	46.62	46.62	46.15	46.3	269302.0
2017-06-14	ADRE	ETF	38.63	38.705	38.3	38.35	3972.0
2017-06-14	AFK	ETF	22.14	22.3599	22.14	22.14	6571.0
2017-06-14	AFTY	ETF	14.97	14.999	14.96	14.96	2400.0
2017-06-14	AGG	ETF	110.0	110.18	109.85	109.94	2627500.0
2017-06-14	AGGY	ETF	50.9	50.97	50.823	50.83	6900.0
2017-06-14	AGNG	ETF	18.36	18.44	18.36	18.44	500.0
2017-06-14	AGQ	ETF	36.38	36.6	34.81	34.9	289400.0
2017-06-14	AGZ	ETF	113.92	114.365	113.7001	113.83	27275.0
2017-06-14	AGZD	ETF	23.975	23.975	23.955	23.96	1600.0
2017-06-14	AIA	ETF	57.28	57.28	56.8	56.96	40579.0
2017-06-14	AIQ	ETF	13.15	13.2	13.1	13.2	95332.0
2017-06-14	AIRR	ETF	24.13	24.13	23.684	23.81	13000.0
2017-06-14	AIVI	ETF	42.26	42.26	41.73	41.73	7700.0
2017-06-14	ALTY	ETF	15.6	15.6	15.58	15.58	2000.0
2017-06-14	AMJ	ETF	29.42	29.49	28.79	28.84	3995756.0
2017-06-14	AMLP	ETF	59.2	59.2	57.95	57.95	1970540.0
2017-06-14	AMZA	ETF	98.7	98.72	95.49	95.7	167110.0
2017-06-14	ANGL	ETF	29.77	29.8	29.66	29.72	179800.0
2017-06-14	AOA	ETF	52.18	52.18	51.85	52.03	88600.0
2017-06-14	AOK	ETF	34.13	34.2009	34.1	34.15	41418.0
2017-06-14	AOM	ETF	37.54	37.55	37.369	37.46	58896.0
2017-06-14	AOR	ETF	43.95	43.9599	43.75	43.86	53791.0
2017-06-14	ARCM	ETF	101.05	101.05	101.05	101.05	40.0
2017-06-14	ARGT	ETF	30.16	30.16	29.45	29.56	45200.0
2017-06-14	ARKG	ETF	21.48	21.48	21.25	21.3	5100.0
2017-06-14	ARKK	ETF	28.99	28.99	28.21	28.46	46500.0
2017-06-14	ARKQ	ETF	29.0	29.0	28.507	28.74	41900.0
2017-06-14	ARKW	ETF	35.54	35.54	34.53	34.76	43200.0
2017-06-14	ASEA	ETF	15.3	15.3	15.13	15.13	600.0
2017-06-14	ASET	ETF	27.94	27.9432	27.94	27.9432	373.0
2017-06-14	ASHR	ETF	26.33	26.33	26.15	26.18	535900.0
2017-06-14	ASHS	ETF	31.9	32.02	31.9	32.01	5600.0
2017-06-14	ASHX	ETF	19.89	19.89	19.87	19.87	531.0
2017-06-14	ATMP	ETF	21.98	21.99	21.48	21.48	68900.0
2017-06-14	BAB	ETF	30.18	30.23	30.101	30.16	100727.0
2017-06-14	BAL	ETF	47.42	47.42	46.83	46.97	25327.0

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

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