PREVIEW / etf_daily / 2017-06-21

all etf daily files

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

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-21	SPY	ETF	243.46	243.59	242.41	242.95	55977600.0
2017-06-21	QQQ	ETF	139.66	140.81	139.59	140.74	35743366.0
2017-06-21	IWM	ETF	140.05	140.8	139.22	139.45	23351400.0
2017-06-21	DIA	ETF	214.65	214.65	213.64	213.89	2129400.0
2017-06-21	GLD	ETF	118.15	118.66	118.15	118.52	4723700.0
2017-06-21	TLT	ETF	127.11	127.64	126.91	127.56	5914800.0
2017-06-21	AADR	ETF	46.0	46.08	45.81	46.03	13400.0
2017-06-21	AAXJ	ETF	67.4	67.56	67.28	67.39	2023000.0
2017-06-21	ACSI	ETF	28.7188	28.7188	28.609	28.66	10836.0
2017-06-21	ACTX	ETF	102.3659	110.921	101.4809	106.201	1203.0
2017-06-21	ACWF	ETF	27.17	27.17	27.079	27.14	3000.0
2017-06-21	ACWI	ETF	65.47	65.58	65.29	65.44	1116500.0
2017-06-21	ACWV	ETF	80.02	80.1	79.79	79.93	427000.0
2017-06-21	ACWX	ETF	45.26	45.37	45.2	45.29	190145.0
2017-06-21	ADRE	ETF	38.1189	38.2899	38.11	38.2	3067.0
2017-06-21	AFK	ETF	21.55	21.5608	21.44	21.44	2169.0
2017-06-21	AGG	ETF	109.88	110.03	109.88	109.98	1217400.0
2017-06-21	AGGY	ETF	50.83	50.878	50.741	50.83	12800.0
2017-06-21	AGNG	ETF	18.95	18.95	18.87	18.87	1300.0
2017-06-21	AGQ	ETF	33.0	33.22	32.95	33.13	69400.0
2017-06-21	AGZ	ETF	113.91	114.19	113.78	114.07	11072.0
2017-06-21	AIA	ETF	57.0456	57.13	56.92	56.95	27824.0
2017-06-21	AIQ	ETF	13.3	13.3	13.267	13.3	7354.0
2017-06-21	AIRR	ETF	23.49	23.553	23.1	23.13	19700.0
2017-06-21	AIVI	ETF	41.3	41.38	41.24	41.35	27200.0
2017-06-21	AMJ	ETF	27.85	28.04	27.61	27.64	3679364.0
2017-06-21	AMLP	ETF	55.85	56.25	55.3	55.3	3794860.0
2017-06-21	AMZA	ETF	91.6	92.3	90.3	90.4	94870.0
2017-06-21	ANGL	ETF	29.53	29.55	29.21	29.3	1143400.0
2017-06-21	AOA	ETF	51.85	51.9	51.72	51.83	36200.0
2017-06-21	AOK	ETF	34.11	34.11	34.0101	34.04	51863.0
2017-06-21	AOM	ETF	37.37	37.4188	37.3101	37.38	56271.0
2017-06-21	AOR	ETF	43.76	43.7699	43.64	43.68	112255.0
2017-06-21	ARCM	ETF	100.4	100.4	100.4	100.4	20.0
2017-06-21	ARGT	ETF	28.86	29.22	28.58	29.18	243200.0
2017-06-21	ARKG	ETF	22.35	22.535	22.29	22.535	31400.0
2017-06-21	ARKK	ETF	29.41	29.78	29.41	29.77	66000.0
2017-06-21	ARKQ	ETF	28.79	29.03	28.79	29.02	23100.0
2017-06-21	ARKW	ETF	35.92	36.18	35.893	36.18	64100.0
2017-06-21	ASEA	ETF	14.99	15.01	14.99	15.01	1200.0
2017-06-21	ASET	ETF	27.58	27.58	27.465	27.465	1654.0
2017-06-21	ASHR	ETF	26.41	26.5	26.37	26.41	1562700.0
2017-06-21	ASHS	ETF	32.42	32.45	32.41	32.45	18700.0
2017-06-21	ASHX	ETF	20.225	20.225	20.225	20.225	200.0
2017-06-21	ATMP	ETF	20.89	21.15	20.83	20.91	78700.0
2017-06-21	BAB	ETF	30.02	30.16	30.02	30.12	124978.0
2017-06-21	BAL	ETF	45.0	45.03	44.87	44.91	5483.0
2017-06-21	BBC	ETF	23.81	24.14	23.72	24.12	24180.0
2017-06-21	BBH	ETF	124.31	128.69	124.31	128.69	89200.0
2017-06-21	BBP	ETF	39.29	40.59	39.29	40.59	16800.0

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

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