PREVIEW / etf_daily / 2015-12-22

all etf daily files

  file:    by_date/etf_daily/2015/2015-12-22.parquet
  size:    49 KB
  rows:    1,224

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-22	SPY	ETF	202.72	203.85	201.55	203.5	111026200.0
2015-12-22	QQQ	ETF	111.65	111.94	111.05	111.78	26540310.0
2015-12-22	IWM	ETF	112.64	113.52	111.79	113.35	28108700.0
2015-12-22	DIA	ETF	173.1	174.28	172.18	174.01	6003700.0
2015-12-22	GLD	ETF	103.09	103.2	102.56	102.61	4123500.0
2015-12-22	TLT	ETF	122.65	122.8	121.99	122.31	5445800.0
2015-12-22	AADR	ETF	38.07	38.62	37.95	38.55	4400.0
2015-12-22	AAXJ	ETF	53.83	54.05	53.65	53.94	1684100.0
2015-12-22	ACTX	ETF	8.2601	8.8501	7.6701	7.6701	1026.0
2015-12-22	ACWF	ETF	23.1099	23.1099	23.0699	23.0699	200.0
2015-12-22	ACWI	ETF	55.53	55.84	55.28	55.74	4090600.0
2015-12-22	ACWV	ETF	68.78	69.2	68.57	69.12	580000.0
2015-12-22	ACWX	ETF	39.41	39.65	39.28	39.64	7067419.0
2015-12-22	ADRE	ETF	29.32	29.59	29.32	29.57	175268.0
2015-12-22	AFK	ETF	17.71	17.79	17.64	17.7	103591.0
2015-12-22	AFTY	ETF	14.946	15.02	14.946	15.0	13300.0
2015-12-22	AGG	ETF	108.27	108.28	108.12	108.2	4507600.0
2015-12-22	AGGY	ETF	49.12	49.12	49.12	49.12	100.0
2015-12-22	AGQ	ETF	29.14	29.16	28.79	28.86	88000.0
2015-12-22	AGZ	ETF	113.3	113.346	113.0001	113.1599	58708.0
2015-12-22	AGZD	ETF	23.865	23.975	23.82	23.975	7600.0
2015-12-22	AIA	ETF	42.51	42.8683	42.51	42.85	29236.0
2015-12-22	AIQ	ETF	9.07	9.15	8.93	9.0	25366.0
2015-12-22	AIRR	ETF	16.39	16.57	16.32	16.55	14600.0
2015-12-22	AIVI	ETF	37.58	37.76	37.45	37.67	51800.0
2015-12-22	AMJ	ETF	26.51	27.945	26.2	27.46	9475325.0
2015-12-22	AMLP	ETF	54.4	57.9	54.15	56.7	5499760.0
2015-12-22	AMZA	ETF	99.2	107.8	98.64	103.6	6320.0
2015-12-22	ANGL	ETF	24.25	24.39	24.15	24.39	87500.0
2015-12-22	AOA	ETF	45.07	45.17	44.81	45.12	263000.0
2015-12-22	AOK	ETF	31.7	31.75	31.65	31.75	166684.0
2015-12-22	AOM	ETF	34.14	34.27	34.1287	34.26	1070987.0
2015-12-22	AOR	ETF	39.04	39.0699	38.84	39.04	451537.0
2015-12-22	ARGT	ETF	18.0	18.02	17.81	18.02	31600.0
2015-12-22	ARKG	ETF	20.5	20.5	20.5	20.5	100.0
2015-12-22	ARKK	ETF	20.96	20.96	20.96	20.96	100.0
2015-12-22	ARKQ	ETF	19.45	19.45	19.45	19.45	200.0
2015-12-22	ARKW	ETF	23.59	23.59	23.433	23.52	2000.0
2015-12-22	ASEA	ETF	12.5	12.56	12.49	12.54	2300.0
2015-12-22	ASET	ETF	24.3	24.34	24.25	24.34	8100.0
2015-12-22	ASHR	ETF	29.57	29.82	29.39	29.76	1560000.0
2015-12-22	ASHS	ETF	44.8	44.8	43.74	44.12	130300.0
2015-12-22	ASHX	ETF	26.55	26.72	26.55	26.72	509.0
2015-12-22	ATMP	ETF	17.3	18.11	16.84	17.65	408800.0
2015-12-22	BAB	ETF	29.02	29.0899	28.92	28.94	119804.0
2015-12-22	BAL	ETF	42.06	42.0847	41.9805	42.0	1083.0
2015-12-22	BBC	ETF	29.17	29.4308	28.89	29.1	9803.0
2015-12-22	BBH	ETF	124.47	124.92	123.51	124.64	34700.0
2015-12-22	BBP	ETF	30.23	30.716	30.23	30.57	12400.0
2015-12-22	BCM	ETF	23.68	23.69	23.53	23.53	42380.0

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

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