PREVIEW / etf_daily / 2023-10-03

all etf daily files

  file:    by_date/etf_daily/2023/2023-10-03.parquet
  size:    111 KB
  rows:    3,079

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-10-03	SPY	ETF	425.06	427.37	420.18	421.59	103760600.0
2023-10-03	QQQ	ETF	358.78	361.01	353.275	354.92	60478489.0
2023-10-03	IWM	ETF	172.95	173.5	170.37	171.14	42733600.0
2023-10-03	DIA	ETF	332.84	333.88	329.04	329.98	4871100.0
2023-10-03	GLD	ETF	169.14	170.08	168.75	169.16	11459800.0
2023-10-03	TLT	ETF	86.31	86.65	84.89	85.06	71362600.0
2023-10-03	AAA	ETF	24.74	24.813	24.74	24.78	2500.0
2023-10-03	AAAU	ETF	18.07	18.16	18.02	18.08	1260300.0
2023-10-03	AADR	ETF	47.64	47.64	47.4	47.4	500.0
2023-10-03	AAPB	ETF	23.205	23.3708	22.77	23.12	5583.0
2023-10-03	AAPD	ETF	22.58	22.72	22.3898	22.54	287269.0
2023-10-03	AAPU	ETF	23.85	24.02	23.47	23.79	84133.0
2023-10-03	AAXJ	ETF	62.57	62.84	62.36	62.49	2828900.0
2023-10-03	ABEQ	ETF	26.845	26.89	26.83	26.878	8400.0
2023-10-03	ACES	ETF	34.5	34.5	33.522	33.69	27900.0
2023-10-03	ACIO	ETF	30.38	30.38	30.04	30.079	58400.0
2023-10-03	ACSI	ETF	43.539	43.539	43.539	43.539	100.0
2023-10-03	ACT	ETF	27.48	27.52	26.91	27.1	126365.0
2023-10-03	ACTV	ETF	29.83	29.83	29.3	29.378	8100.0
2023-10-03	ACVF	ETF	32.85	32.85	32.5	32.501	18600.0
2023-10-03	ACWF	ETF	34.0	34.0	33.655	33.7295	4546.0
2023-10-03	ACWI	ETF	91.36	91.64	90.44	90.73	1968800.0
2023-10-03	ACWV	ETF	93.96	94.2	93.67	93.9	292300.0
2023-10-03	ACWX	ETF	46.08	46.14	45.68	45.82	1600200.0
2023-10-03	ADFI	ETF	8.15	8.15	8.1	8.13	42200.0
2023-10-03	ADIV	ETF	12.985	12.985	12.985	12.985	100.0
2023-10-03	ADME	ETF	34.74	34.74	34.64	34.68	10400.0
2023-10-03	ADPV	ETF	23.26	23.4062	23.22	23.3629	12632.0
2023-10-03	AEMB	ETF	35.21	35.21	34.93	34.93	6300.0
2023-10-03	AESR	ETF	12.21	12.21	12.03	12.03	65900.0
2023-10-03	AETH	ETF	24.98	24.98	24.65	24.675	2142.0
2023-10-03	AFIF	ETF	8.92	8.92	8.9	8.9	9600.0
2023-10-03	AFK	ETF	13.88	13.97	13.78	13.8	3200.0
2023-10-03	AFMC	ETF	23.228	23.228	23.228	23.228	100.0
2023-10-03	AFTY	ETF	14.41	14.465	14.41	14.46	1200.0
2023-10-03	AGG	ETF	92.99	93.09	92.37	92.4	12058400.0
2023-10-03	AGGH	ETF	21.12	21.2	20.93	20.93	157929.0
2023-10-03	AGGY	ETF	41.17	41.225	40.94	40.94	354300.0
2023-10-03	AGNG	ETF	25.54	25.54	25.33	25.44	1700.0
2023-10-03	AGOV	ETF	72.6	72.92	72.1824	72.92	1868.0
2023-10-03	AGOX	ETF	22.37	22.55	22.245	22.35	82200.0
2023-10-03	AGQ	ETF	22.05	22.85	21.9	22.41	1198900.0
2023-10-03	AGRH	ETF	25.52	25.52	25.52	25.52	150.0
2023-10-03	AGZ	ETF	105.25	105.26	104.8	104.8	30500.0
2023-10-03	AGZD	ETF	22.13	22.19	22.08	22.12	35700.0
2023-10-03	AHLT	ETF	27.27	27.58	27.09	27.4976	100271.0
2023-10-03	AHOY	ETF	19.2804	19.2977	19.2804	19.2977	123.0
2023-10-03	AHYB	ETF	42.748	42.748	42.572	42.572	7500.0
2023-10-03	AIA	ETF	54.49	54.7	54.2	54.43	2043200.0
2023-10-03	AIEQ	ETF	29.17	29.26	28.91	29.05	11500.0

> showing 50 of 3,079 rows — these rows as CSV

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