PREVIEW / etf_daily / 2016-04-15

all etf daily files

  file:    by_date/etf_daily/2016/2016-04-15.parquet
  size:    50 KB
  rows:    1,251

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
2016-04-15	SPY	ETF	208.01	208.17	207.4	207.78	75761600.0
2016-04-15	QQQ	ETF	110.83	111.055	110.36	110.64	21353343.0
2016-04-15	IWM	ETF	111.9	112.63	111.86	112.45	21176100.0
2016-04-15	DIA	ETF	178.99	179.14	178.41	178.68	3799900.0
2016-04-15	GLD	ETF	117.33	118.12	117.19	117.92	7838100.0
2016-04-15	TLT	ETF	131.29	132.16	131.25	131.88	5831100.0
2016-04-15	AADR	ETF	39.1	39.1	38.45	38.45	3300.0
2016-04-15	AAXJ	ETF	55.38	55.38	55.08	55.1	526800.0
2016-04-15	ACTX	ETF	5.31	5.31	3.54	4.72	1719.0
2016-04-15	ACWF	ETF	23.31	23.34	23.31	23.34	1157.0
2016-04-15	ACWI	ETF	56.92	57.01	56.83	56.9	2853400.0
2016-04-15	ACWV	ETF	74.05	74.24	73.99	74.19	88600.0
2016-04-15	ACWX	ETF	40.31	40.3799	40.2401	40.25	272155.0
2016-04-15	ADRE	ETF	31.88	31.88	31.8001	31.85	3007.0
2016-04-15	AFK	ETF	19.46	19.665	19.29	19.65	57021.0
2016-04-15	AFTY	ETF	13.02	13.03	12.91	12.91	19200.0
2016-04-15	AGG	ETF	110.8	110.98	110.75	110.95	1579500.0
2016-04-15	AGGY	ETF	50.8	50.85	50.765	50.818	5600.0
2016-04-15	AGQ	ETF	36.11	36.92	35.51	36.33	181200.0
2016-04-15	AGZ	ETF	114.59	114.8999	114.59	114.88	15025.0
2016-04-15	AGZD	ETF	23.785	23.91	23.785	23.825	3400.0
2016-04-15	AIA	ETF	43.82	43.94	43.76	43.76	14310.0
2016-04-15	AIQ	ETF	6.96	7.28	6.96	6.97	7028.0
2016-04-15	AIRR	ETF	17.7	17.83	17.7	17.8	3700.0
2016-04-15	AIVI	ETF	38.98	39.1	38.96	39.0	5600.0
2016-04-15	ALTY	ETF	14.48	14.52	14.48	14.51	3000.0
2016-04-15	AMJ	ETF	27.57	27.69	27.12	27.18	1791443.0
2016-04-15	AMLP	ETF	55.5	56.55	55.15	55.2	1963180.0
2016-04-15	AMZA	ETF	91.3	93.7	89.7	90.5	22080.0
2016-04-15	ANGL	ETF	26.22	26.37	26.2	26.28	146300.0
2016-04-15	AOA	ETF	45.8	45.8	45.64	45.71	97200.0
2016-04-15	AOK	ETF	32.45	32.53	32.4	32.48	17233.0
2016-04-15	AOM	ETF	35.01	35.01	34.8326	34.94	76584.0
2016-04-15	AOR	ETF	39.73	39.78	39.62	39.67	85134.0
2016-04-15	ARGT	ETF	20.25	20.42	20.19	20.22	41900.0
2016-04-15	ARKG	ETF	18.622	18.622	18.622	18.622	2000.0
2016-04-15	ARKK	ETF	19.77	19.77	19.77	19.77	3000.0
2016-04-15	ARKQ	ETF	19.64	19.64	19.64	19.64	300.0
2016-04-15	ARKW	ETF	21.08	21.08	21.08	21.08	300.0
2016-04-15	ASEA	ETF	13.48	13.56	13.48	13.56	1300.0
2016-04-15	ASHR	ETF	24.85	24.97	24.8	24.86	2844400.0
2016-04-15	ASHS	ETF	36.34	36.34	35.69	35.84	27400.0
2016-04-15	ASHX	ETF	22.13	22.1399	22.11	22.1399	1252.0
2016-04-15	ATMP	ETF	18.8	18.89	18.51	18.51	52800.0
2016-04-15	BAB	ETF	30.36	30.38	30.25	30.36	93767.0
2016-04-15	BAL	ETF	39.3	39.83	39.14	39.5788	10298.0
2016-04-15	BBC	ETF	21.05	21.1299	20.677	21.1	11706.0
2016-04-15	BBH	ETF	110.64	111.03	109.63	110.68	416500.0
2016-04-15	BBP	ETF	26.8	26.8	26.488	26.73	1900.0
2016-04-15	BCM	ETF	24.8952	25.03	24.8952	25.01	52115.0

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

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