PREVIEW / etf_daily / 2016-06-10

all etf daily files

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

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-10	SPY	ETF	210.46	210.86	209.43	210.07	113829200.0
2016-06-10	QQQ	ETF	109.2	109.4	108.56	108.94	32965003.0
2016-06-10	IWM	ETF	116.58	116.88	115.69	116.07	32686800.0
2016-06-10	DIA	ETF	178.7	179.24	178.11	178.71	4126600.0
2016-06-10	GLD	ETF	121.55	122.1	121.18	121.74	13940000.0
2016-06-10	TLT	ETF	134.79	135.33	134.26	134.78	6984600.0
2016-06-10	AADR	ETF	38.66	40.3	38.5	38.5	2300.0
2016-06-10	AAXJ	ETF	53.99	54.02	53.54	53.73	813600.0
2016-06-10	ACTX	ETF	4.13	4.13	3.54	4.13	1204.0
2016-06-10	ACWI	ETF	57.03	57.06	56.58	56.71	1338700.0
2016-06-10	ACWV	ETF	74.94	75.03	74.63	74.86	86400.0
2016-06-10	ACWX	ETF	39.9	39.95	39.49	39.57	415098.0
2016-06-10	ADRE	ETF	30.75	30.75	30.3125	30.33	6312.0
2016-06-10	AFK	ETF	20.5166	21.2	20.34	20.34	4899.0
2016-06-10	AFTY	ETF	12.24	12.285	12.234	12.26	5100.0
2016-06-10	AGG	ETF	111.54	111.66	111.45	111.52	1368300.0
2016-06-10	AGGY	ETF	51.48	51.48	51.16	51.384	3300.0
2016-06-10	AGNG	ETF	15.67	15.67	15.573	15.573	1700.0
2016-06-10	AGQ	ETF	40.79	41.09	40.25	40.76	236800.0
2016-06-10	AGZ	ETF	115.16	115.36	115.05	115.3063	10351.0
2016-06-10	AGZD	ETF	23.955	23.955	23.955	23.955	200.0
2016-06-10	AIA	ETF	43.76	43.9599	43.65	43.84	54098.0
2016-06-10	AIQ	ETF	6.49	6.58	6.325	6.5	30009.0
2016-06-10	AIRR	ETF	18.509	18.509	18.49	18.49	1000.0
2016-06-10	AIVI	ETF	38.28	38.28	37.77	37.93	10800.0
2016-06-10	ALTY	ETF	14.83	14.83	14.8	14.8	1400.0
2016-06-10	AMJ	ETF	31.35	31.5	30.87	30.9708	3424927.0
2016-06-10	AMLP	ETF	63.0	63.6	62.35	62.8	2674980.0
2016-06-10	AMZA	ETF	115.3	115.3	110.4	110.8	15630.0
2016-06-10	ANGL	ETF	27.4	27.4	27.24	27.31	123300.0
2016-06-10	AOA	ETF	45.92	45.99	45.65	45.77	24200.0
2016-06-10	AOK	ETF	32.68	32.74	32.48	32.64	43143.0
2016-06-10	AOM	ETF	35.11	35.2801	35.0685	35.1	81579.0
2016-06-10	AOR	ETF	39.81	39.9799	39.75	39.86	53762.0
2016-06-10	ARGT	ETF	21.91	21.91	21.57	21.67	29100.0
2016-06-10	ARKG	ETF	17.34	17.34	17.34	17.34	100.0
2016-06-10	ARKK	ETF	19.6	19.6	19.6	19.6	200.0
2016-06-10	ARKQ	ETF	19.303	19.303	19.303	19.303	300.0
2016-06-10	ARKW	ETF	22.36	22.36	21.68	21.68	900.0
2016-06-10	ASEA	ETF	13.23	13.23	13.1	13.1	1200.0
2016-06-10	ASHR	ETF	23.49	23.5	23.31	23.38	1506700.0
2016-06-10	ASHS	ETF	33.06	33.06	32.9	32.94	16600.0
2016-06-10	ATMP	ETF	21.7	21.79	21.47	21.49	9000.0
2016-06-10	BAB	ETF	31.19	31.19	30.9901	31.17	159218.0
2016-06-10	BAL	ETF	43.28	43.5899	42.9743	42.99	6386.0
2016-06-10	BBC	ETF	20.04	20.04	19.71	19.8199	27896.0
2016-06-10	BBH	ETF	106.18	106.7	105.05	105.59	77400.0
2016-06-10	BBP	ETF	27.28	27.28	26.99	27.14	15500.0
2016-06-10	BCM	ETF	27.67	27.67	27.4969	27.53	4800.0
2016-06-10	BFOR	ETF	7.7275	7.7325	7.6625	7.675	43600.0

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

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