PREVIEW / etf_daily / 2017-10-20

all etf daily files

  file:    by_date/etf_daily/2017/2017-10-20.parquet
  size:    57 KB
  rows:    1,473

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-10-20	SPY	ETF	256.7	257.14	255.77	257.11	89176400.0
2017-10-20	QQQ	ETF	148.91	149.04	148.53	148.71	30173268.0
2017-10-20	IWM	ETF	150.31	150.41	149.86	149.98	25224500.0
2017-10-20	DIA	ETF	232.47	233.13	231.89	233.13	3275700.0
2017-10-20	GLD	ETF	121.68	121.98	121.39	121.61	8481100.0
2017-10-20	TLT	ETF	124.0	124.28	123.64	123.98	12326900.0
2017-10-20	AADR	ETF	57.28	57.45	57.17	57.35	53100.0
2017-10-20	AAXJ	ETF	74.75	74.94	74.7	74.87	676900.0
2017-10-20	ACSI	ETF	29.5746	29.669	29.5746	29.65	1537.0
2017-10-20	ACTX	ETF	52.5105	57.8205	48.9704	56.6405	500.0
2017-10-20	ACWF	ETF	29.785	29.96	29.785	29.83	4551.0
2017-10-20	ACWI	ETF	70.19	70.32	70.07	70.32	1314800.0
2017-10-20	ACWV	ETF	82.8	82.96	82.72	82.88	87300.0
2017-10-20	ACWX	ETF	49.16	49.2	49.1001	49.13	353925.0
2017-10-20	ADRE	ETF	43.34	43.43	43.17	43.17	2644.0
2017-10-20	AFK	ETF	23.5595	23.62	23.53	23.5817	3166.0
2017-10-20	AFTY	ETF	17.62	17.62	17.447	17.473	2900.0
2017-10-20	AGG	ETF	109.32	109.41	109.26	109.3	2014200.0
2017-10-20	AGGY	ETF	50.66	50.754	50.66	50.72	20300.0
2017-10-20	AGNG	ETF	19.77	19.85	19.75	19.85	10600.0
2017-10-20	AGQ	ETF	35.01	35.28	34.2	34.61	97800.0
2017-10-20	AGZ	ETF	113.31	113.4	113.31	113.34	15443.0
2017-10-20	AGZD	ETF	24.055	24.115	24.05	24.055	4000.0
2017-10-20	AIA	ETF	63.87	63.87	63.67	63.76	37517.0
2017-10-20	AIEQ	ETF	25.61	25.61	25.35	25.39	592700.0
2017-10-20	AIRR	ETF	26.232	26.39	26.17	26.37	33200.0
2017-10-20	AIVI	ETF	42.87	42.91	42.81	42.86	8500.0
2017-10-20	ALTY	ETF	15.71	15.71	15.655	15.655	2000.0
2017-10-20	AMJ	ETF	27.43	27.49	27.27	27.29	2240239.0
2017-10-20	AMLP	ETF	54.6	54.65	53.95	54.0	2549860.0
2017-10-20	AMZA	ETF	85.7	85.7	84.7	84.9	106820.0
2017-10-20	ANGL	ETF	30.36	30.37	30.32	30.34	234100.0
2017-10-20	AOA	ETF	54.27	54.3	54.16	54.26	38400.0
2017-10-20	AOK	ETF	34.66	34.66	34.57	34.64	53019.0
2017-10-20	AOM	ETF	38.18	38.18	38.0801	38.14	57593.0
2017-10-20	AOR	ETF	45.25	45.25	45.1514	45.22	37889.0
2017-10-20	ARCM	ETF	100.2	100.2	100.2	100.2	200.0
2017-10-20	ARGT	ETF	31.44	31.52	31.33	31.42	82500.0
2017-10-20	ARKG	ETF	26.3	26.68	26.3	26.51	25300.0
2017-10-20	ARKK	ETF	34.64	34.989	34.623	34.84	76100.0
2017-10-20	ARKQ	ETF	32.55	32.995	32.55	32.9	28200.0
2017-10-20	ARKW	ETF	41.59	41.96	41.55	41.77	56200.0
2017-10-20	ASET	ETF	28.3417	28.37	28.33	28.36	20152.0
2017-10-20	ASHR	ETF	30.08	30.1	30.03	30.07	498300.0
2017-10-20	ASHS	ETF	36.03	36.24	36.03	36.24	9100.0
2017-10-20	ASHX	ETF	22.1	22.17	22.1	22.16	6710.0
2017-10-20	ATMP	ETF	20.82	20.85	20.64	20.64	39800.0
2017-10-20	BAB	ETF	30.48	30.51	30.3968	30.43	116788.0
2017-10-20	BAL	ETF	44.37	44.37	44.0111	44.11	19655.0
2017-10-20	BAR	ETF	12.794	12.817	12.794	12.813	7870.0

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

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