PREVIEW / etf_daily / 2017-06-07

all etf daily files

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

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-07	SPY	ETF	243.6	243.92	242.83	243.66	54144300.0
2017-06-07	QQQ	ETF	143.23	143.54	142.6	143.42	18842408.0
2017-06-07	IWM	ETF	138.86	139.53	138.49	138.98	20542200.0
2017-06-07	DIA	ETF	211.69	211.92	211.14	211.72	1545800.0
2017-06-07	GLD	ETF	122.79	123.16	122.02	122.45	9039200.0
2017-06-07	TLT	ETF	125.24	125.52	124.79	124.92	12852400.0
2017-06-07	AADR	ETF	48.03	48.75	48.03	48.54	32700.0
2017-06-07	AAXJ	ETF	67.66	67.83	67.52	67.77	406000.0
2017-06-07	ACSI	ETF	28.8542	28.9	28.8542	28.8568	1040.0
2017-06-07	ACTX	ETF	56.9355	76.7007	56.9355	70.8006	1959.0
2017-06-07	ACWI	ETF	66.36	66.51	66.16	66.41	2328800.0
2017-06-07	ACWV	ETF	80.91	80.99	80.74	80.9	164900.0
2017-06-07	ACWX	ETF	46.47	46.52	46.22	46.37	181802.0
2017-06-07	ADRE	ETF	38.58	38.589	38.492	38.492	3475.0
2017-06-07	AFK	ETF	22.23	22.23	21.87	21.87	12529.0
2017-06-07	AFTY	ETF	14.94	14.94	14.92	14.92	300.0
2017-06-07	AGG	ETF	109.81	109.87	109.7	109.76	1903500.0
2017-06-07	AGGY	ETF	50.77	50.8	50.67	50.74	9400.0
2017-06-07	AGNG	ETF	18.422	18.422	18.25	18.34	1900.0
2017-06-07	AGQ	ETF	38.33	38.59	37.7	38.08	193500.0
2017-06-07	AGZ	ETF	113.8604	113.98	113.7101	113.98	43564.0
2017-06-07	AGZD	ETF	23.95	23.95	23.95	23.95	800.0
2017-06-07	AIA	ETF	57.03	57.0393	56.711	56.98	28822.0
2017-06-07	AIQ	ETF	13.225	13.25	13.2	13.2	7909.0
2017-06-07	AIRR	ETF	23.41	23.415	23.2	23.24	88100.0
2017-06-07	AIVI	ETF	42.2	42.2	41.97	42.16	27200.0
2017-06-07	ALTY	ETF	15.38	15.475	15.38	15.435	2300.0
2017-06-07	AMJ	ETF	30.06	30.31	29.46	29.46	2195288.0
2017-06-07	AMLP	ETF	59.7	60.3	59.05	59.1	2335520.0
2017-06-07	AMZA	ETF	101.0	102.1	98.2	98.6	286710.0
2017-06-07	ANGL	ETF	29.71	29.72	29.54	29.58	439100.0
2017-06-07	AOA	ETF	51.98	51.99	51.82	51.9	77600.0
2017-06-07	AOK	ETF	34.09	34.1599	34.0307	34.1	48761.0
2017-06-07	AOM	ETF	37.42	37.42	37.32	37.38	65263.0
2017-06-07	AOR	ETF	43.76	43.8299	43.6998	43.77	61180.0
2017-06-07	ARCM	ETF	100.05	100.05	100.05	100.05	2000.0
2017-06-07	ARGT	ETF	30.93	31.0	30.58	30.7	20200.0
2017-06-07	ARKG	ETF	20.95	21.22	20.92	21.126	9800.0
2017-06-07	ARKK	ETF	29.58	29.58	29.287	29.454	40700.0
2017-06-07	ARKQ	ETF	29.39	29.439	29.15	29.32	44600.0
2017-06-07	ARKW	ETF	36.47	36.47	36.06	36.245	61700.0
2017-06-07	ASEA	ETF	15.1	15.1	14.97	14.98	3300.0
2017-06-07	ASET	ETF	27.679	27.679	27.679	27.679	350.0
2017-06-07	ASHR	ETF	26.03	26.08	26.02	26.06	759900.0
2017-06-07	ASHS	ETF	31.61	31.99	31.61	31.96	24700.0
2017-06-07	ASHX	ETF	19.69	19.69	19.69	19.69	650.0
2017-06-07	ATMP	ETF	22.26	22.35	21.86	21.92	68800.0
2017-06-07	BAB	ETF	30.11	30.16	30.08	30.08	105185.0
2017-06-07	BAL	ETF	48.25	48.25	48.0901	48.14	1200.0
2017-06-07	BBC	ETF	22.29	22.507	21.96	22.2514	7411.0

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

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