PREVIEW / etf_daily / 2017-12-20

all etf daily files

  file:    by_date/etf_daily/2017/2017-12-20.parquet
  size:    60 KB
  rows:    1,550

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-12-20	SPY	ETF	268.27	268.33	266.69	267.03	76751500.0
2017-12-20	QQQ	ETF	158.25	158.28	156.91	157.53	38972602.0
2017-12-20	IWM	ETF	153.75	153.94	152.84	153.38	19042800.0
2017-12-20	DIA	ETF	248.33	248.4	246.76	247.07	2401400.0
2017-12-20	GLD	ETF	119.98	120.36	119.81	120.14	5734600.0
2017-12-20	TLT	ETF	124.31	124.71	123.95	124.14	10005800.0
2017-12-20	AADR	ETF	58.67	58.67	58.37	58.59	33200.0
2017-12-20	AAXJ	ETF	74.8	74.81	74.55	74.6	883000.0
2017-12-20	ACSI	ETF	31.3169	31.3169	31.29	31.29	3217.0
2017-12-20	ACTX	ETF	75.2257	79.6507	67.8506	79.0017	789.0
2017-12-20	ACWF	ETF	30.4	30.4599	30.4	30.425	952.0
2017-12-20	ACWI	ETF	71.98	71.98	71.6	71.68	2557600.0
2017-12-20	ACWV	ETF	83.92	83.92	83.63	83.69	73000.0
2017-12-20	ACWX	ETF	49.44	49.45	49.275	49.29	553530.0
2017-12-20	ADRE	ETF	42.62	42.62	42.35	42.41	5721.0
2017-12-20	AFK	ETF	24.6	24.6	24.4001	24.59	8095.0
2017-12-20	AFTY	ETF	17.54	17.54	17.44	17.48	15700.0
2017-12-20	AGG	ETF	108.75	108.88	108.71	108.76	4002500.0
2017-12-20	AGGY	ETF	50.48	50.55	50.455	50.48	88700.0
2017-12-20	AGNG	ETF	19.432	19.56	19.432	19.475	3100.0
2017-12-20	AGQ	ETF	31.0	31.23	30.9	30.93	70000.0
2017-12-20	AGZ	ETF	112.85	113.0	112.85	112.9	12469.0
2017-12-20	AGZD	ETF	24.135	24.235	24.12	24.235	16400.0
2017-12-20	AIA	ETF	65.44	65.6007	65.13	65.4	516691.0
2017-12-20	AIEQ	ETF	26.0	26.0	25.87	25.93	62700.0
2017-12-20	AIRR	ETF	27.25	27.439	27.25	27.4	25500.0
2017-12-20	AIVI	ETF	43.24	43.28	43.14	43.15	5700.0
2017-12-20	ALTY	ETF	15.286	15.302	15.25	15.27	4000.0
2017-12-20	AMJ	ETF	27.16	27.23	26.7813	27.05	4798808.0
2017-12-20	AMLP	ETF	53.85	53.9	52.85	53.7	5835060.0
2017-12-20	AMZA	ETF	85.4	85.4	83.7	84.9	122010.0
2017-12-20	ANGL	ETF	29.97	29.98	29.84	29.88	249500.0
2017-12-20	AOA	ETF	55.73	55.73	55.5	55.58	60500.0
2017-12-20	AOK	ETF	34.57	34.57	34.46	34.5016	112195.0
2017-12-20	AOM	ETF	38.67	38.69	38.53	38.53	253261.0
2017-12-20	AOR	ETF	46.16	46.16	45.98	45.98	184664.0
2017-12-20	ARGT	ETF	35.56	35.56	35.08	35.42	75000.0
2017-12-20	ARKG	ETF	24.57	24.679	24.342	24.61	39000.0
2017-12-20	ARKK	ETF	39.29	39.29	38.0	38.33	449000.0
2017-12-20	ARKQ	ETF	34.96	34.96	34.31	34.42	42900.0
2017-12-20	ARKW	ETF	49.4	49.4	47.71	47.98	323800.0
2017-12-20	ASEA	ETF	16.65	16.72	16.64	16.71	11500.0
2017-12-20	ASET	ETF	28.71	28.71	28.67	28.689	1737.0
2017-12-20	ASHR	ETF	30.58	30.64	30.55	30.62	634200.0
2017-12-20	ASHS	ETF	34.25	34.25	34.2	34.21	4100.0
2017-12-20	ASHX	ETF	22.53	22.75	22.5014	22.5014	6924.0
2017-12-20	ATMP	ETF	20.6	20.6	20.3	20.49	159300.0
2017-12-20	BAB	ETF	30.37	30.4332	30.35	30.39	150185.0
2017-12-20	BAL	ETF	50.05	50.3	50.05	50.3	1101.0
2017-12-20	BAR	ETF	12.651	12.651	12.648	12.648	5560.0

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

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