PREVIEW / etf_daily / 2016-07-07

all etf daily files

  file:    by_date/etf_daily/2016/2016-07-07.parquet
  size:    52 KB
  rows:    1,293

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-07-07	SPY	ETF	209.87	210.65	208.63	209.53	85593800.0
2016-07-07	QQQ	ETF	108.39	108.86	108.11	108.62	19161748.0
2016-07-07	IWM	ETF	114.22	114.99	113.41	114.13	20780600.0
2016-07-07	DIA	ETF	179.15	179.72	178.04	178.79	2343300.0
2016-07-07	GLD	ETF	129.82	130.12	128.98	129.74	16508500.0
2016-07-07	TLT	ETF	142.09	143.19	141.78	142.55	9676400.0
2016-07-07	AADR	ETF	38.93	38.93	38.93	38.93	100.0
2016-07-07	AAXJ	ETF	54.35	54.6	54.03	54.21	495300.0
2016-07-07	ACTX	ETF	4.72	4.72	3.54	4.13	357.0
2016-07-07	ACWF	ETF	22.65	22.67	22.52	22.52	3863.0
2016-07-07	ACWI	ETF	55.85	56.04	55.42	55.61	2131300.0
2016-07-07	ACWV	ETF	77.11	77.11	76.44	76.68	258200.0
2016-07-07	ACWX	ETF	38.45	38.54	38.0626	38.2	549518.0
2016-07-07	ADRE	ETF	31.0	31.0996	30.81	30.847	9030.0
2016-07-07	AFK	ETF	20.25	20.25	19.86	19.86	15612.0
2016-07-07	AFTY	ETF	12.84	12.87	12.761	12.777	6500.0
2016-07-07	AGG	ETF	113.0	113.17	112.92	113.08	3122200.0
2016-07-07	AGGY	ETF	52.19	53.41	52.123	52.28	3000.0
2016-07-07	AGNG	ETF	15.41	15.41	15.41	15.41	100.0
2016-07-07	AGQ	ETF	53.0	53.1	50.8	51.96	656800.0
2016-07-07	AGZ	ETF	116.61	116.61	115.6431	116.04	55634.0
2016-07-07	AGZD	ETF	23.925	23.925	23.79	23.795	2200.0
2016-07-07	AIA	ETF	44.28	44.44	44.0047	44.1	12645.0
2016-07-07	AIQ	ETF	5.96	6.27	5.96	6.01	11439.0
2016-07-07	AIRR	ETF	18.312	18.37	18.312	18.32	900.0
2016-07-07	AIVI	ETF	37.29	37.39	36.83	36.91	57100.0
2016-07-07	ALTY	ETF	15.12	15.12	14.97	14.97	1900.0
2016-07-07	AMJ	ETF	31.47	31.86	31.02	31.21	5648417.0
2016-07-07	AMLP	ETF	63.55	64.1	62.55	62.75	1911780.0
2016-07-07	AMZA	ETF	108.0	110.8	106.9	107.4	17470.0
2016-07-07	ANGL	ETF	27.7	27.8	27.61	27.69	347300.0
2016-07-07	AOA	ETF	45.53	45.53	45.03	45.2	25200.0
2016-07-07	AOK	ETF	32.84	32.89	32.7001	32.81	26400.0
2016-07-07	AOM	ETF	35.15	35.3199	35.0733	35.13	116204.0
2016-07-07	AOR	ETF	39.63	39.7341	39.4537	39.57	47626.0
2016-07-07	ARGT	ETF	22.26	22.41	22.08	22.11	77900.0
2016-07-07	ARKG	ETF	17.482	17.482	17.47	17.47	200.0
2016-07-07	ARKK	ETF	19.62	19.62	19.62	19.62	100.0
2016-07-07	ARKQ	ETF	19.24	19.28	19.24	19.28	700.0
2016-07-07	ARKW	ETF	22.5	22.5	22.48	22.48	800.0
2016-07-07	ASEA	ETF	13.59	13.62	13.49	13.53	5600.0
2016-07-07	ASHR	ETF	24.07	24.09	23.92	23.96	626500.0
2016-07-07	ASHS	ETF	34.69	34.7	34.56	34.58	2500.0
2016-07-07	ASHX	ETF	22.05	22.05	22.05	22.05	246.0
2016-07-07	ATMP	ETF	22.21	22.22	21.73	21.88	102700.0
2016-07-07	BAB	ETF	31.83	31.8999	31.75	31.81	160570.0
2016-07-07	BAL	ETF	43.21	43.21	42.85	42.898	3727.0
2016-07-07	BBC	ETF	18.56	19.03	18.56	19.0099	12467.0
2016-07-07	BBH	ETF	106.32	106.99	105.85	106.66	64100.0
2016-07-07	BBP	ETF	28.42	28.42	27.98	28.31	3000.0

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

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