PREVIEW / etf_daily / 2016-12-22

all etf daily files

  file:    by_date/etf_daily/2016/2016-12-22.parquet
  size:    54 KB
  rows:    1,367

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-22	SPY	ETF	225.6	225.74	224.92	225.38	56219100.0
2016-12-22	QQQ	ETF	120.46	120.5	119.65	120.12	16644996.0
2016-12-22	IWM	ETF	136.56	136.75	134.81	135.32	34737900.0
2016-12-22	DIA	ETF	199.1	199.17	198.58	198.97	2250900.0
2016-12-22	GLD	ETF	107.68	108.1	107.49	107.59	4942800.0
2016-12-22	TLT	ETF	117.53	118.0	117.5	117.81	5177800.0
2016-12-22	AADR	ETF	40.59	40.59	39.24	39.54	5500.0
2016-12-22	AAXJ	ETF	54.18	54.18	53.9	54.13	1211500.0
2016-12-22	ACSI	ETF	27.4	27.42	27.3	27.31	7550.0
2016-12-22	ACTX	ETF	15.9301	17.7002	15.2221	15.9301	522.0
2016-12-22	ACWI	ETF	59.39	59.39	59.21	59.32	1562300.0
2016-12-22	ACWV	ETF	72.2	72.35	72.09	72.35	355000.0
2016-12-22	ACWX	ETF	40.06	40.07	39.96	39.97	1303314.0
2016-12-22	ADRE	ETF	31.89	31.9378	31.781	31.91	17305.0
2016-12-22	AFK	ETF	19.09	19.38	19.0	19.26	11452.0
2016-12-22	AFTY	ETF	13.03	13.055	13.03	13.05	2600.0
2016-12-22	AGG	ETF	107.34	107.46	107.24	107.39	4110200.0
2016-12-22	AGGY	ETF	49.3	49.36	49.3	49.34	11400.0
2016-12-22	AGNG	ETF	15.14	15.14	15.14	15.14	300.0
2016-12-22	AGQ	ETF	32.0	32.56	31.57	31.7	160100.0
2016-12-22	AGZ	ETF	111.93	112.27	111.82	112.22	76498.0
2016-12-22	AGZD	ETF	24.035	24.075	24.035	24.075	5400.0
2016-12-22	AIA	ETF	45.8	45.8	45.54	45.65	43220.0
2016-12-22	AIQ	ETF	9.5	9.6	9.4652	9.575	38093.0
2016-12-22	AIRR	ETF	24.15	24.294	23.96	24.04	154300.0
2016-12-22	AIVI	ETF	37.57	37.61	37.42	37.44	18900.0
2016-12-22	ALTY	ETF	15.038	15.116	15.038	15.116	700.0
2016-12-22	AMJ	ETF	31.01	31.675	31.01	31.52	2850247.0
2016-12-22	AMLP	ETF	62.6	63.4	62.5	63.25	1915940.0
2016-12-22	AMZA	ETF	112.2	113.7	111.8	112.7	53530.0
2016-12-22	ANGL	ETF	28.98	29.02	28.84	28.99	1399000.0
2016-12-22	AOA	ETF	47.61	47.69	47.47	47.57	144500.0
2016-12-22	AOK	ETF	32.57	32.58	32.474	32.54	176392.0
2016-12-22	AOM	ETF	35.79	35.79	35.2701	35.36	458095.0
2016-12-22	AOR	ETF	40.73	40.76	40.64	40.69	361117.0
2016-12-22	ARGT	ETF	22.5	22.64	22.33	22.5	94000.0
2016-12-22	ARKG	ETF	17.4	17.4	17.08	17.086	1100.0
2016-12-22	ARKK	ETF	20.4	20.4	20.22	20.22	1700.0
2016-12-22	ARKQ	ETF	22.47	22.47	22.194	22.194	800.0
2016-12-22	ARKW	ETF	25.6	25.6	25.127	25.127	2900.0
2016-12-22	ASEA	ETF	12.93	12.93	12.78	12.81	1500.0
2016-12-22	ASET	ETF	25.6	25.66	25.6	25.64	400.0
2016-12-22	ASHR	ETF	23.86	23.86	23.76	23.77	1274400.0
2016-12-22	ASHS	ETF	32.87	32.95	32.75	32.79	23900.0
2016-12-22	ASHX	ETF	21.96	21.96	21.96	21.96	173.0
2016-12-22	ATMP	ETF	23.25	23.75	23.25	23.62	160000.0
2016-12-22	BAB	ETF	28.84	28.91	28.8164	28.86	133105.0
2016-12-22	BAL	ETF	46.28	46.28	45.86	46.07	7351.0
2016-12-22	BBC	ETF	18.49	18.6	18.19	18.2005	3063.0
2016-12-22	BBH	ETF	107.39	107.41	106.89	107.41	17600.0

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

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