PREVIEW / etf_daily / 2017-10-17

all etf daily files

  file:    by_date/etf_daily/2017/2017-10-17.parquet
  size:    57 KB
  rows:    1,473

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-10-17	SPY	ETF	255.23	255.52	254.98	255.47	31561000.0
2017-10-17	QQQ	ETF	148.79	149.06	148.57	149.04	13138157.0
2017-10-17	IWM	ETF	149.27	149.77	148.5	148.81	18046800.0
2017-10-17	DIA	ETF	229.71	229.96	229.52	229.85	1838000.0
2017-10-17	GLD	ETF	122.03	122.32	121.73	122.13	7041300.0
2017-10-17	TLT	ETF	125.39	126.09	125.39	125.92	4969600.0
2017-10-17	AADR	ETF	57.47	58.38	56.92	57.06	45200.0
2017-10-17	AAXJ	ETF	75.12	75.22	74.94	75.0	1644200.0
2017-10-17	ACSI	ETF	29.43	29.469	29.43	29.45	2919.0
2017-10-17	ACTX	ETF	54.2805	57.8205	53.1005	57.2305	314.0
2017-10-17	ACWF	ETF	29.64	29.69	29.64	29.69	1269.0
2017-10-17	ACWI	ETF	69.97	70.02	69.86	70.0	1315700.0
2017-10-17	ACWV	ETF	82.54	82.65	82.41	82.63	186600.0
2017-10-17	ACWX	ETF	49.22	49.23	49.11	49.21	392904.0
2017-10-17	ADRE	ETF	43.49	43.59	43.163	43.2654	8327.0
2017-10-17	AFK	ETF	23.83	24.0	23.45	23.7475	8532.0
2017-10-17	AFTY	ETF	17.32	17.4	17.32	17.4	2300.0
2017-10-17	AGG	ETF	109.62	109.74	109.55	109.71	1764400.0
2017-10-17	AGGY	ETF	50.83	50.91	50.83	50.9	12400.0
2017-10-17	AGNG	ETF	19.79	19.85	19.615	19.85	14100.0
2017-10-17	AGQ	ETF	34.69	34.91	34.34	34.62	111800.0
2017-10-17	AGZ	ETF	113.5292	113.63	113.5292	113.62	7555.0
2017-10-17	AIA	ETF	64.2	64.2	63.95	64.06	83403.0
2017-10-17	AIRR	ETF	26.17	26.221	25.951	26.0	48800.0
2017-10-17	AIVI	ETF	42.98	42.98	42.88	42.96	6100.0
2017-10-17	ALTY	ETF	15.739	15.739	15.7	15.7	1700.0
2017-10-17	AMJ	ETF	27.91	28.06	27.69	27.8	1418308.0
2017-10-17	AMLP	ETF	55.5	55.65	54.9	55.05	1237800.0
2017-10-17	AMZA	ETF	87.5	87.5	86.3	86.7	163560.0
2017-10-17	ANGL	ETF	30.29	30.34	30.25	30.34	245000.0
2017-10-17	AOA	ETF	54.12	54.2	54.08	54.2	33400.0
2017-10-17	AOK	ETF	34.7	34.7	34.64	34.68	87984.0
2017-10-17	AOM	ETF	38.08	38.17	38.07	38.16	86127.0
2017-10-17	AOR	ETF	45.13	45.2	45.12	45.19	117134.0
2017-10-17	ARCM	ETF	100.14	100.15	100.125	100.125	200.0
2017-10-17	ARGT	ETF	31.51	31.73	31.36	31.51	55800.0
2017-10-17	ARKG	ETF	26.6	26.71	26.42	26.47	56900.0
2017-10-17	ARKK	ETF	34.67	34.84	34.556	34.73	97400.0
2017-10-17	ARKQ	ETF	32.67	32.76	32.56	32.59	42300.0
2017-10-17	ARKW	ETF	41.58	41.705	41.41	41.66	60900.0
2017-10-17	ASEA	ETF	15.93	15.94	15.93	15.94	1200.0
2017-10-17	ASET	ETF	28.34	28.39	28.34	28.37	11148.0
2017-10-17	ASHR	ETF	30.05	30.08	29.98	30.02	566500.0
2017-10-17	ASHS	ETF	36.5	36.5	36.34	36.39	13300.0
2017-10-17	ATMP	ETF	21.21	21.22	21.07	21.17	39500.0
2017-10-17	BAB	ETF	30.59	30.61	30.531	30.61	114829.0
2017-10-17	BAL	ETF	44.5	44.8311	44.5	44.82	1910.0
2017-10-17	BAR	ETF	12.848	12.848	12.848	12.848	2250.0
2017-10-17	BBC	ETF	28.68	28.87	28.64	28.78	11899.0
2017-10-17	BBH	ETF	134.71	136.33	134.71	135.77	20100.0

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

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