PREVIEW / etf_daily / 2021-04-20

all etf daily files

  file:    by_date/etf_daily/2021/2021-04-20.parquet
  size:    88 KB
  rows:    2,331

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
2021-04-20	SPY	ETF	413.91	415.09	410.59	412.17	81851800.0
2021-04-20	QQQ	ETF	338.2	339.52	334.3816	336.41	38081818.0
2021-04-20	IWM	ETF	220.77	221.62	215.24	217.19	35570800.0
2021-04-20	DIA	ETF	339.4	339.86	336.75	338.12	3762900.0
2021-04-20	GLD	ETF	165.65	166.81	165.62	166.48	6532000.0
2021-04-20	TLT	ETF	138.45	139.76	138.43	139.5	11476500.0
2021-04-20	AAA	ETF	25.054	25.06	25.04	25.05	1289.0
2021-04-20	AAAU	ETF	17.61	17.72	17.6	17.7	434400.0
2021-04-20	AADR	ETF	63.56	63.56	62.49	62.83	1600.0
2021-04-20	AAXJ	ETF	93.86	93.97	92.83	93.16	1036700.0
2021-04-20	ABEQ	ETF	27.22	27.243	27.19	27.243	2200.0
2021-04-20	ACES	ETF	71.96	72.88	70.46	71.27	55800.0
2021-04-20	ACIO	ETF	29.64	29.64	29.436	29.45	12000.0
2021-04-20	ACSI	ETF	47.5	47.7099	47.5	47.7099	603.0
2021-04-20	ACTV	ETF	36.005	36.005	35.6099	35.7371	5062.0
2021-04-20	ACTX	ETF	4.8	4.8	4.8	4.8	456.0
2021-04-20	ACVF	ETF	30.79	30.79	30.59	30.7	2300.0
2021-04-20	ACWF	ETF	37.74	37.74	37.37	37.4852	9187.0
2021-04-20	ACWI	ETF	98.73	98.83	97.84	98.21	2495400.0
2021-04-20	ACWV	ETF	101.03	101.65	101.03	101.56	195100.0
2021-04-20	ACWX	ETF	56.58	56.65	56.07	56.19	1063312.0
2021-04-20	ADFI	ETF	9.64	9.673	9.64	9.673	1800.0
2021-04-20	ADIV	ETF	18.96	18.96	18.94	18.94	100.0
2021-04-20	ADME	ETF	38.51	38.51	38.24	38.33	8100.0
2021-04-20	ADRE	ETF	56.04	56.15	55.16	55.4887	72320.0
2021-04-20	AESR	ETF	13.13	13.15	13.03	13.06	10200.0
2021-04-20	AFIF	ETF	9.72	9.74	9.71	9.74	40249.0
2021-04-20	AFK	ETF	21.66	21.72	21.55	21.63	12036.0
2021-04-20	AFLG	ETF	24.681	24.681	24.681	24.681	200.0
2021-04-20	AFMC	ETF	24.661	24.661	24.661	24.661	100.0
2021-04-20	AFSM	ETF	25.159	25.159	25.159	25.159	100.0
2021-04-20	AFTY	ETF	22.43	22.43	22.288	22.288	3800.0
2021-04-20	AGG	ETF	114.42	114.67	114.39	114.63	4322200.0
2021-04-20	AGGY	ETF	51.7	51.86	51.7	51.8	303000.0
2021-04-20	AGNG	ETF	28.71	28.81	28.6	28.775	2500.0
2021-04-20	AGQ	ETF	45.65	46.8	45.56	45.74	577100.0
2021-04-20	AGZ	ETF	118.19	118.34	118.141	118.34	29441.0
2021-04-20	AGZD	ETF	23.51	23.62	23.5	23.555	165600.0
2021-04-20	AIA	ETF	93.36	93.51	92.42	92.7	101020.0
2021-04-20	AIEQ	ETF	38.87	39.0	38.04	38.25	56200.0
2021-04-20	AIQ	ETF	29.69	29.69	29.23	29.3661	14838.0
2021-04-20	AIRR	ETF	40.9	41.063	40.0	40.39	67300.0
2021-04-20	AIVI	ETF	43.34	43.34	43.02	43.14	3600.0
2021-04-20	ALTL	ETF	38.48	38.5851	38.33	38.5851	4899.0
2021-04-20	ALTY	ETF	13.18	13.18	13.03	13.069	18100.0
2021-04-20	AMJ	ETF	17.0	17.05	16.63	16.95	617399.0
2021-04-20	AMLP	ETF	31.42	31.45	30.72	31.35	2422500.0
2021-04-20	AMNA	ETF	29.7312	29.7312	29.7312	29.7312	0.0
2021-04-20	AMND	ETF	31.647	31.647	31.647	31.647	0.0
2021-04-20	AMOM	ETF	35.15	35.15	34.68	34.87	41700.0

> showing 50 of 2,331 rows — these rows as CSV

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