PREVIEW / etf_daily / 2017-05-15

all etf daily files

  file:    by_date/etf_daily/2017/2017-05-15.parquet
  size:    55 KB
  rows:    1,397

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-05-15	SPY	ETF	239.47	240.44	239.45	240.3	61918900.0
2017-05-15	QQQ	ETF	138.63	139.12	138.53	139.04	20481327.0
2017-05-15	IWM	ETF	137.98	139.25	137.98	138.58	31132200.0
2017-05-15	DIA	ETF	209.4	210.13	209.4	209.93	1818500.0
2017-05-15	GLD	ETF	117.52	117.54	116.99	117.14	5019600.0
2017-05-15	TLT	ETF	121.06	121.21	120.75	121.06	5173200.0
2017-05-15	AADR	ETF	51.25	51.25	48.93	49.17	30600.0
2017-05-15	AAXJ	ETF	66.23	66.43	66.15	66.43	1104600.0
2017-05-15	ACSI	ETF	28.48	28.48	28.43	28.43	4869.0
2017-05-15	ACTX	ETF	72.5707	74.3407	70.8006	72.5707	458.0
2017-05-15	ACWF	ETF	26.69	26.83	26.69	26.7577	2381.0
2017-05-15	ACWI	ETF	65.23	65.41	65.18	65.37	1258500.0
2017-05-15	ACWV	ETF	78.78	78.96	78.63	78.83	1590800.0
2017-05-15	ACWX	ETF	45.67	45.81	45.67	45.79	265179.0
2017-05-15	ADRE	ETF	38.99	38.99	38.6548	38.81	13501.0
2017-05-15	AFK	ETF	21.48	21.6	21.0201	21.0926	2604.0
2017-05-15	AFTY	ETF	14.0	14.025	13.99	14.0	17500.0
2017-05-15	AGG	ETF	108.85	108.94	108.82	108.88	1771000.0
2017-05-15	AGGY	ETF	50.24	50.27	50.15	50.25	28300.0
2017-05-15	AGNG	ETF	17.71	17.71	17.71	17.71	100.0
2017-05-15	AGQ	ETF	34.74	34.77	34.07	34.14	261100.0
2017-05-15	AGZ	ETF	113.23	113.37	113.23	113.36	8766.0
2017-05-15	AGZD	ETF	24.1	24.12	24.01	24.085	2200.0
2017-05-15	AIA	ETF	55.95	56.18	55.84	56.18	27330.0
2017-05-15	AIQ	ETF	13.15	13.2	13.1	13.15	13169.0
2017-05-15	AIRR	ETF	23.74	24.01	23.74	23.9	18700.0
2017-05-15	AIVI	ETF	40.99	41.09	40.99	41.05	12900.0
2017-05-15	ALTY	ETF	15.49	15.495	15.372	15.435	1300.0
2017-05-15	AMJ	ETF	31.8	31.83	31.502	31.6	1015754.0
2017-05-15	AMLP	ETF	62.1	62.1	61.35	61.5	1467000.0
2017-05-15	AMZA	ETF	105.5	105.7	104.5	105.4	148960.0
2017-05-15	ANGL	ETF	29.69	29.7	29.6	29.64	796600.0
2017-05-15	AOA	ETF	51.25	51.28	51.13	51.25	62500.0
2017-05-15	AOK	ETF	33.69	33.75	33.6896	33.75	40803.0
2017-05-15	AOM	ETF	36.91	36.95	36.86	36.87	89235.0
2017-05-15	AOR	ETF	43.16	43.2399	43.16	43.18	59804.0
2017-05-15	ARCM	ETF	100.05	100.05	100.05	100.05	2000.0
2017-05-15	ARGT	ETF	30.69	30.97	30.69	30.96	150000.0
2017-05-15	ARKG	ETF	20.51	20.72	20.42	20.65	5600.0
2017-05-15	ARKK	ETF	26.88	27.005	26.64	26.95	48600.0
2017-05-15	ARKQ	ETF	28.54	28.54	28.19	28.43	118900.0
2017-05-15	ARKW	ETF	32.21	32.34	32.11	32.34	13400.0
2017-05-15	ASEA	ETF	14.93	14.93	14.85	14.93	7300.0
2017-05-15	ASHR	ETF	24.6	24.65	24.58	24.63	644300.0
2017-05-15	ASHS	ETF	30.76	30.92	30.76	30.85	22400.0
2017-05-15	ASHX	ETF	19.1237	19.14	19.1143	19.1143	2511.0
2017-05-15	ATMP	ETF	23.03	23.44	23.03	23.27	216700.0
2017-05-15	BAB	ETF	29.37	29.434	29.35	29.42	64071.0
2017-05-15	BAL	ETF	56.22	56.4499	52.9976	54.62	43987.0
2017-05-15	BBC	ETF	22.31	22.482	22.25	22.273	6603.0

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

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