PREVIEW / etf_daily / 2023-06-27

all etf daily files

  file:    by_date/etf_daily/2023/2023-06-27.parquet
  size:    109 KB
  rows:    2,953

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-27	SPY	ETF	432.35	436.81	431.88	436.17	72813700.0
2023-06-27	QQQ	ETF	359.25	364.57	358.51	363.83	49428091.0
2023-06-27	IWM	ETF	181.2	183.99	180.4	183.36	28818800.0
2023-06-27	DIA	ETF	337.1	339.65	337.1	339.23	1778800.0
2023-06-27	GLD	ETF	179.07	179.29	177.43	177.69	5036900.0
2023-06-27	TLT	ETF	103.59	103.95	102.76	103.17	18105700.0
2023-06-27	AAA	ETF	24.66	24.66	24.66	24.66	108.0
2023-06-27	AAAU	ETF	19.11	19.13	18.94	18.97	909700.0
2023-06-27	AADR	ETF	47.73	49.05	47.73	48.98	1500.0
2023-06-27	AAPB	ETF	27.27	27.92	27.2695	27.832	8571.0
2023-06-27	AAPD	ETF	20.9	20.924	20.6301	20.6727	206249.0
2023-06-27	AAPU	ETF	27.36	27.9	27.36	27.84	57993.0
2023-06-27	AAXJ	ETF	66.38	66.88	66.38	66.82	247500.0
2023-06-27	ABEQ	ETF	28.113	28.221	28.113	28.221	4200.0
2023-06-27	ACES	ETF	42.74	43.21	42.46	43.21	20400.0
2023-06-27	ACIO	ETF	30.685	30.87	30.66	30.845	14800.0
2023-06-27	ACSI	ETF	46.0499	46.3249	46.0499	46.3249	599.0
2023-06-27	ACT	ETF	24.49	24.74	24.26	24.62	122900.0
2023-06-27	ACTV	ETF	30.59	31.09	30.5201	31.0465	21948.0
2023-06-27	ACTX	ETF	0.285	0.285	0.285	0.285	200.0
2023-06-27	ACVF	ETF	33.05	33.36	33.0	33.312	3300.0
2023-06-27	ACWF	ETF	34.6699	34.9061	34.65	34.9061	5013.0
2023-06-27	ACWI	ETF	94.07	94.82	93.88	94.74	2984900.0
2023-06-27	ACWV	ETF	97.25	97.57	97.15	97.53	538900.0
2023-06-27	ACWX	ETF	48.67	48.905	48.515	48.88	618686.0
2023-06-27	ADFI	ETF	8.45	8.46	8.45	8.455	16400.0
2023-06-27	ADIV	ETF	13.68	13.68	13.68	13.68	100.0
2023-06-27	ADME	ETF	35.79	35.95	35.67	35.93	9000.0
2023-06-27	ADPV	ETF	24.29	24.34	24.29	24.34	8238.0
2023-06-27	AEMB	ETF	37.775	37.775	37.775	37.775	100.0
2023-06-27	AESR	ETF	12.53	12.652	12.53	12.644	20800.0
2023-06-27	AFIF	ETF	8.81	8.81	8.7982	8.8046	16398.0
2023-06-27	AFK	ETF	14.79	14.79	14.57	14.79	12153.0
2023-06-27	AFLG	ETF	25.09	25.1	25.07	25.07	300.0
2023-06-27	AFMC	ETF	24.407	24.407	24.407	24.407	100.0
2023-06-27	AFTY	ETF	14.776	14.776	14.776	14.776	200.0
2023-06-27	AGG	ETF	98.45	98.59	98.1	98.19	7803300.0
2023-06-27	AGGH	ETF	22.5599	22.56	22.51	22.56	6844.0
2023-06-27	AGGY	ETF	43.2	43.27	43.05	43.12	127300.0
2023-06-27	AGNG	ETF	27.51	27.62	27.51	27.585	1500.0
2023-06-27	AGOV	ETF	72.5	76.3	72.5	76.3	223.0
2023-06-27	AGOX	ETF	23.05	23.15	22.9	23.07	19200.0
2023-06-27	AGQ	ETF	27.69	27.76	26.96	27.25	472900.0
2023-06-27	AGRH	ETF	25.63	25.63	25.595	25.595	219.0
2023-06-27	AGZ	ETF	107.28	107.28	107.09	107.14	9459.0
2023-06-27	AGZD	ETF	22.02	22.065	22.015	22.065	54200.0
2023-06-27	AHOY	ETF	20.16	20.2176	20.16	20.2176	328.0
2023-06-27	AHYB	ETF	43.66	43.71	43.66	43.71	300.0
2023-06-27	AIA	ETF	60.25	60.62	60.25	60.54	33549.0
2023-06-27	AIEQ	ETF	30.61	31.13	30.544	31.07	13000.0

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

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