PREVIEW / etf_daily / 2022-09-13

all etf daily files

  file:    by_date/etf_daily/2022/2022-09-13.parquet
  size:    105 KB
  rows:    2,802

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-13	SPY	ETF	401.83	403.1	391.92	393.1	122947100.0
2022-09-13	QQQ	ETF	301.8	303.02	292.785	293.7	79562172.0
2022-09-13	IWM	ETF	184.86	185.91	181.54	182.25	34144700.0
2022-09-13	DIA	ETF	318.8	319.59	310.83	311.73	4301200.0
2022-09-13	GLD	ETF	158.47	159.27	158.39	158.54	6526400.0
2022-09-13	TLT	ETF	106.56	107.74	106.24	107.67	22158900.0
2022-09-13	AAA	ETF	24.33	24.33	24.33	24.33	34.0
2022-09-13	AAAU	ETF	16.88	16.97	16.88	16.89	1673000.0
2022-09-13	AADR	ETF	49.54	49.54	48.94	48.94	700.0
2022-09-13	AAPB	ETF	23.53	26.74	21.8	21.88	6145.0
2022-09-13	AAPD	ETF	25.58	26.63	25.56	26.5546	75632.0
2022-09-13	AAPU	ETF	23.69	23.75	22.211	22.35	83595.0
2022-09-13	AAXJ	ETF	65.54	65.9	64.8	64.88	772000.0
2022-09-13	ABEQ	ETF	26.91	26.96	26.584	26.626	5700.0
2022-09-13	ACES	ETF	64.2	66.34	64.2	65.51	66900.0
2022-09-13	ACIO	ETF	29.9	29.9	29.55	29.59	36300.0
2022-09-13	ACSI	ETF	45.74	45.74	45.1886	45.1886	3601.0
2022-09-13	ACT	ETF	24.85	25.225	24.645	24.72	346413.0
2022-09-13	ACTV	ETF	29.94	29.94	29.57	29.6381	5066.0
2022-09-13	ACTX	ETF	0.645	0.645	0.645	0.645	589.0
2022-09-13	ACVF	ETF	30.26	30.26	29.49	29.578	13700.0
2022-09-13	ACWF	ETF	32.4	32.4	31.74	31.8096	5531.0
2022-09-13	ACWI	ETF	86.98	87.16	85.08	85.3	4328300.0
2022-09-13	ACWV	ETF	96.09	96.22	94.48	94.72	128700.0
2022-09-13	ACWX	ETF	44.29	44.59	43.655	43.7	3225924.0
2022-09-13	ADFI	ETF	8.46	8.46	8.43	8.435	2500.0
2022-09-13	ADIV	ETF	13.3	13.3	13.137	13.17	400.0
2022-09-13	ADME	ETF	35.27	35.3	34.876	34.876	28800.0
2022-09-13	ADRE	ETF	39.01	39.07	38.89	38.9	5636.0
2022-09-13	AEMB	ETF	37.75	37.75	37.655	37.69	300.0
2022-09-13	AESR	ETF	11.76	11.76	11.51	11.51	45400.0
2022-09-13	AFIF	ETF	8.9	8.92	8.8818	8.905	51865.0
2022-09-13	AFK	ETF	16.79	16.81	16.45	16.54	4903.0
2022-09-13	AFLG	ETF	23.83	23.83	23.38	23.38	1000.0
2022-09-13	AFMC	ETF	22.023	22.023	22.023	22.023	100.0
2022-09-13	AFTY	ETF	16.6	16.6	16.435	16.435	1800.0
2022-09-13	AGG	ETF	98.91	99.19	98.9	99.07	4957400.0
2022-09-13	AGGY	ETF	43.65	43.736	43.63	43.72	93000.0
2022-09-13	AGNG	ETF	25.15	25.15	24.88	24.88	700.0
2022-09-13	AGOV	ETF	81.01	81.15	80.83	81.15	626.0
2022-09-13	AGOX	ETF	21.3	21.3	20.9	21.01	17300.0
2022-09-13	AGQ	ETF	22.07	22.49	21.5	21.58	1847900.0
2022-09-13	AGZ	ETF	107.88	108.25	107.88	108.25	41250.0
2022-09-13	AGZD	ETF	22.925	22.945	22.885	22.92	38400.0
2022-09-13	AHHX	ETF	8.65	8.65	8.49	8.51	10710.0
2022-09-13	AHYB	ETF	43.415	43.415	43.24	43.24	200.0
2022-09-13	AIA	ETF	56.73	56.87	55.7564	55.79	73814.0
2022-09-13	AIEQ	ETF	33.66	33.66	33.12	33.143	1700.0
2022-09-13	AIQ	ETF	21.47	21.58	21.04	21.09	18995.0
2022-09-13	AIRR	ETF	41.84	42.168	41.519	41.581	8300.0

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

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