PREVIEW / etf_daily / 2022-11-09

all etf daily files

  file:    by_date/etf_daily/2022/2022-11-09.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-09	SPY	ETF	379.93	381.14	373.61	374.13	78495500.0
2022-11-09	QQQ	ETF	267.76	268.56	263.03	263.32	64862129.0
2022-11-09	IWM	ETF	178.0	178.67	174.28	174.63	27277000.0
2022-11-09	DIA	ETF	329.71	330.87	324.96	325.34	4799200.0
2022-11-09	GLD	ETF	159.36	160.35	158.45	158.65	6040600.0
2022-11-09	TLT	ETF	93.82	95.02	93.69	94.61	15637500.0
2022-11-09	AAA	ETF	24.12	24.12	24.12	24.12	87.0
2022-11-09	AAAU	ETF	16.99	17.1	16.89	16.92	1868200.0
2022-11-09	AADR	ETF	48.06	48.12	47.59	47.59	3100.0
2022-11-09	AAPB	ETF	17.51	17.51	16.94	16.95	1725.0
2022-11-09	AAPD	ETF	28.9	29.7	28.9	29.65	160958.0
2022-11-09	AAPU	ETF	18.79	18.79	17.98	18.04	43697.0
2022-11-09	AAXJ	ETF	59.65	59.75	58.85	58.91	2885100.0
2022-11-09	ABEQ	ETF	27.115	27.18	26.91	26.925	13700.0
2022-11-09	ACES	ETF	53.894	53.894	51.82	52.05	54000.0
2022-11-09	ACIO	ETF	28.99	29.235	28.87	28.87	102100.0
2022-11-09	ACSI	ETF	41.7016	41.7016	41.7016	41.7016	16.0
2022-11-09	ACT	ETF	25.97	25.97	25.27	25.36	131155.0
2022-11-09	ACTV	ETF	28.98	29.0	28.6033	28.6033	27461.0
2022-11-09	ACTX	ETF	0.51	0.51	0.45	0.51	8368.0
2022-11-09	ACVF	ETF	29.03	29.15	28.825	28.85	3400.0
2022-11-09	ACWF	ETF	31.68	31.73	31.3294	31.3294	2479.0
2022-11-09	ACWI	ETF	82.95	83.24	81.81	81.89	8720600.0
2022-11-09	ACWV	ETF	92.9	93.63	92.52	92.54	219100.0
2022-11-09	ACWX	ETF	43.01	43.28	42.64	42.64	2202250.0
2022-11-09	ADFI	ETF	8.19	8.19	8.155	8.155	17700.0
2022-11-09	ADIV	ETF	11.72	11.72	11.701	11.701	500.0
2022-11-09	ADME	ETF	34.189	34.2	33.89	33.89	41500.0
2022-11-09	ADPV	ETF	25.07	25.08	25.066	25.066	18511.0
2022-11-09	ADRE	ETF	34.11	34.22	33.59	33.59	7026.0
2022-11-09	AEMB	ETF	35.325	35.325	35.325	35.325	100.0
2022-11-09	AESR	ETF	11.44	11.44	11.21	11.22	10800.0
2022-11-09	AFIF	ETF	8.6642	8.6699	8.61	8.66	54188.0
2022-11-09	AFK	ETF	17.15	17.15	16.03	16.03	3251.0
2022-11-09	AFLG	ETF	23.25	23.25	22.941	22.941	100.0
2022-11-09	AFMC	ETF	22.12	22.12	21.813	21.813	100.0
2022-11-09	AFSM	ETF	22.542	22.542	22.542	22.542	100.0
2022-11-09	AFTY	ETF	14.17	14.17	13.99	14.02	1500.0
2022-11-09	AGG	ETF	94.39	94.7	94.25	94.55	6694200.0
2022-11-09	AGGY	ETF	41.36	41.528	41.325	41.46	148500.0
2022-11-09	AGNG	ETF	25.36	25.36	25.018	25.018	1100.0
2022-11-09	AGOV	ETF	78.7911	78.7911	78.7911	78.7911	2.0
2022-11-09	AGOX	ETF	20.43	20.48	20.17	20.2	29700.0
2022-11-09	AGQ	ETF	25.9	26.53	24.99	25.07	1051300.0
2022-11-09	AGZ	ETF	105.32	105.47	105.275	105.47	14045.0
2022-11-09	AGZD	ETF	22.825	22.845	22.79	22.835	18800.0
2022-11-09	AHHX	ETF	8.4	8.4	8.24	8.26	7564.0
2022-11-09	AHYB	ETF	42.436	42.436	42.039	42.039	800.0
2022-11-09	AIA	ETF	50.02	50.21	49.41	49.57	22028.0
2022-11-09	AIEQ	ETF	29.86	29.86	29.13	29.13	10100.0

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

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