PREVIEW / etf_daily / 2018-05-16

all etf daily files

  file:    by_date/etf_daily/2018/2018-05-16.parquet
  size:    61 KB
  rows:    1,559

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
2018-05-16	SPY	ETF	271.14	272.76	271.11	272.24	53942600.0
2018-05-16	QQQ	ETF	168.1	169.37	168.01	168.98	22941159.0
2018-05-16	IWM	ETF	159.49	161.32	159.47	160.92	21004400.0
2018-05-16	DIA	ETF	247.18	248.28	246.97	247.97	2034400.0
2018-05-16	GLD	ETF	122.38	122.61	122.03	122.29	4943300.0
2018-05-16	TLT	ETF	117.42	117.53	116.79	116.8	6518000.0
2018-05-16	AADR	ETF	59.33	59.7	59.04	59.54	18700.0
2018-05-16	AAXJ	ETF	76.79	77.42	76.79	77.37	534400.0
2018-05-16	ACSI	ETF	31.39	31.39	31.39	31.39	390.0
2018-05-16	ACTX	ETF	60.4755	64.1926	58.7645	61.9506	852.0
2018-05-16	ACWF	ETF	31.2728	31.38	31.19	31.38	19992.0
2018-05-16	ACWI	ETF	73.28	73.6	73.24	73.49	800100.0
2018-05-16	ACWV	ETF	83.54	83.81	83.46	83.6	46700.0
2018-05-16	ACWX	ETF	50.41	50.58	50.36	50.52	394919.0
2018-05-16	ADRE	ETF	44.67	44.99	44.67	44.99	4211.0
2018-05-16	AFK	ETF	25.49	25.91	25.49	25.76	4404.0
2018-05-16	AFTY	ETF	17.329	17.375	17.329	17.375	300.0
2018-05-16	AGG	ETF	105.36	105.42	105.15	105.17	2477500.0
2018-05-16	AGGY	ETF	48.35	48.35	48.225	48.23	76800.0
2018-05-16	AGNG	ETF	20.15	20.15	20.01	20.119	900.0
2018-05-16	AGQ	ETF	30.58	31.12	30.54	30.84	404300.0
2018-05-16	AGZ	ETF	110.7	110.7	110.51	110.52	14415.0
2018-05-16	AGZD	ETF	24.06	24.06	24.05	24.06	2400.0
2018-05-16	AIA	ETF	67.34	67.95	67.34	67.84	145906.0
2018-05-16	AIEQ	ETF	27.31	27.68	27.31	27.66	66600.0
2018-05-16	AIQ	ETF	15.04	15.06	15.0099	15.0362	6157.0
2018-05-16	AIRR	ETF	26.13	26.47	26.13	26.26	12800.0
2018-05-16	AIVI	ETF	44.28	44.43	44.21	44.4	7000.0
2018-05-16	ALTY	ETF	14.7	14.78	14.7	14.78	3400.0
2018-05-16	AMJ	ETF	26.91	27.1	26.84	27.03	1023264.0
2018-05-16	AMLP	ETF	51.05	51.65	51.05	51.65	2307880.0
2018-05-16	AMZA	ETF	75.5	76.4	75.5	76.2	66600.0
2018-05-16	ANGL	ETF	29.13	29.14	29.03	29.13	215900.0
2018-05-16	AOA	ETF	54.04	54.28	54.04	54.23	51000.0
2018-05-16	AOK	ETF	34.01	34.0264	33.9702	34.01	28328.0
2018-05-16	AOM	ETF	37.6	37.65	37.5574	37.62	43596.0
2018-05-16	AOR	ETF	44.73	44.829	44.68	44.79	56539.0
2018-05-16	ARGT	ETF	31.26	31.64	31.2	31.64	304000.0
2018-05-16	ARKG	ETF	28.13	28.47	27.76	28.23	126400.0
2018-05-16	ARKK	ETF	42.67	43.258	42.56	43.07	205400.0
2018-05-16	ARKQ	ETF	34.12	34.522	34.12	34.46	27200.0
2018-05-16	ARKW	ETF	52.64	53.28	52.62	53.23	183100.0
2018-05-16	ASEA	ETF	17.32	17.32	17.32	17.32	100.0
2018-05-16	ASET	ETF	27.855	27.97	27.855	27.9355	2775.0
2018-05-16	ASHR	ETF	30.69	30.78	30.6	30.78	1130800.0
2018-05-16	ASHS	ETF	34.43	34.44	34.38	34.42	10500.0
2018-05-16	ATMP	ETF	20.44	20.48	20.39	20.48	15200.0
2018-05-16	BAB	ETF	29.5	29.5	29.4033	29.44	44439.0
2018-05-16	BAL	ETF	51.34	51.34	51.138	51.23	900.0
2018-05-16	BAR	ETF	12.889	12.926	12.888	12.926	294730.0

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

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