PREVIEW / etf_daily / 2017-05-25

all etf daily files

  file:    by_date/etf_daily/2017/2017-05-25.parquet
  size:    55 KB
  rows:    1,397

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
2017-05-25	SPY	ETF	241.2	242.08	240.96	241.76	64071700.0
2017-05-25	QQQ	ETF	140.315	141.33	140.01	140.97	23928591.0
2017-05-25	IWM	ETF	138.14	138.61	137.2	137.58	22804200.0
2017-05-25	DIA	ETF	210.52	210.92	210.3	210.58	2198200.0
2017-05-25	GLD	ETF	119.52	119.7	119.29	119.48	4105100.0
2017-05-25	TLT	ETF	123.02	123.28	122.76	123.27	6464800.0
2017-05-25	AADR	ETF	47.43	47.83	47.43	47.66	23800.0
2017-05-25	AAXJ	ETF	66.98	67.15	66.96	67.1	330000.0
2017-05-25	ACSI	ETF	28.6099	28.7	28.6099	28.6917	1247.0
2017-05-25	ACTX	ETF	46.6104	52.5105	41.8904	51.9205	1334.0
2017-05-25	ACWF	ETF	27.05	27.07	26.945	27.0516	10937.0
2017-05-25	ACWI	ETF	65.78	65.96	65.78	65.87	1089500.0
2017-05-25	ACWV	ETF	79.63	79.94	79.55	79.86	265800.0
2017-05-25	ACWX	ETF	46.15	46.25	46.08	46.125	422124.0
2017-05-25	ADRE	ETF	38.39	38.4	38.28	38.33	6646.0
2017-05-25	AFK	ETF	21.63	21.895	21.63	21.711	3336.0
2017-05-25	AFTY	ETF	14.61	14.62	14.59	14.59	8100.0
2017-05-25	AGG	ETF	109.45	109.49	109.37	109.48	1558100.0
2017-05-25	AGGY	ETF	50.41	50.43	50.37	50.408	13400.0
2017-05-25	AGQ	ETF	36.5	36.62	36.2	36.29	53900.0
2017-05-25	AGZ	ETF	113.57	113.73	113.41	113.72	51384.0
2017-05-25	AGZD	ETF	23.985	23.985	23.935	23.94	1600.0
2017-05-25	AIA	ETF	56.5	56.77	56.5	56.74	66526.0
2017-05-25	AIQ	ETF	13.2	13.3	13.15	13.175	51505.0
2017-05-25	AIRR	ETF	23.33	23.33	23.03	23.07	50000.0
2017-05-25	AIVI	ETF	42.04	42.14	41.97	42.02	14500.0
2017-05-25	ALTY	ETF	15.44	15.62	15.44	15.565	12300.0
2017-05-25	AMJ	ETF	31.02	31.25	30.6	30.7	2254433.0
2017-05-25	AMLP	ETF	61.45	61.7	60.8	61.0	2148060.0
2017-05-25	AMZA	ETF	104.7	105.4	103.5	104.0	56640.0
2017-05-25	ANGL	ETF	29.8	29.84	29.72	29.73	224300.0
2017-05-25	AOA	ETF	51.53	51.64	51.44	51.57	44400.0
2017-05-25	AOK	ETF	33.85	33.9472	33.85	33.93	53891.0
2017-05-25	AOM	ETF	37.15	37.1815	37.071	37.17	133034.0
2017-05-25	AOR	ETF	43.46	43.52	43.434	43.47	46295.0
2017-05-25	ARCM	ETF	100.1	100.1	100.1	100.1	200.0
2017-05-25	ARGT	ETF	30.53	30.75	30.53	30.68	123500.0
2017-05-25	ARKG	ETF	21.15	21.15	20.731	20.758	7200.0
2017-05-25	ARKK	ETF	28.72	29.08	28.13	28.61	117300.0
2017-05-25	ARKQ	ETF	28.62	28.74	28.507	28.73	73900.0
2017-05-25	ARKW	ETF	35.4	35.91	34.72	35.328	143800.0
2017-05-25	ASEA	ETF	15.03	15.03	14.96	14.96	9200.0
2017-05-25	ASET	ETF	27.4206	27.4206	27.4206	27.4206	232.0
2017-05-25	ASHR	ETF	25.3	25.56	25.28	25.5	2097000.0
2017-05-25	ASHS	ETF	30.86	31.02	30.84	30.98	15000.0
2017-05-25	ASHX	ETF	19.72	19.72	19.72	19.72	8861.0
2017-05-25	ATMP	ETF	22.68	23.08	22.6	22.72	73100.0
2017-05-25	BAB	ETF	29.86	29.88	29.78	29.87	199794.0
2017-05-25	BAL	ETF	49.158	49.34	49.02	49.02	10528.0
2017-05-25	BBC	ETF	22.38	22.4554	22.1747	22.229	3882.0

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

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