PREVIEW / etf_daily / 2016-08-04

all etf daily files

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

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-08-04	SPY	ETF	216.31	216.78	214.25	216.41	46585500.0
2016-08-04	QQQ	ETF	115.32	115.78	115.03	115.67	12835296.0
2016-08-04	IWM	ETF	120.45	121.19	120.26	120.56	17526700.0
2016-08-04	DIA	ETF	183.5	183.89	183.15	183.45	2368900.0
2016-08-04	GLD	ETF	130.01	130.28	129.82	129.87	4908100.0
2016-08-04	TLT	ETF	139.46	140.16	139.27	139.45	5646000.0
2016-08-04	AADR	ETF	40.58	40.67	40.28	40.58	1100.0
2016-08-04	AAXJ	ETF	57.43	57.63	57.26	57.43	503300.0
2016-08-04	ACTX	ETF	4.13	4.13	3.54	3.54	252.0
2016-08-04	ACWF	ETF	23.52	23.6771	23.52	23.5201	327.0
2016-08-04	ACWI	ETF	58.0	58.13	57.86	58.07	955500.0
2016-08-04	ACWV	ETF	77.31	77.45	77.17	77.31	195300.0
2016-08-04	ACWX	ETF	40.19	40.39	40.16	40.34	622774.0
2016-08-04	ADRE	ETF	32.87	33.0301	32.54	32.54	2646.0
2016-08-04	AFK	ETF	20.4	20.95	20.4	20.9	4774.0
2016-08-04	AFTY	ETF	13.04	13.08	13.04	13.08	5200.0
2016-08-04	AGG	ETF	112.54	112.66	112.5	112.55	2002800.0
2016-08-04	AGGY	ETF	51.94	52.12	51.94	52.069	17600.0
2016-08-04	AGQ	ETF	54.67	55.7	54.65	55.15	123200.0
2016-08-04	AGZ	ETF	115.69	115.96	114.968	115.62	52253.0
2016-08-04	AIA	ETF	46.85	47.0	46.84	46.89	19241.0
2016-08-04	AIQ	ETF	5.84	5.96	5.79	5.85	17100.0
2016-08-04	AIRR	ETF	19.07	19.25	19.07	19.16	25800.0
2016-08-04	AIVI	ETF	38.33	38.52	38.23	38.38	35100.0
2016-08-04	ALTY	ETF	15.61	15.61	15.438	15.438	800.0
2016-08-04	AMJ	ETF	31.84	31.99	31.34	31.59	1616004.0
2016-08-04	AMLP	ETF	64.1	64.45	63.55	64.2	1138340.0
2016-08-04	AMZA	ETF	113.5	114.2	111.8	112.9	7900.0
2016-08-04	ANGL	ETF	28.08	28.21	28.04	28.11	119200.0
2016-08-04	AOA	ETF	46.78	46.9	46.7	46.76	15400.0
2016-08-04	AOK	ETF	33.21	33.22	33.084	33.2	39789.0
2016-08-04	AOM	ETF	35.73	35.839	35.675	35.69	60205.0
2016-08-04	AOR	ETF	40.52	40.679	40.52	40.64	35312.0
2016-08-04	ARGT	ETF	22.4	22.64	22.37	22.63	14400.0
2016-08-04	ARKG	ETF	19.0	19.148	19.0	19.08	3500.0
2016-08-04	ARKK	ETF	20.75	20.75	20.68	20.68	200.0
2016-08-04	ARKQ	ETF	20.69	20.69	20.635	20.66	1800.0
2016-08-04	ARKW	ETF	24.03	24.37	24.03	24.37	1000.0
2016-08-04	ASEA	ETF	13.93	13.96	13.91	13.96	3000.0
2016-08-04	ASHR	ETF	24.17	24.24	24.12	24.22	391500.0
2016-08-04	ASHS	ETF	34.4	34.4	34.28	34.31	7500.0
2016-08-04	ATMP	ETF	22.77	22.86	22.5	22.64	19600.0
2016-08-04	BAB	ETF	31.65	31.71	31.6001	31.66	150931.0
2016-08-04	BAL	ETF	49.8	50.91	49.8	50.64	41319.0
2016-08-04	BBC	ETF	20.8	20.8199	20.471	20.471	6575.0
2016-08-04	BBH	ETF	118.3	118.52	117.05	117.38	103800.0
2016-08-04	BBP	ETF	31.57	31.63	31.296	31.33	5200.0
2016-08-04	BCM	ETF	25.67	25.78	25.46	25.76	33184.0
2016-08-04	BFOR	ETF	7.92	7.97	7.92	7.95	53200.0
2016-08-04	BIB	ETF	52.37	52.39	50.97	51.23	538190.0

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

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