PREVIEW / etf_daily / 2023-06-13

all etf daily files

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

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-13	SPY	ETF	435.32	437.33	434.63	436.66	95899700.0
2023-06-13	QQQ	ETF	363.29	364.11	360.03	363.26	57097804.0
2023-06-13	IWM	ETF	186.44	188.98	186.27	187.93	35758200.0
2023-06-13	DIA	ETF	341.74	343.63	341.6	342.62	3259300.0
2023-06-13	GLD	ETF	182.1	182.43	180.17	180.54	5126700.0
2023-06-13	TLT	ETF	102.11	102.33	100.97	101.21	25910800.0
2023-06-13	AAA	ETF	24.5999	24.5999	24.565	24.565	870.0
2023-06-13	AAAU	ETF	19.43	19.47	19.23	19.26	1341600.0
2023-06-13	AADR	ETF	49.0	49.53	48.6	49.38	3300.0
2023-06-13	AAPB	ETF	26.889	26.889	26.56	26.76	10083.0
2023-06-13	AAPD	ETF	21.44	21.49	21.3	21.41	126786.0
2023-06-13	AAPU	ETF	26.89	27.18	26.79	26.97	172424.0
2023-06-13	AAXJ	ETF	68.27	68.46	68.1	68.28	514500.0
2023-06-13	ABEQ	ETF	28.304	28.32	28.23	28.27	7500.0
2023-06-13	ACES	ETF	45.7	46.61	45.7	46.57	42500.0
2023-06-13	ACIO	ETF	30.66	30.84	30.66	30.779	20900.0
2023-06-13	ACSI	ETF	45.93	46.4142	45.93	46.4142	411.0
2023-06-13	ACT	ETF	25.91	26.07	25.67	25.85	477431.0
2023-06-13	ACTV	ETF	31.41	31.62	31.41	31.4633	4154.0
2023-06-13	ACTX	ETF	0.0141	0.2495	0.0141	0.2495	375.0
2023-06-13	ACVF	ETF	33.43	33.43	33.11	33.27	31900.0
2023-06-13	ACWF	ETF	34.95	35.04	34.911	35.01	8507.0
2023-06-13	ACWI	ETF	94.9	95.21	94.72	95.05	4370100.0
2023-06-13	ACWV	ETF	97.5	97.74	97.25	97.5	152100.0
2023-06-13	ACWX	ETF	49.48	49.5758	49.38	49.49	2288850.0
2023-06-13	ADFI	ETF	8.451	8.46	8.445	8.445	16200.0
2023-06-13	ADIV	ETF	13.914	13.92	13.914	13.92	300.0
2023-06-13	ADME	ETF	35.99	35.99	35.79	35.87	6800.0
2023-06-13	ADPV	ETF	24.23	24.24	24.21	24.24	16869.0
2023-06-13	AEMB	ETF	37.41	37.41	37.374	37.374	300.0
2023-06-13	AESR	ETF	12.58	12.68	12.58	12.64	25400.0
2023-06-13	AFIF	ETF	8.8472	8.8472	8.79	8.79	26039.0
2023-06-13	AFK	ETF	15.8	15.8	15.65	15.79	13972.0
2023-06-13	AFLG	ETF	24.96	24.967	24.96	24.967	200.0
2023-06-13	AFMC	ETF	24.291	24.35	24.291	24.31	3500.0
2023-06-13	AFSM	ETF	24.588	24.588	24.501	24.501	300.0
2023-06-13	AFTY	ETF	15.01	15.05	15.01	15.01	1800.0
2023-06-13	AGG	ETF	98.48	98.48	97.6	97.68	9568100.0
2023-06-13	AGGH	ETF	22.7	22.7	22.61	22.6102	9125.0
2023-06-13	AGGY	ETF	43.19	43.22	42.95	43.0	79800.0
2023-06-13	AGNG	ETF	28.0	28.04	27.995	28.03	2500.0
2023-06-13	AGOV	ETF	75.59	77.0001	75.4625	76.02	11859.0
2023-06-13	AGOX	ETF	22.99	23.24	22.99	23.12	137000.0
2023-06-13	AGQ	ETF	30.43	30.62	29.15	29.37	717800.0
2023-06-13	AGZ	ETF	108.0	108.0	106.8616	106.95	41032.0
2023-06-13	AGZD	ETF	21.885	22.02	21.885	21.99	44600.0
2023-06-13	AHOY	ETF	20.25	20.25	20.2	20.209	302.0
2023-06-13	AHYB	ETF	43.851	43.851	43.79	43.79	2900.0
2023-06-13	AIA	ETF	62.07	62.4	62.0	62.19	371532.0
2023-06-13	AIEQ	ETF	31.36	31.635	31.35	31.55	26500.0

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

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