PREVIEW / etf_daily / 2018-11-15

all etf daily files

  file:    by_date/etf_daily/2018/2018-11-15.parquet
  size:    64 KB
  rows:    1,665

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-11-15	SPY	ETF	268.78	273.54	267.01	273.02	135101400.0
2018-11-15	QQQ	ETF	164.84	168.54	163.46	168.09	73254349.0
2018-11-15	IWM	ETF	148.49	151.8	148.13	151.58	24482000.0
2018-11-15	DIA	ETF	250.2	254.0	248.35	253.22	5667000.0
2018-11-15	GLD	ETF	114.83	114.99	114.56	114.77	8910600.0
2018-11-15	TLT	ETF	114.44	114.54	113.68	114.04	7879600.0
2018-11-15	AAAU	ETF	12.12	12.15	12.12	12.15	3400.0
2018-11-15	AADR	ETF	44.98	45.68	44.9	45.47	34100.0
2018-11-15	AAXJ	ETF	65.02	66.43	64.85	66.15	4019500.0
2018-11-15	ACES	ETF	24.18	24.18	24.18	24.18	100.0
2018-11-15	ACSI	ETF	32.3412	32.723	32.3117	32.723	23038.0
2018-11-15	ACTX	ETF	65.4906	72.5707	64.9006	70.2106	677.0
2018-11-15	ACWF	ETF	28.0445	28.665	28.0445	28.5199	4078.0
2018-11-15	ACWI	ETF	68.45	69.56	68.13	69.4	6045200.0
2018-11-15	ACWV	ETF	84.75	85.57	84.36	85.44	302300.0
2018-11-15	ACWX	ETF	43.99	44.655	43.87	44.56	2872873.0
2018-11-15	ADRE	ETF	37.72	38.43	37.72	38.2707	3179.0
2018-11-15	AFIF	ETF	10.01	10.0316	10.0	10.03	155924.0
2018-11-15	AFK	ETF	20.09	20.675	20.09	20.58	9155.0
2018-11-15	AFTY	ETF	14.33	14.575	14.315	14.51	14200.0
2018-11-15	AGG	ETF	104.48	104.51	104.31	104.49	3861300.0
2018-11-15	AGGY	ETF	47.53	47.53	47.46	47.51	19400.0
2018-11-15	AGNG	ETF	19.64	19.76	19.51	19.76	400.0
2018-11-15	AGQ	ETF	22.4	22.92	22.33	22.76	63000.0
2018-11-15	AGZ	ETF	110.5501	110.6008	110.461	110.5488	20965.0
2018-11-15	AGZD	ETF	23.9	23.95	23.77	23.775	44600.0
2018-11-15	AIA	ETF	56.65	57.77	56.47	57.62	119034.0
2018-11-15	AIEQ	ETF	25.83	26.456	25.82	26.34	34100.0
2018-11-15	AIQ	ETF	13.76	13.9875	13.64	13.9875	31927.0
2018-11-15	AIRR	ETF	24.78	25.28	24.721	25.21	534900.0
2018-11-15	AIVI	ETF	39.62	39.91	39.52	39.88	4500.0
2018-11-15	ALTY	ETF	14.427	14.46	14.42	14.451	5400.0
2018-11-15	AMJ	ETF	25.07	25.44	24.97	25.37	1281358.0
2018-11-15	AMLP	ETF	47.75	48.5	47.5	48.35	3437420.0
2018-11-15	AMZA	ETF	62.4	63.5	62.0	63.4	75630.0
2018-11-15	ANGL	ETF	27.58	27.64	27.44	27.61	509400.0
2018-11-15	AOA	ETF	50.96	51.61	50.8	51.49	71700.0
2018-11-15	AOK	ETF	33.04	33.22	33.04	33.19	85579.0
2018-11-15	AOM	ETF	36.37	36.5931	36.3	36.56	350863.0
2018-11-15	AOR	ETF	42.66	43.05	42.55	43.01	104847.0
2018-11-15	ARGT	ETF	25.44	26.08	25.44	26.08	26500.0
2018-11-15	ARKG	ETF	27.98	29.11	27.838	28.98	47700.0
2018-11-15	ARKK	ETF	42.37	43.909	42.293	43.84	278500.0
2018-11-15	ARKQ	ETF	32.93	33.7	32.9	33.6	15200.0
2018-11-15	ARKW	ETF	51.85	53.694	51.762	53.61	98400.0
2018-11-15	ARVR	ETF	17.72	17.86	17.72	17.86	953.0
2018-11-15	ASEA	ETF	15.46	15.73	15.46	15.73	1500.0
2018-11-15	ASET	ETF	26.68	26.8802	26.65	26.8802	949.0
2018-11-15	ASHR	ETF	23.68	24.15	23.61	24.0	3339300.0
2018-11-15	ASHS	ETF	24.47	24.78	24.35	24.72	26200.0

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

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