PREVIEW / etf_daily / 2019-10-14

all etf daily files

  file:    by_date/etf_daily/2019/2019-10-14.parquet
  size:    70 KB
  rows:    1,837

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
2019-10-14	SPY	ETF	295.93	296.67	295.57	295.95	40394800.0
2019-10-14	QQQ	ETF	190.82	191.7	190.645	191.09	15372774.0
2019-10-14	IWM	ETF	149.91	150.15	149.1	149.67	10692600.0
2019-10-14	DIA	ETF	267.6	268.73	267.44	267.86	1194600.0
2019-10-14	GLD	ETF	140.45	140.82	140.34	140.59	4006700.0
2019-10-14	TLT	ETF	141.48	141.51	141.08	141.46	5936900.0
2019-10-14	AAAU	ETF	14.87	14.91	14.86	14.9	267800.0
2019-10-14	AADR	ETF	48.18	48.38	48.08	48.29	7300.0
2019-10-14	AAXJ	ETF	67.75	67.85	67.56	67.6	894000.0
2019-10-14	ACES	ETF	30.94	30.968	30.72	30.75	6400.0
2019-10-14	ACIO	ETF	24.491	24.54	24.491	24.494	6500.0
2019-10-14	ACSI	ETF	33.734	33.74	33.6999	33.6999	916.0
2019-10-14	ACTX	ETF	14.7501	14.7501	11.2101	13.9241	870.0
2019-10-14	ACWF	ETF	28.92	29.0399	28.92	28.9528	7303.0
2019-10-14	ACWI	ETF	73.75	73.94	73.72	73.77	1201900.0
2019-10-14	ACWV	ETF	94.66	94.75	94.44	94.5	143800.0
2019-10-14	ACWX	ETF	46.2	46.32	46.19	46.22	948857.0
2019-10-14	ADRE	ETF	39.42	39.42	39.24	39.3499	1213.0
2019-10-14	AFIF	ETF	9.745	9.745	9.73	9.74	9846.0
2019-10-14	AFK	ETF	20.2417	20.2417	20.16	20.16	1933.0
2019-10-14	AFTY	ETF	17.6	17.64	17.57	17.57	4200.0
2019-10-14	AGG	ETF	112.93	112.93	112.82	112.92	1716600.0
2019-10-14	AGGY	ETF	52.23	52.24	52.16	52.23	39200.0
2019-10-14	AGNG	ETF	21.355	21.355	21.355	21.355	100.0
2019-10-14	AGQ	ETF	31.25	31.72	31.03	31.52	211200.0
2019-10-14	AGZ	ETF	116.21	116.2399	116.17	116.2112	18402.0
2019-10-14	AGZD	ETF	23.91	23.92	23.875	23.91	26800.0
2019-10-14	AIA	ETF	60.03	60.27	59.95	59.96	8423.0
2019-10-14	AIEQ	ETF	26.19	26.33	26.19	26.22	45000.0
2019-10-14	AIQ	ETF	16.19	16.19	16.07	16.17	4486.0
2019-10-14	AIRR	ETF	26.5	26.59	26.44	26.556	8500.0
2019-10-14	AIVI	ETF	40.63	40.75	40.63	40.67	6000.0
2019-10-14	ALTY	ETF	14.64	14.686	14.625	14.647	9500.0
2019-10-14	AMJ	ETF	22.12	22.3399	22.03	22.11	1316000.0
2019-10-14	AMLP	ETF	43.85	44.0	43.35	43.65	4057920.0
2019-10-14	AMUB	ETF	13.9513	13.9513	13.9513	13.9513	0.0
2019-10-14	AMZA	ETF	46.8	46.8	46.1	46.4	34360.0
2019-10-14	ANGL	ETF	29.24	29.33	29.21	29.32	854300.0
2019-10-14	AOA	ETF	54.72	54.8	54.66	54.75	31600.0
2019-10-14	AOK	ETF	35.51	35.57	35.4901	35.57	108620.0
2019-10-14	AOM	ETF	39.0	39.08	39.0	39.02	129884.0
2019-10-14	AOR	ETF	45.83	45.88	45.737	45.83	64732.0
2019-10-14	ARCM	ETF	100.166	100.19	100.166	100.19	300.0
2019-10-14	ARGT	ETF	23.0	23.05	22.83	22.86	24200.0
2019-10-14	ARKF	ETF	21.66	21.721	21.648	21.711	7200.0
2019-10-14	ARKG	ETF	28.53	28.98	28.305	28.61	51600.0
2019-10-14	ARKK	ETF	41.86	42.46	41.734	42.26	164200.0
2019-10-14	ARKQ	ETF	32.0	32.272	31.883	32.21	6500.0
2019-10-14	ARKW	ETF	49.2	49.706	49.2	49.61	59000.0
2019-10-14	ASEA	ETF	15.54	15.76	15.54	15.62	5300.0

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

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