PREVIEW / etf_daily / 2016-12-19

all etf daily files

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

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-19	SPY	ETF	225.25	226.02	225.08	225.53	90341100.0
2016-12-19	QQQ	ETF	119.74	120.83	119.55	120.09	21138658.0
2016-12-19	IWM	ETF	136.04	137.19	135.91	136.8	33393900.0
2016-12-19	DIA	ETF	198.3	198.9	198.21	198.6	2729400.0
2016-12-19	GLD	ETF	108.6	108.88	108.34	108.59	5339100.0
2016-12-19	TLT	ETF	117.98	118.58	117.74	118.4	10868300.0
2016-12-19	AADR	ETF	39.57	39.57	39.11	39.11	1600.0
2016-12-19	AAXJ	ETF	55.67	55.77	55.51	55.55	1448300.0
2016-12-19	ACSI	ETF	27.38	27.43	27.3412	27.43	9374.0
2016-12-19	ACTX	ETF	18.8212	20.6502	12.9801	15.3401	3126.0
2016-12-19	ACWF	ETF	24.2101	24.2101	24.2101	24.2101	336.0
2016-12-19	ACWI	ETF	59.89	60.05	59.83	59.91	1356200.0
2016-12-19	ACWV	ETF	73.4	73.69	73.4	73.54	125400.0
2016-12-19	ACWX	ETF	40.56	40.6	40.44	40.44	2051022.0
2016-12-19	ADRE	ETF	32.22	32.22	31.967	31.97	7987.0
2016-12-19	AFK	ETF	19.25	19.7	19.005	19.27	35892.0
2016-12-19	AFTY	ETF	13.04	13.13	13.0	13.06	33900.0
2016-12-19	AGG	ETF	107.4	107.55	107.35	107.51	3202500.0
2016-12-19	AGGY	ETF	49.16	49.31	49.16	49.3	6600.0
2016-12-19	AGQ	ETF	32.76	32.8	32.15	32.47	133500.0
2016-12-19	AGZ	ETF	112.04	112.38	112.04	112.27	13316.0
2016-12-19	AGZD	ETF	24.05	24.05	24.05	24.05	12600.0
2016-12-19	AIA	ETF	47.2	47.2066	47.03	47.05	22089.0
2016-12-19	AIQ	ETF	9.6	9.85	9.45	9.575	23424.0
2016-12-19	AIRR	ETF	24.2	24.2	23.76	23.99	154700.0
2016-12-19	AIVI	ETF	37.53	37.74	37.47	37.49	115100.0
2016-12-19	ALTY	ETF	15.0	15.0	14.96	14.96	1100.0
2016-12-19	AMJ	ETF	30.4	30.825	29.85	30.49	1424671.0
2016-12-19	AMLP	ETF	62.05	62.1	61.5	61.75	1351080.0
2016-12-19	AMZA	ETF	110.0	110.2	109.35	109.7	33420.0
2016-12-19	ANGL	ETF	28.94	28.94	28.86	28.91	150700.0
2016-12-19	AOA	ETF	47.69	47.69	47.5	47.56	110300.0
2016-12-19	AOK	ETF	32.58	32.58	32.4401	32.52	170132.0
2016-12-19	AOM	ETF	35.44	35.44	35.28	35.33	608653.0
2016-12-19	AOR	ETF	40.83	40.83	40.6906	40.75	501296.0
2016-12-19	ARGT	ETF	22.64	22.64	22.23	22.24	56900.0
2016-12-19	ARKG	ETF	18.17	18.2	17.78	17.78	4200.0
2016-12-19	ARKK	ETF	20.83	20.9	20.83	20.89	900.0
2016-12-19	ARKQ	ETF	22.45	22.45	22.35	22.42	2000.0
2016-12-19	ARKW	ETF	25.62	25.623	25.52	25.52	4400.0
2016-12-19	ASEA	ETF	13.12	13.12	13.12	13.12	700.0
2016-12-19	ASET	ETF	25.63	26.66	25.63	25.669	19800.0
2016-12-19	ASHR	ETF	23.99	24.01	23.94	23.95	883300.0
2016-12-19	ASHS	ETF	32.44	32.89	32.44	32.72	32400.0
2016-12-19	ASHX	ETF	22.0	22.0	21.99	21.99	2620.0
2016-12-19	ATMP	ETF	22.99	23.06	22.89	22.97	34700.0
2016-12-19	BAB	ETF	28.9	29.0	28.85	28.94	159463.0
2016-12-19	BAL	ETF	46.1794	46.1794	45.0	45.67	84344.0
2016-12-19	BBC	ETF	19.19	19.7068	19.1	19.1191	5959.0
2016-12-19	BBH	ETF	108.79	109.48	107.22	107.25	42500.0

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

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