PREVIEW / etf_daily / 2022-11-02

all etf daily files

  file:    by_date/etf_daily/2022/2022-11-02.parquet
  size:    106 KB
  rows:    2,871

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-11-02	SPY	ETF	383.9	388.63	374.76	374.87	126990400.0
2022-11-02	QQQ	ETF	275.08	278.21	265.61	265.68	79803142.0
2022-11-02	IWM	ETF	182.84	185.0	177.43	177.49	38139600.0
2022-11-02	DIA	ETF	325.46	330.75	321.32	321.36	7110300.0
2022-11-02	GLD	ETF	154.16	155.42	152.26	152.39	7210900.0
2022-11-02	TLT	ETF	96.91	97.63	95.96	96.35	25010500.0
2022-11-02	AAA	ETF	24.11	24.11	24.0803	24.0803	420.0
2022-11-02	AAAU	ETF	16.44	16.57	16.23	16.24	1990400.0
2022-11-02	AADR	ETF	47.34	47.34	46.68	46.68	1700.0
2022-11-02	AAPB	ETF	19.28	19.28	19.28	19.28	1632.0
2022-11-02	AAPD	ETF	26.9	27.69	26.47	27.69	155500.0
2022-11-02	AAPU	ETF	21.04	21.519	20.1	20.11	94957.0
2022-11-02	AAXJ	ETF	56.95	57.64	56.36	56.36	712300.0
2022-11-02	ABEQ	ETF	26.93	27.24	26.62	26.62	1600.0
2022-11-02	ACES	ETF	54.18	54.94	52.27	52.35	36200.0
2022-11-02	ACIO	ETF	29.28	29.52	29.04	29.14	68400.0
2022-11-02	ACSI	ETF	42.5852	42.5852	42.5852	42.5852	71.0
2022-11-02	ACT	ETF	27.35	28.37	25.82	26.09	512795.0
2022-11-02	ACTV	ETF	28.971	29.43	28.6078	28.6078	3884.0
2022-11-02	ACVF	ETF	29.33	29.345	28.783	28.783	2200.0
2022-11-02	ACWF	ETF	31.56	31.77	30.9675	30.9778	5508.0
2022-11-02	ACWI	ETF	82.84	83.84	81.09	81.15	10681700.0
2022-11-02	ACWV	ETF	92.61	93.52	91.42	91.49	93800.0
2022-11-02	ACWX	ETF	41.95	42.46	41.31	41.31	3339000.0
2022-11-02	ADFI	ETF	8.21	8.27	8.194	8.194	5800.0
2022-11-02	ADIV	ETF	11.36	11.36	11.36	11.36	500.0
2022-11-02	ADME	ETF	34.49	34.75	34.0	34.13	15300.0
2022-11-02	ADRE	ETF	33.15	33.26	32.4	32.4	4475.0
2022-11-02	AEMB	ETF	35.48	35.48	35.27	35.355	500.0
2022-11-02	AESR	ETF	11.46	11.476	11.26	11.28	21800.0
2022-11-02	AFIF	ETF	8.6665	8.69	8.62	8.65	83136.0
2022-11-02	AFK	ETF	15.64	15.73	15.3064	15.42	11685.0
2022-11-02	AFLG	ETF	23.39	23.41	22.995	22.995	3400.0
2022-11-02	AFMC	ETF	22.34	22.34	21.876	21.876	100.0
2022-11-02	AFSM	ETF	23.03	23.05	22.657	22.657	500.0
2022-11-02	AFTY	ETF	13.85	13.89	13.695	13.695	900.0
2022-11-02	AGG	ETF	94.98	95.51	94.53	94.7	8584100.0
2022-11-02	AGGH	ETF	22.13	22.13	22.0209	22.0209	520.0
2022-11-02	AGGY	ETF	41.57	41.82	41.397	41.45	118800.0
2022-11-02	AGNG	ETF	24.95	25.36	24.79	24.79	2900.0
2022-11-02	AGOV	ETF	80.34	80.41	78.66	79.25	6048.0
2022-11-02	AGOX	ETF	20.56	20.78	20.18	20.192	31600.0
2022-11-02	AGQ	ETF	22.3	22.88	21.0	21.05	1496300.0
2022-11-02	AGZ	ETF	105.595	105.9538	105.3337	105.735	12496.0
2022-11-02	AGZD	ETF	22.88	22.88	22.76	22.79	111600.0
2022-11-02	AHHX	ETF	8.415	8.415	8.195	8.345	1480.0
2022-11-02	AHYB	ETF	42.72	42.72	42.424	42.424	300.0
2022-11-02	AIA	ETF	47.5	47.96	46.75	46.75	28903.0
2022-11-02	AIEQ	ETF	31.63	31.63	30.56	30.56	3200.0
2022-11-02	AIQ	ETF	19.73	19.73	19.11	19.11	11285.0

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

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