PREVIEW / etf_daily / 2023-04-12

all etf daily files

  file:    by_date/etf_daily/2023/2023-04-12.parquet
  size:    109 KB
  rows:    2,955

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-04-12	SPY	ETF	411.87	412.17	407.44	408.05	86420400.0
2023-04-12	QQQ	ETF	317.82	318.42	312.565	313.04	62813305.0
2023-04-12	IWM	ETF	178.82	178.98	175.58	175.84	27018100.0
2023-04-12	DIA	ETF	338.61	339.01	335.96	336.61	3363800.0
2023-04-12	GLD	ETF	187.54	187.66	185.97	187.19	10000900.0
2023-04-12	TLT	ETF	107.05	107.17	105.88	106.89	20563000.0
2023-04-12	AAA	ETF	24.505	24.505	24.505	24.505	4.0
2023-04-12	AAAU	ETF	20.01	20.02	19.86	19.98	7099700.0
2023-04-12	AADR	ETF	48.52	48.52	48.14	48.15	3500.0
2023-04-12	AAPB	ETF	21.7998	21.85	21.4466	21.4466	7432.0
2023-04-12	AAPD	ETF	24.1428	24.4299	24.08	24.36	145240.0
2023-04-12	AAPU	ETF	22.51	22.66	22.191	22.28	77324.0
2023-04-12	AAXJ	ETF	68.3	68.3	67.25	67.36	457600.0
2023-04-12	ABEQ	ETF	28.565	28.63	28.5	28.54	9500.0
2023-04-12	ACES	ETF	45.77	45.77	44.465	44.48	69300.0
2023-04-12	ACIO	ETF	30.28	30.46	30.12	30.14	37000.0
2023-04-12	ACSI	ETF	43.8444	43.8444	43.8444	43.8444	143.0
2023-04-12	ACT	ETF	24.12	24.605	24.08	24.44	98305.0
2023-04-12	ACTV	ETF	29.7099	29.71	29.14	29.141	12712.0
2023-04-12	ACTX	ETF	0.3	0.3	0.3	0.3	111.0
2023-04-12	ACVF	ETF	31.67	31.67	31.27	31.27	1300.0
2023-04-12	ACWF	ETF	33.93	33.99	33.7128	33.7128	16506.0
2023-04-12	ACWI	ETF	92.05	92.14	91.25	91.35	2390200.0
2023-04-12	ACWV	ETF	98.54	98.84	98.24	98.32	81600.0
2023-04-12	ACWX	ETF	49.59	49.6	49.23	49.31	866418.0
2023-04-12	ADFI	ETF	8.56	8.57	8.56	8.57	6400.0
2023-04-12	ADIV	ETF	13.77	13.77	13.77	13.77	200.0
2023-04-12	ADME	ETF	34.83	34.86	34.591	34.601	11200.0
2023-04-12	ADPV	ETF	23.13	23.1821	23.0	23.0072	6585.0
2023-04-12	AEMB	ETF	37.95	37.96	37.87	37.875	600.0
2023-04-12	AESR	ETF	12.1	12.13	12.027	12.027	9200.0
2023-04-12	AFIF	ETF	8.87	8.87	8.8499	8.8499	16706.0
2023-04-12	AFK	ETF	16.09	16.25	15.86	15.8636	60902.0
2023-04-12	AFLG	ETF	24.11	24.11	23.937	23.937	300.0
2023-04-12	AFMC	ETF	23.13	23.13	22.953	22.953	100.0
2023-04-12	AFSM	ETF	23.13	23.13	22.977	22.977	100.0
2023-04-12	AFTY	ETF	15.995	15.995	15.995	15.995	100.0
2023-04-12	AGG	ETF	100.17	100.2	99.61	99.93	7226000.0
2023-04-12	AGGH	ETF	23.05	23.05	22.94	22.95	13484.0
2023-04-12	AGGY	ETF	44.0	44.03	43.83	43.905	102600.0
2023-04-12	AGNG	ETF	27.78	27.81	27.65	27.66	3100.0
2023-04-12	AGOV	ETF	78.41	79.76	76.43	77.0	1304.0
2023-04-12	AGOX	ETF	21.68	21.825	21.56	21.657	23300.0
2023-04-12	AGQ	ETF	34.77	35.01	33.8	34.93	927000.0
2023-04-12	AGRH	ETF	25.45	25.45	25.45	25.45	101.0
2023-04-12	AGZ	ETF	108.46	108.505	108.38	108.5	11414.0
2023-04-12	AGZD	ETF	21.72	21.82	21.71	21.755	44600.0
2023-04-12	AHYB	ETF	44.048	44.048	43.968	43.968	900.0
2023-04-12	AIA	ETF	61.02	61.0675	60.01	60.01	34558.0
2023-04-12	AIEQ	ETF	29.26	29.26	28.7	28.735	8200.0

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

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