PREVIEW / etf_daily / 2020-05-05

all etf daily files

  file:    by_date/etf_daily/2020/2020-05-05.parquet
  size:    74 KB
  rows:    1,947

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
2020-05-05	SPY	ETF	286.64	289.25	283.71	286.19	79569900.0
2020-05-05	QQQ	ETF	217.4	220.14	216.85	217.66	37783075.0
2020-05-05	IWM	ETF	128.07	129.92	126.1	126.65	31209400.0
2020-05-05	DIA	ETF	240.02	241.74	238.7	238.8	3143500.0
2020-05-05	GLD	ETF	160.16	161.1	159.33	161.02	10563100.0
2020-05-05	TLT	ETF	165.57	166.27	165.27	166.09	7831800.0
2020-05-05	AAAU	ETF	17.0	17.08	16.91	17.07	460300.0
2020-05-05	AADR	ETF	45.62	46.08	45.56	45.83	6500.0
2020-05-05	AAXJ	ETF	63.0	63.26	62.74	62.75	2014900.0
2020-05-05	ABEQ	ETF	21.913	21.945	21.793	21.793	7500.0
2020-05-05	ACES	ETF	32.59	33.33	32.59	32.705	22900.0
2020-05-05	ACIO	ETF	24.004	24.11	23.92	23.96	54100.0
2020-05-05	ACSI	ETF	30.5575	30.5575	30.1775	30.1775	320.0
2020-05-05	ACTX	ETF	4.3041	5.31	4.248	5.31	127.0
2020-05-05	ACWF	ETF	25.83	26.1313	25.75	25.82	10051.0
2020-05-05	ACWI	ETF	67.82	68.27	67.54	67.6	2558800.0
2020-05-05	ACWV	ETF	85.83	86.46	85.71	85.9	473300.0
2020-05-05	ACWX	ETF	39.49	39.63	39.21	39.28	2534050.0
2020-05-05	ADME	ETF	30.09	30.39	30.09	30.177	51400.0
2020-05-05	ADRE	ETF	35.47	35.52	35.03	35.098	2907.0
2020-05-05	AESR	ETF	9.13	9.28	9.13	9.186	113000.0
2020-05-05	AFIF	ETF	9.8098	9.83	9.77	9.775	571847.0
2020-05-05	AFK	ETF	14.54	14.7397	14.36	14.44	31319.0
2020-05-05	AFTY	ETF	15.26	15.42	15.26	15.379	13600.0
2020-05-05	AGG	ETF	116.96	116.97	116.81	116.88	4611500.0
2020-05-05	AGGY	ETF	52.96	53.08	52.912	53.05	317800.0
2020-05-05	AGNG	ETF	22.768	22.775	22.768	22.775	600.0
2020-05-05	AGQ	ETF	20.04	20.4	19.8	20.3	361900.0
2020-05-05	AGZ	ETF	120.21	120.69	120.21	120.64	49016.0
2020-05-05	AGZD	ETF	23.73	23.73	23.18	23.435	16600.0
2020-05-05	AIA	ETF	58.83	58.85	58.53	58.53	42760.0
2020-05-05	AIEQ	ETF	25.71	25.876	25.51	25.662	12700.0
2020-05-05	AIQ	ETF	17.59	17.8778	17.59	17.83	8050.0
2020-05-05	AIRR	ETF	21.23	21.443	20.8	20.816	99900.0
2020-05-05	AIVI	ETF	33.06	33.06	32.8	32.82	1400.0
2020-05-05	ALTY	ETF	9.76	9.97	9.653	9.715	9300.0
2020-05-05	AMJ	ETF	13.69	14.23	13.12	13.2	1914798.0
2020-05-05	AMLP	ETF	25.65	26.05	24.65	24.85	5217740.0
2020-05-05	AMUB	ETF	8.6	8.6	8.2988	8.2988	4095.0
2020-05-05	AMZA	ETF	17.84	18.11	17.0	17.18	60400.0
2020-05-05	ANGL	ETF	26.78	26.98	26.71	26.92	876800.0
2020-05-05	AOA	ETF	50.59	51.03	50.51	50.59	73700.0
2020-05-05	AOK	ETF	34.9	35.06	34.9	34.95	290189.0
2020-05-05	AOM	ETF	37.92	38.15	37.87	37.97	342619.0
2020-05-05	AOR	ETF	43.54	43.74	43.43	43.47	244350.0
2020-05-05	ARCM	ETF	100.82	100.85	100.04	100.465	1900.0
2020-05-05	ARGT	ETF	18.04	18.5	17.89	18.02	6700.0
2020-05-05	ARKF	ETF	24.28	24.6	24.2	24.25	56000.0
2020-05-05	ARKG	ETF	42.02	42.298	41.24	41.57	386700.0
2020-05-05	ARKK	ETF	55.53	56.02	54.76	55.06	637400.0

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

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