PREVIEW / etf_daily / 2023-09-12

all etf daily files

  file:    by_date/etf_daily/2023/2023-09-12.parquet
  size:    106 KB
  rows:    2,992

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-09-12	SPY	ETF	446.95	448.53	445.39	445.99	67565400.0
2023-09-12	QQQ	ETF	375.27	376.9517	372.5	372.79	41391024.0
2023-09-12	IWM	ETF	184.04	185.34	183.74	184.18	16826300.0
2023-09-12	DIA	ETF	346.64	349.3	346.36	347.21	1813800.0
2023-09-12	GLD	ETF	177.11	177.7	177.05	177.49	4445400.0
2023-09-12	TLT	ETF	93.89	94.24	93.58	94.23	20034300.0
2023-09-12	AAA	ETF	24.769	24.82	24.76	24.79	2800.0
2023-09-12	AAAU	ETF	18.92	18.98	18.91	18.95	1289000.0
2023-09-12	AADR	ETF	50.68	50.68	50.45	50.5	21600.0
2023-09-12	AAPB	ETF	24.99	25.15	23.86	24.25	38576.0
2023-09-12	AAPD	ETF	21.79	22.3497	21.751	22.16	346011.0
2023-09-12	AAPU	ETF	25.56	25.65	24.56	24.88	273079.0
2023-09-12	AAXJ	ETF	65.14	65.6	65.07	65.43	386300.0
2023-09-12	ABEQ	ETF	28.12	28.14	28.112	28.124	2400.0
2023-09-12	ACES	ETF	40.37	41.19	40.37	40.96	159500.0
2023-09-12	ACIO	ETF	31.41	31.41	31.291	31.326	87800.0
2023-09-12	ACSI	ETF	45.97	45.97	45.97	45.97	100.0
2023-09-12	ACT	ETF	28.02	28.28	28.02	28.05	98052.0
2023-09-12	ACTV	ETF	31.02	31.333	31.02	31.213	4800.0
2023-09-12	ACVF	ETF	34.485	34.63	34.44	34.441	9700.0
2023-09-12	ACWF	ETF	35.45	35.56	35.36	35.4	11246.0
2023-09-12	ACWI	ETF	95.77	96.17	95.65	95.69	1073700.0
2023-09-12	ACWV	ETF	97.57	97.81	97.45	97.53	140100.0
2023-09-12	ACWX	ETF	48.27	48.53	48.23	48.37	822900.0
2023-09-12	ADFI	ETF	8.32	8.38	8.32	8.375	11100.0
2023-09-12	ADIV	ETF	13.62	13.62	13.62	13.62	100.0
2023-09-12	ADME	ETF	36.625	36.625	36.5	36.526	30400.0
2023-09-12	ADPV	ETF	24.93	24.9315	24.93	24.9315	35180.0
2023-09-12	AEMB	ETF	36.74	36.74	36.74	36.74	200.0
2023-09-12	AESR	ETF	12.82	12.82	12.72	12.74	45000.0
2023-09-12	AFIF	ETF	8.94	8.97	8.94	8.95	5100.0
2023-09-12	AFK	ETF	14.43	14.74	14.43	14.55	2100.0
2023-09-12	AFLG	ETF	25.455	25.455	25.455	25.455	100.0
2023-09-12	AFMC	ETF	24.59	24.65	24.51	24.56	1400.0
2023-09-12	AFSM	ETF	24.53	24.53	24.442	24.442	800.0
2023-09-12	AFTY	ETF	14.9	14.95	14.9	14.926	1000.0
2023-09-12	AGG	ETF	95.71	95.73	95.57	95.7	4583400.0
2023-09-12	AGGH	ETF	21.97	21.98	21.94	21.94	6313.0
2023-09-12	AGGY	ETF	42.26	42.28	42.22	42.27	55900.0
2023-09-12	AGNG	ETF	27.258	27.258	27.16	27.18	1800.0
2023-09-12	AGOV	ETF	74.045	74.045	74.045	74.045	271.0
2023-09-12	AGOX	ETF	23.4	23.51	23.34	23.36	21900.0
2023-09-12	AGQ	ETF	26.44	27.0	26.36	26.83	493400.0
2023-09-12	AGZ	ETF	106.23	106.35	106.01	106.28	21800.0
2023-09-12	AGZD	ETF	22.28	22.34	22.15	22.29	6500.0
2023-09-12	AHLT	ETF	25.9	26.03	25.7399	25.7399	555.0
2023-09-12	AHOY	ETF	20.27	20.29	20.2571	20.2571	1262.0
2023-09-12	AHYB	ETF	43.91	43.91	43.89	43.89	600.0
2023-09-12	AIA	ETF	57.36	57.82	57.34	57.65	72700.0
2023-09-12	AIEQ	ETF	30.93	31.05	30.9	30.939	9700.0

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

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