PREVIEW / etf_daily / 2023-07-06

all etf daily files

  file:    by_date/etf_daily/2023/2023-07-06.parquet
  size:    106 KB
  rows:    2,946

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-07-06	SPY	ETF	439.42	440.1	437.06	439.66	80658300.0
2023-07-06	QQQ	ETF	366.51	367.91	364.52	367.46	49374728.0
2023-07-06	IWM	ETF	183.63	183.71	180.72	182.78	39080800.0
2023-07-06	DIA	ETF	340.24	340.87	337.7	339.23	3742400.0
2023-07-06	GLD	ETF	177.51	177.8	176.66	177.31	5133000.0
2023-07-06	TLT	ETF	100.2	100.38	99.47	99.68	41375700.0
2023-07-06	AAA	ETF	24.61	24.61	24.55	24.58	400.0
2023-07-06	AAAU	ETF	18.95	18.98	18.86	18.93	1179400.0
2023-07-06	AADR	ETF	48.22	48.59	48.1	48.1	8500.0
2023-07-06	AAPB	ETF	28.27	28.79	28.199	28.79	14951.0
2023-07-06	AAPD	ETF	20.52	20.56	20.28	20.31	89274.0
2023-07-06	AAPU	ETF	28.21	28.65	28.05	28.62	119558.0
2023-07-06	AAXJ	ETF	65.47	65.81	65.14	65.45	434900.0
2023-07-06	ABEQ	ETF	27.73	27.87	27.73	27.87	19100.0
2023-07-06	ACES	ETF	45.28	45.28	44.128	44.71	16900.0
2023-07-06	ACIO	ETF	30.77	30.96	30.77	30.95	763100.0
2023-07-06	ACSI	ETF	46.704	46.704	46.704	46.704	100.0
2023-07-06	ACT	ETF	25.37	25.37	24.93	25.11	148719.0
2023-07-06	ACTV	ETF	30.99	31.02	30.71	31.003	31000.0
2023-07-06	ACVF	ETF	33.58	33.58	33.4	33.559	7200.0
2023-07-06	ACWF	ETF	34.858	34.858	34.858	34.858	200.0
2023-07-06	ACWI	ETF	94.62	94.66	93.98	94.52	2127100.0
2023-07-06	ACWV	ETF	97.26	97.26	96.68	96.94	183100.0
2023-07-06	ACWX	ETF	48.21	48.22	47.78	48.03	2759300.0
2023-07-06	ADFI	ETF	8.345	8.38	8.345	8.365	38000.0
2023-07-06	ADIV	ETF	13.28	13.29	13.265	13.29	300.0
2023-07-06	ADME	ETF	36.05	36.08	35.9	36.08	14700.0
2023-07-06	ADPV	ETF	24.02	24.2601	24.02	24.2601	1158.0
2023-07-06	AESR	ETF	12.67	12.76	12.66	12.74	69100.0
2023-07-06	AFIF	ETF	8.81	8.82	8.81	8.81	7100.0
2023-07-06	AFK	ETF	14.83	14.85	14.5	14.55	6300.0
2023-07-06	AFMC	ETF	24.38	24.428	24.31	24.428	200.0
2023-07-06	AFTY	ETF	14.7	14.7	14.651	14.651	1300.0
2023-07-06	AGG	ETF	96.56	96.64	96.28	96.51	9534200.0
2023-07-06	AGGH	ETF	22.1843	22.24	22.1843	22.2206	919.0
2023-07-06	AGGY	ETF	42.62	42.62	42.48	42.57	93000.0
2023-07-06	AGNG	ETF	27.29	27.29	27.12	27.14	1500.0
2023-07-06	AGOV	ETF	75.725	75.725	75.725	75.725	1.0
2023-07-06	AGOX	ETF	23.07	23.15	22.97	23.144	8400.0
2023-07-06	AGQ	ETF	27.27	27.28	26.35	26.77	761200.0
2023-07-06	AGRH	ETF	25.6	25.6	25.555	25.555	12075.0
2023-07-06	AGZ	ETF	106.12	106.16	105.96	106.11	28400.0
2023-07-06	AGZD	ETF	22.045	22.185	22.045	22.12	29400.0
2023-07-06	AHYB	ETF	43.29	43.363	43.29	43.363	400.0
2023-07-06	AIA	ETF	58.6	58.67	58.1	58.28	98100.0
2023-07-06	AIEQ	ETF	31.35	31.39	31.18	31.39	14900.0
2023-07-06	AIQ	ETF	27.66	27.68	27.357	27.55	241500.0
2023-07-06	AIRR	ETF	52.75	52.881	51.74	52.28	118800.0
2023-07-06	AIVI	ETF	37.89	38.09	37.87	38.08	4300.0
2023-07-06	AIVL	ETF	92.41	92.41	91.86	92.35	1300.0

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

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