PREVIEW / etf_daily / 2021-04-16

all etf daily files

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

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-16	SPY	ETF	417.25	417.91	415.73	417.26	82037300.0
2021-04-16	QQQ	ETF	342.15	342.23	340.08	342.01	40860099.0
2021-04-16	IWM	ETF	225.4	225.68	223.01	224.65	23943000.0
2021-04-16	DIA	ETF	341.73	342.43	340.98	341.86	3748900.0
2021-04-16	GLD	ETF	166.24	166.81	165.94	166.35	10057600.0
2021-04-16	TLT	ETF	139.1	139.73	138.93	139.26	15238400.0
2021-04-16	AAA	ETF	25.0522	25.06	25.05	25.05	2256.0
2021-04-16	AAAU	ETF	17.65	17.72	17.64	17.68	505200.0
2021-04-16	AADR	ETF	64.19	64.73	64.19	64.67	5500.0
2021-04-16	AAXJ	ETF	94.13	94.24	93.79	94.1	696800.0
2021-04-16	ABEQ	ETF	27.31	27.33	27.295	27.327	1800.0
2021-04-16	ACES	ETF	73.29	74.75	73.05	74.62	331700.0
2021-04-16	ACIO	ETF	29.52	29.7	29.48	29.67	38900.0
2021-04-16	ACSI	ETF	48.5289	48.5289	48.5289	48.5289	309.0
2021-04-16	ACTV	ETF	37.4	37.4	36.46	36.5742	3788.0
2021-04-16	ACVF	ETF	31.21	31.27	31.04	31.13	11700.0
2021-04-16	ACWF	ETF	37.87	38.039	37.87	37.99	12616.0
2021-04-16	ACWI	ETF	99.56	99.72	99.25	99.68	2934300.0
2021-04-16	ACWV	ETF	101.22	101.83	101.22	101.64	85500.0
2021-04-16	ACWX	ETF	57.07	57.245	56.97	57.24	2282488.0
2021-04-16	ADFI	ETF	9.681	9.7	9.68	9.695	800.0
2021-04-16	ADIV	ETF	18.884	18.932	18.884	18.932	100.0
2021-04-16	ADME	ETF	38.64	38.74	38.58	38.71	28000.0
2021-04-16	ADRE	ETF	56.66	56.71	56.5095	56.67	5748.0
2021-04-16	AESR	ETF	13.21	13.26	13.19	13.243	13500.0
2021-04-16	AFIF	ETF	9.72	9.72	9.71	9.7116	51076.0
2021-04-16	AFK	ETF	21.75	21.75	21.74	21.75	9872.0
2021-04-16	AFLG	ETF	24.96	25.04	24.96	25.022	7900.0
2021-04-16	AFSM	ETF	26.058	26.058	26.058	26.058	100.0
2021-04-16	AFTY	ETF	21.95	22.01	21.95	21.97	3200.0
2021-04-16	AGG	ETF	114.56	114.67	114.5	114.54	3663600.0
2021-04-16	AGGY	ETF	51.8	51.89	51.8	51.81	115400.0
2021-04-16	AGNG	ETF	28.86	28.86	28.66	28.78	5500.0
2021-04-16	AGQ	ETF	46.85	46.93	46.3	46.41	761400.0
2021-04-16	AGZ	ETF	118.18	118.2524	118.18	118.22	29571.0
2021-04-16	AGZD	ETF	23.52	23.56	23.47	23.555	110400.0
2021-04-16	AIA	ETF	94.37	94.37	93.79	93.85	98471.0
2021-04-16	AIEQ	ETF	39.77	39.82	39.358	39.54	40200.0
2021-04-16	AIQ	ETF	30.08	30.08	29.95	30.0	18395.0
2021-04-16	AIRR	ETF	41.36	41.79	41.345	41.583	117100.0
2021-04-16	AIVI	ETF	43.56	43.7	43.56	43.7	2400.0
2021-04-16	ALTL	ETF	39.9999	39.9999	39.82	39.9554	9065.0
2021-04-16	ALTY	ETF	13.16	13.16	13.066	13.13	22800.0
2021-04-16	AMJ	ETF	17.11	17.25	16.95	16.96	296791.0
2021-04-16	AMLP	ETF	31.78	31.85	31.31	31.33	1952300.0
2021-04-16	AMNA	ETF	29.96	29.96	29.96	29.96	0.0
2021-04-16	AMND	ETF	31.8523	31.8523	31.8523	31.8523	0.0
2021-04-16	AMOM	ETF	35.76	35.76	35.18	35.44	84000.0
2021-04-16	AMPS	ETF	9.97	10.0	9.91	9.98	35568.0
2021-04-16	AMTR	ETF	35.0305	35.0305	35.0305	35.0305	3.0

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

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