PREVIEW / etf_daily / 2022-07-18

all etf daily files

  file:    by_date/etf_daily/2022/2022-07-18.parquet
  size:    102 KB
  rows:    2,753

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-07-18	SPY	ETF	388.38	389.09	380.66	381.95	63203600.0
2022-07-18	QQQ	ETF	294.72	296.16	288.2	289.4	59519581.0
2022-07-18	IWM	ETF	175.13	176.29	172.06	172.6	23031500.0
2022-07-18	DIA	ETF	315.76	316.35	309.73	310.65	2344900.0
2022-07-18	GLD	ETF	160.08	160.43	159.05	159.16	5791800.0
2022-07-18	TLT	ETF	115.25	115.32	114.18	114.93	15838300.0
2022-07-18	AAA	ETF	24.285	24.285	24.285	24.285	0.0
2022-07-18	AAAU	ETF	17.05	17.09	16.95	16.95	877600.0
2022-07-18	AADR	ETF	48.13	48.13	47.55	47.75	800.0
2022-07-18	AAXJ	ETF	67.7	68.0	67.03	67.15	3693200.0
2022-07-18	ABEQ	ETF	26.9	26.9	26.46	26.5	9600.0
2022-07-18	ACES	ETF	49.94	51.257	49.94	50.17	36800.0
2022-07-18	ACIO	ETF	28.71	29.574	28.345	28.83	45300.0
2022-07-18	ACSI	ETF	43.1247	43.1247	43.1247	43.1247	20.0
2022-07-18	ACT	ETF	21.4	21.77	20.9388	20.95	158155.0
2022-07-18	ACTV	ETF	30.82	30.82	30.19	30.2691	7458.0
2022-07-18	ACTX	ETF	0.65	0.65	0.63	0.65	1738.0
2022-07-18	ACVF	ETF	29.18	29.225	28.829	28.829	3300.0
2022-07-18	ACWF	ETF	31.48	31.5	31.005	31.0733	12071.0
2022-07-18	ACWI	ETF	85.08	85.32	83.75	83.99	2886400.0
2022-07-18	ACWV	ETF	95.46	95.46	94.02	94.24	88000.0
2022-07-18	ACWX	ETF	44.46	44.6401	44.01	44.1	2903481.0
2022-07-18	ADFI	ETF	7.96	8.54	7.96	8.527	5700.0
2022-07-18	ADIV	ETF	13.53	13.53	13.53	13.53	200.0
2022-07-18	ADME	ETF	34.94	35.02	34.47	34.488	22500.0
2022-07-18	ADRE	ETF	38.5	38.5399	37.91	37.91	4600.0
2022-07-18	AEMB	ETF	36.81	36.81	36.559	36.559	400.0
2022-07-18	AESR	ETF	11.25	11.34	11.07	11.17	5300.0
2022-07-18	AFIF	ETF	8.8001	8.82	8.8	8.82	36051.0
2022-07-18	AFK	ETF	16.9	16.9	16.5901	16.6	9232.0
2022-07-18	AFLG	ETF	22.768	22.768	22.768	22.768	100.0
2022-07-18	AFMC	ETF	21.31	21.31	21.31	21.31	100.0
2022-07-18	AFTY	ETF	18.18	18.18	18.021	18.021	700.0
2022-07-18	AGG	ETF	102.0	102.03	101.72	101.92	6006400.0
2022-07-18	AGGY	ETF	44.98	45.034	44.87	44.989	85500.0
2022-07-18	AGNG	ETF	25.625	25.625	25.43	25.467	600.0
2022-07-18	AGOV	ETF	79.93	80.78	79.93	80.0702	867.0
2022-07-18	AGOX	ETF	20.55	20.601	20.2	20.32	53800.0
2022-07-18	AGQ	ETF	21.15	21.36	20.56	20.62	730600.0
2022-07-18	AGZ	ETF	109.86	109.86	109.66	109.78	22043.0
2022-07-18	AGZD	ETF	22.96	22.985	22.88	22.925	106400.0
2022-07-18	AHHX	ETF	8.57	8.57	8.47	8.4816	6296.0
2022-07-18	AHYB	ETF	43.176	43.176	43.176	43.176	200.0
2022-07-18	AIA	ETF	61.33	61.65	60.64	60.75	78901.0
2022-07-18	AIEQ	ETF	31.56	31.771	30.78	30.905	7800.0
2022-07-18	AIQ	ETF	21.43	21.57	21.15	21.17	12199.0
2022-07-18	AIRR	ETF	38.15	38.37	37.65	37.748	17400.0
2022-07-18	AIVI	ETF	34.83	34.9	34.55	34.55	3700.0
2022-07-18	AIVL	ETF	89.68	89.82	88.45	88.65	4100.0
2022-07-18	ALTL	ETF	40.86	40.86	40.21	40.26	56217.0

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

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