PREVIEW / etf_daily / 2019-09-23

all etf daily files

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

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-23	SPY	ETF	297.55	299.0	297.27	298.21	43476800.0
2019-09-23	QQQ	ETF	190.36	191.07	189.72	190.5	22917563.0
2019-09-23	IWM	ETF	154.86	155.95	154.56	155.31	14944600.0
2019-09-23	DIA	ETF	268.25	269.97	268.07	269.36	1898300.0
2019-09-23	GLD	ETF	143.22	143.94	143.07	143.75	9006500.0
2019-09-23	TLT	ETF	142.24	143.16	141.7	141.86	15246700.0
2019-09-23	AAAU	ETF	15.17	15.24	15.15	15.23	67400.0
2019-09-23	AADR	ETF	48.0	48.71	48.0	48.61	6500.0
2019-09-23	AAXJ	ETF	67.41	67.65	67.32	67.6	888600.0
2019-09-23	ACES	ETF	31.8	32.129	31.674	32.11	14100.0
2019-09-23	ACIO	ETF	24.87	24.92	24.811	24.857	28000.0
2019-09-23	ACSI	ETF	34.0206	34.0952	34.0206	34.0952	603.0
2019-09-23	ACTX	ETF	19.9422	20.0484	18.8802	19.9835	198.0
2019-09-23	ACWF	ETF	29.11	29.2313	29.11	29.2085	13270.0
2019-09-23	ACWI	ETF	74.01	74.3	73.94	74.13	928500.0
2019-09-23	ACWV	ETF	94.67	94.99	94.61	94.87	198600.0
2019-09-23	ACWX	ETF	46.2	46.41	46.2	46.39	700294.0
2019-09-23	ADRE	ETF	39.31	39.31	39.1231	39.1906	7413.0
2019-09-23	AFIF	ETF	9.76	9.76	9.7122	9.72	35693.0
2019-09-23	AFK	ETF	20.71	22.4	20.58	20.625	8583.0
2019-09-23	AFTY	ETF	16.91	16.975	16.91	16.975	1000.0
2019-09-23	AGG	ETF	113.02	113.24	112.94	112.97	3412000.0
2019-09-23	AGGY	ETF	52.36	52.44	52.312	52.36	137400.0
2019-09-23	AGNG	ETF	21.889	21.889	21.675	21.675	3200.0
2019-09-23	AGQ	ETF	34.87	35.74	34.8	35.73	591000.0
2019-09-23	AGZ	ETF	116.26	116.4895	116.25	116.31	24087.0
2019-09-23	AGZD	ETF	23.94	23.985	23.94	23.94	5600.0
2019-09-23	AIA	ETF	58.88	59.185	58.88	59.14	4971.0
2019-09-23	AIEQ	ETF	26.38	26.509	26.36	26.42	29200.0
2019-09-23	AIQ	ETF	16.26	16.27	16.191	16.24	7052.0
2019-09-23	AIRR	ETF	26.655	26.911	26.591	26.911	5800.0
2019-09-23	AIVI	ETF	41.07	41.19	41.01	41.16	9400.0
2019-09-23	ALTY	ETF	14.94	15.23	14.7	14.98	9600.0
2019-09-23	AMJ	ETF	24.03	24.16	23.8433	23.91	1161688.0
2019-09-23	AMLP	ETF	47.2	47.25	46.85	47.1	2570880.0
2019-09-23	AMUB	ETF	15.0821	15.0821	15.0821	15.0821	0.0
2019-09-23	AMZA	ETF	50.7	51.2	50.2	50.7	46930.0
2019-09-23	ANGL	ETF	29.55	29.58	29.43	29.51	1375600.0
2019-09-23	AOA	ETF	55.17	55.19	54.99	55.15	28500.0
2019-09-23	AOK	ETF	35.7	35.74	35.63	35.67	302616.0
2019-09-23	AOM	ETF	39.25	39.36	39.21	39.3	102656.0
2019-09-23	AOR	ETF	46.06	46.2167	46.06	46.1531	43685.0
2019-09-23	ARGT	ETF	22.71	22.74	22.58	22.59	25300.0
2019-09-23	ARKF	ETF	21.75	21.756	21.64	21.707	14100.0
2019-09-23	ARKG	ETF	32.28	32.42	31.833	31.9	67600.0
2019-09-23	ARKK	ETF	44.63	44.844	44.45	44.54	141400.0
2019-09-23	ARKQ	ETF	32.27	32.48	32.169	32.4	21800.0
2019-09-23	ARKW	ETF	49.88	50.026	49.62	49.81	23500.0
2019-09-23	ASEA	ETF	15.62	15.86	15.62	15.8	1000.0
2019-09-23	ASET	ETF	29.94	29.96	29.94	29.96	384.0

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

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