PREVIEW / etf_daily / 2018-12-12

all etf daily files

  file:    by_date/etf_daily/2018/2018-12-12.parquet
  size:    66 KB
  rows:    1,711

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-12-12	SPY	ETF	267.47	269.0	265.37	265.46	97976700.0
2018-12-12	QQQ	ETF	166.06	167.6	164.96	165.05	53779992.0
2018-12-12	IWM	ETF	144.88	146.76	144.76	144.82	27894800.0
2018-12-12	DIA	ETF	247.39	248.76	245.65	245.88	3734800.0
2018-12-12	GLD	ETF	117.7	117.95	117.61	117.79	4136800.0
2018-12-12	TLT	ETF	118.58	118.72	118.24	118.35	6182200.0
2018-12-12	AAAU	ETF	12.45	12.46	12.44	12.46	10100.0
2018-12-12	AADR	ETF	43.34	43.67	43.29	43.46	53200.0
2018-12-12	AAXJ	ETF	65.95	66.43	65.8	65.8	2706500.0
2018-12-12	ACES	ETF	24.898	24.898	24.864	24.864	400.0
2018-12-12	ACSI	ETF	31.6178	31.74	31.4713	31.4713	4421.0
2018-12-12	ACTX	ETF	60.1805	60.7705	56.6405	60.7705	1386.0
2018-12-12	ACWF	ETF	27.5899	27.81	27.5103	27.5103	131636.0
2018-12-12	ACWI	ETF	67.9	68.44	67.72	67.74	5630900.0
2018-12-12	ACWV	ETF	85.72	85.82	85.2	85.22	467700.0
2018-12-12	ACWX	ETF	43.61	43.89	43.53	43.53	6621295.0
2018-12-12	ADRE	ETF	37.7	37.9157	37.7	37.72	5323.0
2018-12-12	AFIF	ETF	9.9702	9.9969	9.96	9.976	26328.0
2018-12-12	AFK	ETF	20.5	20.5	20.42	20.42	2341.0
2018-12-12	AFTY	ETF	14.18	14.4	14.18	14.23	2600.0
2018-12-12	AGG	ETF	105.48	105.57	105.46	105.5	8089000.0
2018-12-12	AGGY	ETF	47.83	47.9	47.82	47.825	57700.0
2018-12-12	AGNG	ETF	20.313	20.313	20.313	20.313	400.0
2018-12-12	AGQ	ETF	23.97	24.26	23.93	24.07	165700.0
2018-12-12	AGZ	ETF	111.3	111.3392	111.201	111.243	24778.0
2018-12-12	AGZD	ETF	23.915	24.32	23.75	23.805	79600.0
2018-12-12	AIA	ETF	57.5	57.88	57.24	57.26	26294.0
2018-12-12	AIEQ	ETF	25.52	25.813	25.41	25.41	30900.0
2018-12-12	AIQ	ETF	14.0485	14.15	14.0485	14.11	7560.0
2018-12-12	AIRR	ETF	23.07	23.461	23.07	23.19	48400.0
2018-12-12	AIVI	ETF	39.21	39.46	39.21	39.24	13300.0
2018-12-12	ALTY	ETF	14.204	14.239	14.145	14.172	2300.0
2018-12-12	AMJ	ETF	24.28	24.35	24.02	24.08	3345393.0
2018-12-12	AMLP	ETF	47.15	47.65	46.85	47.2	5285840.0
2018-12-12	AMUB	ETF	15.1569	15.1569	15.1569	15.1569	0.0
2018-12-12	AMZA	ETF	59.5	60.1	58.9	59.4	84510.0
2018-12-12	ANGL	ETF	27.41	27.5	27.4	27.44	95600.0
2018-12-12	AOA	ETF	50.63	50.96	50.51	50.54	214100.0
2018-12-12	AOK	ETF	33.2	33.24	33.085	33.15	340404.0
2018-12-12	AOM	ETF	36.45	36.595	36.35	36.4	931835.0
2018-12-12	AOR	ETF	42.66	42.78	42.52	42.53	509877.0
2018-12-12	ARGT	ETF	25.69	25.83	25.54	25.54	39500.0
2018-12-12	ARKG	ETF	28.69	29.08	28.58	28.59	47700.0
2018-12-12	ARKK	ETF	43.12	44.05	42.97	43.31	471300.0
2018-12-12	ARKQ	ETF	32.17	32.883	32.17	32.52	12000.0
2018-12-12	ARKW	ETF	52.7	53.933	52.7	52.94	156000.0
2018-12-12	ARVR	ETF	17.3734	17.3734	17.3734	17.3734	139.0
2018-12-12	ASEA	ETF	15.82	15.98	15.82	15.87	1800.0
2018-12-12	ASET	ETF	27.09	27.09	26.94	26.94	4248.0
2018-12-12	ASHR	ETF	23.18	23.3	23.13	23.15	1491800.0

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

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