PREVIEW / etf_daily / 2023-06-26

all etf daily files

  file:    by_date/etf_daily/2023/2023-06-26.parquet
  size:    110 KB
  rows:    2,969

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-06-26	SPY	ETF	432.62	434.61	431.19	431.44	72823600.0
2023-06-26	QQQ	ETF	362.0	364.84	357.59	357.68	52685478.0
2023-06-26	IWM	ETF	180.44	182.74	180.37	180.75	31507900.0
2023-06-26	DIA	ETF	336.8	338.08	335.95	337.14	2301900.0
2023-06-26	GLD	ETF	179.05	179.08	178.42	178.51	3222100.0
2023-06-26	TLT	ETF	103.62	103.8	103.16	103.44	12894900.0
2023-06-26	AAA	ETF	24.645	24.645	24.645	24.645	81.0
2023-06-26	AAAU	ETF	19.11	19.12	19.05	19.06	979200.0
2023-06-26	AADR	ETF	48.79	48.79	48.79	48.79	100.0
2023-06-26	AAPB	ETF	27.63	27.77	27.1315	27.1315	10931.0
2023-06-26	AAPD	ETF	20.83	21.0	20.67	20.99	140736.0
2023-06-26	AAPU	ETF	27.59	27.82	27.24	27.24	84056.0
2023-06-26	AAXJ	ETF	66.35	66.35	65.98	66.01	249500.0
2023-06-26	ABEQ	ETF	28.02	28.17	28.02	28.138	4400.0
2023-06-26	ACES	ETF	42.6	43.49	42.45	42.45	25200.0
2023-06-26	ACIO	ETF	30.77	30.775	30.6	30.6	48500.0
2023-06-26	ACSI	ETF	45.92	45.92	45.7218	45.7218	275.0
2023-06-26	ACT	ETF	24.85	25.2	24.46	24.46	216926.0
2023-06-26	ACTV	ETF	30.62	30.62	30.5415	30.5415	2142.0
2023-06-26	ACTX	ETF	0.041	0.041	0.041	0.041	100.0
2023-06-26	ACVF	ETF	33.02	33.02	32.88	32.9	3800.0
2023-06-26	ACWF	ETF	34.7	34.74	34.48	34.5301	10544.0
2023-06-26	ACWI	ETF	93.95	94.26	93.73	93.75	1824500.0
2023-06-26	ACWV	ETF	97.04	97.12	96.64	97.0	255600.0
2023-06-26	ACWX	ETF	48.38	48.545	48.38	48.45	763496.0
2023-06-26	ADFI	ETF	8.45	8.455	8.45	8.455	1100.0
2023-06-26	ADIV	ETF	13.5	13.5	13.492	13.492	200.0
2023-06-26	ADME	ETF	35.72	35.845	35.61	35.62	26600.0
2023-06-26	AEMB	ETF	37.795	37.795	37.795	37.795	300.0
2023-06-26	AESR	ETF	12.59	12.59	12.499	12.499	9000.0
2023-06-26	AFIF	ETF	8.76	8.8	8.76	8.8	669.0
2023-06-26	AFK	ETF	14.8	15.0499	14.8	14.9	5681.0
2023-06-26	AFLG	ETF	24.67	24.83	24.67	24.801	1500.0
2023-06-26	AFMC	ETF	24.13	24.13	24.054	24.054	100.0
2023-06-26	AFTY	ETF	14.61	14.614	14.61	14.614	300.0
2023-06-26	AGG	ETF	98.5	98.51	98.31	98.38	10632300.0
2023-06-26	AGGH	ETF	22.76	23.09	22.76	22.9203	3211.0
2023-06-26	AGGY	ETF	43.2	43.22	43.12	43.19	1209600.0
2023-06-26	AGNG	ETF	27.86	27.86	27.669	27.75	900.0
2023-06-26	AGOV	ETF	76.26	76.4225	76.26	76.4225	359.0
2023-06-26	AGOX	ETF	22.8	22.981	22.8	22.826	27500.0
2023-06-26	AGQ	ETF	26.84	27.25	26.59	27.01	486500.0
2023-06-26	AGZ	ETF	107.31	107.3211	107.23	107.31	30421.0
2023-06-26	AGZD	ETF	22.055	22.055	21.99	22.025	28200.0
2023-06-26	AHOY	ETF	20.13	20.18	20.0865	20.0865	617.0
2023-06-26	AHYB	ETF	43.57	43.6	43.57	43.599	1300.0
2023-06-26	AIA	ETF	59.86	60.07	59.62	59.62	24114.0
2023-06-26	AIEQ	ETF	30.25	30.647	30.25	30.532	12700.0
2023-06-26	AIQ	ETF	27.43	27.69	27.15	27.2	186792.0
2023-06-26	AIRR	ETF	51.21	52.026	51.21	51.54	66200.0

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

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