PREVIEW / etf_daily / 2023-04-13

all etf daily files

  file:    by_date/etf_daily/2023/2023-04-13.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-04-13	SPY	ETF	409.18	413.84	407.99	413.47	85814800.0
2023-04-13	QQQ	ETF	314.83	319.65	313.63	319.17	54613792.0
2023-04-13	IWM	ETF	176.54	178.69	175.93	178.17	23259900.0
2023-04-13	DIA	ETF	337.07	340.58	336.07	340.37	3040900.0
2023-04-13	GLD	ETF	189.76	190.41	188.99	189.72	14060100.0
2023-04-13	TLT	ETF	107.05	107.39	105.88	106.05	22079400.0
2023-04-13	AAA	ETF	24.515	24.515	24.515	24.515	62.0
2023-04-13	AAAU	ETF	20.25	20.32	20.17	20.23	2650700.0
2023-04-13	AADR	ETF	48.38	48.86	48.38	48.86	1000.0
2023-04-13	AAPB	ETF	21.82	22.79	21.82	22.78	5062.0
2023-04-13	AAPD	ETF	24.21	24.21	23.53	23.57	303439.0
2023-04-13	AAPU	ETF	22.59	23.43	22.56	23.41	167249.0
2023-04-13	AAXJ	ETF	67.97	68.48	67.97	68.43	1211200.0
2023-04-13	ABEQ	ETF	28.62	28.787	28.62	28.787	2200.0
2023-04-13	ACES	ETF	44.81	45.55	44.6	45.25	15600.0
2023-04-13	ACIO	ETF	30.31	30.41	30.17	30.39	87300.0
2023-04-13	ACSI	ETF	44.5299	44.5299	44.5299	44.5299	36.0
2023-04-13	ACT	ETF	24.35	24.54	24.15	24.34	126825.0
2023-04-13	ACTV	ETF	29.216	29.57	29.216	29.46	12254.0
2023-04-13	ACTX	ETF	0.0794	0.3	0.0794	0.3	3214.0
2023-04-13	ACVF	ETF	31.44	31.604	31.44	31.604	900.0
2023-04-13	ACWF	ETF	34.02	34.1897	34.02	34.1863	2970.0
2023-04-13	ACWI	ETF	91.78	92.65	91.78	92.57	2465600.0
2023-04-13	ACWV	ETF	98.83	99.18	98.5	99.13	95200.0
2023-04-13	ACWX	ETF	49.75	50.015	49.725	49.99	1085549.0
2023-04-13	ADFI	ETF	8.57	8.6	8.57	8.59	24000.0
2023-04-13	ADIV	ETF	13.98	13.98	13.98	13.98	100.0
2023-04-13	ADME	ETF	34.64	35.05	34.64	35.0	22600.0
2023-04-13	ADPV	ETF	23.23	23.23	23.2224	23.2224	2747.0
2023-04-13	AEMB	ETF	37.96	37.96	37.96	37.96	100.0
2023-04-13	AESR	ETF	12.088	12.18	12.088	12.164	17200.0
2023-04-13	AFIF	ETF	8.83	8.88	8.83	8.8698	3293.0
2023-04-13	AFK	ETF	16.1	16.4197	16.1	16.3996	2814.0
2023-04-13	AFLG	ETF	24.19	24.19	24.159	24.159	100.0
2023-04-13	AFMC	ETF	23.11	23.11	23.082	23.082	100.0
2023-04-13	AFSM	ETF	23.24	23.24	23.228	23.228	400.0
2023-04-13	AFTY	ETF	16.22	16.22	16.22	16.22	100.0
2023-04-13	AGG	ETF	100.16	100.27	99.81	99.89	3964800.0
2023-04-13	AGGH	ETF	23.0699	23.0699	23.012	23.0506	32189.0
2023-04-13	AGGY	ETF	44.04	44.085	43.87	43.94	101800.0
2023-04-13	AGNG	ETF	28.14	28.14	28.14	28.14	100.0
2023-04-13	AGOV	ETF	78.505	78.505	77.01	77.309	1382.0
2023-04-13	AGOX	ETF	21.72	21.95	21.67	21.838	9100.0
2023-04-13	AGQ	ETF	35.77	36.21	35.32	35.9	794400.0
2023-04-13	AGRH	ETF	25.48	25.48	25.48	25.48	160.0
2023-04-13	AGZ	ETF	108.65	108.71	108.43	108.49	77228.0
2023-04-13	AGZD	ETF	21.77	21.795	21.72	21.775	36800.0
2023-04-13	AHYB	ETF	44.28	44.28	44.227	44.227	400.0
2023-04-13	AIA	ETF	61.02	61.37	60.93	61.34	62833.0
2023-04-13	AIEQ	ETF	28.81	29.19	28.81	29.05	10300.0

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

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