PREVIEW / etf_daily / 2017-03-21

all etf daily files

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

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-21	SPY	ETF	237.47	237.61	233.58	233.73	131809300.0
2017-03-21	QQQ	ETF	132.31	132.43	129.73	129.81	35841897.0
2017-03-21	IWM	ETF	138.51	138.6	133.92	133.97	61869000.0
2017-03-21	DIA	ETF	209.33	209.43	206.25	206.35	6192400.0
2017-03-21	GLD	ETF	117.77	118.8	117.76	118.54	9567900.0
2017-03-21	TLT	ETF	119.05	120.3	119.02	120.14	12540700.0
2017-03-21	AADR	ETF	46.48	46.48	45.85	45.9	5700.0
2017-03-21	AAXJ	ETF	63.72	63.85	62.83	62.9	1667900.0
2017-03-21	ACSI	ETF	27.906	27.906	27.61	27.61	1306.0
2017-03-21	ACTX	ETF	104.4309	106.26	97.6459	100.8909	1961.0
2017-03-21	ACWF	ETF	26.22	26.22	25.72	25.76	2514.0
2017-03-21	ACWI	ETF	63.79	63.87	62.86	62.91	2535600.0
2017-03-21	ACWV	ETF	77.62	77.67	77.1	77.19	161000.0
2017-03-21	ACWX	ETF	43.9	43.95	43.3	43.33	627987.0
2017-03-21	ADRE	ETF	37.1	37.1	36.1501	36.3664	15255.0
2017-03-21	AFK	ETF	21.62	21.62	21.2	21.2	8235.0
2017-03-21	AFTY	ETF	13.58	13.817	13.58	13.817	800.0
2017-03-21	AGG	ETF	107.93	108.27	107.93	108.27	2049700.0
2017-03-21	AGGY	ETF	49.583	49.779	49.583	49.77	12300.0
2017-03-21	AGNG	ETF	16.628	16.628	16.628	16.628	200.0
2017-03-21	AGQ	ETF	38.27	38.57	38.14	38.25	165700.0
2017-03-21	AGZ	ETF	112.57	113.03	112.57	112.9499	23827.0
2017-03-21	AGZD	ETF	24.055	24.065	24.05	24.065	2400.0
2017-03-21	AIA	ETF	53.78	53.78	52.9473	52.9473	22817.0
2017-03-21	AIQ	ETF	10.15	10.25	10.1	10.1	4519.0
2017-03-21	AIRR	ETF	23.81	23.81	23.01	23.01	77400.0
2017-03-21	AIVI	ETF	39.94	40.0	39.48	39.48	28600.0
2017-03-21	ALTY	ETF	15.47	15.49	15.3	15.3	10700.0
2017-03-21	AMJ	ETF	31.79	31.87	31.23	31.48	2516605.0
2017-03-21	AMLP	ETF	63.1	63.35	62.25	62.55	1099480.0
2017-03-21	AMZA	ETF	109.6	109.9	107.8	108.6	73480.0
2017-03-21	ANGL	ETF	29.22	29.25	28.96	28.96	907100.0
2017-03-21	AOA	ETF	50.1	50.18	49.55	49.58	60900.0
2017-03-21	AOK	ETF	33.27	33.27	33.09	33.09	33967.0
2017-03-21	AOM	ETF	36.39	36.4	36.1644	36.22	66007.0
2017-03-21	AOR	ETF	42.48	42.48	42.1	42.15	55705.0
2017-03-21	ARGT	ETF	27.64	27.86	27.06	27.06	112600.0
2017-03-21	ARKG	ETF	20.88	20.88	19.89	19.89	15600.0
2017-03-21	ARKK	ETF	23.79	23.79	23.039	23.039	10600.0
2017-03-21	ARKQ	ETF	24.49	24.511	23.76	23.76	8400.0
2017-03-21	ARKW	ETF	28.84	28.84	28.135	28.135	5300.0
2017-03-21	ASEA	ETF	14.01	14.01	13.9	13.98	2200.0
2017-03-21	ASET	ETF	26.47	26.47	26.19	26.1963	3347.0
2017-03-21	ASHR	ETF	25.07	25.17	25.06	25.11	859900.0
2017-03-21	ASHS	ETF	34.28	34.28	34.14	34.14	37500.0
2017-03-21	ATMP	ETF	23.39	23.39	22.96	23.18	74500.0
2017-03-21	BAB	ETF	29.23	29.36	29.17	29.35	136206.0
2017-03-21	BAL	ETF	50.0	50.01	49.8701	49.95	4158.0
2017-03-21	BBC	ETF	24.31	24.31	22.44	22.53	39500.0
2017-03-21	BBH	ETF	119.61	119.98	116.97	117.0	114000.0

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

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