PREVIEW / etf_daily / 2016-01-11

all etf daily files

  file:    by_date/etf_daily/2016/2016-01-11.parquet
  size:    50 KB
  rows:    1,253

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-01-11	SPY	ETF	193.01	193.41	189.82	192.11	187941300.0
2016-01-11	QQQ	ETF	104.79	105.06	102.73	104.33	50024094.0
2016-01-11	IWM	ETF	104.21	104.78	102.31	103.4	47144800.0
2016-01-11	DIA	ETF	164.16	164.5	162.15	163.83	12353700.0
2016-01-11	GLD	ETF	105.47	105.57	104.71	104.74	6272400.0
2016-01-11	TLT	ETF	122.04	122.79	121.86	122.01	10040300.0
2016-01-11	AADR	ETF	35.76	35.76	35.57	35.57	500.0
2016-01-11	AAXJ	ETF	49.33	49.49	48.74	49.14	1787500.0
2016-01-11	ACTX	ETF	8.8501	8.8501	7.0801	7.0801	859.0
2016-01-11	ACWF	ETF	21.58	21.58	21.31	21.31	2401.0
2016-01-11	ACWI	ETF	52.57	52.67	51.7	52.24	2958400.0
2016-01-11	ACWV	ETF	67.09	67.15	66.33	66.81	139200.0
2016-01-11	ACWX	ETF	37.21	37.21	36.55	36.87	2910152.0
2016-01-11	ADRE	ETF	26.5	26.54	26.25	26.41	6354.0
2016-01-11	AFK	ETF	16.66	16.66	16.08	16.32	17783.0
2016-01-11	AFTY	ETF	12.7	12.7	12.555	12.57	8700.0
2016-01-11	AGG	ETF	108.39	108.59	108.34	108.35	2820200.0
2016-01-11	AGGY	ETF	49.278	49.278	49.259	49.259	300.0
2016-01-11	AGQ	ETF	27.82	27.9	27.11	27.28	97400.0
2016-01-11	AGZ	ETF	113.198	113.5699	113.198	113.305	45087.0
2016-01-11	AGZD	ETF	23.9	23.955	23.84	23.84	2600.0
2016-01-11	AIA	ETF	39.1	39.2	38.6701	38.98	136020.0
2016-01-11	AIQ	ETF	8.0	8.0	7.48	7.73	24995.0
2016-01-11	AIRR	ETF	15.3	15.32	14.97	15.14	7400.0
2016-01-11	AIVI	ETF	36.25	36.25	35.73	35.87	17300.0
2016-01-11	AMJ	ETF	26.71	26.86	24.98	25.34	9986174.0
2016-01-11	AMLP	ETF	54.7	54.95	51.0	52.0	4436620.0
2016-01-11	AMZA	ETF	96.0	102.3	86.0	86.3	8500.0
2016-01-11	ANGL	ETF	24.38	24.38	24.15	24.25	100400.0
2016-01-11	AOA	ETF	42.86	42.96	42.35	42.65	497100.0
2016-01-11	AOK	ETF	31.2	31.2	31.02	31.06	204094.0
2016-01-11	AOM	ETF	33.36	33.37	33.1504	33.28	731961.0
2016-01-11	AOR	ETF	37.55	37.6799	37.22	37.42	1138631.0
2016-01-11	ARGT	ETF	16.9	16.92	16.55	16.75	17800.0
2016-01-11	ARKG	ETF	18.98	18.98	17.931	17.931	1400.0
2016-01-11	ARKK	ETF	18.33	18.33	18.17	18.17	2200.0
2016-01-11	ARKQ	ETF	17.75	17.75	17.051	17.051	1300.0
2016-01-11	ARKW	ETF	21.55	21.55	20.78	20.78	1100.0
2016-01-11	ASEA	ETF	11.55	11.55	11.34	11.4	11000.0
2016-01-11	ASET	ETF	23.38	23.38	23.13	23.24	5001.0
2016-01-11	ASHR	ETF	23.85	23.9	23.44	23.67	2910300.0
2016-01-11	ASHS	ETF	33.33	33.33	32.25	32.78	178700.0
2016-01-11	ASHX	ETF	21.73	21.84	21.45	21.83	4667.0
2016-01-11	ATMP	ETF	17.21	17.21	16.36	16.52	242600.0
2016-01-11	BAB	ETF	29.38	29.5095	29.37	29.41	153469.0
2016-01-11	BAL	ETF	40.77	41.319	40.66	40.69	18767.0
2016-01-11	BBC	ETF	23.68	23.77	21.58	22.14	16463.0
2016-01-11	BBH	ETF	116.5	116.5	109.84	112.11	118600.0
2016-01-11	BBP	ETF	27.0	27.0	25.07	25.76	22800.0
2016-01-11	BCM	ETF	22.431	22.46	22.4291	22.458	7389.0

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

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