PREVIEW / etf_daily / 2022-11-07

all etf daily files

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

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-07	SPY	ETF	377.71	380.57	375.53	379.95	68286900.0
2022-11-07	QQQ	ETF	265.75	268.14	263.57	267.59	47333828.0
2022-11-07	IWM	ETF	179.74	180.59	177.68	179.49	20689900.0
2022-11-07	DIA	ETF	325.14	328.95	324.15	328.42	4518300.0
2022-11-07	GLD	ETF	156.22	156.57	155.81	155.85	4425700.0
2022-11-07	TLT	ETF	94.8	94.86	93.24	93.28	14522800.0
2022-11-07	AAA	ETF	24.105	24.105	24.105	24.105	122.0
2022-11-07	AAAU	ETF	16.66	16.69	16.61	16.61	719700.0
2022-11-07	AADR	ETF	48.27	48.33	48.2	48.24	2300.0
2022-11-07	AAPB	ETF	17.35	17.85	17.22	17.8415	8113.0
2022-11-07	AAPD	ETF	29.18	29.48	28.76	28.7909	225026.0
2022-11-07	AAPU	ETF	18.49	18.9	18.23	18.9	80374.0
2022-11-07	AAXJ	ETF	59.71	59.88	59.23	59.54	899600.0
2022-11-07	ABEQ	ETF	26.855	26.959	26.82	26.959	26000.0
2022-11-07	ACES	ETF	54.04	54.04	52.05	52.65	49200.0
2022-11-07	ACIO	ETF	28.9	29.17	28.9	29.16	53900.0
2022-11-07	ACSI	ETF	42.6326	42.6326	42.6326	42.6326	65.0
2022-11-07	ACT	ETF	25.98	26.25	25.67	25.83	151592.0
2022-11-07	ACTV	ETF	28.63	28.9775	28.48	28.9775	9601.0
2022-11-07	ACVF	ETF	29.09	29.31	28.949	29.272	3500.0
2022-11-07	ACWF	ETF	31.6	31.7064	31.6	31.7064	997.0
2022-11-07	ACWI	ETF	82.67	83.04	82.17	82.85	7741200.0
2022-11-07	ACWV	ETF	92.33	92.76	92.09	92.42	129100.0
2022-11-07	ACWX	ETF	43.0	43.03	42.74	42.89	2352240.0
2022-11-07	ADFI	ETF	8.17	8.17	8.15	8.165	2500.0
2022-11-07	ADIV	ETF	11.75	11.773	11.75	11.773	400.0
2022-11-07	ADME	ETF	34.15	34.15	33.86	34.138	69600.0
2022-11-07	ADPV	ETF	25.11	25.11	25.03	25.03	25500.0
2022-11-07	ADRE	ETF	34.4	34.4	34.02	34.02	3259.0
2022-11-07	AEMB	ETF	35.53	35.53	35.53	35.53	100.0
2022-11-07	AESR	ETF	11.32	11.44	11.32	11.42	12100.0
2022-11-07	AFIF	ETF	8.65	8.66	8.62	8.65	24921.0
2022-11-07	AFK	ETF	16.1	16.35	15.73	16.1	22587.0
2022-11-07	AFLG	ETF	23.11	23.263	23.11	23.263	1200.0
2022-11-07	AFMC	ETF	22.193	22.193	22.193	22.193	100.0
2022-11-07	AFSM	ETF	23.063	23.063	23.063	23.063	100.0
2022-11-07	AFTY	ETF	14.431	14.431	14.431	14.431	100.0
2022-11-07	AGG	ETF	94.41	94.46	94.03	94.04	7597200.0
2022-11-07	AGGY	ETF	41.37	41.38	41.2	41.22	110000.0
2022-11-07	AGNG	ETF	25.12	25.12	25.12	25.12	100.0
2022-11-07	AGOV	ETF	79.44	80.278	79.44	80.147	1026.0
2022-11-07	AGOX	ETF	20.33	20.54	20.33	20.493	55900.0
2022-11-07	AGQ	ETF	24.7	25.06	24.52	24.52	672200.0
2022-11-07	AGZ	ETF	105.29	105.29	105.07	105.07	17220.0
2022-11-07	AGZD	ETF	22.85	22.91	22.795	22.875	148800.0
2022-11-07	AHHX	ETF	8.3641	8.41	8.321	8.3909	9242.0
2022-11-07	AHYB	ETF	42.53	42.53	42.428	42.475	1200.0
2022-11-07	AIA	ETF	50.24	50.29	49.58	49.93	31115.0
2022-11-07	AIEQ	ETF	30.42	30.42	29.965	30.257	5300.0
2022-11-07	AIQ	ETF	19.16	19.2899	19.0001	19.2899	12794.0

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

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