PREVIEW / etf_daily / 2019-09-17

all etf daily files

  file:    by_date/etf_daily/2019/2019-09-17.parquet
  size:    69 KB
  rows:    1,816

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-09-17	SPY	ETF	299.94	301.02	299.75	300.92	41475500.0
2019-09-17	QQQ	ETF	191.7	192.6	191.29	192.6	21113675.0
2019-09-17	IWM	ETF	157.36	157.57	156.45	157.49	22986700.0
2019-09-17	DIA	ETF	270.59	271.58	270.37	271.56	1756200.0
2019-09-17	GLD	ETF	141.82	142.11	141.22	141.6	7010200.0
2019-09-17	TLT	ETF	138.36	139.6	138.02	139.03	9081200.0
2019-09-17	AAAU	ETF	15.02	15.03	14.97	14.99	15400.0
2019-09-17	AADR	ETF	48.46	49.01	48.46	49.01	7400.0
2019-09-17	AAXJ	ETF	67.53	68.08	67.48	68.05	418300.0
2019-09-17	ACES	ETF	31.28	31.615	31.28	31.574	8400.0
2019-09-17	ACIO	ETF	25.02	25.02	24.992	24.992	30300.0
2019-09-17	ACSI	ETF	34.4299	34.5319	34.4299	34.5319	1646.0
2019-09-17	ACTX	ETF	17.7002	21.8302	17.7002	18.2902	275.0
2019-09-17	ACWF	ETF	29.3256	29.464	29.3256	29.464	2834.0
2019-09-17	ACWI	ETF	74.19	74.53	74.13	74.47	1054000.0
2019-09-17	ACWV	ETF	93.65	94.42	93.65	94.33	170800.0
2019-09-17	ACWX	ETF	46.27	46.59	46.24	46.54	431893.0
2019-09-17	ADRE	ETF	39.4369	39.6739	39.4369	39.666	1814.0
2019-09-17	AFIF	ETF	9.7435	9.77	9.7435	9.76	3996.0
2019-09-17	AFK	ETF	21.0	21.0	20.845	20.8761	3046.0
2019-09-17	AFTY	ETF	17.03	17.143	17.03	17.143	4900.0
2019-09-17	AGG	ETF	112.11	112.37	112.02	112.22	2614200.0
2019-09-17	AGGY	ETF	51.82	51.97	51.82	51.94	104400.0
2019-09-17	AGNG	ETF	21.46	21.54	21.39	21.463	2900.0
2019-09-17	AGQ	ETF	32.78	33.53	32.52	33.26	254500.0
2019-09-17	AGZ	ETF	115.77	115.94	115.68	115.886	40783.0
2019-09-17	AGZD	ETF	23.925	23.97	23.925	23.94	3800.0
2019-09-17	AIA	ETF	59.36	59.76	59.36	59.75	15367.0
2019-09-17	AIEQ	ETF	26.41	26.67	26.41	26.62	14000.0
2019-09-17	AIQ	ETF	16.29	16.41	16.29	16.3827	7605.0
2019-09-17	AIRR	ETF	27.15	27.15	26.995	27.1	5100.0
2019-09-17	AIVI	ETF	41.18	41.4	41.18	41.4	5800.0
2019-09-17	ALTY	ETF	14.845	14.872	14.845	14.872	1000.0
2019-09-17	AMJ	ETF	24.14	24.22	23.775	24.05	1506872.0
2019-09-17	AMLP	ETF	47.2	47.65	46.9	47.35	3576500.0
2019-09-17	AMUB	ETF	15.1412	15.1412	15.1412	15.1412	0.0
2019-09-17	AMZA	ETF	51.4	52.0	50.8	51.5	86620.0
2019-09-17	ANGL	ETF	29.51	29.55	29.45	29.51	160600.0
2019-09-17	AOA	ETF	55.09	55.3	55.05	55.3	37800.0
2019-09-17	AOK	ETF	35.51	35.59	35.48	35.58	61209.0
2019-09-17	AOM	ETF	39.19	39.26	39.1	39.26	79229.0
2019-09-17	AOR	ETF	46.05	46.2	46.0216	46.2	54450.0
2019-09-17	ARGT	ETF	22.81	22.98	22.7	22.87	27700.0
2019-09-17	ARKF	ETF	22.018	22.1	21.98	22.09	4700.0
2019-09-17	ARKG	ETF	32.11	32.14	31.774	31.977	47600.0
2019-09-17	ARKK	ETF	45.35	45.5	45.149	45.5	194100.0
2019-09-17	ARKQ	ETF	32.98	33.154	32.9	33.14	7300.0
2019-09-17	ARKW	ETF	51.07	51.46	51.045	51.46	25000.0
2019-09-17	ASEA	ETF	15.79	15.99	15.79	15.99	600.0
2019-09-17	ASET	ETF	29.9001	29.92	29.9001	29.92	553.0

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

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