PREVIEW / etf_daily / 2022-08-22

all etf daily files

  file:    by_date/etf_daily/2022/2022-08-22.parquet
  size:    103 KB
  rows:    2,786

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-08-22	SPY	ETF	417.05	417.23	412.4	413.35	77695600.0
2022-08-22	QQQ	ETF	318.5	318.74	313.53	314.36	51098890.0
2022-08-22	IWM	ETF	191.99	192.35	190.01	190.64	22937000.0
2022-08-22	DIA	ETF	333.11	333.52	330.16	330.76	2684500.0
2022-08-22	GLD	ETF	161.66	162.12	161.36	161.64	4458100.0
2022-08-22	TLT	ETF	112.86	112.96	112.13	112.66	10457200.0
2022-08-22	AAA	ETF	24.45	24.45	24.42	24.42	826.0
2022-08-22	AAAU	ETF	17.23	17.27	17.2	17.23	939300.0
2022-08-22	AADR	ETF	50.52	50.67	50.52	50.67	600.0
2022-08-22	AAPB	ETF	26.19	26.21	25.5	25.5758	8030.0
2022-08-22	AAPD	ETF	24.32	24.61	24.2739	24.6	76267.0
2022-08-22	AAPU	ETF	25.96	26.059	25.45	25.59	21544.0
2022-08-22	AAXJ	ETF	66.82	67.05	66.69	66.74	502200.0
2022-08-22	ABEQ	ETF	27.38	27.4	27.287	27.309	3900.0
2022-08-22	ACES	ETF	61.51	62.0	61.08	61.63	29000.0
2022-08-22	ACIO	ETF	31.09	31.09	30.704	30.76	89700.0
2022-08-22	ACSI	ETF	46.7811	46.7811	46.7811	46.7811	20.0
2022-08-22	ACT	ETF	26.35	26.39	26.03	26.11	98721.0
2022-08-22	ACTV	ETF	34.05	34.05	31.01	31.1104	7539.0
2022-08-22	ACVF	ETF	31.3	31.3	31.084	31.095	1600.0
2022-08-22	ACWF	ETF	33.23	33.23	32.94	32.9721	54744.0
2022-08-22	ACWI	ETF	89.79	89.79	88.92	89.06	3564400.0
2022-08-22	ACWV	ETF	99.0	99.0	98.23	98.32	82900.0
2022-08-22	ACWX	ETF	45.54	45.54	45.225	45.29	2196946.0
2022-08-22	ADFI	ETF	8.571	8.62	8.57	8.615	21500.0
2022-08-22	ADIV	ETF	13.525	13.525	13.525	13.525	100.0
2022-08-22	ADME	ETF	36.79	36.84	36.67	36.7	29300.0
2022-08-22	ADRE	ETF	38.88	39.1166	38.88	39.06	2075.0
2022-08-22	AEMB	ETF	38.37	38.37	38.275	38.275	1400.0
2022-08-22	AESR	ETF	12.116	12.116	12.03	12.03	37600.0
2022-08-22	AFIF	ETF	8.97	8.979	8.94	8.94	31888.0
2022-08-22	AFK	ETF	17.31	17.31	17.07	17.16	6057.0
2022-08-22	AFLG	ETF	24.672	24.672	24.484	24.484	500.0
2022-08-22	AFMC	ETF	23.147	23.147	22.995	22.995	400.0
2022-08-22	AFSM	ETF	24.262	24.262	24.114	24.114	400.0
2022-08-22	AFTY	ETF	17.06	17.076	17.06	17.076	200.0
2022-08-22	AGG	ETF	101.82	101.89	101.52	101.55	7133200.0
2022-08-22	AGGY	ETF	45.05	45.06	44.83	44.91	141100.0
2022-08-22	AGIH	ETF	25.5987	25.615	25.5987	25.615	102.0
2022-08-22	AGNG	ETF	25.818	25.818	25.568	25.64	900.0
2022-08-22	AGOV	ETF	82.4175	82.4175	82.4175	82.4175	10.0
2022-08-22	AGOX	ETF	21.67	21.823	21.67	21.742	19900.0
2022-08-22	AGQ	ETF	20.86	21.19	20.5	20.93	813200.0
2022-08-22	AGZ	ETF	109.7	109.78	109.49	109.5574	12649.0
2022-08-22	AGZD	ETF	23.03	23.045	22.945	22.985	60400.0
2022-08-22	AHHX	ETF	8.71	8.75	8.68	8.7	7157.0
2022-08-22	AHYB	ETF	44.24	44.24	44.154	44.154	500.0
2022-08-22	AIA	ETF	58.57	58.732	58.44	58.46	20695.0
2022-08-22	AIEQ	ETF	34.94	34.97	34.689	34.71	5400.0
2022-08-22	AIQ	ETF	22.57	22.57	22.11	22.16	52371.0

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

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