PREVIEW / etf_daily / 2017-06-27

all etf daily files

  file:    by_date/etf_daily/2017/2017-06-27.parquet
  size:    56 KB
  rows:    1,418

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-27	SPY	ETF	243.04	243.38	241.31	241.33	82247700.0
2017-06-27	QQQ	ETF	140.07	140.22	138.02	138.03	65957819.0
2017-06-27	IWM	ETF	141.1	141.62	139.75	139.84	24610100.0
2017-06-27	DIA	ETF	213.71	214.13	212.87	212.93	1981600.0
2017-06-27	GLD	ETF	118.87	119.05	118.48	118.81	5759300.0
2017-06-27	TLT	ETF	127.43	127.49	126.62	126.89	8354200.0
2017-06-27	AADR	ETF	46.23	46.37	46.03	46.06	7300.0
2017-06-27	AAXJ	ETF	68.09	68.19	67.73	67.73	655100.0
2017-06-27	ACSI	ETF	28.83	28.86	28.6643	28.6643	13687.0
2017-06-27	ACTX	ETF	98.8259	103.2509	94.4008	94.9909	350.0
2017-06-27	ACWF	ETF	27.2232	27.2794	27.1912	27.1912	1532.0
2017-06-27	ACWI	ETF	65.73	65.79	65.4	65.42	1694300.0
2017-06-27	ACWV	ETF	79.93	80.02	79.51	79.59	139900.0
2017-06-27	ACWX	ETF	45.68	45.73	45.53	45.59	476823.0
2017-06-27	ADRE	ETF	38.63	38.63	38.31	38.36	4780.0
2017-06-27	AFK	ETF	21.67	21.68	21.65	21.65	3942.0
2017-06-27	AFTY	ETF	15.32	15.36	15.32	15.35	2700.0
2017-06-27	AGG	ETF	109.93	109.98	109.79	109.82	3072300.0
2017-06-27	AGGY	ETF	50.77	50.77	50.61	50.61	16400.0
2017-06-27	AGNG	ETF	19.27	19.27	19.0	19.02	2200.0
2017-06-27	AGQ	ETF	33.94	34.44	33.66	34.21	81600.0
2017-06-27	AGZ	ETF	113.98	114.2	113.823	114.14	19134.0
2017-06-27	AGZD	ETF	23.97	23.97	23.92	23.97	5200.0
2017-06-27	AIA	ETF	57.88	57.88	57.55	57.56	28383.0
2017-06-27	AIQ	ETF	13.25	13.3	13.25	13.275	5768.0
2017-06-27	AIRR	ETF	23.53	23.719	23.47	23.47	100300.0
2017-06-27	AIVI	ETF	40.83	40.89	40.78	40.81	36800.0
2017-06-27	ALTY	ETF	15.61	15.63	15.56	15.56	16900.0
2017-06-27	AMJ	ETF	29.07	29.26	28.76	28.8	2113463.0
2017-06-27	AMLP	ETF	58.4	58.75	57.9	57.95	2556580.0
2017-06-27	AMZA	ETF	97.7	98.4	96.2	96.4	100250.0
2017-06-27	ANGL	ETF	29.54	29.55	29.42	29.52	284900.0
2017-06-27	AOA	ETF	51.92	51.99	51.7	51.7	65500.0
2017-06-27	AOK	ETF	34.12	34.16	33.98	33.98	79102.0
2017-06-27	AOM	ETF	37.41	37.48	37.2663	37.27	93739.0
2017-06-27	AOR	ETF	43.79	43.82	43.59	43.59	69018.0
2017-06-27	ARCM	ETF	100.15	100.15	100.15	100.15	20.0
2017-06-27	ARGT	ETF	29.34	29.34	28.94	28.98	63900.0
2017-06-27	ARKG	ETF	23.2	23.23	22.433	22.46	42200.0
2017-06-27	ARKK	ETF	29.81	29.84	29.16	29.206	94700.0
2017-06-27	ARKQ	ETF	28.79	28.79	28.295	28.33	61400.0
2017-06-27	ARKW	ETF	36.0	36.016	35.32	35.32	46000.0
2017-06-27	ASEA	ETF	15.08	15.08	15.08	15.08	300.0
2017-06-27	ASET	ETF	27.42	27.42	27.35	27.35	569.0
2017-06-27	ASHR	ETF	27.08	27.15	27.08	27.08	559800.0
2017-06-27	ASHS	ETF	32.59	32.65	32.59	32.64	3800.0
2017-06-27	ATMP	ETF	22.01	22.01	21.67	21.72	61200.0
2017-06-27	BAB	ETF	30.21	30.3099	30.11	30.15	73996.0
2017-06-27	BAL	ETF	44.6	44.75	44.3956	44.58	7074.0
2017-06-27	BBC	ETF	25.16	25.23	24.13	24.13	11436.0

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

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