PREVIEW / etf_daily / 2016-11-25

all etf daily files

  file:    by_date/etf_daily/2016/2016-11-25.parquet
  size:    50 KB
  rows:    1,280

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-11-25	SPY	ETF	221.1	221.56	221.01	221.52	37872300.0
2016-11-25	QQQ	ETF	118.56	118.85	118.42	118.8	7162785.0
2016-11-25	IWM	ETF	133.73	134.1	133.54	134.07	13373400.0
2016-11-25	DIA	ETF	191.09	191.34	190.98	191.3	1547100.0
2016-11-25	GLD	ETF	113.42	113.51	112.35	112.61	5345900.0
2016-11-25	TLT	ETF	121.19	121.29	120.4	120.82	3126300.0
2016-11-25	AADR	ETF	40.74	40.82	40.74	40.74	700.0
2016-11-25	AAXJ	ETF	56.63	56.72	56.53	56.56	290700.0
2016-11-25	ACSI	ETF	26.75	26.75	26.75	26.75	10135.0
2016-11-25	ACTX	ETF	32.1553	32.4503	30.0903	32.3323	1253.0
2016-11-25	ACWF	ETF	24.2308	24.47	24.2308	24.46	986.0
2016-11-25	ACWI	ETF	58.68	58.79	58.64	58.79	633700.0
2016-11-25	ACWV	ETF	72.64	72.84	72.48	72.77	103400.0
2016-11-25	ACWX	ETF	39.91	39.91	39.82	39.9	305964.0
2016-11-25	ADRE	ETF	33.08	33.08	33.0087	33.0087	1084.0
2016-11-25	AFK	ETF	19.57	19.78	19.4265	19.4265	3050.0
2016-11-25	AFTY	ETF	13.92	14.0	13.86	13.95	12400.0
2016-11-25	AGG	ETF	108.3	108.37	108.09	108.17	1071500.0
2016-11-25	AGGY	ETF	49.71	49.81	49.665	49.665	2200.0
2016-11-25	AGQ	ETF	35.09	35.15	34.66	34.79	328200.0
2016-11-25	AGZ	ETF	113.33	113.358	113.02	113.05	6931.0
2016-11-25	AIA	ETF	47.81	47.91	47.81	47.87	9079.0
2016-11-25	AIQ	ETF	7.35	7.42	7.3	7.4	6153.0
2016-11-25	AIRR	ETF	23.37	23.37	23.21	23.31	88500.0
2016-11-25	AIVI	ETF	36.53	36.53	36.4	36.51	8700.0
2016-11-25	ALTY	ETF	14.779	14.78	14.742	14.742	1500.0
2016-11-25	AMJ	ETF	30.36	30.36	30.02	30.1	759039.0
2016-11-25	AMLP	ETF	61.65	61.7	61.1	61.15	369920.0
2016-11-25	AMZA	ETF	109.79	109.79	108.25	108.5	14270.0
2016-11-25	ANGL	ETF	28.62	28.66	28.55	28.55	39900.0
2016-11-25	AOA	ETF	46.91	46.91	46.74	46.86	73100.0
2016-11-25	AOK	ETF	32.43	32.5	32.3401	32.41	36893.0
2016-11-25	AOM	ETF	35.16	35.17	34.9709	35.08	38761.0
2016-11-25	AOR	ETF	40.44	40.44	40.23	40.28	54306.0
2016-11-25	ARGT	ETF	23.22	23.22	23.01	23.14	11900.0
2016-11-25	ARKG	ETF	18.71	18.77	18.53	18.76	900.0
2016-11-25	ARKK	ETF	20.85	20.96	20.84	20.95	2000.0
2016-11-25	ASEA	ETF	12.89	12.89	12.89	12.89	100.0
2016-11-25	ASET	ETF	25.08	25.08	25.08	25.08	430.0
2016-11-25	ASHR	ETF	25.6	25.7	25.53	25.7	762200.0
2016-11-25	ASHS	ETF	34.8	34.91	34.8	34.85	14100.0
2016-11-25	ATMP	ETF	23.01	23.01	22.58	22.68	14900.0
2016-11-25	BAB	ETF	29.27	29.39	29.22	29.25	102262.0
2016-11-25	BAL	ETF	46.79	47.02	46.54	46.88	44295.0
2016-11-25	BBC	ETF	21.36	21.71	21.36	21.71	1633.0
2016-11-25	BBH	ETF	111.88	112.5	110.97	111.9	13000.0
2016-11-25	BBP	ETF	35.19	35.61	34.915	35.6	18500.0
2016-11-25	BFOR	ETF	8.7	8.7275	8.6975	8.7275	47600.0
2016-11-25	BIB	ETF	46.42	46.42	45.0949	46.09	186109.0
2016-11-25	BICK	ETF	22.2859	22.2859	22.2859	22.2859	351.0

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

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