PREVIEW / etf_daily / 2016-12-12

all etf daily files

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

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-12	SPY	ETF	226.4	226.96	225.76	226.25	102016100.0
2016-12-12	QQQ	ETF	118.95	119.21	118.47	118.96	23259310.0
2016-12-12	IWM	ETF	137.95	138.57	136.51	136.85	34592900.0
2016-12-12	DIA	ETF	197.84	198.39	197.68	198.08	3791700.0
2016-12-12	GLD	ETF	110.59	111.11	110.27	110.82	6156700.0
2016-12-12	TLT	ETF	117.27	117.8	116.88	117.72	9496300.0
2016-12-12	AADR	ETF	40.65	40.66	40.28	40.46	6900.0
2016-12-12	AAXJ	ETF	57.0	57.09	56.75	56.92	2778400.0
2016-12-12	ACSI	ETF	27.39	27.43	27.299	27.36	9913.0
2016-12-12	ACTX	ETF	21.8302	22.4202	18.8802	21.2402	848.0
2016-12-12	ACWF	ETF	24.91	24.91	24.6681	24.6681	1654.0
2016-12-12	ACWI	ETF	60.15	60.35	60.04	60.12	3016800.0
2016-12-12	ACWV	ETF	73.19	73.58	73.19	73.52	133900.0
2016-12-12	ACWX	ETF	41.0	41.09	40.89	40.96	1149501.0
2016-12-12	ADRE	ETF	33.38	33.3818	33.135	33.21	8168.0
2016-12-12	AFK	ETF	20.13	20.13	19.71	19.9747	9376.0
2016-12-12	AFTY	ETF	14.05	14.05	13.86	13.86	12800.0
2016-12-12	AGG	ETF	107.7	107.82	107.61	107.74	3074200.0
2016-12-12	AGGY	ETF	49.3	49.45	49.29	49.3	12600.0
2016-12-12	AGQ	ETF	37.42	37.65	37.12	37.17	120100.0
2016-12-12	AGZ	ETF	112.51	112.7045	112.26	112.62	20760.0
2016-12-12	AGZD	ETF	24.02	24.02	23.99	24.015	14400.0
2016-12-12	AIA	ETF	48.03	48.23	47.95	48.02	25690.0
2016-12-12	AIQ	ETF	8.7	9.2	8.7	9.0	211877.0
2016-12-12	AIRR	ETF	25.28	25.28	24.0	24.08	294800.0
2016-12-12	AIVI	ETF	37.91	38.11	37.91	37.99	16300.0
2016-12-12	ALTY	ETF	14.95	15.072	14.92	15.072	2200.0
2016-12-12	AMJ	ETF	30.5	30.999	30.04	30.05	1828115.0
2016-12-12	AMLP	ETF	62.05	62.05	61.2	61.6	1952260.0
2016-12-12	AMZA	ETF	110.0	110.0	107.7	108.2	30720.0
2016-12-12	ANGL	ETF	29.01	29.01	28.89	28.93	188700.0
2016-12-12	AOA	ETF	47.93	47.93	47.65	47.71	113000.0
2016-12-12	AOK	ETF	32.59	32.5999	32.42	32.51	126611.0
2016-12-12	AOM	ETF	35.51	35.51	35.35	35.43	395733.0
2016-12-12	AOR	ETF	40.98	40.98	40.77	40.82	564682.0
2016-12-12	ARGT	ETF	23.2	23.21	22.98	23.0	170600.0
2016-12-12	ARKG	ETF	17.5	17.551	17.415	17.42	1400.0
2016-12-12	ARKK	ETF	20.43	20.43	20.399	20.399	1400.0
2016-12-12	ARKQ	ETF	22.18	22.18	22.054	22.12	1400.0
2016-12-12	ARKW	ETF	25.19	25.23	25.0	25.03	25000.0
2016-12-12	ASEA	ETF	13.38	13.38	13.16	13.31	1700.0
2016-12-12	ASHR	ETF	24.85	24.86	24.51	24.6	2646000.0
2016-12-12	ASHS	ETF	32.8	32.8	32.0	32.55	29600.0
2016-12-12	ASHX	ETF	23.2907	23.2907	23.2592	23.2592	450.0
2016-12-12	ATMP	ETF	22.86	23.03	22.51	22.55	129700.0
2016-12-12	BAB	ETF	29.01	29.0871	28.93	29.01	238416.0
2016-12-12	BAL	ETF	46.5718	47.2	46.5718	47.17	2632.0
2016-12-12	BBC	ETF	19.33	19.3953	19.061	19.12	9333.0
2016-12-12	BBH	ETF	106.51	107.25	106.23	107.06	60600.0
2016-12-12	BBP	ETF	33.84	33.84	33.31	33.5	8100.0

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

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