PREVIEW / etf_daily / 2016-06-15

all etf daily files

  file:    by_date/etf_daily/2016/2016-06-15.parquet
  size:    51 KB
  rows:    1,277

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-06-15	SPY	ETF	208.04	209.36	207.53	207.75	109124500.0
2016-06-15	QQQ	ETF	108.32	108.44	107.54	107.72	24605701.0
2016-06-15	IWM	ETF	114.89	115.56	114.46	114.56	24197700.0
2016-06-15	DIA	ETF	177.25	177.84	176.38	176.57	2470100.0
2016-06-15	GLD	ETF	122.52	123.87	122.38	123.68	15053000.0
2016-06-15	TLT	ETF	135.52	136.23	135.31	135.8	7953200.0
2016-06-15	AADR	ETF	37.65	37.89	37.39	37.56	1900.0
2016-06-15	AAXJ	ETF	53.35	53.78	53.26	53.32	739900.0
2016-06-15	ACTX	ETF	3.599	3.599	3.54	3.54	693.0
2016-06-15	ACWF	ETF	22.7723	22.7723	22.7723	22.7723	700.0
2016-06-15	ACWI	ETF	55.94	56.23	55.8	55.9	2752700.0
2016-06-15	ACWV	ETF	74.36	74.86	74.18	74.19	847300.0
2016-06-15	ACWX	ETF	38.78	39.0	38.72	38.79	677713.0
2016-06-15	ADRE	ETF	29.96	30.0738	29.9501	30.0738	1402.0
2016-06-15	AFK	ETF	20.25	20.25	19.71	19.97	46233.0
2016-06-15	AFTY	ETF	12.31	12.31	12.31	12.31	800.0
2016-06-15	AGG	ETF	111.67	111.93	111.64	111.8	1732100.0
2016-06-15	AGGY	ETF	51.434	51.46	51.21	51.325	2600.0
2016-06-15	AGQ	ETF	41.49	42.15	41.23	41.85	204000.0
2016-06-15	AGZ	ETF	115.42	115.68	115.25	115.53	93493.0
2016-06-15	AGZD	ETF	23.87	23.87	23.87	23.87	1200.0
2016-06-15	AIA	ETF	43.36	43.66	43.35	43.38	27792.0
2016-06-15	AIQ	ETF	6.63	6.63	6.25	6.36	16357.0
2016-06-15	AIRR	ETF	18.25	18.27	18.19	18.19	2200.0
2016-06-15	AIVI	ETF	37.2	37.39	37.11	37.14	9300.0
2016-06-15	ALTY	ETF	14.59	14.59	14.59	14.59	400.0
2016-06-15	AMJ	ETF	30.04	30.81	29.91	30.59	2877477.0
2016-06-15	AMLP	ETF	61.2	62.65	60.7	62.25	1766560.0
2016-06-15	AMZA	ETF	109.5	110.6	106.5	110.1	10770.0
2016-06-15	ANGL	ETF	27.16	27.28	27.1	27.14	40600.0
2016-06-15	AOA	ETF	45.28	45.44	45.2	45.23	12900.0
2016-06-15	AOK	ETF	32.46	32.6099	32.46	32.54	21470.0
2016-06-15	AOM	ETF	34.9199	35.2099	34.8701	35.02	126551.0
2016-06-15	AOR	ETF	39.56	39.7045	39.45	39.45	129053.0
2016-06-15	ARGT	ETF	21.57	21.82	21.44	21.7	47600.0
2016-06-15	ARKG	ETF	17.095	17.095	17.095	17.095	100.0
2016-06-15	ARKK	ETF	19.42	19.42	19.4	19.4	300.0
2016-06-15	ARKQ	ETF	19.602	19.602	19.602	19.602	100.0
2016-06-15	ARKW	ETF	22.44	22.45	22.44	22.45	500.0
2016-06-15	ASEA	ETF	12.99	13.09	12.99	13.06	4700.0
2016-06-15	ASET	ETF	26.01	26.02	26.01	26.019	1500.0
2016-06-15	ASHR	ETF	23.2	23.28	23.13	23.15	3120700.0
2016-06-15	ASHS	ETF	32.85	33.15	32.7	32.84	62900.0
2016-06-15	ASHX	ETF	20.9634	20.9634	20.9634	20.9634	200.0
2016-06-15	ATMP	ETF	21.02	21.31	20.73	21.11	50000.0
2016-06-15	BAB	ETF	31.16	31.2499	31.05	31.12	211859.0
2016-06-15	BAL	ETF	42.18	42.2	42.0599	42.11	12524.0
2016-06-15	BBC	ETF	19.1005	19.339	19.1005	19.32	22718.0
2016-06-15	BBH	ETF	104.49	104.57	103.36	103.45	45000.0
2016-06-15	BBP	ETF	27.087	27.16	26.87	26.87	600.0

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

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