PREVIEW / etf_daily / 2017-09-08

all etf daily files

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

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-08	SPY	ETF	246.54	247.11	246.3	246.58	63832800.0
2017-09-08	QQQ	ETF	145.28	145.35	144.06	144.21	27890115.0
2017-09-08	IWM	ETF	138.93	139.77	138.62	139.22	21870500.0
2017-09-08	DIA	ETF	217.61	218.66	217.52	218.24	2135800.0
2017-09-08	GLD	ETF	128.21	128.3	127.59	127.97	9020000.0
2017-09-08	TLT	ETF	129.11	129.16	128.57	129.0	9808500.0
2017-09-08	AADR	ETF	53.83	53.85	53.28	53.48	25500.0
2017-09-08	AAXJ	ETF	72.21	72.27	71.84	71.95	545600.0
2017-09-08	ACSI	ETF	28.6485	28.6485	28.58	28.6324	25701.0
2017-09-08	ACTX	ETF	66.0806	71.3906	66.0806	70.2106	283.0
2017-09-08	ACWI	ETF	67.72	67.81	67.64	67.69	610400.0
2017-09-08	ACWV	ETF	81.33	81.67	81.31	81.53	136500.0
2017-09-08	ACWX	ETF	47.95	47.95	47.77	47.8	282059.0
2017-09-08	ADRE	ETF	42.76	42.81	42.47	42.47	10732.0
2017-09-08	AFK	ETF	24.22	24.22	23.91	23.91	3655.0
2017-09-08	AFTY	ETF	17.31	17.31	17.19	17.25	7700.0
2017-09-08	AGG	ETF	110.54	110.58	110.43	110.44	2363200.0
2017-09-08	AGGY	ETF	51.11	51.11	51.05	51.1	6000.0
2017-09-08	AGNG	ETF	19.546	19.63	19.546	19.63	1500.0
2017-09-08	AGQ	ETF	39.4	39.44	38.46	38.98	189600.0
2017-09-08	AGZ	ETF	114.4461	114.52	114.421	114.49	20416.0
2017-09-08	AGZD	ETF	23.96	23.96	23.89	23.955	2600.0
2017-09-08	AIA	ETF	60.95	61.0109	60.7197	60.74	19958.0
2017-09-08	AIRR	ETF	23.49	23.834	23.49	23.79	9600.0
2017-09-08	AIVI	ETF	42.94	42.94	42.75	42.77	3200.0
2017-09-08	ALTY	ETF	15.575	15.59	15.57	15.57	12100.0
2017-09-08	AMJ	ETF	28.11	28.15	27.85	27.94	2041066.0
2017-09-08	AMLP	ETF	55.9	56.0	55.4	55.55	1817540.0
2017-09-08	AMZA	ETF	92.0	92.1	90.99	91.4	78290.0
2017-09-08	ANGL	ETF	30.06	30.06	29.91	29.92	253800.0
2017-09-08	AOA	ETF	52.82	52.88	52.76	52.76	20700.0
2017-09-08	AOK	ETF	34.45	34.468	34.3901	34.44	43765.0
2017-09-08	AOM	ETF	37.86	37.87	37.75	37.83	118711.0
2017-09-08	AOR	ETF	44.45	44.45	44.36	44.4	28603.0
2017-09-08	ARGT	ETF	30.54	30.54	30.21	30.33	14300.0
2017-09-08	ARKG	ETF	25.3	25.3	25.1	25.117	11100.0
2017-09-08	ARKK	ETF	33.8	33.8	33.16	33.27	64000.0
2017-09-08	ARKQ	ETF	30.3	30.3	29.906	29.965	10900.0
2017-09-08	ARKW	ETF	40.35	40.35	39.66	39.72	50500.0
2017-09-08	ASEA	ETF	15.71	15.71	15.61	15.61	2800.0
2017-09-08	ASET	ETF	28.32	28.32	28.32	28.32	500.0
2017-09-08	ASHR	ETF	30.0	30.02	29.86	29.86	511400.0
2017-09-08	ASHS	ETF	37.35	37.35	36.97	37.03	10000.0
2017-09-08	ASHX	ETF	21.701	21.701	21.701	21.701	100.0
2017-09-08	ATMP	ETF	21.26	21.4	21.18	21.25	49200.0
2017-09-08	BAB	ETF	30.9	30.927	30.8251	30.9	66068.0
2017-09-08	BAL	ETF	50.11	50.249	49.39	49.5	8466.0
2017-09-08	BAR	ETF	13.872	14.287	13.4813	13.4973	30060.0
2017-09-08	BBC	ETF	28.56	28.56	28.1	28.1	20740.0
2017-09-08	BBH	ETF	135.38	136.21	135.07	135.43	12700.0

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

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