PREVIEW / etf_daily / 2017-09-15

all etf daily files

  file:    by_date/etf_daily/2017/2017-09-15.parquet
  size:    56 KB
  rows:    1,441

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-09-15	SPY	ETF	248.69	249.29	248.57	249.19	95432400.0
2017-09-15	QQQ	ETF	145.56	146.59	145.29	146.06	46422402.0
2017-09-15	IWM	ETF	141.64	142.47	141.55	142.41	23184000.0
2017-09-15	DIA	ETF	222.13	222.57	221.91	222.45	2377700.0
2017-09-15	GLD	ETF	125.99	125.99	125.41	125.53	8375100.0
2017-09-15	TLT	ETF	127.0	127.01	126.54	126.86	9769200.0
2017-09-15	AADR	ETF	54.41	55.08	54.41	54.78	23500.0
2017-09-15	AAXJ	ETF	72.79	73.18	72.72	73.12	474100.0
2017-09-15	ACSI	ETF	28.891	29.13	28.891	29.13	8400.0
2017-09-15	ACTX	ETF	71.3906	76.1107	71.3906	75.5207	125.0
2017-09-15	ACWI	ETF	68.5	68.58	68.41	68.57	969800.0
2017-09-15	ACWV	ETF	81.56	81.7	81.46	81.69	60300.0
2017-09-15	ACWX	ETF	48.29	48.29	48.18	48.29	627671.0
2017-09-15	ADRE	ETF	43.41	43.43	43.2101	43.43	5515.0
2017-09-15	AFK	ETF	23.31	23.62	23.251	23.32	15026.0
2017-09-15	AFTY	ETF	17.16	17.16	16.97	17.01	9700.0
2017-09-15	AGG	ETF	110.0	110.04	109.86	109.91	2818000.0
2017-09-15	AGGY	ETF	50.91	50.91	50.81	50.875	14100.0
2017-09-15	AGNG	ETF	19.54	19.56	19.481	19.545	3600.0
2017-09-15	AGQ	ETF	37.52	37.54	37.09	37.19	110500.0
2017-09-15	AGZ	ETF	114.05	114.05	113.975	114.02	7170.0
2017-09-15	AGZD	ETF	23.92	24.025	23.92	23.95	17400.0
2017-09-15	AIA	ETF	61.47	61.65	61.26	61.65	23646.0
2017-09-15	AIRR	ETF	24.3	24.6	24.3	24.57	39400.0
2017-09-15	AIVI	ETF	42.88	42.94	42.85	42.94	4900.0
2017-09-15	ALTY	ETF	15.623	15.633	15.623	15.633	1400.0
2017-09-15	AMJ	ETF	28.43	28.49	28.23	28.31	2328904.0
2017-09-15	AMLP	ETF	56.7	56.95	56.3	56.35	1507420.0
2017-09-15	AMZA	ETF	93.1	93.2	92.2	92.4	49160.0
2017-09-15	ANGL	ETF	30.11	30.13	30.02	30.12	156300.0
2017-09-15	AOA	ETF	53.27	53.33	53.18	53.33	49600.0
2017-09-15	AOK	ETF	34.45	34.46	34.38	34.45	209376.0
2017-09-15	AOM	ETF	37.92	37.94	37.8039	37.94	377031.0
2017-09-15	AOR	ETF	44.65	44.71	44.5933	44.71	149935.0
2017-09-15	ARGT	ETF	31.33	31.33	31.03	31.14	18200.0
2017-09-15	ARKG	ETF	25.49	25.59	25.34	25.446	17800.0
2017-09-15	ARKK	ETF	33.54	34.02	33.451	33.95	126200.0
2017-09-15	ARKQ	ETF	30.89	31.26	30.89	31.26	55200.0
2017-09-15	ARKW	ETF	40.01	40.64	39.96	40.54	27800.0
2017-09-15	ASEA	ETF	15.69	15.73	15.69	15.73	900.0
2017-09-15	ASET	ETF	28.2899	28.3398	28.2899	28.3398	1395.0
2017-09-15	ASHR	ETF	29.76	29.79	29.69	29.78	343400.0
2017-09-15	ASHS	ETF	37.2	37.2	37.08	37.2	13900.0
2017-09-15	ASHX	ETF	21.73	21.73	21.73	21.73	100.0
2017-09-15	ATMP	ETF	21.52	21.52	21.47	21.48	5300.0
2017-09-15	BAB	ETF	30.63	30.64	30.58	30.64	52997.0
2017-09-15	BAL	ETF	45.42	45.55	45.42	45.4645	2258.0
2017-09-15	BAR	ETF	13.2548	13.2548	13.2224	13.2224	4580.0
2017-09-15	BBC	ETF	27.82	28.07	27.4	28.06	11487.0
2017-09-15	BBH	ETF	134.35	134.94	134.06	134.26	9300.0

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

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