PREVIEW / etf_daily / 2017-02-24

all etf daily files

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

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-24	SPY	ETF	235.46	236.79	235.41	236.74	82381600.0
2017-02-24	QQQ	ETF	129.47	130.26	129.38	130.26	18624489.0
2017-02-24	IWM	ETF	137.46	138.65	137.3	138.65	24512300.0
2017-02-24	DIA	ETF	207.08	207.95	207.07	207.93	3703900.0
2017-02-24	GLD	ETF	119.74	119.88	119.25	119.7	9809000.0
2017-02-24	TLT	ETF	121.35	122.14	121.26	122.01	11336000.0
2017-02-24	AADR	ETF	45.3	46.17	45.0	45.05	14500.0
2017-02-24	AAXJ	ETF	60.8	61.02	60.73	61.02	343800.0
2017-02-24	ACSI	ETF	27.95	28.09	27.93	28.06	5577.0
2017-02-24	ACTX	ETF	97.9409	102.6609	76.7007	93.2208	4153.0
2017-02-24	ACWF	ETF	25.49	25.49	25.4	25.4	12800.0
2017-02-24	ACWI	ETF	62.32	62.58	62.31	62.58	1936700.0
2017-02-24	ACWV	ETF	76.2	76.6	76.18	76.59	159700.0
2017-02-24	ACWX	ETF	42.45	42.57	42.42	42.54	1370640.0
2017-02-24	ADRE	ETF	36.23	36.327	36.081	36.2422	7132.0
2017-02-24	AFK	ETF	21.56	21.56	21.06	21.11	15185.0
2017-02-24	AFTY	ETF	14.08	14.1	14.063	14.063	1900.0
2017-02-24	AGG	ETF	108.88	109.06	108.82	109.0	2670900.0
2017-02-24	AGGY	ETF	49.942	50.07	49.91	50.0	8500.0
2017-02-24	AGNG	ETF	16.545	16.545	16.545	16.545	100.0
2017-02-24	AGQ	ETF	42.07	42.47	41.74	42.2	257200.0
2017-02-24	AGZ	ETF	113.08	113.37	113.0495	113.26	11903.0
2017-02-24	AGZD	ETF	24.04	24.04	24.04	24.04	800.0
2017-02-24	AIA	ETF	51.02	51.15	50.87	51.15	21305.0
2017-02-24	AIQ	ETF	10.35	10.45	10.3	10.4	5051.0
2017-02-24	AIRR	ETF	23.71	24.271	23.7	24.24	98100.0
2017-02-24	AIVI	ETF	38.62	38.73	38.62	38.68	9900.0
2017-02-24	ALTY	ETF	15.56	15.595	15.422	15.55	30800.0
2017-02-24	AMJ	ETF	33.36	33.74	32.9257	33.11	1686689.0
2017-02-24	AMLP	ETF	64.35	64.45	63.85	64.1	2541740.0
2017-02-24	AMZA	ETF	111.7	112.15	110.9	111.35	35370.0
2017-02-24	ANGL	ETF	29.58	29.6	29.54	29.58	220700.0
2017-02-24	AOA	ETF	49.25	49.44	49.25	49.42	43500.0
2017-02-24	AOK	ETF	33.17	33.2299	33.1456	33.22	33077.0
2017-02-24	AOM	ETF	36.19	36.25	36.08	36.23	81353.0
2017-02-24	AOR	ETF	41.91	42.07	41.9	42.07	73527.0
2017-02-24	ARGT	ETF	26.56	26.56	26.12	26.47	65700.0
2017-02-24	ARKG	ETF	18.73	18.8	18.73	18.8	400.0
2017-02-24	ARKK	ETF	22.7	22.86	22.7	22.86	5700.0
2017-02-24	ARKQ	ETF	23.97	24.03	23.684	24.0	6000.0
2017-02-24	ARKW	ETF	28.43	28.43	28.21	28.412	2800.0
2017-02-24	ASEA	ETF	13.58	13.58	13.58	13.58	800.0
2017-02-24	ASET	ETF	26.36	26.3696	26.3489	26.3489	1473.0
2017-02-24	ASHR	ETF	25.29	25.4	25.28	25.34	247000.0
2017-02-24	ASHS	ETF	34.17	34.28	34.17	34.25	2100.0
2017-02-24	ASHX	ETF	19.64	19.64	19.62	19.62	336.0
2017-02-24	ATMP	ETF	24.2	24.35	23.97	24.08	42100.0
2017-02-24	BAB	ETF	29.45	29.5	29.41	29.46	347780.0
2017-02-24	BAL	ETF	50.01	50.01	49.56	49.81	9832.0
2017-02-24	BBC	ETF	20.55	20.6019	20.1602	20.6019	5036.0

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

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