PREVIEW / etf_daily / 2015-12-17

all etf daily files

  file:    by_date/etf_daily/2015/2015-12-17.parquet
  size:    50 KB
  rows:    1,241

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
2015-12-17	SPY	ETF	208.4	208.48	204.84	204.86	173092500.0
2015-12-17	QQQ	ETF	114.46	114.48	112.3	112.32	45668795.0
2015-12-17	IWM	ETF	114.91	114.94	112.97	113.21	41318000.0
2015-12-17	DIA	ETF	178.15	178.19	175.09	175.1	8504100.0
2015-12-17	GLD	ETF	100.92	100.99	100.23	100.5	10156200.0
2015-12-17	TLT	ETF	121.78	122.78	121.64	122.55	9923000.0
2015-12-17	AADR	ETF	38.32	38.32	38.29	38.29	700.0
2015-12-17	AAXJ	ETF	54.78	54.78	54.08	54.09	785600.0
2015-12-17	ACTX	ETF	7.6701	9.4401	7.5521	8.2601	3342.0
2015-12-17	ACWF	ETF	23.206	23.206	23.1	23.19	5618.0
2015-12-17	ACWI	ETF	57.21	57.22	56.36	56.36	8454900.0
2015-12-17	ACWV	ETF	70.49	70.58	69.68	69.68	172300.0
2015-12-17	ACWX	ETF	40.27	40.27	39.75	39.75	2414542.0
2015-12-17	ADRE	ETF	30.29	30.29	29.84	29.99	9325.0
2015-12-17	AFK	ETF	17.99	17.99	17.7525	17.77	7378.0
2015-12-17	AFTY	ETF	16.79	16.79	16.43	16.48	184800.0
2015-12-17	AGG	ETF	108.24	108.3	108.02	108.15	5407800.0
2015-12-17	AGQ	ETF	27.24	27.35	26.55	26.67	191800.0
2015-12-17	AGZ	ETF	112.87	113.22	112.74	113.2	1238473.0
2015-12-17	AGZD	ETF	24.035	24.035	23.98	24.015	6800.0
2015-12-17	AIA	ETF	43.63	43.63	43.21	43.21	32136.0
2015-12-17	AIQ	ETF	8.92	9.27	8.79	9.09	40627.0
2015-12-17	AIRR	ETF	16.94	16.94	16.68	16.69	4800.0
2015-12-17	AIVI	ETF	38.36	38.36	37.94	37.94	52500.0
2015-12-17	ALTY	ETF	13.81	13.81	13.741	13.75	300.0
2015-12-17	AMJ	ETF	25.95	26.175	24.83	25.23	8163054.0
2015-12-17	AMLP	ETF	52.95	53.25	50.55	51.8	4827300.0
2015-12-17	AMZA	ETF	91.91	95.4	91.5	92.7	2650.0
2015-12-17	ANGL	ETF	24.67	24.67	24.13	24.31	15400.0
2015-12-17	AOA	ETF	45.64	45.64	45.06	45.09	237600.0
2015-12-17	AOK	ETF	31.9	31.9	31.7	31.72	95940.0
2015-12-17	AOM	ETF	34.5	34.53	34.2303	34.25	442191.0
2015-12-17	AOR	ETF	39.28	39.44	38.99	38.99	603478.0
2015-12-17	ARGT	ETF	17.76	17.99	17.74	17.91	57400.0
2015-12-17	ARKG	ETF	20.48	20.48	20.47	20.47	200.0
2015-12-17	ARKK	ETF	20.84	21.11	20.84	20.993	600.0
2015-12-17	ARKQ	ETF	19.58	19.58	19.58	19.58	100.0
2015-12-17	ARKW	ETF	23.907	23.907	23.577	23.577	2200.0
2015-12-17	ASEA	ETF	12.54	12.63	12.54	12.55	1800.0
2015-12-17	ASET	ETF	24.44	24.44	24.35	24.35	700.0
2015-12-17	ASHR	ETF	28.75	28.77	28.27	28.3	981200.0
2015-12-17	ASHS	ETF	43.1	43.1	42.15	42.86	270400.0
2015-12-17	ASHX	ETF	25.7757	25.78	25.7757	25.78	350.0
2015-12-17	ATMP	ETF	17.07	17.17	16.35	16.56	397900.0
2015-12-17	BAB	ETF	29.08	29.17	29.0115	29.11	92844.0
2015-12-17	BAL	ETF	41.901	41.905	41.83	41.89	4380.0
2015-12-17	BBC	ETF	29.39	29.8499	29.0	29.444	5538.0
2015-12-17	BBH	ETF	126.62	126.88	124.26	124.47	49000.0
2015-12-17	BBP	ETF	30.778	30.787	30.24	30.43	4200.0
2015-12-17	BCM	ETF	23.17	23.47	23.17	23.45	3048.0

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

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