PREVIEW / etf_daily / 2015-06-16

all etf daily files

  file:    by_date/etf_daily/2015/2015-06-16.parquet
  size:    47 KB
  rows:    1,181

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
2015-06-16	SPY	ETF	208.93	210.35	208.72	210.25	85308200.0
2015-06-16	QQQ	ETF	108.1	108.9799	108.05	108.8	16456867.0
2015-06-16	IWM	ETF	125.38	126.65	125.32	126.42	32800900.0
2015-06-16	DIA	ETF	178.07	179.36	177.88	179.21	3276900.0
2015-06-16	GLD	ETF	113.08	113.45	112.79	113.32	4033300.0
2015-06-16	TLT	ETF	118.61	119.08	117.94	119.07	7046400.0
2015-06-16	AADR	ETF	39.47	39.47	39.47	39.47	1300.0
2015-06-16	AAXJ	ETF	63.27	63.59	63.26	63.46	2209600.0
2015-06-16	ACTX	ETF	3.54	4.13	2.95	4.13	504.0
2015-06-16	ACWF	ETF	24.82	24.85	24.8	24.85	900.0
2015-06-16	ACWI	ETF	60.79	61.17	60.75	61.14	515900.0
2015-06-16	ACWV	ETF	70.66	71.0	70.6	70.98	64700.0
2015-06-16	ACWX	ETF	45.25	45.54	45.25	45.5	185591.0
2015-06-16	ADRE	ETF	35.23	35.5045	35.2	35.44	14054.0
2015-06-16	AFK	ETF	24.6	24.79	24.57	24.79	17342.0
2015-06-16	AFTY	ETF	22.44	22.44	22.165	22.34	110000.0
2015-06-16	AGG	ETF	108.83	108.89	108.68	108.89	1309900.0
2015-06-16	AGQ	ETF	37.87	38.15	37.5	38.08	148300.0
2015-06-16	AGZ	ETF	112.9199	112.98	112.7877	112.86	13293.0
2015-06-16	AGZD	ETF	24.425	24.44	24.4	24.4	10800.0
2015-06-16	AIA	ETF	50.6	50.73	50.49	50.72	24536.0
2015-06-16	AIQ	ETF	18.52	19.13	18.5	19.1	18324.0
2015-06-16	AIRR	ETF	18.51	18.65	18.51	18.65	2800.0
2015-06-16	AIVI	ETF	44.35	44.61	44.25	44.5	12600.0
2015-06-16	AMJ	ETF	42.15	42.25	41.9035	42.06	598366.0
2015-06-16	AMLP	ETF	81.3	81.5	80.95	81.2	541220.0
2015-06-16	AMZA	ETF	209.8	210.39	206.0	207.1	2490.0
2015-06-16	ANGL	ETF	27.28	27.33	27.26	27.29	18900.0
2015-06-16	AOA	ETF	47.66	47.95	47.65	47.94	55500.0
2015-06-16	AOK	ETF	32.57	32.6694	32.56	32.65	19694.0
2015-06-16	AOM	ETF	35.39	35.46	35.19	35.46	45522.0
2015-06-16	AOR	ETF	40.81	40.9499	40.7201	40.91	68146.0
2015-06-16	ARGT	ETF	21.01	21.01	20.84	20.89	1500.0
2015-06-16	ARKG	ETF	23.22	23.24	23.22	23.24	300.0
2015-06-16	ARKK	ETF	21.64	21.64	21.62	21.62	300.0
2015-06-16	ARKQ	ETF	20.03	20.075	20.03	20.075	500.0
2015-06-16	ARKW	ETF	23.31	23.464	23.31	23.464	2900.0
2015-06-16	ASEA	ETF	15.09	15.13	15.06	15.1	5000.0
2015-06-16	ASHR	ETF	51.63	51.91	51.47	51.75	2628700.0
2015-06-16	ASHS	ETF	73.05	73.05	69.91	70.83	239700.0
2015-06-16	ATMP	ETF	28.63	28.63	28.27	28.43	86700.0
2015-06-16	AWAY	ETF	30.96	31.42	30.89	31.06	1099853.0
2015-06-16	BAB	ETF	28.69	28.92	28.69	28.87	162706.0
2015-06-16	BAL	ETF	42.37	43.5572	42.2792	43.5	21283.0
2015-06-16	BALT	ETF	1.52	1.56	1.515	1.53	196357.0
2015-06-16	BAR	ETF	2.526	2.615	2.526	2.615	24520.0
2015-06-16	BBC	ETF	35.41	35.66	35.11	35.1699	28235.0
2015-06-16	BBH	ETF	133.02	134.41	132.82	133.95	87800.0
2015-06-16	BBP	ETF	33.32	34.08	33.32	33.92	27000.0
2015-06-16	BCHP	ETF	20.18	20.18	20.18	20.18	200.0

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

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