PREVIEW / etf_daily / 2016-01-15

all etf daily files

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

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-15	SPY	ETF	186.77	188.76	185.52	187.81	324846400.0
2016-01-15	QQQ	ETF	100.57	101.94	99.51	100.84	91443918.0
2016-01-15	IWM	ETF	99.08	100.29	97.51	100.12	85759200.0
2016-01-15	DIA	ETF	159.26	160.58	158.23	159.68	19969100.0
2016-01-15	GLD	ETF	104.92	104.96	103.97	104.08	10052700.0
2016-01-15	TLT	ETF	125.4	125.96	125.08	125.75	13976300.0
2016-01-15	AADR	ETF	34.83	34.83	34.72	34.72	300.0
2016-01-15	AAXJ	ETF	47.55	47.67	46.83	47.37	1154500.0
2016-01-15	ACTX	ETF	7.3751	7.6701	6.4901	7.6701	593.0
2016-01-15	ACWF	ETF	20.77	20.905	20.75	20.75	3688.0
2016-01-15	ACWI	ETF	50.77	51.14	50.29	50.78	3601900.0
2016-01-15	ACWV	ETF	65.42	65.8	65.04	65.52	308800.0
2016-01-15	ACWX	ETF	35.8	35.95	35.39	35.65	1944681.0
2016-01-15	ADRE	ETF	25.98	25.984	25.39	25.91	13924.0
2016-01-15	AFK	ETF	15.37	15.42	14.96	15.25	144990.0
2016-01-15	AFTY	ETF	12.22	12.22	12.012	12.19	4200.0
2016-01-15	AGG	ETF	109.08	109.12	108.83	108.93	3348900.0
2016-01-15	AGGY	ETF	49.45	49.45	49.45	49.45	500.0
2016-01-15	AGQ	ETF	28.06	28.11	27.23	27.31	193200.0
2016-01-15	AGZ	ETF	113.8	114.2	113.46	113.8	34464.0
2016-01-15	AGZD	ETF	23.805	23.825	23.725	23.725	7600.0
2016-01-15	AIA	ETF	37.44	37.64	36.95	37.4	67019.0
2016-01-15	AIQ	ETF	6.84	7.3	6.48	6.81	29550.0
2016-01-15	AIRR	ETF	14.481	14.68	14.33	14.61	2900.0
2016-01-15	AIVI	ETF	34.94	35.18	34.69	34.86	22700.0
2016-01-15	ALTY	ETF	12.65	12.65	12.65	12.65	100.0
2016-01-15	AMJ	ETF	23.93	24.81	23.83	24.1	7507511.0
2016-01-15	AMLP	ETF	48.95	50.7	48.55	49.05	5160320.0
2016-01-15	AMZA	ETF	77.0	82.86	75.5	79.7	3980.0
2016-01-15	ANGL	ETF	23.75	23.93	23.54	23.79	134400.0
2016-01-15	AOA	ETF	41.7	41.92	41.48	41.72	324600.0
2016-01-15	AOK	ETF	30.8	30.9599	30.75	30.85	204836.0
2016-01-15	AOM	ETF	32.91	32.995	32.8005	32.95	576898.0
2016-01-15	AOR	ETF	36.8	36.99	36.62	36.7864	605646.0
2016-01-15	ARGT	ETF	16.19	16.27	15.84	16.12	55200.0
2016-01-15	ARKG	ETF	17.49	17.49	17.49	17.49	200.0
2016-01-15	ARKK	ETF	17.337	17.457	17.0	17.32	3600.0
2016-01-15	ARKQ	ETF	16.73	16.73	16.3	16.3	1300.0
2016-01-15	ARKW	ETF	20.09	20.09	19.34	19.716	4500.0
2016-01-15	ASEA	ETF	11.2	11.2	11.06	11.08	2700.0
2016-01-15	ASET	ETF	22.72	22.72	22.72	22.72	180.0
2016-01-15	ASHR	ETF	22.72	22.86	22.26	22.67	2861200.0
2016-01-15	ASHS	ETF	31.08	31.3	30.61	30.68	257600.0
2016-01-15	ATMP	ETF	15.99	16.18	15.62	15.62	19000.0
2016-01-15	BAB	ETF	29.61	29.72	29.61	29.69	296582.0
2016-01-15	BAL	ETF	40.91	40.95	40.68	40.7	6455.0
2016-01-15	BBC	ETF	20.89	21.01	20.1101	21.01	16466.0
2016-01-15	BBH	ETF	108.36	109.96	107.12	108.96	151900.0
2016-01-15	BBP	ETF	24.76	25.038	24.22	24.965	8000.0
2016-01-15	BCM	ETF	21.97	21.97	21.8801	21.8943	2950.0

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

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