PREVIEW / etf_daily / 2017-11-30

all etf daily files

  file:    by_date/etf_daily/2017/2017-11-30.parquet
  size:    60 KB
  rows:    1,535

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-30	SPY	ETF	263.76	266.05	263.67	265.01	127894400.0
2017-11-30	QQQ	ETF	154.46	155.45	154.145	155.15	56595465.0
2017-11-30	IWM	ETF	154.1	154.55	153.28	153.65	32230700.0
2017-11-30	DIA	ETF	240.68	243.49	240.41	242.84	6586400.0
2017-11-30	GLD	ETF	121.44	121.7	120.64	121.1	7936300.0
2017-11-30	TLT	ETF	125.31	125.52	124.44	125.12	9630000.0
2017-11-30	AADR	ETF	56.32	56.32	55.69	55.85	116100.0
2017-11-30	AAXJ	ETF	75.78	76.19	75.56	75.63	1812000.0
2017-11-30	ACSI	ETF	30.89	31.0102	30.89	30.97	2833.0
2017-11-30	ACTX	ETF	58.7055	71.0956	56.0505	70.2106	600.0
2017-11-30	ACWF	ETF	32.98	32.98	30.13	30.62	14763.0
2017-11-30	ACWI	ETF	71.67	71.89	71.54	71.72	7719200.0
2017-11-30	ACWV	ETF	84.54	84.83	84.47	84.56	592500.0
2017-11-30	ACWX	ETF	49.7	49.73	49.47	49.49	769104.0
2017-11-30	ADRE	ETF	42.64	42.64	42.21	42.387	3626.0
2017-11-30	AFK	ETF	24.55	24.55	24.37	24.505	3535.0
2017-11-30	AFTY	ETF	18.51	18.51	18.33	18.37	7400.0
2017-11-30	AGG	ETF	109.25	109.3	109.02	109.08	4011300.0
2017-11-30	AGGY	ETF	50.59	50.61	50.44	50.52	34900.0
2017-11-30	AGNG	ETF	19.55	19.55	19.55	19.55	1100.0
2017-11-30	AGQ	ETF	31.86	32.16	31.58	32.03	171400.0
2017-11-30	AGZ	ETF	113.4	113.4191	113.1605	113.22	21884.0
2017-11-30	AGZD	ETF	24.08	24.135	24.045	24.045	4000.0
2017-11-30	AIA	ETF	65.96	65.96	65.52	65.63	159421.0
2017-11-30	AIEQ	ETF	25.5	25.74	25.5	25.55	134200.0
2017-11-30	AIRR	ETF	27.24	27.316	27.1	27.12	27800.0
2017-11-30	AIVI	ETF	43.54	43.6	43.34	43.41	22400.0
2017-11-30	ALTY	ETF	15.4	15.46	15.37	15.385	25200.0
2017-11-30	AMJ	ETF	25.18	26.31	25.14	26.24	6975094.0
2017-11-30	AMLP	ETF	49.65	52.0	49.65	51.85	9563300.0
2017-11-30	AMUB	ETF	16.4101	16.4275	16.4101	16.4275	378.0
2017-11-30	AMZA	ETF	77.5	81.9	77.5	81.9	205560.0
2017-11-30	ANGL	ETF	30.13	30.13	29.93	30.08	1219800.0
2017-11-30	AOA	ETF	55.17	55.32	55.14	55.23	70200.0
2017-11-30	AOK	ETF	34.85	34.86	34.79	34.84	166982.0
2017-11-30	AOM	ETF	38.49	38.5243	38.44	38.49	142614.0
2017-11-30	AOR	ETF	45.8	45.88	45.74	45.84	481038.0
2017-11-30	ARCM	ETF	100.24	100.24	100.24	100.24	600.0
2017-11-30	ARGT	ETF	32.22	32.43	32.15	32.27	119100.0
2017-11-30	ARKG	ETF	25.22	25.719	25.22	25.683	29900.0
2017-11-30	ARKK	ETF	37.08	37.38	36.69	37.2	249800.0
2017-11-30	ARKQ	ETF	34.11	34.15	33.9	34.05	49500.0
2017-11-30	ARKW	ETF	45.25	45.489	44.8	45.29	129700.0
2017-11-30	ASEA	ETF	16.8	17.06	16.78	17.04	4800.0
2017-11-30	ASET	ETF	28.6289	28.679	28.6289	28.65	3559.0
2017-11-30	ASHR	ETF	30.66	30.67	30.56	30.56	741300.0
2017-11-30	ASHS	ETF	34.52	34.53	34.41	34.41	1500.0
2017-11-30	ASHX	ETF	22.64	22.64	22.491	22.503	1169.0
2017-11-30	ATMP	ETF	19.59	19.86	19.27	19.86	83900.0
2017-11-30	BAB	ETF	30.47	30.5	30.36	30.44	200342.0

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

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