PREVIEW / etf_daily / 2022-10-03

all etf daily files

  file:    by_date/etf_daily/2022/2022-10-03.parquet
  size:    105 KB
  rows:    2,845

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-10-03	SPY	ETF	361.08	368.55	359.21	366.61	89756500.0
2022-10-03	QQQ	ETF	269.07	275.16	267.53	273.53	61267449.0
2022-10-03	IWM	ETF	167.34	170.3	165.25	169.29	33611600.0
2022-10-03	DIA	ETF	290.56	296.37	289.47	294.79	3457600.0
2022-10-03	GLD	ETF	155.44	158.48	155.23	158.43	10362200.0
2022-10-03	TLT	ETF	103.85	104.68	103.15	103.83	27192200.0
2022-10-03	AAA	ETF	24.075	24.075	24.075	24.075	9.0
2022-10-03	AAAU	ETF	16.56	16.89	16.55	16.88	585100.0
2022-10-03	AADR	ETF	45.02	45.49	45.02	45.49	2700.0
2022-10-03	AAPB	ETF	18.14	19.04	18.1385	18.9148	4140.0
2022-10-03	AAPD	ETF	29.34	29.49	28.41	28.62	175290.0
2022-10-03	AAPU	ETF	18.88	19.88	18.861	19.77	65916.0
2022-10-03	AAXJ	ETF	58.72	59.26	58.41	59.09	833500.0
2022-10-03	ABEQ	ETF	25.62	25.704	25.57	25.665	20700.0
2022-10-03	ACES	ETF	55.75	57.13	55.1	56.6	47100.0
2022-10-03	ACIO	ETF	28.37	28.61	28.36	28.49	41800.0
2022-10-03	ACSI	ETF	41.8911	41.8911	41.8911	41.8911	11.0
2022-10-03	ACT	ETF	22.22	23.13	22.065	22.99	196671.0
2022-10-03	ACTV	ETF	27.195	27.53	27.16	27.41	29831.0
2022-10-03	ACVF	ETF	27.33	27.736	27.2	27.64	9300.0
2022-10-03	ACWF	ETF	29.851	30.16	29.83	30.0	5927.0
2022-10-03	ACWI	ETF	78.66	80.05	78.26	79.68	2645600.0
2022-10-03	ACWV	ETF	89.4	90.53	89.14	90.16	136900.0
2022-10-03	ACWX	ETF	40.35	40.95	40.23	40.84	4236823.0
2022-10-03	ADFI	ETF	8.28	8.28	8.23	8.235	19100.0
2022-10-03	ADIV	ETF	11.895	11.895	11.895	11.895	100.0
2022-10-03	ADME	ETF	33.32	33.511	33.298	33.37	19100.0
2022-10-03	ADRE	ETF	34.82	35.55	34.82	35.35	5311.0
2022-10-03	AEMB	ETF	35.54	35.81	35.54	35.81	900.0
2022-10-03	AESR	ETF	10.67	10.8	10.67	10.75	20900.0
2022-10-03	AFIF	ETF	8.63	8.71	8.63	8.71	49192.0
2022-10-03	AFK	ETF	15.26	15.5	15.22	15.43	3661.0
2022-10-03	AFLG	ETF	22.01	22.07	22.01	22.045	400.0
2022-10-03	AFMC	ETF	20.734	20.734	20.734	20.734	100.0
2022-10-03	AFSM	ETF	21.38	21.48	21.37	21.375	75200.0
2022-10-03	AFTY	ETF	15.613	15.613	15.613	15.613	100.0
2022-10-03	AGG	ETF	96.89	97.48	96.64	96.91	9617900.0
2022-10-03	AGGH	ETF	22.855	22.8592	22.74	22.8506	1195.0
2022-10-03	AGGY	ETF	42.52	42.77	42.47	42.61	335800.0
2022-10-03	AGNG	ETF	23.72	23.945	23.662	23.849	8700.0
2022-10-03	AGOV	ETF	78.5	79.0235	78.5	79.0235	840.0
2022-10-03	AGOX	ETF	19.58	19.75	19.51	19.662	563500.0
2022-10-03	AGQ	ETF	23.13	24.69	23.01	24.67	2565700.0
2022-10-03	AGZ	ETF	106.76	107.15	106.56	106.74	23427.0
2022-10-03	AGZD	ETF	22.74	22.805	22.72	22.725	365200.0
2022-10-03	AHHX	ETF	8.17	8.27	8.17	8.225	39367.0
2022-10-03	AHYB	ETF	41.79	41.917	41.79	41.917	300.0
2022-10-03	AIA	ETF	50.0	50.58	49.86	50.49	106843.0
2022-10-03	AIEQ	ETF	29.2	29.975	29.1	29.817	7500.0
2022-10-03	AIQ	ETF	19.29	19.595	19.1701	19.54	8035.0

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

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