PREVIEW / etf_daily / 2016-06-16

all etf daily files

  file:    by_date/etf_daily/2016/2016-06-16.parquet
  size:    51 KB
  rows:    1,278

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-06-16	SPY	ETF	207.75	208.57	205.59	208.37	149533100.0
2016-06-16	QQQ	ETF	107.17	108.14	106.5	108.04	32079929.0
2016-06-16	IWM	ETF	113.72	114.59	112.89	114.55	36306600.0
2016-06-16	DIA	ETF	175.73	177.67	174.8	177.46	5573700.0
2016-06-16	GLD	ETF	125.17	125.67	122.23	122.38	26635000.0
2016-06-16	TLT	ETF	136.74	137.56	136.18	136.46	10372700.0
2016-06-16	AADR	ETF	37.2	37.75	37.1	37.55	2000.0
2016-06-16	AAXJ	ETF	53.0	53.22	52.22	53.17	1035700.0
2016-06-16	ACTX	ETF	3.54	4.13	3.54	4.13	188.0
2016-06-16	ACWI	ETF	55.34	56.01	55.01	55.94	1725700.0
2016-06-16	ACWV	ETF	73.83	74.5	73.7	74.39	219000.0
2016-06-16	ACWX	ETF	38.22	38.81	37.94	38.79	419981.0
2016-06-16	ADRE	ETF	29.7	30.06	29.58	30.06	11445.0
2016-06-16	AFK	ETF	20.0	20.3073	19.305	19.36	32397.0
2016-06-16	AFTY	ETF	12.35	12.382	12.35	12.382	500.0
2016-06-16	AGG	ETF	111.92	112.07	111.78	111.87	2533000.0
2016-06-16	AGGY	ETF	51.37	51.432	51.31	51.31	2300.0
2016-06-16	AGQ	ETF	42.93	43.04	39.85	39.95	420400.0
2016-06-16	AGZ	ETF	115.49	115.96	115.341	115.54	7129.0
2016-06-16	AGZD	ETF	23.85	23.88	23.85	23.88	6800.0
2016-06-16	AIA	ETF	42.72	43.18	42.44	43.18	21593.0
2016-06-16	AIQ	ETF	6.31	6.34	6.0	6.28	18044.0
2016-06-16	AIRR	ETF	18.07	18.07	17.85	18.006	2200.0
2016-06-16	AIVI	ETF	36.77	37.42	36.41	37.39	46900.0
2016-06-16	ALTY	ETF	14.64	14.66	14.64	14.66	300.0
2016-06-16	AMJ	ETF	30.33	30.7	30.0	30.6	2539205.0
2016-06-16	AMLP	ETF	61.75	62.55	60.95	62.4	1935880.0
2016-06-16	AMZA	ETF	108.9	110.7	106.5	110.1	5520.0
2016-06-16	ANGL	ETF	27.19	27.2	27.02	27.11	99500.0
2016-06-16	AOA	ETF	44.88	45.26	44.66	45.26	19900.0
2016-06-16	AOK	ETF	32.46	32.5799	32.3301	32.56	63386.0
2016-06-16	AOM	ETF	34.84	35.03	34.76	35.03	98215.0
2016-06-16	AOR	ETF	39.28	39.57	39.15	39.57	68963.0
2016-06-16	ARGT	ETF	21.51	21.68	21.25	21.62	158400.0
2016-06-16	ARKG	ETF	16.903	16.903	16.9	16.9	700.0
2016-06-16	ARKK	ETF	19.42	19.42	19.42	19.42	100.0
2016-06-16	ARKQ	ETF	19.31	19.45	19.31	19.45	1100.0
2016-06-16	ARKW	ETF	22.33	22.5	22.33	22.5	1400.0
2016-06-16	ASEA	ETF	12.84	13.06	12.84	13.06	700.0
2016-06-16	ASET	ETF	25.77	25.82	25.77	25.79	574.0
2016-06-16	ASHR	ETF	23.07	23.32	22.98	23.28	1049400.0
2016-06-16	ASHS	ETF	32.85	33.07	32.72	33.03	23300.0
2016-06-16	ATMP	ETF	20.88	21.24	20.77	21.21	34300.0
2016-06-16	BAB	ETF	31.15	31.2876	31.11	31.18	313252.0
2016-06-16	BAL	ETF	42.29	43.012	42.1	42.95	2793.0
2016-06-16	BBC	ETF	18.77	19.02	18.5708	19.02	7975.0
2016-06-16	BBH	ETF	102.73	103.46	102.0	103.29	53300.0
2016-06-16	BBP	ETF	26.69	26.96	25.99	26.96	3600.0
2016-06-16	BCM	ETF	26.957	26.957	26.7832	26.7937	13773.0
2016-06-16	BFOR	ETF	7.51	7.55	7.4625	7.55	32000.0

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

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