PREVIEW / etf_daily / 2015-06-17

all etf daily files

  file:    by_date/etf_daily/2015/2015-06-17.parquet
  size:    48 KB
  rows:    1,180

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-17	SPY	ETF	210.59	211.32	209.36	210.59	126708600.0
2015-06-17	QQQ	ETF	108.98	109.45	108.43	109.1	23296738.0
2015-06-17	IWM	ETF	126.74	126.96	125.97	126.23	32467000.0
2015-06-17	DIA	ETF	179.66	180.14	178.49	179.48	3650900.0
2015-06-17	GLD	ETF	113.07	114.04	112.63	113.85	6456000.0
2015-06-17	TLT	ETF	118.5	118.63	117.25	118.15	13626100.0
2015-06-17	AAXJ	ETF	63.73	64.21	63.39	63.96	1106500.0
2015-06-17	ACTX	ETF	4.72	4.72	2.95	3.54	4794.0
2015-06-17	ACWI	ETF	61.18	61.35	60.74	61.18	654500.0
2015-06-17	ACWV	ETF	70.91	71.27	70.63	71.12	29800.0
2015-06-17	ACWX	ETF	45.37	45.595	45.05	45.48	446509.0
2015-06-17	ADRE	ETF	35.38	35.7	35.38	35.6694	8591.0
2015-06-17	AFK	ETF	24.79	24.9	24.63	24.9	3265.0
2015-06-17	AFTY	ETF	22.34	22.6	22.34	22.48	154100.0
2015-06-17	AGG	ETF	108.84	108.9	108.44	108.9	1895700.0
2015-06-17	AGQ	ETF	38.28	39.28	37.78	38.82	376200.0
2015-06-17	AGZ	ETF	112.72	112.97	112.48	112.96	17525.0
2015-06-17	AGZD	ETF	24.44	24.45	24.31	24.425	10200.0
2015-06-17	AIA	ETF	50.74	51.014	50.54	50.91	51265.0
2015-06-17	AIQ	ETF	18.4201	19.56	18.42	19.33	13452.0
2015-06-17	AIRR	ETF	18.57	18.57	18.54	18.57	1100.0
2015-06-17	AIVI	ETF	44.38	44.59	44.13	44.51	17800.0
2015-06-17	ALTL	ETF	36.75	36.75	36.75	36.75	210.0
2015-06-17	AMJ	ETF	42.03	42.35	41.85	42.02	1086321.0
2015-06-17	AMLP	ETF	81.55	81.65	80.7	81.15	640900.0
2015-06-17	AMZA	ETF	213.8	213.8	205.0	208.78	1330.0
2015-06-17	ANGL	ETF	27.28	27.28	27.22	27.23	8600.0
2015-06-17	AOA	ETF	48.0	48.03	47.57	47.98	20900.0
2015-06-17	AOK	ETF	32.58	32.7	32.4788	32.57	39759.0
2015-06-17	AOM	ETF	35.51	35.525	35.2201	35.5	26714.0
2015-06-17	AOR	ETF	40.84	41.02	40.67	40.89	126437.0
2015-06-17	ARGT	ETF	20.72	20.72	20.27	20.42	16600.0
2015-06-17	ARKG	ETF	23.27	23.27	23.27	23.27	300.0
2015-06-17	ARKK	ETF	21.86	21.86	21.83	21.83	500.0
2015-06-17	ARKQ	ETF	20.24	20.24	20.22	20.22	300.0
2015-06-17	ARKW	ETF	23.51	23.51	23.51	23.51	2000.0
2015-06-17	ASEA	ETF	15.11	15.28	15.05	15.28	8900.0
2015-06-17	ASHR	ETF	52.65	52.71	52.36	52.6	2022800.0
2015-06-17	ASHS	ETF	71.77	72.45	71.77	72.28	135900.0
2015-06-17	ATMP	ETF	28.65	28.65	28.28	28.48	38900.0
2015-06-17	AWAY	ETF	31.1	31.61	31.02	31.32	863657.0
2015-06-17	BAB	ETF	28.79	29.0	28.79	28.9	55585.0
2015-06-17	BAL	ETF	43.385	43.594	43.002	43.48	4163.0
2015-06-17	BALT	ETF	1.55	1.64	1.5	1.52	220474.0
2015-06-17	BAR	ETF	2.57	2.62	2.547	2.5946	32330.0
2015-06-17	BBC	ETF	35.503	35.8544	35.4501	35.68	20056.0
2015-06-17	BBH	ETF	134.34	134.93	133.35	134.4	123700.0
2015-06-17	BBP	ETF	33.91	34.45	33.91	34.346	17600.0
2015-06-17	BCM	ETF	31.54	31.54	31.154	31.39	5200.0
2015-06-17	BFOR	ETF	8.455	8.4775	8.425	8.4425	37600.0

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

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