PREVIEW / etf_daily / 2023-02-21

all etf daily files

  file:    by_date/etf_daily/2023/2023-02-21.parquet
  size:    109 KB
  rows:    2,957

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
2023-02-21	SPY	ETF	403.06	404.16	398.82	399.09	82655900.0
2023-02-21	QQQ	ETF	297.26	298.73	293.89	294.03	46526708.0
2023-02-21	IWM	ETF	190.75	191.34	187.24	187.43	26004000.0
2023-02-21	DIA	ETF	334.72	335.94	331.1	331.25	3142900.0
2023-02-21	GLD	ETF	171.2	171.5	170.34	170.62	4035900.0
2023-02-21	TLT	ETF	101.01	101.2	100.28	100.39	22728000.0
2023-02-21	AAA	ETF	24.68	24.68	24.68	24.68	17.0
2023-02-21	AAAU	ETF	18.26	18.29	18.17	18.2	466000.0
2023-02-21	AADR	ETF	48.94	48.94	48.56	48.56	300.0
2023-02-21	AAPB	ETF	19.58	19.69	19.16	19.16	5331.0
2023-02-21	AAPD	ETF	26.09	26.4	25.97	26.4	189889.0
2023-02-21	AAPU	ETF	20.5	20.7	20.14	20.14	60806.0
2023-02-21	AAXJ	ETF	67.49	67.81	67.15	67.18	803900.0
2023-02-21	ABEQ	ETF	28.0	28.0	27.906	27.942	3400.0
2023-02-21	ACES	ETF	50.1	50.31	48.5	48.55	40700.0
2023-02-21	ACIO	ETF	31.0	31.03	29.5	29.51	49700.0
2023-02-21	ACSI	ETF	44.9879	44.9879	44.6911	44.6911	118.0
2023-02-21	ACT	ETF	24.51	24.59	23.91	24.22	91757.0
2023-02-21	ACTV	ETF	32.7	32.7	32.0599	32.07	9424.0
2023-02-21	ACTX	ETF	0.32	0.44	0.32	0.44	501.0
2023-02-21	ACVF	ETF	31.06	31.13	30.787	30.826	4800.0
2023-02-21	ACWF	ETF	33.49	33.49	33.1404	33.1404	2739.0
2023-02-21	ACWI	ETF	89.88	90.13	89.1	89.16	6718300.0
2023-02-21	ACWV	ETF	95.31	95.57	95.07	95.07	143500.0
2023-02-21	ACWX	ETF	48.34	48.495	48.0842	48.12	1323819.0
2023-02-21	ADFI	ETF	8.37	8.38	8.345	8.345	31600.0
2023-02-21	ADIV	ETF	14.024	14.024	14.024	14.024	100.0
2023-02-21	ADME	ETF	34.16	34.16	34.0	34.0	36200.0
2023-02-21	ADPV	ETF	25.21	25.21	25.06	25.06	22882.0
2023-02-21	ADRE	ETF	40.09	40.31	39.77	39.77	5302.0
2023-02-21	AEMB	ETF	37.59	37.59	37.332	37.332	800.0
2023-02-21	AESR	ETF	11.68	11.71	11.645	11.645	31000.0
2023-02-21	AFIF	ETF	8.83	8.83	8.8	8.8111	19048.0
2023-02-21	AFK	ETF	16.5	16.5509	16.32	16.34	9542.0
2023-02-21	AFLG	ETF	23.96	23.96	23.924	23.924	100.0
2023-02-21	AFMC	ETF	23.702	23.702	23.702	23.702	100.0
2023-02-21	AFTY	ETF	16.86	16.86	16.746	16.746	400.0
2023-02-21	AGG	ETF	97.36	97.46	97.08	97.08	8369600.0
2023-02-21	AGGH	ETF	22.12	22.155	22.12	22.155	304.0
2023-02-21	AGGY	ETF	42.99	42.992	42.82	42.83	320400.0
2023-02-21	AGNG	ETF	26.71	26.71	26.64	26.64	600.0
2023-02-21	AGOV	ETF	74.1	75.863	74.1	75.863	211.0
2023-02-21	AGOX	ETF	22.14	22.14	21.66	21.716	248000.0
2023-02-21	AGQ	ETF	26.13	26.35	25.82	26.04	445800.0
2023-02-21	AGRH	ETF	25.61	25.62	25.5627	25.5627	1500.0
2023-02-21	AGZ	ETF	106.63	106.7299	106.5934	106.63	24210.0
2023-02-21	AGZD	ETF	21.985	21.995	21.935	21.97	210200.0
2023-02-21	AHHX	ETF	8.55	8.55	8.18	8.47	544287.0
2023-02-21	AHYB	ETF	42.977	43.0	42.833	42.833	800.0
2023-02-21	AIA	ETF	60.7	60.89	60.22	60.31	2485353.0

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

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