PREVIEW / etf_daily / 2016-11-28

all etf daily files

  file:    by_date/etf_daily/2016/2016-11-28.parquet
  size:    53 KB
  rows:    1,342

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-28	SPY	ETF	221.16	221.48	220.36	220.48	76572500.0
2016-11-28	QQQ	ETF	118.64	119.08	118.4101	118.53	13479045.0
2016-11-28	IWM	ETF	133.97	134.0	132.15	132.33	32505700.0
2016-11-28	DIA	ETF	190.93	191.21	190.52	190.78	3159600.0
2016-11-28	GLD	ETF	113.23	113.84	112.77	113.8	5655400.0
2016-11-28	TLT	ETF	121.41	121.73	121.09	121.71	8555000.0
2016-11-28	AADR	ETF	40.72	41.08	40.72	41.04	2200.0
2016-11-28	AAXJ	ETF	56.75	56.91	56.65	56.7	754000.0
2016-11-28	ACSI	ETF	26.69	26.69	26.59	26.62	13715.0
2016-11-28	ACTX	ETF	32.7453	35.4003	29.5003	32.9223	2162.0
2016-11-28	ACWF	ETF	24.48	24.48	24.48	24.48	225.0
2016-11-28	ACWI	ETF	58.7	58.76	58.5	58.57	2643800.0
2016-11-28	ACWV	ETF	72.9	73.11	72.84	72.92	334600.0
2016-11-28	ACWX	ETF	39.88	39.9	39.74	39.77	1083549.0
2016-11-28	ADRE	ETF	33.15	33.32	33.14	33.242	2937.0
2016-11-28	AFK	ETF	19.69	19.69	19.39	19.45	8218.0
2016-11-28	AFTY	ETF	14.16	14.16	13.94	14.036	10700.0
2016-11-28	AGG	ETF	108.38	108.57	108.33	108.55	2476800.0
2016-11-28	AGGY	ETF	49.77	49.88	49.77	49.849	20100.0
2016-11-28	AGQ	ETF	35.14	35.67	34.79	35.35	206000.0
2016-11-28	AGZ	ETF	113.015	113.4225	113.01	113.33	9643.0
2016-11-28	AGZD	ETF	24.0	24.005	23.885	23.885	23400.0
2016-11-28	AIA	ETF	48.06	48.17	48.02	48.025	14406.0
2016-11-28	AIQ	ETF	7.4	7.4	7.25	7.25	15496.0
2016-11-28	AIRR	ETF	23.36	23.36	22.91	22.95	112700.0
2016-11-28	AIVI	ETF	36.36	36.45	36.29	36.3	22200.0
2016-11-28	ALTY	ETF	14.835	14.835	14.82	14.82	400.0
2016-11-28	AMJ	ETF	30.4	30.4	29.51	29.52	1900181.0
2016-11-28	AMLP	ETF	61.3	61.35	60.15	60.15	1225080.0
2016-11-28	AMZA	ETF	109.6	110.0	106.1	106.5	68370.0
2016-11-28	ANGL	ETF	28.63	28.69	28.46	28.62	681500.0
2016-11-28	AOA	ETF	46.92	46.92	46.67	46.69	64600.0
2016-11-28	AOK	ETF	32.58	32.58	32.3701	32.49	126549.0
2016-11-28	AOM	ETF	35.16	35.16	35.041	35.09	204025.0
2016-11-28	AOR	ETF	40.3	40.34	40.23	40.27	202415.0
2016-11-28	ARGT	ETF	23.16	23.23	23.0	23.1	46800.0
2016-11-28	ARKG	ETF	18.48	18.63	18.255	18.255	900.0
2016-11-28	ARKK	ETF	20.86	20.86	20.86	20.86	600.0
2016-11-28	ARKQ	ETF	22.22	22.22	21.95	21.95	1700.0
2016-11-28	ARKW	ETF	25.83	25.83	25.669	25.669	1200.0
2016-11-28	ASEA	ETF	12.96	12.97	12.96	12.97	400.0
2016-11-28	ASHR	ETF	25.72	25.77	25.69	25.73	723000.0
2016-11-28	ASHS	ETF	34.74	35.0	34.74	34.98	6200.0
2016-11-28	ATMP	ETF	22.68	22.69	22.23	22.66	342800.0
2016-11-28	BAB	ETF	29.43	29.48	29.3	29.46	144205.0
2016-11-28	BAL	ETF	47.03	47.5844	47.03	47.43	2519.0
2016-11-28	BBC	ETF	21.43	21.43	20.65	20.7	30442.0
2016-11-28	BBH	ETF	111.62	111.62	110.56	110.61	87900.0
2016-11-28	BBP	ETF	35.9	35.9	34.85	34.85	12900.0
2016-11-28	BCM	ETF	26.7167	26.7167	26.6434	26.6434	1407.0

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

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