PREVIEW / etf_daily / 2017-09-11

all etf daily files

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

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-11	SPY	ETF	248.04	249.3	248.02	249.21	71364800.0
2017-09-11	QQQ	ETF	145.3	146.12	145.3	145.87	27126332.0
2017-09-11	IWM	ETF	140.39	140.92	140.23	140.68	22617700.0
2017-09-11	DIA	ETF	219.58	220.89	219.58	220.76	3019300.0
2017-09-11	GLD	ETF	126.74	126.94	126.05	126.19	9126600.0
2017-09-11	TLT	ETF	127.87	128.05	127.26	127.46	17856700.0
2017-09-11	AADR	ETF	54.0	54.35	53.93	54.24	29100.0
2017-09-11	AAXJ	ETF	72.87	72.95	72.46	72.95	674900.0
2017-09-11	ACSI	ETF	28.85	28.93	28.85	28.88	22233.0
2017-09-11	ACTX	ETF	68.7356	82.6007	68.7356	71.3906	800.0
2017-09-11	ACWF	ETF	28.6	28.66	28.6	28.66	801.0
2017-09-11	ACWI	ETF	68.04	68.39	68.04	68.31	961400.0
2017-09-11	ACWV	ETF	81.79	82.0	81.79	81.9	131700.0
2017-09-11	ACWX	ETF	48.14	48.28	48.13	48.23	223302.0
2017-09-11	ADRE	ETF	43.0	43.3299	43.0	43.3299	13356.0
2017-09-11	AFK	ETF	24.13	24.13	23.9893	23.9893	3306.0
2017-09-11	AFTY	ETF	17.17	17.17	17.095	17.135	5200.0
2017-09-11	AGG	ETF	110.27	110.29	110.1	110.14	2492700.0
2017-09-11	AGGY	ETF	51.01	51.02	50.91	50.956	16600.0
2017-09-11	AGNG	ETF	19.71	19.71	19.613	19.63	4000.0
2017-09-11	AGQ	ETF	38.03	38.5	37.76	37.83	226000.0
2017-09-11	AGZ	ETF	114.25	114.33	114.23	114.23	6456.0
2017-09-11	AGZD	ETF	23.955	23.955	23.905	23.905	4800.0
2017-09-11	AIA	ETF	61.46	61.73	61.46	61.73	26310.0
2017-09-11	AIRR	ETF	23.97	24.03	23.91	23.95	26300.0
2017-09-11	AIVI	ETF	43.12	43.2	43.1	43.12	11200.0
2017-09-11	ALTY	ETF	15.57	15.64	15.57	15.64	2900.0
2017-09-11	AMJ	ETF	27.96	28.1611	27.825	28.1	1237316.0
2017-09-11	AMLP	ETF	55.6	56.05	55.55	56.05	1515600.0
2017-09-11	AMUB	ETF	17.695	17.695	17.695	17.695	101.0
2017-09-11	AMZA	ETF	91.6	92.7	91.43	92.2	32810.0
2017-09-11	ANGL	ETF	30.01	30.05	29.96	30.01	261500.0
2017-09-11	AOA	ETF	53.08	53.24	53.05	53.2	32300.0
2017-09-11	AOK	ETF	34.53	34.53	34.451	34.49	22887.0
2017-09-11	AOM	ETF	37.9	37.952	37.8001	37.93	62668.0
2017-09-11	AOR	ETF	44.6	44.676	44.5349	44.65	91764.0
2017-09-11	ARGT	ETF	30.49	31.12	30.49	31.03	55800.0
2017-09-11	ARKG	ETF	25.5	25.5	25.16	25.33	17400.0
2017-09-11	ARKK	ETF	33.39	33.79	33.302	33.72	110800.0
2017-09-11	ARKQ	ETF	30.12	30.6	30.12	30.58	26300.0
2017-09-11	ARKW	ETF	40.04	40.48	40.04	40.36	45200.0
2017-09-11	ASEA	ETF	15.72	15.72	15.72	15.72	200.0
2017-09-11	ASET	ETF	28.48	28.52	28.4598	28.52	2340.0
2017-09-11	ASHR	ETF	29.82	29.85	29.76	29.78	1056500.0
2017-09-11	ASHS	ETF	37.43	37.49	37.38	37.45	12800.0
2017-09-11	ATMP	ETF	21.44	21.52	21.38	21.45	41900.0
2017-09-11	BAB	ETF	30.78	30.82	30.69	30.69	65894.0
2017-09-11	BAL	ETF	47.9272	48.2326	47.751	47.785	10502.0
2017-09-11	BAR	ETF	13.49	13.49	13.293	13.293	14170.0
2017-09-11	BBC	ETF	28.56	28.56	27.8645	28.09	21671.0

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

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