PREVIEW / etf_daily / 2017-11-28

all etf daily files

  file:    by_date/etf_daily/2017/2017-11-28.parquet
  size:    59 KB
  rows:    1,521

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-11-28	SPY	ETF	260.76	262.9	260.65	262.87	98971700.0
2017-11-28	QQQ	ETF	156.52	156.69	155.7	156.59	25227320.0
2017-11-28	IWM	ETF	151.02	152.97	150.66	152.86	35898300.0
2017-11-28	DIA	ETF	236.32	238.44	236.23	238.34	4844500.0
2017-11-28	GLD	ETF	123.05	123.17	122.53	122.81	5603100.0
2017-11-28	TLT	ETF	126.77	127.18	126.47	126.79	5983000.0
2017-11-28	AADR	ETF	57.1	57.1	56.82	56.99	22600.0
2017-11-28	AAXJ	ETF	77.42	77.6	77.15	77.52	1042400.0
2017-11-28	ACSI	ETF	30.1762	30.4072	30.1762	30.4072	1246.0
2017-11-28	ACTX	ETF	78.4707	82.7187	64.9006	74.3407	896.0
2017-11-28	ACWF	ETF	30.62	30.62	30.61	30.62	5579.0
2017-11-28	ACWI	ETF	71.32	71.66	71.21	71.65	1015900.0
2017-11-28	ACWV	ETF	83.82	84.4	83.77	84.4	1192300.0
2017-11-28	ACWX	ETF	49.9	49.9943	49.76	49.94	467754.0
2017-11-28	ADRE	ETF	43.43	43.62	43.3165	43.4685	11696.0
2017-11-28	AFK	ETF	24.37	24.71	24.351	24.5812	33149.0
2017-11-28	AFTY	ETF	18.61	18.68	18.61	18.677	16200.0
2017-11-28	AGG	ETF	109.59	109.63	109.47	109.53	5126900.0
2017-11-28	AGGY	ETF	50.75	50.78	50.67	50.68	88000.0
2017-11-28	AGNG	ETF	19.75	19.75	19.61	19.61	1000.0
2017-11-28	AGQ	ETF	34.54	34.54	33.36	33.7	116200.0
2017-11-28	AGZ	ETF	113.53	113.605	113.495	113.5499	11503.0
2017-11-28	AGZD	ETF	24.045	24.095	24.045	24.055	2000.0
2017-11-28	AIA	ETF	67.27	67.5175	67.115	67.36	74635.0
2017-11-28	AIEQ	ETF	25.03	25.408	25.01	25.4	93400.0
2017-11-28	AIRR	ETF	26.15	26.66	26.15	26.66	29200.0
2017-11-28	AIVI	ETF	43.21	43.36	43.16	43.32	62600.0
2017-11-28	ALTY	ETF	15.7	15.7	15.439	15.47	6100.0
2017-11-28	AMJ	ETF	25.39	25.61	25.33	25.38	3305509.0
2017-11-28	AMLP	ETF	50.2	50.35	49.75	49.9	4038460.0
2017-11-28	AMZA	ETF	78.0	78.4	77.3	77.8	147070.0
2017-11-28	ANGL	ETF	30.06	30.18	30.04	30.17	353800.0
2017-11-28	AOA	ETF	54.85	55.22	54.85	55.11	31700.0
2017-11-28	AOK	ETF	34.85	34.89	34.8233	34.85	332675.0
2017-11-28	AOM	ETF	38.42	38.54	38.37	38.54	121433.0
2017-11-28	AOR	ETF	45.67	45.82	45.65	45.77	146641.0
2017-11-28	ARCM	ETF	100.23	100.23	100.23	100.23	600.0
2017-11-28	ARGT	ETF	32.38	32.38	32.12	32.18	41400.0
2017-11-28	ARKG	ETF	25.37	25.37	24.85	25.275	26300.0
2017-11-28	ARKK	ETF	37.45	37.75	37.34	37.67	433800.0
2017-11-28	ARKQ	ETF	34.96	35.02	34.756	34.98	50000.0
2017-11-28	ARKW	ETF	46.34	46.71	46.15	46.39	228800.0
2017-11-28	ASEA	ETF	16.64	16.69	16.63	16.63	1900.0
2017-11-28	ASET	ETF	28.43	28.46	28.4183	28.459	1391.0
2017-11-28	ASHR	ETF	31.09	31.19	31.05	31.13	652100.0
2017-11-28	ASHS	ETF	34.68	34.7	34.64	34.7	4100.0
2017-11-28	ASHX	ETF	22.85	22.87	22.83	22.87	2148.0
2017-11-28	ATMP	ETF	19.14	19.39	19.11	19.28	125900.0
2017-11-28	BAB	ETF	30.63	30.68	30.48	30.53	148946.0
2017-11-28	BAL	ETF	47.24	47.7827	47.23	47.71	25271.0

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

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