PREVIEW / etf_daily / 2016-12-06

all etf daily files

  file:    by_date/etf_daily/2016/2016-12-06.parquet
  size:    53 KB
  rows:    1,340

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-12-06	SPY	ETF	221.22	221.74	220.66	221.7	59877400.0
2016-12-06	QQQ	ETF	116.88	117.08	116.39	116.88	27293348.0
2016-12-06	IWM	ETF	133.52	134.91	132.74	134.59	27820000.0
2016-12-06	DIA	ETF	192.16	192.57	191.87	192.49	2669400.0
2016-12-06	GLD	ETF	111.69	112.03	111.19	111.43	5533700.0
2016-12-06	TLT	ETF	119.34	119.94	119.12	119.38	11526600.0
2016-12-06	AADR	ETF	40.5	40.69	40.49	40.67	20400.0
2016-12-06	AAXJ	ETF	56.91	57.02	56.81	56.94	1306000.0
2016-12-06	ACSI	ETF	26.69	26.77	26.6568	26.76	9472.0
2016-12-06	ACTX	ETF	22.4202	22.4202	19.3522	21.2402	821.0
2016-12-06	ACWI	ETF	58.89	59.11	58.79	59.11	1701600.0
2016-12-06	ACWV	ETF	72.19	72.36	72.15	72.31	144600.0
2016-12-06	ACWX	ETF	40.19	40.44	40.19	40.41	1566994.0
2016-12-06	ADRE	ETF	32.82	32.9038	32.785	32.86	5765.0
2016-12-06	AFK	ETF	19.68	19.87	19.4591	19.57	18591.0
2016-12-06	AFTY	ETF	13.94	13.94	13.9	13.903	1100.0
2016-12-06	AGG	ETF	108.14	108.18	108.04	108.09	3306900.0
2016-12-06	AGGY	ETF	49.53	49.62	49.5	49.62	14900.0
2016-12-06	AGQ	ETF	35.79	36.4	35.61	35.66	93700.0
2016-12-06	AGZ	ETF	112.46	113.14	112.15	112.69	32428.0
2016-12-06	AGZD	ETF	24.035	24.08	23.955	24.0	5800.0
2016-12-06	AIA	ETF	48.33	48.33	48.19	48.28	24043.0
2016-12-06	AIQ	ETF	7.65	8.15	7.5568	8.0	34197.0
2016-12-06	AIRR	ETF	23.38	23.5	23.205	23.45	116400.0
2016-12-06	AIVI	ETF	36.86	37.13	36.86	37.08	20200.0
2016-12-06	ALTY	ETF	14.777	14.777	14.777	14.777	200.0
2016-12-06	AMJ	ETF	29.57	29.905	29.53	29.74	1937360.0
2016-12-06	AMLP	ETF	60.55	60.9	60.15	60.55	1244940.0
2016-12-06	AMZA	ETF	107.8	107.8	106.63	107.4	23390.0
2016-12-06	ANGL	ETF	28.77	28.83	28.74	28.83	246300.0
2016-12-06	AOA	ETF	46.94	47.17	46.94	47.15	135700.0
2016-12-06	AOK	ETF	32.47	32.5	32.3601	32.41	170000.0
2016-12-06	AOM	ETF	35.22	35.26	35.13	35.24	227074.0
2016-12-06	AOR	ETF	40.31	40.5	40.31	40.49	371207.0
2016-12-06	ARGT	ETF	23.2	23.3	23.17	23.29	21000.0
2016-12-06	ARKG	ETF	17.659	17.723	17.659	17.723	300.0
2016-12-06	ARKK	ETF	20.087	20.21	20.08	20.175	4900.0
2016-12-06	ARKQ	ETF	21.8	21.8	21.618	21.76	1700.0
2016-12-06	ARKW	ETF	25.0	25.001	24.97	24.989	2000.0
2016-12-06	ASEA	ETF	13.26	13.26	13.21	13.22	8400.0
2016-12-06	ASHR	ETF	25.37	25.41	25.33	25.35	784600.0
2016-12-06	ASHS	ETF	33.94	34.25	33.94	34.21	4900.0
2016-12-06	ASHX	ETF	23.9199	23.9199	23.9199	23.9199	100.0
2016-12-06	ATMP	ETF	22.17	22.39	22.16	22.36	34400.0
2016-12-06	BAB	ETF	29.34	29.3776	29.215	29.27	197750.0
2016-12-06	BAL	ETF	46.9895	47.06	46.74	47.0267	6380.0
2016-12-06	BBC	ETF	19.89	20.39	19.7148	20.36	5921.0
2016-12-06	BBH	ETF	107.44	109.07	107.44	108.79	53200.0
2016-12-06	BBP	ETF	33.942	34.653	33.94	34.653	5300.0
2016-12-06	BCM	ETF	27.3971	27.4181	27.3906	27.3906	1105.0

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

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