PREVIEW / etf_daily / 2023-02-16

all etf daily files

  file:    by_date/etf_daily/2023/2023-02-16.parquet
  size:    109 KB
  rows:    2,939

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
2023-02-16	SPY	ETF	408.79	412.91	408.14	408.28	76431500.0
2023-02-16	QQQ	ETF	304.38	308.43	303.15	303.3	59498630.0
2023-02-16	IWM	ETF	191.8	194.87	191.25	192.6	21366300.0
2023-02-16	DIA	ETF	338.5	340.89	337.31	337.39	3229600.0
2023-02-16	GLD	ETF	170.34	171.6	169.96	170.75	4540400.0
2023-02-16	TLT	ETF	102.07	102.22	101.33	101.59	19267300.0
2023-02-16	AAA	ETF	24.685	24.685	24.685	24.685	72.0
2023-02-16	AAAU	ETF	18.17	18.31	18.13	18.21	987000.0
2023-02-16	AADR	ETF	49.89	50.02	49.75	50.02	500.0
2023-02-16	AAPB	ETF	20.39	20.91	20.38	20.39	8240.0
2023-02-16	AAPD	ETF	25.51	25.51	25.07	25.5	133160.0
2023-02-16	AAPU	ETF	21.18	21.78	21.18	21.27	85854.0
2023-02-16	AAXJ	ETF	68.6	69.08	68.28	68.72	610800.0
2023-02-16	ABEQ	ETF	28.27	28.47	28.27	28.348	5500.0
2023-02-16	ACES	ETF	52.14	53.09	51.52	51.52	46100.0
2023-02-16	ACIO	ETF	30.07	30.17	29.904	29.95	77500.0
2023-02-16	ACSI	ETF	46.4399	46.4399	45.8003	45.8003	1113.0
2023-02-16	ACT	ETF	24.38	24.88	24.14	24.45	101173.0
2023-02-16	ACTV	ETF	33.29	33.3399	33.0906	33.0906	5896.0
2023-02-16	ACVF	ETF	31.7	31.89	31.55	31.554	13500.0
2023-02-16	ACWF	ETF	33.68	34.03	33.68	33.7981	1792.0
2023-02-16	ACWI	ETF	90.85	91.79	90.77	90.94	2273900.0
2023-02-16	ACWV	ETF	95.09	95.79	95.0	95.34	133700.0
2023-02-16	ACWX	ETF	48.61	49.0487	48.52	48.77	856915.0
2023-02-16	ADFI	ETF	8.43	8.45	8.41	8.41	8900.0
2023-02-16	ADIV	ETF	13.99	14.1	13.99	14.036	1100.0
2023-02-16	ADME	ETF	34.3	34.634	34.3	34.46	10700.0
2023-02-16	ADPV	ETF	25.4099	25.56	25.35	25.43	13765.0
2023-02-16	ADRE	ETF	41.17	41.5599	41.17	41.35	4832.0
2023-02-16	AEMB	ETF	38.15	38.15	37.976	37.976	400.0
2023-02-16	AESR	ETF	11.83	11.93	11.82	11.829	7100.0
2023-02-16	AFIF	ETF	8.82	8.86	8.82	8.845	6729.0
2023-02-16	AFK	ETF	16.79	16.79	16.65	16.7	3952.0
2023-02-16	AFLG	ETF	24.52	24.62	24.493	24.493	700.0
2023-02-16	AFMC	ETF	24.334	24.334	24.334	24.334	100.0
2023-02-16	AFSM	ETF	25.01	25.01	24.814	24.814	800.0
2023-02-16	AFTY	ETF	16.731	16.737	16.731	16.737	200.0
2023-02-16	AGG	ETF	97.88	98.03	97.69	97.77	5235600.0
2023-02-16	AGGY	ETF	43.18	43.24	43.105	43.13	112300.0
2023-02-16	AGNG	ETF	26.77	26.79	26.77	26.79	300.0
2023-02-16	AGOV	ETF	75.4684	75.4684	75.3105	75.3105	198.0
2023-02-16	AGOX	ETF	22.22	22.37	22.174	22.18	8900.0
2023-02-16	AGQ	ETF	25.14	25.87	25.04	25.36	473100.0
2023-02-16	AGZ	ETF	106.91	107.15	106.83	106.87	24714.0
2023-02-16	AGZD	ETF	21.97	21.995	21.925	21.99	67600.0
2023-02-16	AHHX	ETF	8.5992	8.6	8.56	8.588	1513.0
2023-02-16	AHYB	ETF	43.4	43.48	43.319	43.319	1100.0
2023-02-16	AIA	ETF	62.33	63.0599	62.18	62.58	32844.0
2023-02-16	AIEQ	ETF	31.81	32.14	31.71	31.76	30100.0
2023-02-16	AIQ	ETF	23.64	23.93	23.57	23.61	19071.0

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

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