PREVIEW / etf_daily / 2021-03-15

all etf daily files

  file:    by_date/etf_daily/2021/2021-03-15.parquet
  size:    86 KB
  rows:    2,275

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-03-15	SPY	ETF	394.33	396.69	392.03	396.41	73427200.0
2021-03-15	QQQ	ETF	315.79	319.0	314.095	318.83	43123176.0
2021-03-15	IWM	ETF	233.34	234.53	231.91	234.42	21497400.0
2021-03-15	DIA	ETF	329.18	330.24	326.81	330.09	4456000.0
2021-03-15	GLD	ETF	162.31	162.55	161.43	162.2	8104500.0
2021-03-15	TLT	ETF	136.49	137.09	136.41	136.86	11366500.0
2021-03-15	AAA	ETF	25.09	25.09	25.09	25.09	152.0
2021-03-15	AAAU	ETF	17.23	17.27	17.15	17.23	386900.0
2021-03-15	AADR	ETF	64.2	64.22	63.97	64.22	3900.0
2021-03-15	AAXJ	ETF	93.72	94.4	93.44	94.4	670600.0
2021-03-15	ABEQ	ETF	26.32	26.436	26.295	26.436	18900.0
2021-03-15	ACES	ETF	81.0	81.99	80.13	81.72	220400.0
2021-03-15	ACIO	ETF	27.859	28.02	27.811	28.0	26900.0
2021-03-15	ACSI	ETF	46.33	46.5452	46.235	46.5452	633.0
2021-03-15	ACTV	ETF	36.85	36.99	36.8099	36.9857	3255.0
2021-03-15	ACTX	ETF	4.0	4.0	3.5	3.5	836.0
2021-03-15	ACVF	ETF	29.45	29.606	29.39	29.606	3700.0
2021-03-15	ACWF	ETF	35.8	36.07	35.74	36.07	6369.0
2021-03-15	ACWI	ETF	95.14	95.7	94.67	95.68	866800.0
2021-03-15	ACWV	ETF	97.01	97.72	97.01	97.7	300800.0
2021-03-15	ACWX	ETF	55.62	55.83	55.32	55.8	1888281.0
2021-03-15	ADFI	ETF	9.625	9.65	9.62	9.63	9500.0
2021-03-15	ADME	ETF	35.91	36.26	35.91	36.26	22500.0
2021-03-15	ADRE	ETF	58.53	58.6	57.9254	58.525	29141.0
2021-03-15	AESR	ETF	12.51	12.58	12.46	12.58	31300.0
2021-03-15	AFIF	ETF	9.74	9.74	9.69	9.715	43178.0
2021-03-15	AFK	ETF	21.67	21.69	21.58	21.68	8566.0
2021-03-15	AFLG	ETF	23.83	23.88	23.71	23.88	6700.0
2021-03-15	AFMC	ETF	24.867	24.867	24.867	24.867	100.0
2021-03-15	AFSM	ETF	26.12	26.237	26.12	26.237	200.0
2021-03-15	AFTY	ETF	22.8	22.8	22.715	22.772	5600.0
2021-03-15	AGG	ETF	113.6	114.01	113.6	113.91	5000500.0
2021-03-15	AGGY	ETF	51.38	51.45	51.342	51.42	131800.0
2021-03-15	AGNG	ETF	27.76	27.85	27.72	27.81	2700.0
2021-03-15	AGQ	ETF	47.42	47.96	46.83	47.74	1307200.0
2021-03-15	AGZ	ETF	117.85	117.9604	117.85	117.91	32504.0
2021-03-15	AGZD	ETF	23.685	23.685	23.66	23.67	17200.0
2021-03-15	AIA	ETF	93.7	94.56	93.42	94.56	144260.0
2021-03-15	AIEQ	ETF	39.82	40.19	39.53	40.115	50500.0
2021-03-15	AIQ	ETF	28.62	28.915	28.59	28.915	30862.0
2021-03-15	AIRR	ETF	42.57	42.57	41.73	42.35	99300.0
2021-03-15	AIVI	ETF	42.73	42.79	42.55	42.79	5200.0
2021-03-15	ALTL	ETF	40.77	40.77	40.2	40.7334	27651.0
2021-03-15	ALTY	ETF	12.73	12.84	12.709	12.801	14900.0
2021-03-15	AMJ	ETF	17.58	17.7	17.375	17.51	1293862.0
2021-03-15	AMLP	ETF	32.36	32.68	32.05	32.35	1878800.0
2021-03-15	AMNA	ETF	30.7875	30.7875	30.7875	30.7875	7.0
2021-03-15	AMND	ETF	32.7596	32.7596	32.7596	32.7596	0.0
2021-03-15	AMOM	ETF	32.65	32.944	32.604	32.944	3100.0
2021-03-15	AMPS	ETF	9.9913	10.0	9.99	9.99	1260.0

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

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