PREVIEW / etf_daily / 2017-04-26

all etf daily files

  file:    by_date/etf_daily/2017/2017-04-26.parquet
  size:    55 KB
  rows:    1,380

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-04-26	SPY	ETF	238.51	239.53	238.35	238.4	84702500.0
2017-04-26	QQQ	ETF	135.17	135.51	134.86	134.94	25398542.0
2017-04-26	IWM	ETF	140.17	141.82	140.13	140.99	41669200.0
2017-04-26	DIA	ETF	209.81	210.43	209.44	209.47	2865300.0
2017-04-26	GLD	ETF	120.21	120.96	119.87	120.84	9758800.0
2017-04-26	TLT	ETF	121.52	122.14	121.43	122.12	5766200.0
2017-04-26	AADR	ETF	47.0	50.03	47.0	47.5	37300.0
2017-04-26	AAXJ	ETF	64.25	64.36	64.14	64.17	1639100.0
2017-04-26	ACSI	ETF	28.545	28.545	28.48	28.48	331.0
2017-04-26	ACTX	ETF	93.2208	93.2208	85.5508	88.5008	537.0
2017-04-26	ACWF	ETF	26.3112	26.325	26.3112	26.325	1378.0
2017-04-26	ACWI	ETF	64.34	64.57	64.28	64.28	1360900.0
2017-04-26	ACWV	ETF	78.09	78.3	78.04	78.05	96400.0
2017-04-26	ACWX	ETF	44.63	44.73	44.56	44.57	505165.0
2017-04-26	ADRE	ETF	37.17	37.17	36.9802	37.0537	9512.0
2017-04-26	AFK	ETF	21.24	21.24	21.1	21.19	9509.0
2017-04-26	AFTY	ETF	13.67	13.67	13.65	13.65	200.0
2017-04-26	AGG	ETF	108.85	108.97	108.77	108.96	2893700.0
2017-04-26	AGGY	ETF	49.99	50.1	49.96	50.1	21800.0
2017-04-26	AGQ	ETF	38.0	38.03	37.16	37.92	255500.0
2017-04-26	AGZ	ETF	113.16	113.45	113.16	113.43	10239.0
2017-04-26	AGZD	ETF	23.97	23.975	23.96	23.97	3400.0
2017-04-26	AIA	ETF	53.34	53.53	53.34	53.34	42673.0
2017-04-26	AIQ	ETF	13.05	13.15	13.05	13.1	20488.0
2017-04-26	AIRR	ETF	24.825	24.954	24.77	24.8	36800.0
2017-04-26	AIVI	ETF	39.94	40.01	39.91	39.97	8700.0
2017-04-26	ALTY	ETF	15.663	15.79	15.663	15.79	3000.0
2017-04-26	AMJ	ETF	32.21	32.32	32.1	32.13	1529376.0
2017-04-26	AMLP	ETF	63.45	63.6	63.3	63.45	955860.0
2017-04-26	AMZA	ETF	106.8	106.8	106.0	106.4	43900.0
2017-04-26	ANGL	ETF	29.68	29.68	29.58	29.6	312200.0
2017-04-26	AOA	ETF	50.62	50.73	50.53	50.61	203900.0
2017-04-26	AOK	ETF	33.57	33.61	33.5345	33.6	49844.0
2017-04-26	AOM	ETF	36.61	36.707	36.6	36.64	201019.0
2017-04-26	AOR	ETF	42.81	42.87	42.74	42.81	92358.0
2017-04-26	ARCM	ETF	100.0	100.0	100.0	100.0	3500.0
2017-04-26	ARGT	ETF	29.01	29.01	28.75	28.76	40200.0
2017-04-26	ARKG	ETF	20.66	20.9	20.634	20.87	7900.0
2017-04-26	ARKK	ETF	25.11	25.38	25.052	25.33	14300.0
2017-04-26	ARKQ	ETF	26.11	26.32	25.97	26.24	66800.0
2017-04-26	ARKW	ETF	30.4	30.449	30.319	30.372	3400.0
2017-04-26	ASEA	ETF	14.5	14.5	14.32	14.48	5300.0
2017-04-26	ASET	ETF	27.02	27.05	26.9998	26.9998	2232.0
2017-04-26	ASHR	ETF	24.81	24.89	24.81	24.84	249900.0
2017-04-26	ASHS	ETF	32.4	32.4	32.32	32.36	3800.0
2017-04-26	ASHX	ETF	19.31	19.33	19.31	19.33	650.0
2017-04-26	ATMP	ETF	23.85	23.9	23.74	23.75	22600.0
2017-04-26	BAB	ETF	29.36	29.41	29.33	29.41	65328.0
2017-04-26	BAL	ETF	50.59	50.779	50.23	50.38	15513.0
2017-04-26	BBC	ETF	22.7394	22.9399	22.7394	22.9399	4132.0

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

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