PREVIEW / etf_daily / 2022-05-23

all etf daily files

  file:    by_date/etf_daily/2022/2022-05-23.parquet
  size:    102 KB
  rows:    2,729

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-05-23	SPY	ETF	392.83	397.73	390.38	396.92	76414900.0
2022-05-23	QQQ	ETF	289.75	293.87	287.29	293.48	63648400.0
2022-05-23	IWM	ETF	177.88	178.96	175.5	178.21	24644100.0
2022-05-23	DIA	ETF	315.32	319.65	314.78	318.84	4484600.0
2022-05-23	GLD	ETF	173.13	173.38	172.28	172.83	5518500.0
2022-05-23	TLT	ETF	117.71	118.25	116.54	116.56	15925200.0
2022-05-23	AAA	ETF	24.46	24.51	24.46	24.51	608.0
2022-05-23	AAAU	ETF	18.44	18.46	18.36	18.41	883400.0
2022-05-23	AADR	ETF	55.45	55.64	55.32	55.64	1900.0
2022-05-23	AAXJ	ETF	69.63	69.92	69.3	69.77	2464300.0
2022-05-23	ABEQ	ETF	28.657	28.66	28.55	28.55	2500.0
2022-05-23	ACES	ETF	49.63	50.09	48.34	49.97	96900.0
2022-05-23	ACIO	ETF	28.97	29.218	28.925	29.1	30100.0
2022-05-23	ACSI	ETF	43.2638	43.2638	43.2638	43.2638	274.0
2022-05-23	ACT	ETF	23.79	24.245	23.79	24.0	160906.0
2022-05-23	ACTV	ETF	31.96	32.15	31.84	31.9012	7431.0
2022-05-23	ACTX	ETF	0.7408	0.7408	0.7408	0.7408	307.0
2022-05-23	ACVF	ETF	29.78	30.02	29.745	30.02	4900.0
2022-05-23	ACWF	ETF	33.46	33.69	33.36	33.5505	8315.0
2022-05-23	ACWI	ETF	88.61	89.52	88.18	89.37	1945400.0
2022-05-23	ACWV	ETF	96.91	97.68	96.8	97.54	249100.0
2022-05-23	ACWX	ETF	48.4	48.75	48.26	48.65	3417445.0
2022-05-23	ADFI	ETF	8.6	8.66	8.6	8.64	3300.0
2022-05-23	ADIV	ETF	14.562	14.562	14.562	14.562	300.0
2022-05-23	ADME	ETF	36.029	36.31	35.975	36.23	17600.0
2022-05-23	ADRE	ETF	39.38	39.73	39.38	39.61	3484.0
2022-05-23	AEMB	ETF	40.13	40.14	40.13	40.14	100.0
2022-05-23	AESR	ETF	11.54	11.69	11.54	11.69	23700.0
2022-05-23	AFIF	ETF	8.9586	8.96	8.931	8.94	74331.0
2022-05-23	AFK	ETF	19.21	19.21	18.82	18.98	10512.0
2022-05-23	AFLG	ETF	23.74	23.835	23.74	23.835	100.0
2022-05-23	AFMC	ETF	22.51	22.51	22.51	22.51	100.0
2022-05-23	AFSM	ETF	23.09	23.189	23.09	23.189	100.0
2022-05-23	AFTY	ETF	17.06	17.084	17.05	17.084	1500.0
2022-05-23	AGG	ETF	103.01	103.2	102.73	102.82	8007200.0
2022-05-23	AGGH	ETF	23.84	23.84	23.7502	23.7502	485.0
2022-05-23	AGGY	ETF	45.58	45.62	45.4	45.46	167500.0
2022-05-23	AGNG	ETF	25.83	25.93	25.74	25.874	5700.0
2022-05-23	AGOV	ETF	81.18	81.18	79.8	80.3986	2544.0
2022-05-23	AGOX	ETF	21.65	21.65	21.31	21.539	296200.0
2022-05-23	AGQ	ETF	29.16	29.24	28.55	28.78	787400.0
2022-05-23	AGZ	ETF	110.86	110.9	110.5707	110.7	23669.0
2022-05-23	AGZD	ETF	22.935	22.995	22.84	22.97	107200.0
2022-05-23	AHHX	ETF	9.11	9.1169	9.09	9.1169	1423.0
2022-05-23	AHYB	ETF	44.44	44.44	44.435	44.435	400.0
2022-05-23	AIA	ETF	63.07	63.18	62.73	62.96	33784.0
2022-05-23	AIEQ	ETF	32.72	33.157	32.53	33.075	7900.0
2022-05-23	AIQ	ETF	21.67	21.84	21.42	21.79	21201.0
2022-05-23	AIRR	ETF	38.42	38.774	38.23	38.67	17600.0
2022-05-23	AIVI	ETF	39.23	39.57	39.23	39.44	3000.0

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

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