PREVIEW / etf_daily / 2016-01-05

all etf daily files

  file:    by_date/etf_daily/2016/2016-01-05.parquet
  size:    50 KB
  rows:    1,230

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-01-05	SPY	ETF	201.4	201.9	200.05	201.36	110845800.0
2016-01-05	QQQ	ETF	110.04	110.18	108.8	109.31	38756825.0
2016-01-05	IWM	ETF	110.41	110.58	109.55	110.25	28253300.0
2016-01-05	DIA	ETF	171.69	171.74	170.17	171.39	9413000.0
2016-01-05	GLD	ETF	103.13	103.46	102.93	103.18	3500300.0
2016-01-05	TLT	ETF	120.88	121.5	120.66	120.96	6242600.0
2016-01-05	AADR	ETF	37.71	37.8	37.71	37.71	4200.0
2016-01-05	AAXJ	ETF	52.05	52.19	51.86	51.95	1571600.0
2016-01-05	ACTX	ETF	7.6701	7.6701	6.4901	7.6701	334.0
2016-01-05	ACWF	ETF	22.75	22.75	22.58	22.58	1512.0
2016-01-05	ACWI	ETF	54.84	54.97	54.57	54.88	3243700.0
2016-01-05	ACWV	ETF	68.49	68.79	68.31	68.73	87200.0
2016-01-05	ACWX	ETF	38.79	38.85	38.57	38.81	1045461.0
2016-01-05	ADRE	ETF	28.3	28.3699	28.1801	28.27	7135.0
2016-01-05	AFK	ETF	17.7	17.789	17.501	17.54	40110.0
2016-01-05	AFTY	ETF	13.49	13.49	13.39	13.44	8900.0
2016-01-05	AGG	ETF	107.87	108.12	107.87	108.02	2732900.0
2016-01-05	AGQ	ETF	27.55	27.85	27.35	27.66	75800.0
2016-01-05	AGZ	ETF	113.74	113.74	112.9001	113.15	12927.0
2016-01-05	AGZD	ETF	24.055	24.055	24.045	24.045	2200.0
2016-01-05	AIA	ETF	41.24	41.24	41.0399	41.08	10020.0
2016-01-05	AIQ	ETF	8.65	8.89	8.245	8.79	20504.0
2016-01-05	AIRR	ETF	16.04	16.15	16.01	16.15	5900.0
2016-01-05	AIVI	ETF	37.34	37.41	37.1	37.39	51100.0
2016-01-05	AMJ	ETF	29.35	29.51	28.73	29.22	6718955.0
2016-01-05	AMLP	ETF	60.5	60.95	59.35	60.4	2231800.0
2016-01-05	AMZA	ETF	109.8	113.9	105.8	108.69	1760.0
2016-01-05	ANGL	ETF	24.39	24.43	24.18	24.39	40900.0
2016-01-05	AOA	ETF	44.35	44.4	44.15	44.38	67300.0
2016-01-05	AOK	ETF	31.52	31.52	31.4001	31.5	71235.0
2016-01-05	AOM	ETF	33.94	33.969	33.77	33.89	104709.0
2016-01-05	AOR	ETF	38.52	38.59	38.34	38.5	360125.0
2016-01-05	ARGT	ETF	17.68	17.86	17.65	17.83	19400.0
2016-01-05	ARKG	ETF	20.357	20.357	20.357	20.357	200.0
2016-01-05	ARKK	ETF	20.24	20.24	20.17	20.17	300.0
2016-01-05	ARKQ	ETF	18.85	18.88	18.85	18.88	900.0
2016-01-05	ARKW	ETF	22.72	22.72	22.51	22.58	1300.0
2016-01-05	ASEA	ETF	11.96	12.0	11.89	11.97	4600.0
2016-01-05	ASET	ETF	24.06	24.15	24.0	24.15	500.0
2016-01-05	ASHR	ETF	25.97	26.0	25.77	25.96	2816200.0
2016-01-05	ASHS	ETF	37.36	38.16	37.36	37.5	68800.0
2016-01-05	ASHX	ETF	23.73	23.74	23.72	23.74	1247.0
2016-01-05	ATMP	ETF	19.02	19.18	18.86	19.16	75500.0
2016-01-05	BAB	ETF	29.2	29.33	29.06	29.28	116249.0
2016-01-05	BAL	ETF	41.53	41.625	41.53	41.62	1249.0
2016-01-05	BBC	ETF	27.7	27.871	27.5	27.5384	3724.0
2016-01-05	BBH	ETF	123.73	124.96	123.01	123.69	49200.0
2016-01-05	BBP	ETF	30.31	30.31	29.57	29.57	2900.0
2016-01-05	BCM	ETF	23.425	23.425	23.39	23.416	429.0
2016-01-05	BFOR	ETF	7.3875	7.415	7.33	7.365	70800.0

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

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