PREVIEW / etf_daily / 2018-02-16

all etf daily files

  file:    by_date/etf_daily/2018/2018-02-16.parquet
  size:    61 KB
  rows:    1,572

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
2018-02-16	SPY	ETF	272.32	275.32	272.27	273.11	160420100.0
2018-02-16	QQQ	ETF	165.18	166.755	164.6799	164.96	62256291.0
2018-02-16	IWM	ETF	152.61	154.29	152.54	153.34	27973900.0
2018-02-16	DIA	ETF	251.43	254.12	251.2	251.96	6399000.0
2018-02-16	GLD	ETF	128.3	128.7	127.57	127.96	7956900.0
2018-02-16	TLT	ETF	119.04	119.21	118.34	118.71	8454100.0
2018-02-16	AADR	ETF	60.73	61.46	60.38	60.79	55800.0
2018-02-16	AAXJ	ETF	78.88	79.61	78.7	78.93	658800.0
2018-02-16	ACSI	ETF	31.2799	31.34	31.26	31.26	5810.0
2018-02-16	ACTX	ETF	70.8006	73.7507	64.9006	67.1426	1416.0
2018-02-16	ACWF	ETF	31.67	31.9098	31.67	31.8065	12405.0
2018-02-16	ACWI	ETF	73.58	74.36	73.58	73.87	2834200.0
2018-02-16	ACWV	ETF	84.4	85.03	84.39	84.66	128900.0
2018-02-16	ACWX	ETF	50.86	51.31	50.86	51.0	371021.0
2018-02-16	ADRE	ETF	45.8	46.11	45.54	45.54	8875.0
2018-02-16	AFK	ETF	26.29	26.59	26.0601	26.17	18084.0
2018-02-16	AFTY	ETF	19.0	19.144	19.0	19.05	5700.0
2018-02-16	AGG	ETF	106.85	106.88	106.71	106.8	3648900.0
2018-02-16	AGGY	ETF	49.35	49.38	49.264	49.305	74700.0
2018-02-16	AGNG	ETF	20.315	20.39	20.23	20.345	3800.0
2018-02-16	AGQ	ETF	32.85	33.2	32.3	32.63	110800.0
2018-02-16	AGZ	ETF	111.57	111.57	111.44	111.46	9087.0
2018-02-16	AGZD	ETF	24.06	24.2	24.055	24.175	8000.0
2018-02-16	AIA	ETF	69.77	70.63	69.64	70.06	414730.0
2018-02-16	AIEQ	ETF	26.76	26.95	26.71	26.74	96300.0
2018-02-16	AIRR	ETF	26.14	26.67	26.14	26.57	22000.0
2018-02-16	AIVI	ETF	43.75	44.03	43.75	43.91	15000.0
2018-02-16	ALTY	ETF	15.04	15.04	14.785	14.79	4400.0
2018-02-16	AMJ	ETF	27.56	27.94	27.39	27.39	3840427.0
2018-02-16	AMLP	ETF	53.75	53.95	52.85	53.05	2644040.0
2018-02-16	AMZA	ETF	82.6	83.1	81.5	81.7	153540.0
2018-02-16	ANGL	ETF	29.45	29.63	29.45	29.62	609800.0
2018-02-16	AOA	ETF	54.4	54.84	54.4	54.61	82200.0
2018-02-16	AOK	ETF	34.29	34.53	34.29	34.43	75951.0
2018-02-16	AOM	ETF	37.92	38.145	37.9	38.06	125365.0
2018-02-16	AOR	ETF	45.11	45.372	45.0601	45.15	121462.0
2018-02-16	ARGT	ETF	36.73	37.25	36.73	36.85	100200.0
2018-02-16	ARKG	ETF	26.88	27.1	26.643	26.75	87800.0
2018-02-16	ARKK	ETF	41.1	41.45	40.91	41.06	286900.0
2018-02-16	ARKQ	ETF	35.15	35.27	34.791	34.94	29400.0
2018-02-16	ARKW	ETF	51.36	51.59	51.05	51.13	316200.0
2018-02-16	ASEA	ETF	17.86	17.98	17.86	17.97	1800.0
2018-02-16	ASET	ETF	27.88	27.88	27.83	27.88	2360.0
2018-02-16	ASHR	ETF	32.23	32.38	32.13	32.23	711300.0
2018-02-16	ASHS	ETF	34.31	34.31	33.95	34.08	12500.0
2018-02-16	ASHX	ETF	22.39	22.39	22.39	22.39	501.0
2018-02-16	ATMP	ETF	20.86	21.1	20.79	20.82	58500.0
2018-02-16	BAB	ETF	29.64	29.66	29.5742	29.6	49445.0
2018-02-16	BAL	ETF	50.2	50.48	50.2	50.48	2001.0
2018-02-16	BAR	ETF	13.473	13.473	13.47	13.47	13090.0

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

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