PREVIEW / etf_daily / 2022-09-20

all etf daily files

  file:    by_date/etf_daily/2022/2022-09-20.parquet
  size:    103 KB
  rows:    2,794

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-09-20	SPY	ETF	385.06	386.12	381.2	384.09	77274900.0
2022-09-20	QQQ	ETF	288.49	291.07	286.38	288.73	51271117.0
2022-09-20	IWM	ETF	178.77	178.94	176.71	178.06	22247500.0
2022-09-20	DIA	ETF	307.69	307.99	304.58	307.02	2822800.0
2022-09-20	GLD	ETF	155.03	155.23	154.59	155.07	5943700.0
2022-09-20	TLT	ETF	105.69	106.84	105.4	106.25	20133800.0
2022-09-20	AAA	ETF	24.26	24.26	24.26	24.26	107.0
2022-09-20	AAAU	ETF	16.52	16.54	16.48	16.52	504400.0
2022-09-20	AADR	ETF	47.62	47.9	47.58	47.9	3000.0
2022-09-20	AAPB	ETF	22.06	22.7	22.06	22.5226	3219.0
2022-09-20	AAPD	ETF	26.55	26.55	25.83	26.0	48237.0
2022-09-20	AAPU	ETF	22.21	23.16	22.21	22.98	149560.0
2022-09-20	AAXJ	ETF	63.87	64.01	63.53	63.69	457900.0
2022-09-20	ABEQ	ETF	26.22	26.24	26.17	26.207	7700.0
2022-09-20	ACES	ETF	64.63	64.63	62.77	62.88	35700.0
2022-09-20	ACIO	ETF	29.095	29.15	29.025	29.06	113200.0
2022-09-20	ACSI	ETF	44.6423	44.6423	44.6423	44.6423	12.0
2022-09-20	ACT	ETF	23.65	23.785	23.04	23.21	125630.0
2022-09-20	ACTV	ETF	28.88	28.94	28.71	28.81	7153.0
2022-09-20	ACTX	ETF	0.605	0.605	0.605	0.605	1201.0
2022-09-20	ACVF	ETF	29.09	29.09	28.67	28.867	3200.0
2022-09-20	ACWF	ETF	31.3	31.3	30.94	31.13	4095.0
2022-09-20	ACWI	ETF	83.78	83.92	82.95	83.5	2801600.0
2022-09-20	ACWV	ETF	93.49	93.49	92.69	93.1	96300.0
2022-09-20	ACWX	ETF	42.9	42.96	42.53	42.73	2277796.0
2022-09-20	ADFI	ETF	8.36	8.39	8.34	8.372	14500.0
2022-09-20	ADIV	ETF	12.94	13.03	12.91	12.94	9600.0
2022-09-20	ADME	ETF	34.15	34.24	34.05	34.21	31200.0
2022-09-20	ADRE	ETF	37.75	37.8131	37.57	37.75	3469.0
2022-09-20	AEMB	ETF	37.27	37.27	37.27	37.27	100.0
2022-09-20	AESR	ETF	11.24	11.35	11.24	11.32	18700.0
2022-09-20	AFIF	ETF	8.805	8.82	8.79	8.8051	18710.0
2022-09-20	AFK	ETF	16.24	16.24	16.0107	16.13	4395.0
2022-09-20	AFLG	ETF	22.89	22.96	22.84	22.923	500.0
2022-09-20	AFMC	ETF	21.457	21.457	21.457	21.457	100.0
2022-09-20	AFTY	ETF	16.021	16.021	16.021	16.021	100.0
2022-09-20	AGG	ETF	98.21	98.4	98.08	98.24	11271700.0
2022-09-20	AGGH	ETF	23.01	23.01	22.85	22.85	857.0
2022-09-20	AGGY	ETF	43.23	43.4	43.23	43.33	64700.0
2022-09-20	AGNG	ETF	24.23	24.4	24.04	24.17	10700.0
2022-09-20	AGOV	ETF	80.7	82.14	79.93	81.3588	2538.0
2022-09-20	AGOX	ETF	20.57	20.66	20.477	20.535	15700.0
2022-09-20	AGQ	ETF	21.26	21.47	20.98	21.37	836200.0
2022-09-20	AGZ	ETF	107.42	107.61	107.42	107.59	68300.0
2022-09-20	AGZD	ETF	22.925	22.95	22.895	22.95	75200.0
2022-09-20	AHHX	ETF	8.44	8.52	8.42	8.435	40559.0
2022-09-20	AHYB	ETF	42.989	42.989	42.9	42.939	1000.0
2022-09-20	AIA	ETF	54.91	55.09	54.601	54.73	11049.0
2022-09-20	AIEQ	ETF	31.97	32.01	31.797	31.86	4000.0
2022-09-20	AIQ	ETF	20.56	20.67	20.4	20.4	5942.0

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

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