PREVIEW / etf_daily / 2017-12-18

all etf daily files

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

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-18	SPY	ETF	268.1	268.6	267.98	268.2	83653600.0
2017-12-18	QQQ	ETF	158.29	158.77	158.07	158.64	26844519.0
2017-12-18	IWM	ETF	153.67	154.72	153.46	154.3	22714300.0
2017-12-18	DIA	ETF	248.01	248.54	247.53	247.79	3285700.0
2017-12-18	GLD	ETF	119.63	119.99	119.6	119.73	5452200.0
2017-12-18	TLT	ETF	127.97	128.0	126.91	127.18	7239700.0
2017-12-18	AADR	ETF	57.83	58.37	57.83	58.26	40300.0
2017-12-18	AAXJ	ETF	75.79	76.05	75.77	75.88	1889900.0
2017-12-18	ACSI	ETF	31.43	31.49	31.43	31.45	1382.0
2017-12-18	ACTX	ETF	86.4358	88.5008	70.8006	79.5917	787.0
2017-12-18	ACWF	ETF	30.82	30.88	30.7785	30.8	3266.0
2017-12-18	ACWI	ETF	72.54	72.76	72.54	72.63	2077200.0
2017-12-18	ACWV	ETF	85.19	85.34	85.0	85.08	92700.0
2017-12-18	ACWX	ETF	49.96	50.14	49.93	50.01	753952.0
2017-12-18	ADRE	ETF	42.5	42.629	42.29	42.57	13015.0
2017-12-18	AFK	ETF	24.53	24.6414	24.17	24.18	21087.0
2017-12-18	AFTY	ETF	17.08	17.13	17.05	17.074	10900.0
2017-12-18	AGG	ETF	109.47	109.47	109.25	109.33	4474300.0
2017-12-18	AGGY	ETF	50.86	50.86	50.742	50.79	57200.0
2017-12-18	AGNG	ETF	19.67	19.67	19.612	19.623	6600.0
2017-12-18	AGQ	ETF	30.81	30.96	30.66	30.74	157800.0
2017-12-18	AGZ	ETF	113.28	113.39	113.22	113.3	20484.0
2017-12-18	AGZD	ETF	24.245	24.245	24.125	24.155	5400.0
2017-12-18	AIA	ETF	65.35	65.5975	65.35	65.45	30030.0
2017-12-18	AIEQ	ETF	25.87	26.0	25.82	25.98	65700.0
2017-12-18	AIRR	ETF	27.03	27.4	27.03	27.355	21800.0
2017-12-18	AIVI	ETF	43.27	43.47	43.27	43.32	18500.0
2017-12-18	ALTY	ETF	15.412	15.42	15.342	15.383	12100.0
2017-12-18	AMJ	ETF	27.36	27.83	27.33	27.53	4723497.0
2017-12-18	AMLP	ETF	54.1	55.0	53.95	54.25	3844160.0
2017-12-18	AMUB	ETF	17.38	17.38	17.38	17.38	1500.0
2017-12-18	AMZA	ETF	86.2	87.5	85.51	86.3	107350.0
2017-12-18	ANGL	ETF	30.05	30.06	29.92	29.93	626000.0
2017-12-18	AOA	ETF	55.68	55.88	55.56	55.82	61700.0
2017-12-18	AOK	ETF	34.69	34.7	34.6063	34.66	639613.0
2017-12-18	AOM	ETF	38.77	38.79	38.66	38.74	357232.0
2017-12-18	AOR	ETF	46.19	46.26	46.1671	46.23	210399.0
2017-12-18	ARGT	ETF	35.07	35.19	34.99	35.12	123300.0
2017-12-18	ARKG	ETF	24.87	24.87	24.4	24.577	52100.0
2017-12-18	ARKK	ETF	39.15	39.956	39.08	39.94	924600.0
2017-12-18	ARKQ	ETF	35.1	35.36	35.0	35.34	73500.0
2017-12-18	ARKW	ETF	49.12	50.5	49.074	50.46	480600.0
2017-12-18	ASEA	ETF	16.89	16.97	16.73	16.85	3700.0
2017-12-18	ASET	ETF	29.0	29.0	28.97	28.98	1075.0
2017-12-18	ASHR	ETF	30.45	30.46	30.37	30.38	513500.0
2017-12-18	ASHS	ETF	34.06	34.17	34.06	34.16	12400.0
2017-12-18	ASHX	ETF	22.5508	22.5508	22.4048	22.484	1694.0
2017-12-18	ATMP	ETF	20.69	20.96	20.69	20.73	132800.0
2017-12-18	BAB	ETF	30.77	30.77	30.65	30.68	83185.0
2017-12-18	BAL	ETF	50.49	50.49	49.78	49.82	5380.0

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

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