PREVIEW / etf_daily / 2017-03-24

all etf daily files

  file:    by_date/etf_daily/2017/2017-03-24.parquet
  size:    54 KB
  rows:    1,370

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-03-24	SPY	ETF	234.38	235.04	232.96	233.86	112504900.0
2017-03-24	QQQ	ETF	130.78	131.29	130.13	130.63	22967566.0
2017-03-24	IWM	ETF	134.95	135.47	133.86	134.49	33514400.0
2017-03-24	DIA	ETF	206.58	206.9	205.0	205.75	4052700.0
2017-03-24	GLD	ETF	118.5	119.21	118.39	118.86	6879600.0
2017-03-24	TLT	ETF	120.53	121.1	120.4	120.88	5819600.0
2017-03-24	AADR	ETF	46.33	46.7	46.28	46.6	12400.0
2017-03-24	AAXJ	ETF	63.26	63.44	63.17	63.31	512600.0
2017-03-24	ACSI	ETF	27.7	27.7	27.61	27.61	2669.0
2017-03-24	ACTX	ETF	103.2509	106.201	97.3509	98.5309	1168.0
2017-03-24	ACWF	ETF	25.88	25.88	25.84	25.84	7350.0
2017-03-24	ACWI	ETF	63.09	63.28	62.92	63.08	1503500.0
2017-03-24	ACWV	ETF	77.41	77.58	77.26	77.38	189200.0
2017-03-24	ACWX	ETF	43.59	43.7	43.54	43.62	1047862.0
2017-03-24	ADRE	ETF	36.47	36.61	36.4274	36.61	2148.0
2017-03-24	AFK	ETF	21.49	21.49	21.2	21.2	6431.0
2017-03-24	AGG	ETF	108.35	108.51	108.31	108.36	3374900.0
2017-03-24	AGGY	ETF	49.74	49.86	49.74	49.83	8400.0
2017-03-24	AGNG	ETF	16.899	16.899	16.846	16.846	2400.0
2017-03-24	AGQ	ETF	38.74	39.39	38.66	39.25	158200.0
2017-03-24	AGZ	ETF	113.18	113.56	112.93	113.05	99093.0
2017-03-24	AGZD	ETF	24.075	24.075	24.055	24.055	5600.0
2017-03-24	AIA	ETF	53.05	53.1	52.93	53.02	16077.0
2017-03-24	AIQ	ETF	10.1	10.15	9.9	10.1	25444.0
2017-03-24	AIRR	ETF	23.24	23.37	23.036	23.1	25800.0
2017-03-24	AIVI	ETF	39.67	39.78	39.65	39.68	8700.0
2017-03-24	ALTY	ETF	15.355	15.425	15.3	15.3	1500.0
2017-03-24	AMJ	ETF	31.55	31.93	31.55	31.61	1102771.0
2017-03-24	AMLP	ETF	62.85	63.05	62.75	62.75	1185340.0
2017-03-24	AMZA	ETF	109.5	110.2	109.0	109.8	50700.0
2017-03-24	ANGL	ETF	29.08	29.18	29.04	29.12	255300.0
2017-03-24	AOA	ETF	49.76	49.85	49.62	49.76	40100.0
2017-03-24	AOK	ETF	33.18	33.25	33.16	33.23	52707.0
2017-03-24	AOM	ETF	36.23	36.34	36.2	36.29	188847.0
2017-03-24	AOR	ETF	42.26	42.31	42.1646	42.25	69142.0
2017-03-24	ARGT	ETF	27.42	27.63	27.28	27.6	140200.0
2017-03-24	ARKG	ETF	20.02	20.09	20.0	20.07	1400.0
2017-03-24	ARKK	ETF	23.2	23.2	23.16	23.16	1000.0
2017-03-24	ARKQ	ETF	24.05	24.13	23.96	24.01	10200.0
2017-03-24	ARKW	ETF	28.2	28.345	28.093	28.229	3900.0
2017-03-24	ASEA	ETF	14.04	14.06	14.03	14.06	3900.0
2017-03-24	ASET	ETF	26.39	26.4226	26.39	26.418	816.0
2017-03-24	ASHR	ETF	25.37	25.48	25.32	25.4	661000.0
2017-03-24	ASHS	ETF	34.52	34.6	34.46	34.5	7400.0
2017-03-24	ASHX	ETF	19.44	19.44	19.44	19.44	388.0
2017-03-24	ATMP	ETF	23.14	23.45	23.13	23.35	32100.0
2017-03-24	BAB	ETF	29.4	29.44	29.35	29.43	186139.0
2017-03-24	BAL	ETF	50.63	50.77	50.2308	50.31	2400.0
2017-03-24	BBC	ETF	22.97	23.0045	22.84	22.97	5883.0
2017-03-24	BBH	ETF	117.31	118.16	117.21	117.8	16900.0

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

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