PREVIEW / etf_daily / 2021-11-30

all etf daily files

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

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-30	SPY	ETF	462.0	464.03	455.3	455.56	148559600.0
2021-11-30	QQQ	ETF	398.78	401.19	391.75	393.82	81332693.0
2021-11-30	IWM	ETF	220.66	221.86	215.88	218.17	64908400.0
2021-11-30	DIA	ETF	348.7	350.01	344.36	344.9	9543500.0
2021-11-30	GLD	ETF	167.77	169.01	165.37	165.5	12925300.0
2021-11-30	TLT	ETF	150.83	152.07	150.25	151.59	31481100.0
2021-11-30	AAA	ETF	25.04	25.04	25.04	25.04	106.0
2021-11-30	AAAU	ETF	17.84	17.98	17.6	17.61	250700.0
2021-11-30	AADR	ETF	61.79	62.23	60.94	61.4	7200.0
2021-11-30	AAXJ	ETF	83.18	83.77	82.45	83.29	1216900.0
2021-11-30	ABEQ	ETF	27.17	27.23	26.981	26.981	5900.0
2021-11-30	ACES	ETF	74.85	75.69	72.513	74.02	94300.0
2021-11-30	ACIO	ETF	31.665	31.71	31.35	31.37	69100.0
2021-11-30	ACSI	ETF	51.1607	51.1607	51.1607	51.1607	26.0
2021-11-30	ACT	ETF	20.8	21.13	20.69	20.76	140107.0
2021-11-30	ACTV	ETF	36.155	36.2799	35.87	36.0664	4717.0
2021-11-30	ACVF	ETF	34.72	34.72	34.066	34.066	11300.0
2021-11-30	ACWF	ETF	37.9	37.96	37.2901	37.45	13150.0
2021-11-30	ACWI	ETF	103.87	104.34	102.5	102.88	7431500.0
2021-11-30	ACWV	ETF	105.15	105.19	103.68	103.68	116200.0
2021-11-30	ACWX	ETF	54.9474	55.15	54.2	54.68	4685440.0
2021-11-30	ADFI	ETF	9.61	9.61	9.605	9.605	600.0
2021-11-30	ADIV	ETF	17.345	17.345	17.345	17.345	100.0
2021-11-30	ADME	ETF	41.925	42.05	41.49	41.49	30500.0
2021-11-30	ADRE	ETF	47.36	47.5601	46.33	46.7982	11824.0
2021-11-30	AEMB	ETF	47.99	48.0	47.978	47.978	9200.0
2021-11-30	AESR	ETF	14.59	14.59	14.37	14.39	5900.0
2021-11-30	AFIF	ETF	9.58	9.58	9.56	9.575	23754.0
2021-11-30	AFK	ETF	20.37	20.58	20.01	20.165	21456.0
2021-11-30	AFLG	ETF	27.04	27.17	26.71	26.71	4500.0
2021-11-30	AFMC	ETF	25.55	25.68	25.45	25.45	8000.0
2021-11-30	AFSM	ETF	26.98	26.98	26.62	26.743	1200.0
2021-11-30	AFTY	ETF	20.82	20.82	20.817	20.817	400.0
2021-11-30	AGG	ETF	114.87	115.11	114.5	114.77	13109000.0
2021-11-30	AGGY	ETF	51.9	52.04	51.815	51.899	159300.0
2021-11-30	AGNG	ETF	27.75	27.75	27.45	27.489	3600.0
2021-11-30	AGOV	ETF	98.42	98.42	98.04	98.35	4020.0
2021-11-30	AGOX	ETF	25.65	25.65	24.86	24.99	34600.0
2021-11-30	AGQ	ETF	33.79	35.01	33.12	33.4	950500.0
2021-11-30	AGZ	ETF	118.33	118.38	118.0	118.08	54727.0
2021-11-30	AGZD	ETF	23.325	23.375	23.275	23.275	111000.0
2021-11-30	AHHX	ETF	10.11	10.3799	10.08	10.23	9880.0
2021-11-30	AHYB	ETF	49.415	49.415	49.415	49.415	100.0
2021-11-30	AIA	ETF	76.73	77.1855	75.97	76.51	58655.0
2021-11-30	AIEQ	ETF	42.79	42.92	41.876	41.99	12400.0
2021-11-30	AIQ	ETF	32.21	32.39	31.54	31.62	40383.0
2021-11-30	AIRR	ETF	44.89	44.95	43.75	43.93	41200.0
2021-11-30	AIVI	ETF	40.25	40.35	39.78	40.01	8300.0
2021-11-30	ALTL	ETF	44.65	44.65	43.57	43.61	26638.0
2021-11-30	ALTY	ETF	13.23	13.309	13.15	13.17	18500.0

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

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