PREVIEW / etf_daily / 2021-05-06

all etf daily files

  file:    by_date/etf_daily/2021/2021-05-06.parquet
  size:    88 KB
  rows:    2,319

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-05-06	SPY	ETF	415.83	419.21	413.68	419.07	74321400.0
2021-05-06	QQQ	ETF	328.76	331.67	326.45	331.51	46814283.0
2021-05-06	IWM	ETF	222.65	222.81	218.64	222.59	27647300.0
2021-05-06	DIA	ETF	342.93	345.64	341.91	345.51	4276700.0
2021-05-06	GLD	ETF	167.95	170.29	167.92	170.06	13574100.0
2021-05-06	TLT	ETF	139.25	140.19	139.2	139.92	21907600.0
2021-05-06	AAA	ETF	25.0	25.0	25.0	25.0	110.0
2021-05-06	AAAU	ETF	17.85	18.09	17.84	18.07	472100.0
2021-05-06	AADR	ETF	64.99	65.37	64.99	65.37	600.0
2021-05-06	AAXJ	ETF	92.94	93.42	92.71	93.39	1635200.0
2021-05-06	ABEQ	ETF	27.84	28.01	27.79	28.003	6300.0
2021-05-06	ACES	ETF	67.66	67.78	65.85	67.11	400700.0
2021-05-06	ACIO	ETF	29.65	29.79	29.56	29.79	27200.0
2021-05-06	ACSI	ETF	48.73	49.0694	48.7201	49.0694	1024.0
2021-05-06	ACTV	ETF	37.3399	37.79	37.1	37.66	17508.0
2021-05-06	ACVF	ETF	30.84	31.13	30.82	31.129	7400.0
2021-05-06	ACWF	ETF	37.73	37.9259	37.649	37.9259	3056.0
2021-05-06	ACWI	ETF	99.13	99.76	98.62	99.71	3563700.0
2021-05-06	ACWV	ETF	101.84	102.5	101.75	102.46	165400.0
2021-05-06	ACWX	ETF	56.96	57.35	56.81	57.35	748020.0
2021-05-06	ADFI	ETF	9.78	9.78	9.69	9.695	1100.0
2021-05-06	ADIV	ETF	18.653	18.653	18.653	18.653	111900.0
2021-05-06	ADME	ETF	38.55	38.732	38.43	38.732	14900.0
2021-05-06	ADRE	ETF	56.21	56.7193	55.88	56.4688	8649.0
2021-05-06	AESR	ETF	13.33	13.33	13.185	13.29	20100.0
2021-05-06	AFIF	ETF	9.72	9.75	9.71	9.7328	38803.0
2021-05-06	AFK	ETF	22.0	22.1	21.9	22.1	20701.0
2021-05-06	AFLG	ETF	24.97	25.079	24.94	25.079	1700.0
2021-05-06	AFMC	ETF	25.506	25.506	25.506	25.506	100.0
2021-05-06	AFSM	ETF	25.754	25.754	25.754	25.754	1600.0
2021-05-06	AFTY	ETF	22.544	22.544	22.544	22.544	100.0
2021-05-06	AGG	ETF	114.55	114.71	114.53	114.64	4739400.0
2021-05-06	AGGY	ETF	51.81	51.85	51.78	51.85	148100.0
2021-05-06	AGNG	ETF	28.391	28.6	28.345	28.6	7400.0
2021-05-06	AGQ	ETF	49.4	51.7	49.37	51.25	1842000.0
2021-05-06	AGZ	ETF	118.19	118.2461	118.1269	118.21	57385.0
2021-05-06	AGZD	ETF	23.52	23.565	23.51	23.54	15200.0
2021-05-06	AIA	ETF	91.28	91.87	91.171	91.72	159439.0
2021-05-06	AIEQ	ETF	37.5	37.5	36.57	37.22	54900.0
2021-05-06	AIQ	ETF	28.52	28.56	28.2	28.5158	32937.0
2021-05-06	AIRR	ETF	42.11	42.33	41.61	42.33	71600.0
2021-05-06	AIVI	ETF	43.67	43.99	43.67	43.99	5300.0
2021-05-06	ALTL	ETF	41.7	41.7	41.31	41.5411	103600.0
2021-05-06	ALTY	ETF	13.369	13.37	13.23	13.33	18900.0
2021-05-06	AMJ	ETF	18.2	18.4	17.83	18.4	426300.0
2021-05-06	AMLP	ETF	33.51	33.93	32.88	33.93	2369000.0
2021-05-06	AMNA	ETF	32.1756	32.1756	32.1756	32.1756	1.0
2021-05-06	AMND	ETF	34.1689	34.1689	34.1689	34.1689	0.0
2021-05-06	AMOM	ETF	34.54	34.73	34.22	34.73	14500.0
2021-05-06	AMPS	ETF	9.9401	9.95	9.93	9.94	13944.0

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

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