PREVIEW / etf_daily / 2022-01-24

all etf daily files

  file:    by_date/etf_daily/2022/2022-01-24.parquet
  size:    101 KB
  rows:    2,669

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-24	SPY	ETF	432.03	440.38	420.76	439.84	251783900.0
2022-01-24	QQQ	ETF	345.905	353.98	334.15	353.3	199448109.0
2022-01-24	IWM	ETF	194.07	202.39	191.23	201.53	85782000.0
2022-01-24	DIA	ETF	338.43	344.12	331.35	343.81	29707000.0
2022-01-24	GLD	ETF	171.78	172.14	170.85	172.03	15727700.0
2022-01-24	TLT	ETF	144.3	144.37	142.43	142.45	25001600.0
2022-01-24	AAA	ETF	24.985	25.0	24.97	25.0	2822.0
2022-01-24	AAAU	ETF	18.29	18.32	18.19	18.3	382400.0
2022-01-24	AADR	ETF	58.79	60.01	57.76	60.01	37400.0
2022-01-24	AAXJ	ETF	81.83	81.83	79.87	81.59	1840700.0
2022-01-24	ABEQ	ETF	27.73	28.154	27.58	28.154	9500.0
2022-01-24	ACES	ETF	50.78	52.816	48.83	52.79	138000.0
2022-01-24	ACIO	ETF	30.61	31.12	30.45	31.12	116600.0
2022-01-24	ACSI	ETF	48.0959	49.1447	47.5985	49.1447	3411.0
2022-01-24	ACT	ETF	20.82	21.3	20.4	20.98	150859.0
2022-01-24	ACTV	ETF	34.61	34.63	33.24	34.59	17416.0
2022-01-24	ACTX	ETF	1.2	1.2	1.2	1.2	174.0
2022-01-24	ACVF	ETF	32.52	32.96	31.61	32.96	22000.0
2022-01-24	ACWF	ETF	36.37	36.977	35.7	36.977	11641.0
2022-01-24	ACWI	ETF	97.87	99.4	95.6	99.36	11927600.0
2022-01-24	ACWV	ETF	102.08	102.82	100.74	102.73	258400.0
2022-01-24	ACWX	ETF	53.5	53.81	52.4	53.78	7097369.0
2022-01-24	ADFI	ETF	9.38	9.385	9.38	9.385	400.0
2022-01-24	ADIV	ETF	16.2	16.239	16.08	16.239	2000.0
2022-01-24	ADME	ETF	39.88	40.71	39.78	40.53	133100.0
2022-01-24	ADRE	ETF	46.01	46.02	44.44	46.02	90731.0
2022-01-24	AEMB	ETF	46.67	46.67	46.67	46.67	100.0
2022-01-24	AESR	ETF	12.72	12.942	12.4	12.942	15400.0
2022-01-24	AFIF	ETF	9.5	9.5	9.48	9.4899	18208.0
2022-01-24	AFK	ETF	20.6	20.6	19.8	20.21	23148.0
2022-01-24	AFLG	ETF	25.339	26.016	25.339	26.016	400.0
2022-01-24	AFMC	ETF	24.17	24.673	24.17	24.673	100.0
2022-01-24	AFSM	ETF	24.01	25.094	23.8	25.094	700.0
2022-01-24	AFTY	ETF	20.24	20.465	20.161	20.465	1800.0
2022-01-24	AGG	ETF	112.38	112.42	112.1	112.1	12131400.0
2022-01-24	AGGY	ETF	50.62	50.65	50.53	50.551	294100.0
2022-01-24	AGNG	ETF	26.59	26.59	25.75	26.584	6200.0
2022-01-24	AGOV	ETF	96.19	96.32	96.19	96.32	3421.0
2022-01-24	AGOX	ETF	23.11	23.91	22.84	23.72	222200.0
2022-01-24	AGQ	ETF	36.08	36.54	35.3	36.48	1653500.0
2022-01-24	AGZ	ETF	116.44	116.529	116.29	116.29	37616.0
2022-01-24	AGZD	ETF	23.19	23.31	23.19	23.28	297800.0
2022-01-24	AHHX	ETF	9.96	10.08	9.94	10.035	106843.0
2022-01-24	AHYB	ETF	49.197	49.33	49.197	49.33	1900.0
2022-01-24	AIA	ETF	77.05	77.3	75.3	77.3	137905.0
2022-01-24	AIEQ	ETF	35.26	36.25	34.286	36.16	49600.0
2022-01-24	AIQ	ETF	27.23	27.875	26.36	27.87	75864.0
2022-01-24	AIRR	ETF	40.08	41.51	39.72	41.46	35500.0
2022-01-24	AIVI	ETF	41.72	41.83	41.07	41.83	11200.0
2022-01-24	AIVL	ETF	97.13	98.35	95.5	98.33	14100.0

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

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