PREVIEW / etf_daily / 2017-06-26

all etf daily files

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

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-26	SPY	ETF	243.9	244.38	243.05	243.29	56700500.0
2017-06-26	QQQ	ETF	142.0	142.29	140.27	140.58	34411094.0
2017-06-26	IWM	ETF	141.09	141.53	140.2	141.08	22988300.0
2017-06-26	DIA	ETF	214.29	214.76	213.53	213.87	1940400.0
2017-06-26	GLD	ETF	118.29	118.54	118.17	118.36	6593400.0
2017-06-26	TLT	ETF	128.27	128.57	128.16	128.26	5541600.0
2017-06-26	AADR	ETF	46.11	46.32	46.11	46.2	3100.0
2017-06-26	AAXJ	ETF	68.48	68.61	68.22	68.41	255200.0
2017-06-26	ACSI	ETF	28.86	28.86	28.74	28.8	21857.0
2017-06-26	ACTX	ETF	106.201	106.201	94.4008	100.3009	541.0
2017-06-26	ACWF	ETF	27.43	27.43	27.38	27.39	741.0
2017-06-26	ACWI	ETF	65.93	65.98	65.64	65.7	3644700.0
2017-06-26	ACWV	ETF	80.24	80.32	80.02	80.02	149700.0
2017-06-26	ACWX	ETF	45.84	45.885	45.65	45.66	279570.0
2017-06-26	ADRE	ETF	38.86	39.02	38.699	38.7468	10009.0
2017-06-26	AFK	ETF	21.5	21.6975	21.4501	21.6003	5875.0
2017-06-26	AFTY	ETF	15.2	15.247	15.2	15.231	1900.0
2017-06-26	AGG	ETF	110.19	110.24	110.13	110.15	1914400.0
2017-06-26	AGGY	ETF	50.86	50.88	50.826	50.86	14900.0
2017-06-26	AGNG	ETF	19.16	19.38	19.12	19.26	4000.0
2017-06-26	AGQ	ETF	33.75	33.95	33.62	33.72	97000.0
2017-06-26	AGZ	ETF	114.02	114.27	113.986	114.27	7951.0
2017-06-26	AGZD	ETF	23.97	23.97	23.965	23.965	5400.0
2017-06-26	AIA	ETF	58.31	58.31	57.95	58.01	68710.0
2017-06-26	AIQ	ETF	13.3	13.3	13.2	13.25	12666.0
2017-06-26	AIRR	ETF	23.38	23.635	23.33	23.56	18200.0
2017-06-26	AIVI	ETF	41.07	41.07	40.85	40.91	94500.0
2017-06-26	ALTY	ETF	15.494	15.62	15.494	15.54	1500.0
2017-06-26	AMJ	ETF	28.67	29.01	28.5	28.97	2252482.0
2017-06-26	AMLP	ETF	57.5	58.45	57.35	58.45	4497520.0
2017-06-26	AMZA	ETF	95.0	97.1	95.0	97.1	85950.0
2017-06-26	ANGL	ETF	29.49	29.53	29.43	29.48	302800.0
2017-06-26	AOA	ETF	52.13	52.22	51.97	52.02	37500.0
2017-06-26	AOK	ETF	34.2	34.249	34.1458	34.17	41835.0
2017-06-26	AOM	ETF	37.5	37.5599	37.44	37.5	77259.0
2017-06-26	AOR	ETF	43.82	43.98	43.82	43.82	45401.0
2017-06-26	ARCM	ETF	100.15	100.15	100.15	100.15	20.0
2017-06-26	ARGT	ETF	29.7	29.7	29.34	29.4	23900.0
2017-06-26	ARKG	ETF	23.9	23.9	22.884	23.2	49800.0
2017-06-26	ARKK	ETF	30.57	31.0	29.64	29.85	108500.0
2017-06-26	ARKQ	ETF	29.23	29.44	28.617	28.78	58700.0
2017-06-26	ARKW	ETF	37.06	37.07	36.0	36.12	70100.0
2017-06-26	ASEA	ETF	15.15	15.17	15.13	15.17	800.0
2017-06-26	ASET	ETF	27.46	27.46	27.41	27.415	696.0
2017-06-26	ASHR	ETF	26.98	27.08	26.97	27.05	2203200.0
2017-06-26	ASHS	ETF	32.57	32.63	32.55	32.56	26000.0
2017-06-26	ASHX	ETF	20.7223	20.7223	20.6801	20.6801	258.0
2017-06-26	ATMP	ETF	21.68	21.86	21.51	21.86	32300.0
2017-06-26	BAB	ETF	30.3	30.338	30.27	30.29	80209.0
2017-06-26	BAL	ETF	43.91	44.47	43.61	44.365	3912.0

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

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