PREVIEW / etf_daily / 2016-04-29

all etf daily files

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

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-29	SPY	ETF	206.72	207.13	205.03	206.33	142424100.0
2016-04-29	QQQ	ETF	106.22	106.495	104.88	105.72	67502786.0
2016-04-29	IWM	ETF	113.01	113.46	111.72	112.48	33284500.0
2016-04-29	DIA	ETF	177.4	177.95	176.29	177.59	5496000.0
2016-04-29	GLD	ETF	122.43	123.93	122.34	123.65	19043900.0
2016-04-29	TLT	ETF	128.45	129.71	128.2	129.38	7416300.0
2016-04-29	AADR	ETF	38.51	38.51	38.28	38.28	1300.0
2016-04-29	AAXJ	ETF	54.25	54.26	53.64	54.01	831400.0
2016-04-29	ACTX	ETF	4.13	4.13	4.13	4.13	81.0
2016-04-29	ACWI	ETF	56.94	57.01	56.46	56.81	1693200.0
2016-04-29	ACWV	ETF	73.54	73.78	73.2	73.56	188600.0
2016-04-29	ACWX	ETF	40.6	40.67	40.31	40.48	1219866.0
2016-04-29	ADRE	ETF	31.56	31.6632	31.3001	31.5228	5378.0
2016-04-29	AFK	ETF	20.79	21.3477	20.79	21.23	54869.0
2016-04-29	AFTY	ETF	12.76	12.8	12.72	12.76	3100.0
2016-04-29	AGG	ETF	110.82	110.93	110.75	110.89	5112900.0
2016-04-29	AGGY	ETF	50.88	50.89	50.78	50.83	12500.0
2016-04-29	AGQ	ETF	43.47	44.23	43.07	43.6	485600.0
2016-04-29	AGZ	ETF	114.34	114.82	114.34	114.82	12580.0
2016-04-29	AIA	ETF	43.07	43.07	42.641	42.89	28802.0
2016-04-29	AIQ	ETF	7.2	7.21	7.12	7.19	15725.0
2016-04-29	AIRR	ETF	18.087	18.25	18.02	18.11	3000.0
2016-04-29	AIVI	ETF	39.48	39.57	39.26	39.45	12200.0
2016-04-29	AMJ	ETF	29.9	30.15	29.6	30.04	1981797.0
2016-04-29	AMLP	ETF	60.3	61.55	60.2	61.05	2348240.0
2016-04-29	AMZA	ETF	104.4	105.48	102.0	105.0	6920.0
2016-04-29	ANGL	ETF	27.17	27.29	27.02	27.22	201600.0
2016-04-29	AOA	ETF	45.7	45.7	45.37	45.59	48900.0
2016-04-29	AOK	ETF	32.43	32.47	32.356	32.47	22878.0
2016-04-29	AOM	ETF	34.97	34.97	34.77	34.91	46127.0
2016-04-29	AOR	ETF	39.65	39.75	39.46	39.62	83371.0
2016-04-29	ARGT	ETF	20.78	20.95	20.65	20.74	38900.0
2016-04-29	ARKG	ETF	17.46	17.46	17.46	17.46	2100.0
2016-04-29	ARKK	ETF	18.93	18.93	18.88	18.88	7200.0
2016-04-29	ARKQ	ETF	18.87	18.92	18.85	18.914	3900.0
2016-04-29	ARKW	ETF	20.72	20.79	20.72	20.74	3300.0
2016-04-29	ASEA	ETF	13.26	13.3	13.21	13.25	5200.0
2016-04-29	ASHR	ETF	23.96	23.96	23.77	23.92	1165500.0
2016-04-29	ASHS	ETF	33.43	33.48	33.24	33.35	28600.0
2016-04-29	ATMP	ETF	20.69	21.14	20.35	20.56	72100.0
2016-04-29	BAB	ETF	30.06	30.235	30.0001	30.08	362413.0
2016-04-29	BAL	ETF	42.38	42.74	41.88	42.634	10776.0
2016-04-29	BBC	ETF	20.114	20.1385	19.588	19.77	13699.0
2016-04-29	BBH	ETF	108.25	108.6	105.39	106.27	137700.0
2016-04-29	BBP	ETF	26.06	26.59	25.66	25.86	5600.0
2016-04-29	BCM	ETF	26.73	26.73	26.5701	26.628	702.0
2016-04-29	BDCZ	ETF	20.4	20.49	20.31	20.31	2502.0
2016-04-29	BFOR	ETF	7.6	7.635	7.5575	7.6	62400.0
2016-04-29	BIB	ETF	44.5	45.12	42.14	42.85	990148.0
2016-04-29	BIL	ETF	91.4	91.42	91.4	91.42	722100.0

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

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