PREVIEW / etf_daily / 2022-01-28

all etf daily files

  file:    by_date/etf_daily/2022/2022-01-28.parquet
  size:    99 KB
  rows:    2,656

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
2022-01-28	SPY	ETF	432.68	442.0	427.82	441.95	164457400.0
2022-01-28	QQQ	ETF	343.03	352.02	337.95	351.8	108167897.0
2022-01-28	IWM	ETF	191.7	195.31	188.09	195.25	65870000.0
2022-01-28	DIA	ETF	341.86	347.18	337.9	347.11	12008900.0
2022-01-28	GLD	ETF	166.56	167.46	166.37	167.1	9782500.0
2022-01-28	TLT	ETF	142.09	143.46	141.85	143.13	12826500.0
2022-01-28	AAA	ETF	25.01	25.01	25.0	25.01	5227.0
2022-01-28	AAAU	ETF	17.73	17.82	17.71	17.77	584900.0
2022-01-28	AADR	ETF	60.23	60.96	60.23	60.96	1100.0
2022-01-28	AAXJ	ETF	78.69	79.0	77.87	78.98	1109600.0
2022-01-28	ABEQ	ETF	27.594	28.013	27.594	28.013	3000.0
2022-01-28	ACES	ETF	48.4	49.6	47.34	49.59	53900.0
2022-01-28	ACIO	ETF	30.73	31.235	30.73	31.17	30200.0
2022-01-28	ACSI	ETF	48.59	49.0288	48.59	49.0288	187.0
2022-01-28	ACT	ETF	20.84	21.395	20.53	21.14	147275.0
2022-01-28	ACTV	ETF	33.67	34.36	33.67	34.36	6631.0
2022-01-28	ACTX	ETF	1.0	1.05	0.95	0.95	4304.0
2022-01-28	ACVF	ETF	32.43	33.0	32.0	33.0	3800.0
2022-01-28	ACWF	ETF	35.93	36.32	35.57	36.31	24980.0
2022-01-28	ACWI	ETF	97.37	98.96	96.44	98.93	10745600.0
2022-01-28	ACWV	ETF	100.63	102.1	99.85	102.09	137100.0
2022-01-28	ACWX	ETF	52.64	53.1	52.28	53.1	4477738.0
2022-01-28	ADFI	ETF	9.34	9.36	9.325	9.345	3300.0
2022-01-28	ADIV	ETF	15.73	15.748	15.73	15.748	300.0
2022-01-28	ADME	ETF	40.2	40.93	40.14	40.93	12700.0
2022-01-28	ADRE	ETF	44.3	44.45	43.67	44.45	30334.0
2022-01-28	AEMB	ETF	46.863	46.863	46.863	46.863	100.0
2022-01-28	AESR	ETF	12.6	12.858	12.59	12.858	54900.0
2022-01-28	AFIF	ETF	9.43	9.45	9.43	9.45	134906.0
2022-01-28	AFK	ETF	19.94	20.09	19.84	20.09	2134.0
2022-01-28	AFLG	ETF	25.31	25.965	25.309	25.965	2400.0
2022-01-28	AFMC	ETF	23.515	24.077	23.515	24.077	600.0
2022-01-28	AFSM	ETF	24.313	24.313	24.313	24.313	100.0
2022-01-28	AFTY	ETF	19.56	19.56	19.42	19.525	2200.0
2022-01-28	AGG	ETF	111.46	111.86	111.44	111.81	10855600.0
2022-01-28	AGGY	ETF	50.15	50.33	50.13	50.31	110800.0
2022-01-28	AGNG	ETF	25.763	26.25	25.64	26.25	2400.0
2022-01-28	AGOV	ETF	95.84	95.9085	95.8381	95.8381	1720.0
2022-01-28	AGOX	ETF	23.42	23.65	22.98	23.65	189200.0
2022-01-28	AGQ	ETF	31.96	32.35	31.04	31.76	837300.0
2022-01-28	AGZ	ETF	115.86	116.11	115.8331	116.0	140775.0
2022-01-28	AGZD	ETF	23.33	23.33	23.235	23.255	58200.0
2022-01-28	AHHX	ETF	9.895	9.895	9.84	9.8897	4237.0
2022-01-28	AHYB	ETF	48.7	48.801	48.65	48.801	1800.0
2022-01-28	AIA	ETF	74.01	74.42	73.18	74.35	47222.0
2022-01-28	AIEQ	ETF	34.48	35.52	34.334	35.52	9400.0
2022-01-28	AIQ	ETF	26.91	27.6	26.535	27.54	30193.0
2022-01-28	AIRR	ETF	39.52	39.8	38.63	39.79	34400.0
2022-01-28	AIVI	ETF	41.52	41.65	41.3	41.65	21800.0
2022-01-28	AIVL	ETF	95.82	97.49	95.54	97.49	12700.0

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

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