PREVIEW / etf_daily / 2022-03-02

all etf daily files

  file:    by_date/etf_daily/2022/2022-03-02.parquet
  size:    100 KB
  rows:    2,674

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-03-02	SPY	ETF	432.37	439.72	431.57	437.89	117726500.0
2022-03-02	QQQ	ETF	343.08	348.59	340.24	347.22	70609015.0
2022-03-02	IWM	ETF	200.84	205.3	200.69	204.24	29978600.0
2022-03-02	DIA	ETF	335.27	340.45	334.69	339.0	6836200.0
2022-03-02	GLD	ETF	180.13	180.71	178.79	179.73	19727200.0
2022-03-02	TLT	ETF	139.84	140.42	136.41	136.47	30397400.0
2022-03-02	AAA	ETF	24.9	24.98	24.9	24.95	6291.0
2022-03-02	AAAU	ETF	19.18	19.23	19.04	19.14	1836200.0
2022-03-02	AADR	ETF	58.32	58.67	58.09	58.6	4100.0
2022-03-02	AAXJ	ETF	78.0	78.29	77.3	78.03	1253300.0
2022-03-02	ABEQ	ETF	28.648	28.89	28.648	28.81	10000.0
2022-03-02	ACES	ETF	56.62	56.62	55.25	56.33	157100.0
2022-03-02	ACIO	ETF	30.45	31.19	30.45	31.19	88100.0
2022-03-02	ACSI	ETF	49.03	49.0636	49.03	49.0636	100.0
2022-03-02	ACT	ETF	20.04	20.89	20.04	20.75	125652.0
2022-03-02	ACTV	ETF	34.38	34.94	34.24	34.7826	8408.0
2022-03-02	ACTX	ETF	0.72	1.0	0.72	0.8	402.0
2022-03-02	ACVF	ETF	32.49	32.914	32.49	32.876	2700.0
2022-03-02	ACWF	ETF	36.46	36.81	36.34	36.7487	9920.0
2022-03-02	ACWI	ETF	96.78	97.92	96.41	97.6	5907300.0
2022-03-02	ACWV	ETF	101.25	102.36	101.11	102.17	486400.0
2022-03-02	ACWX	ETF	51.61	52.04	51.425	51.93	2127121.0
2022-03-02	ADFI	ETF	9.2	9.2	9.14	9.161	4600.0
2022-03-02	ADIV	ETF	15.72	15.84	15.685	15.793	4500.0
2022-03-02	ADME	ETF	39.84	40.507	39.84	40.22	59800.0
2022-03-02	ADRE	ETF	44.0	44.61	44.0	44.4985	5476.0
2022-03-02	AEMB	ETF	43.62	43.744	43.62	43.744	100.0
2022-03-02	AESR	ETF	12.8	12.914	12.8	12.877	14000.0
2022-03-02	AFIF	ETF	9.3815	9.4	9.3499	9.35	11470.0
2022-03-02	AFK	ETF	21.39	21.4567	21.33	21.43	7693.0
2022-03-02	AFLG	ETF	26.03	26.072	26.027	26.027	800.0
2022-03-02	AFMC	ETF	24.928	24.928	24.928	24.928	100.0
2022-03-02	AFSM	ETF	25.895	25.895	25.895	25.895	100.0
2022-03-02	AFTY	ETF	19.68	19.8	19.68	19.744	2200.0
2022-03-02	AGG	ETF	110.3	110.38	109.46	109.49	9028800.0
2022-03-02	AGGH	ETF	25.1901	25.1901	25.04	25.0621	1030.0
2022-03-02	AGGY	ETF	49.47	49.482	49.04	49.05	806600.0
2022-03-02	AGNG	ETF	27.0	27.22	26.98	27.099	15200.0
2022-03-02	AGOV	ETF	86.72	88.89	86.72	88.89	2700.0
2022-03-02	AGOX	ETF	23.52	24.14	23.499	24.03	76400.0
2022-03-02	AGQ	ETF	39.8	40.58	39.17	40.26	1341600.0
2022-03-02	AGZ	ETF	115.1291	115.15	114.7467	114.77	73942.0
2022-03-02	AGZD	ETF	23.14	23.145	23.055	23.095	161400.0
2022-03-02	AHHX	ETF	9.62	9.78	9.62	9.7196	16814.0
2022-03-02	AHYB	ETF	48.158	48.158	48.146	48.146	400.0
2022-03-02	AIA	ETF	71.75	71.78	71.0	71.53	33151.0
2022-03-02	AIEQ	ETF	35.71	36.589	35.71	36.41	9700.0
2022-03-02	AIQ	ETF	26.52	26.96	26.21	26.81	15864.0
2022-03-02	AIRR	ETF	41.24	42.22	41.24	42.1	26400.0
2022-03-02	AIVI	ETF	39.42	39.83	39.42	39.72	8800.0

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

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