PREVIEW / etf_daily / 2022-10-27

all etf daily files

  file:    by_date/etf_daily/2022/2022-10-27.parquet
  size:    106 KB
  rows:    2,838

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-27	SPY	ETF	383.07	385.0	379.33	379.98	81971800.0
2022-10-27	QQQ	ETF	276.79	278.2795	272.34	272.87	57760302.0
2022-10-27	IWM	ETF	180.59	182.0	178.87	179.09	28651800.0
2022-10-27	DIA	ETF	321.56	323.87	319.92	320.46	4262200.0
2022-10-27	GLD	ETF	154.71	155.09	154.22	154.74	3654900.0
2022-10-27	TLT	ETF	96.98	97.9	96.22	97.47	20270000.0
2022-10-27	AAA	ETF	24.205	24.205	24.205	24.205	3.0
2022-10-27	AAAU	ETF	16.5	16.53	16.44	16.5	556600.0
2022-10-27	AADR	ETF	46.73	46.9	46.73	46.9	600.0
2022-10-27	AAPB	ETF	20.14	20.27	19.2125	19.3	11551.0
2022-10-27	AAPD	ETF	27.16	28.0298	27.16	27.885	362852.0
2022-10-27	AAPU	ETF	20.87	21.0	20.0	20.2	81985.0
2022-10-27	AAXJ	ETF	56.63	56.93	56.28	56.3	752600.0
2022-10-27	ABEQ	ETF	26.86	26.895	26.76	26.76	2700.0
2022-10-27	ACES	ETF	53.59	54.08	53.43	53.6	20900.0
2022-10-27	ACIO	ETF	29.46	29.53	29.075	29.36	26500.0
2022-10-27	ACSI	ETF	42.9802	42.9802	42.9802	42.9802	15.0
2022-10-27	ACT	ETF	25.15	25.56	25.081	25.16	140597.0
2022-10-27	ACTV	ETF	28.92	29.216	28.77	28.78	7424.0
2022-10-27	ACVF	ETF	29.09	29.3	28.876	28.876	10900.0
2022-10-27	ACWF	ETF	31.32	31.52	31.1847	31.1847	8632.0
2022-10-27	ACWI	ETF	82.55	83.03	81.9	82.01	3342300.0
2022-10-27	ACWV	ETF	91.84	92.39	91.5	91.57	100800.0
2022-10-27	ACWX	ETF	41.72	42.04	41.495	41.52	3002137.0
2022-10-27	ADFI	ETF	8.22	8.24	8.21	8.226	4200.0
2022-10-27	ADIV	ETF	11.455	11.455	11.404	11.404	2200.0
2022-10-27	ADME	ETF	34.79	34.93	34.71	34.71	24100.0
2022-10-27	ADRE	ETF	32.89	33.25	32.7501	32.82	7177.0
2022-10-27	AEMB	ETF	35.51	35.51	35.44	35.5	800.0
2022-10-27	AESR	ETF	11.433	11.45	11.37	11.37	9700.0
2022-10-27	AFIF	ETF	8.71	8.71	8.6601	8.68	23525.0
2022-10-27	AFK	ETF	15.57	15.71	15.29	15.56	13436.0
2022-10-27	AFLG	ETF	23.22	23.22	23.052	23.052	100.0
2022-10-27	AFSM	ETF	23.103	23.18	22.852	22.852	10600.0
2022-10-27	AFTY	ETF	13.79	13.8	13.73	13.73	2500.0
2022-10-27	AGG	ETF	95.21	95.62	94.99	95.46	6913500.0
2022-10-27	AGGY	ETF	41.62	41.81	41.524	41.73	121400.0
2022-10-27	AGNG	ETF	24.865	24.865	24.67	24.67	4000.0
2022-10-27	AGOV	ETF	79.44	80.17	79.0	80.17	1647.0
2022-10-27	AGOX	ETF	20.44	20.57	20.293	20.293	13100.0
2022-10-27	AGQ	ETF	21.67	21.9	21.36	21.55	986700.0
2022-10-27	AGZ	ETF	105.855	106.18	105.85	106.16	21322.0
2022-10-27	AGZD	ETF	22.685	22.76	22.68	22.705	87200.0
2022-10-27	AHHX	ETF	8.38	8.4359	8.37	8.4359	2593.0
2022-10-27	AHYB	ETF	43.066	43.066	43.066	43.066	100.0
2022-10-27	AIA	ETF	46.73	47.16	46.53	46.56	23113.0
2022-10-27	AIEQ	ETF	31.38	31.65	31.257	31.257	3200.0
2022-10-27	AIQ	ETF	19.81	19.8179	19.525	19.525	4328.0
2022-10-27	AIRR	ETF	43.78	44.418	43.732	43.792	39500.0
2022-10-27	AIVI	ETF	32.38	32.5	32.23	32.23	3700.0

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

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