PREVIEW / etf_daily / 2023-05-02

all etf daily files

  file:    by_date/etf_daily/2023/2023-05-02.parquet
  size:    110 KB
  rows:    2,972

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-05-02	SPY	ETF	414.77	414.82	407.82	410.84	103998500.0
2023-05-02	QQQ	ETF	322.12	322.45	317.61	319.38	56519407.0
2023-05-02	IWM	ETF	174.4	174.45	169.92	171.7	40851100.0
2023-05-02	DIA	ETF	339.94	340.0	334.31	336.87	3275800.0
2023-05-02	GLD	ETF	184.65	187.64	184.52	187.52	14680600.0
2023-05-02	TLT	ETF	104.0	105.7	103.89	105.7	30057800.0
2023-05-02	AAA	ETF	24.49	24.52	24.49	24.52	1607.0
2023-05-02	AAAU	ETF	19.71	20.02	19.7	20.01	1248200.0
2023-05-02	AADR	ETF	47.01	47.17	47.01	47.09	500.0
2023-05-02	AAPB	ETF	23.77	23.77	23.17	23.38	6081.0
2023-05-02	AAPD	ETF	23.01	23.32	22.96	23.21	185709.0
2023-05-02	AAPU	ETF	24.25	24.35	23.76	23.97	89019.0
2023-05-02	AAXJ	ETF	66.24	66.25	65.66	65.84	338200.0
2023-05-02	ABEQ	ETF	28.51	28.75	28.51	28.748	12700.0
2023-05-02	ACES	ETF	41.39	41.39	40.367	40.68	71900.0
2023-05-02	ACIO	ETF	30.34	30.36	29.97	30.095	41600.0
2023-05-02	ACSI	ETF	43.7	43.7024	43.7	43.7024	766.0
2023-05-02	ACT	ETF	24.19	24.28	23.64	24.04	130464.0
2023-05-02	ACTV	ETF	28.98	29.02	28.81	29.02	8323.0
2023-05-02	ACVF	ETF	31.65	31.65	31.26	31.315	1800.0
2023-05-02	ACWF	ETF	33.95	33.96	33.5371	33.7477	147172.0
2023-05-02	ACWI	ETF	92.13	92.13	90.84	91.43	1313600.0
2023-05-02	ACWV	ETF	99.2	99.41	98.62	99.13	76500.0
2023-05-02	ACWX	ETF	49.18	49.19	48.8	49.09	1363334.0
2023-05-02	ADFI	ETF	8.5	8.51	8.5	8.505	4100.0
2023-05-02	ADIV	ETF	13.42	13.46	13.42	13.46	1500.0
2023-05-02	ADME	ETF	34.945	34.945	34.6	34.725	94200.0
2023-05-02	ADPV	ETF	22.84	22.94	22.83	22.94	4067.0
2023-05-02	AEMB	ETF	39.32	39.32	37.59	37.59	300.0
2023-05-02	AESR	ETF	12.1	12.1	11.96	12.05	18500.0
2023-05-02	AFIF	ETF	8.79	8.87	8.79	8.8549	180318.0
2023-05-02	AFK	ETF	15.55	15.7199	15.55	15.5974	4762.0
2023-05-02	AFLG	ETF	23.78	23.908	23.78	23.908	300.0
2023-05-02	AFMC	ETF	23.04	23.04	22.74	22.77	2100.0
2023-05-02	AFSM	ETF	22.32	22.5	22.32	22.5	1500.0
2023-05-02	AFTY	ETF	15.917	15.965	15.917	15.965	200.0
2023-05-02	AGG	ETF	98.96	99.67	98.93	99.65	6085800.0
2023-05-02	AGGY	ETF	43.5	43.785	43.5	43.78	381600.0
2023-05-02	AGNG	ETF	28.13	28.13	27.98	28.02	3500.0
2023-05-02	AGOV	ETF	79.8	79.8	77.0	78.25	1452.0
2023-05-02	AGOX	ETF	21.69	21.69	21.34	21.523	76800.0
2023-05-02	AGQ	ETF	32.48	34.68	32.36	34.45	874400.0
2023-05-02	AGZ	ETF	107.95	108.45	107.95	108.44	34208.0
2023-05-02	AGZD	ETF	21.825	21.89	21.67	21.77	76800.0
2023-05-02	AHOY	ETF	19.27	19.27	19.2481	19.2649	207.0
2023-05-02	AHYB	ETF	43.65	43.755	43.65	43.755	300.0
2023-05-02	AIA	ETF	58.26	58.26	57.52	57.69	46612.0
2023-05-02	AIEQ	ETF	27.17	27.22	26.75	27.02	12500.0
2023-05-02	AIQ	ETF	23.77	23.78	23.38	23.55	54428.0
2023-05-02	AIRR	ETF	45.89	45.93	45.01	45.75	28200.0

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

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