PREVIEW / etf_daily / 2017-05-17

all etf daily files

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

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-17	SPY	ETF	240.08	240.08	235.75	235.82	172174100.0
2017-05-17	QQQ	ETF	138.55	138.77	136.05	136.07	55642178.0
2017-05-17	IWM	ETF	136.33	137.04	134.75	134.89	50791200.0
2017-05-17	DIA	ETF	208.12	208.59	206.37	206.47	5717400.0
2017-05-17	GLD	ETF	119.36	120.02	119.27	119.79	13936900.0
2017-05-17	TLT	ETF	122.63	123.54	122.39	123.28	11236400.0
2017-05-17	AADR	ETF	49.55	49.55	48.35	48.35	62600.0
2017-05-17	AAXJ	ETF	66.01	66.04	65.42	65.42	1682300.0
2017-05-17	ACSI	ETF	28.13	28.13	27.99	28.0	2080.0
2017-05-17	ACTX	ETF	72.2756	74.3407	67.8506	69.6206	571.0
2017-05-17	ACWF	ETF	26.505	26.6099	26.4396	26.4396	2426.0
2017-05-17	ACWI	ETF	65.06	65.18	64.5	64.5	1467800.0
2017-05-17	ACWV	ETF	78.45	78.74	78.4	78.5	436800.0
2017-05-17	ACWX	ETF	45.8	45.81	45.42	45.44	406936.0
2017-05-17	ADRE	ETF	38.75	38.75	38.23	38.2768	19487.0
2017-05-17	AFK	ETF	21.48	21.51	21.38	21.47	6532.0
2017-05-17	AFTY	ETF	13.93	13.93	13.79	13.83	15700.0
2017-05-17	AGG	ETF	109.35	109.6	109.28	109.58	2464500.0
2017-05-17	AGGY	ETF	50.51	50.605	50.51	50.59	8100.0
2017-05-17	AGQ	ETF	35.63	35.8	34.75	35.22	349800.0
2017-05-17	AGZ	ETF	113.32	113.75	113.32	113.6	20691.0
2017-05-17	AGZD	ETF	24.055	24.06	24.01	24.05	5600.0
2017-05-17	AIA	ETF	55.61	55.65	55.15	55.21	27119.0
2017-05-17	AIQ	ETF	13.1	13.2	13.1	13.175	10692.0
2017-05-17	AIRR	ETF	23.2	23.374	23.0	23.0	117900.0
2017-05-17	AIVI	ETF	41.36	41.37	41.11	41.11	9800.0
2017-05-17	ALTY	ETF	15.21	15.385	15.21	15.35	8100.0
2017-05-17	AMJ	ETF	31.41	31.46	30.84	30.86	1347605.0
2017-05-17	AMLP	ETF	61.35	61.4	60.45	60.65	2446340.0
2017-05-17	AMZA	ETF	104.4	104.5	102.9	103.1	64380.0
2017-05-17	ANGL	ETF	29.61	29.67	29.57	29.58	257400.0
2017-05-17	AOA	ETF	51.2	51.3	50.73	50.75	86300.0
2017-05-17	AOK	ETF	33.72	33.7899	33.69	33.71	82026.0
2017-05-17	AOM	ETF	36.88	37.006	36.84	36.87	74000.0
2017-05-17	AOR	ETF	43.14	43.21	42.95	42.98	104300.0
2017-05-17	ARCM	ETF	100.05	100.05	100.05	100.05	200.0
2017-05-17	ARGT	ETF	30.74	30.75	30.35	30.35	150300.0
2017-05-17	ARKG	ETF	20.66	20.66	20.064	20.064	3900.0
2017-05-17	ARKK	ETF	26.98	26.98	26.08	26.12	48500.0
2017-05-17	ARKQ	ETF	28.5	28.5	27.61	27.61	55700.0
2017-05-17	ARKW	ETF	32.29	32.29	31.47	31.47	34400.0
2017-05-17	ASEA	ETF	14.81	14.93	14.79	14.79	11200.0
2017-05-17	ASET	ETF	26.92	26.92	26.88	26.88	861.0
2017-05-17	ASHR	ETF	24.67	24.71	24.58	24.6	761400.0
2017-05-17	ASHS	ETF	31.6	31.62	31.57	31.57	2500.0
2017-05-17	ASHX	ETF	19.085	19.085	19.085	19.085	2047.0
2017-05-17	ATMP	ETF	23.25	23.25	22.77	22.77	46300.0
2017-05-17	BAB	ETF	29.67	29.86	29.6024	29.81	242485.0
2017-05-17	BAL	ETF	52.98	52.98	50.92	51.23	12222.0
2017-05-17	BBC	ETF	22.0	22.07	21.66	21.66	34091.0

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

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