PREVIEW / etf_daily / 2017-11-27

all etf daily files

  file:    by_date/etf_daily/2017/2017-11-27.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-27	SPY	ETF	260.41	260.75	260.0	260.23	52274900.0
2017-11-27	QQQ	ETF	156.2	156.56	155.83	156.19	22653389.0
2017-11-27	IWM	ETF	151.3	151.62	150.44	150.49	18416900.0
2017-11-27	DIA	ETF	235.5	236.33	235.39	235.73	2329500.0
2017-11-27	GLD	ETF	123.26	123.33	122.67	122.83	4961200.0
2017-11-27	TLT	ETF	126.86	127.05	126.42	126.62	6079900.0
2017-11-27	AADR	ETF	57.27	57.27	56.74	56.8	21600.0
2017-11-27	AAXJ	ETF	77.6	77.6	76.95	76.98	1147600.0
2017-11-27	ACSI	ETF	30.06	30.09	30.06	30.09	1367.0
2017-11-27	ACTX	ETF	83.1908	84.9608	76.7007	81.4207	1370.0
2017-11-27	ACWF	ETF	30.49	30.49	30.3743	30.3743	4697.0
2017-11-27	ACWI	ETF	71.31	71.33	71.07	71.09	1098100.0
2017-11-27	ACWV	ETF	83.53	83.63	83.53	83.58	147900.0
2017-11-27	ACWX	ETF	49.95	49.96	49.67	49.68	541404.0
2017-11-27	ADRE	ETF	43.82	43.82	43.29	43.29	23669.0
2017-11-27	AFK	ETF	24.4	24.5	24.23	24.26	6147.0
2017-11-27	AFTY	ETF	18.83	18.83	18.58	18.74	17800.0
2017-11-27	AGG	ETF	109.53	109.58	109.44	109.53	2653300.0
2017-11-27	AGGY	ETF	50.7	50.72	50.62	50.69	71500.0
2017-11-27	AGNG	ETF	19.77	19.77	19.57	19.625	1300.0
2017-11-27	AGQ	ETF	34.89	35.03	34.38	34.46	71100.0
2017-11-27	AGZ	ETF	113.43	113.58	113.43	113.46	12389.0
2017-11-27	AGZD	ETF	24.105	24.105	24.105	24.105	400.0
2017-11-27	AIA	ETF	67.28	67.28	66.8499	66.86	91568.0
2017-11-27	AIEQ	ETF	25.1	25.15	25.0	25.05	51500.0
2017-11-27	AIRR	ETF	26.29	26.32	26.09	26.09	11600.0
2017-11-27	AIVI	ETF	43.35	43.35	43.1	43.13	20400.0
2017-11-27	ALTY	ETF	15.468	15.49	15.4	15.445	12300.0
2017-11-27	AMJ	ETF	26.22	26.33	25.9744	25.99	2163956.0
2017-11-27	AMLP	ETF	50.75	50.85	50.05	50.05	3008520.0
2017-11-27	AMZA	ETF	79.6	79.8	78.0	78.0	171620.0
2017-11-27	ANGL	ETF	30.13	30.14	30.04	30.04	266200.0
2017-11-27	AOA	ETF	54.94	55.0	54.83	54.87	43900.0
2017-11-27	AOK	ETF	34.86	34.87	34.77	34.81	165533.0
2017-11-27	AOM	ETF	38.49	38.49	38.34	38.34	562175.0
2017-11-27	AOR	ETF	45.7	45.83	45.58	45.64	92370.0
2017-11-27	ARCM	ETF	100.21	100.21	100.21	100.21	600.0
2017-11-27	ARGT	ETF	32.63	32.83	32.32	32.34	32000.0
2017-11-27	ARKG	ETF	25.25	25.38	25.05	25.26	38300.0
2017-11-27	ARKK	ETF	37.14	37.41	37.01	37.26	301400.0
2017-11-27	ARKQ	ETF	34.83	34.83	34.55	34.72	53900.0
2017-11-27	ARKW	ETF	46.21	46.5	45.978	46.0	273800.0
2017-11-27	ASEA	ETF	16.61	16.61	16.5	16.5	1100.0
2017-11-27	ASET	ETF	28.4472	28.4472	28.4099	28.429	6409.0
2017-11-27	ASHR	ETF	31.14	31.14	30.96	31.02	1421400.0
2017-11-27	ASHS	ETF	34.38	34.38	34.03	34.05	10200.0
2017-11-27	ASHX	ETF	22.869	22.87	22.8135	22.8135	7814.0
2017-11-27	ATMP	ETF	19.8	19.8	19.6	19.62	383700.0
2017-11-27	BAB	ETF	30.7	30.71	30.61	30.67	62602.0
2017-11-27	BAL	ETF	47.7244	47.73	47.06	47.1132	2769.0

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

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