PREVIEW / etf_daily / 2021-11-23

all etf daily files

  file:    by_date/etf_daily/2021/2021-11-23.parquet
  size:    97 KB
  rows:    2,586

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-11-23	SPY	ETF	467.22	469.1	464.45	468.19	73206500.0
2021-11-23	QQQ	ETF	398.11	400.23	392.92	397.48	70098736.0
2021-11-23	IWM	ETF	231.39	233.0	228.62	231.33	33843800.0
2021-11-23	DIA	ETF	356.28	358.37	355.34	358.02	5789300.0
2021-11-23	GLD	ETF	167.28	167.6	166.53	167.28	8047800.0
2021-11-23	TLT	ETF	145.93	146.11	144.5	144.5	15318500.0
2021-11-23	AAA	ETF	25.04	25.04	25.02	25.03	27847.0
2021-11-23	AAAU	ETF	17.79	17.83	17.71	17.8	276600.0
2021-11-23	AADR	ETF	63.79	63.79	63.03	63.53	4000.0
2021-11-23	AAXJ	ETF	86.27	86.56	85.76	86.02	803300.0
2021-11-23	ABEQ	ETF	27.885	28.0	27.885	28.0	2300.0
2021-11-23	ACES	ETF	78.45	78.748	75.68	76.64	37300.0
2021-11-23	ACIO	ETF	31.99	32.03	31.81	32.03	68100.0
2021-11-23	ACSI	ETF	53.07	53.45	53.07	53.4404	2487.0
2021-11-23	ACT	ETF	23.28	23.38	22.21	22.89	237810.0
2021-11-23	ACTV	ETF	38.08	38.19	38.04	38.1369	4142.0
2021-11-23	ACTX	ETF	1.87	1.87	1.85	1.85	8143.0
2021-11-23	ACVF	ETF	35.0	35.0	34.76	34.99	9300.0
2021-11-23	ACWF	ETF	38.55	38.5863	38.37	38.5863	7899.0
2021-11-23	ACWI	ETF	105.81	106.23	105.2	105.91	2681400.0
2021-11-23	ACWV	ETF	106.15	106.61	106.09	106.55	127800.0
2021-11-23	ACWX	ETF	56.56	56.79	56.35	56.62	1394990.0
2021-11-23	ADFI	ETF	9.55	9.58	9.54	9.555	1200.0
2021-11-23	ADIV	ETF	17.79	17.79	17.79	17.79	100.0
2021-11-23	ADME	ETF	42.26	42.44	42.17	42.44	75000.0
2021-11-23	ADRE	ETF	49.005	49.005	48.2	48.52	6723.0
2021-11-23	AEMB	ETF	48.05	48.05	48.05	48.05	100.0
2021-11-23	AESR	ETF	14.75	14.84	14.72	14.821	6200.0
2021-11-23	AFIF	ETF	9.551	9.5599	9.54	9.55	23401.0
2021-11-23	AFK	ETF	21.07	21.07	20.77	20.86	2951.0
2021-11-23	AFLG	ETF	27.28	27.462	27.28	27.462	100.0
2021-11-23	AFMC	ETF	26.91	26.913	26.91	26.913	8600.0
2021-11-23	AFSM	ETF	28.55	28.55	28.369	28.369	900.0
2021-11-23	AFTY	ETF	21.06	21.061	20.99	21.025	3800.0
2021-11-23	AGG	ETF	113.71	113.77	113.45	113.45	6268600.0
2021-11-23	AGGY	ETF	51.44	51.47	51.31	51.35	92600.0
2021-11-23	AGNG	ETF	28.75	28.75	28.476	28.66	1500.0
2021-11-23	AGOV	ETF	97.9	97.91	97.88	97.88	735.0
2021-11-23	AGOX	ETF	26.16	26.16	25.71	25.92	92300.0
2021-11-23	AGQ	ETF	35.65	36.25	34.98	36.2	1098200.0
2021-11-23	AGZ	ETF	117.54	117.54	117.11	117.36	53975.0
2021-11-23	AGZD	ETF	23.395	23.42	23.38	23.39	38200.0
2021-11-23	AHHX	ETF	10.36	10.5	10.225	10.335	22712.0
2021-11-23	AHYB	ETF	49.76	49.76	49.737	49.737	100.0
2021-11-23	AIA	ETF	80.13	80.38	79.441	79.66	23625.0
2021-11-23	AIEQ	ETF	43.54	43.761	42.96	43.55	15700.0
2021-11-23	AIQ	ETF	32.4	32.55	31.96	32.16	24814.0
2021-11-23	AIRR	ETF	47.28	47.589	47.023	47.436	51100.0
2021-11-23	AIVI	ETF	41.24	41.44	41.24	41.44	8500.0
2021-11-23	ALTL	ETF	45.04	45.11	44.84	45.0833	38392.0

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

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