PREVIEW / etf_daily / 2023-08-28

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-28.parquet
  size:    107 KB
  rows:    2,982

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-08-28	SPY	ETF	442.24	443.4	439.97	442.76	61595400.0
2023-08-28	QQQ	ETF	366.99	367.71	364.25	366.76	40910019.0
2023-08-28	IWM	ETF	184.84	186.75	184.82	185.64	23002000.0
2023-08-28	DIA	ETF	345.21	346.67	344.5	345.71	2382700.0
2023-08-28	GLD	ETF	177.65	178.73	177.51	178.13	4740700.0
2023-08-28	TLT	ETF	95.65	95.66	94.89	95.32	16037300.0
2023-08-28	AAA	ETF	24.82	24.88	24.82	24.85	2200.0
2023-08-28	AAAU	ETF	18.98	19.09	18.96	19.02	801900.0
2023-08-28	AADR	ETF	52.06	52.06	52.0	52.0	200.0
2023-08-28	AAPB	ETF	25.1409	25.35	24.995	25.35	10803.0
2023-08-28	AAPD	ETF	21.67	21.884	21.67	21.695	34988.0
2023-08-28	AAPU	ETF	25.82	25.84	25.44	25.82	91398.0
2023-08-28	AAXJ	ETF	65.11	65.56	65.07	65.47	600500.0
2023-08-28	ABEQ	ETF	27.98	27.98	27.882	27.92	3000.0
2023-08-28	ACES	ETF	40.25	40.509	39.98	40.28	113700.0
2023-08-28	ACIO	ETF	31.12	31.14	31.02	31.1	49300.0
2023-08-28	ACSI	ETF	45.52	45.769	45.52	45.769	300.0
2023-08-28	ACT	ETF	28.97	29.68	28.96	29.05	177247.0
2023-08-28	ACTV	ETF	31.56	31.67	31.56	31.623	4700.0
2023-08-28	ACTX	ETF	0.0003	0.0003	0.0003	0.0003	2500.0
2023-08-28	ACVF	ETF	34.21	34.21	34.045	34.17	4300.0
2023-08-28	ACWF	ETF	35.11	35.21	35.0649	35.1817	3520.0
2023-08-28	ACWI	ETF	95.02	95.34	94.89	95.21	2006900.0
2023-08-28	ACWV	ETF	97.5	97.6	97.31	97.49	624300.0
2023-08-28	ACWX	ETF	48.33	48.51	48.3	48.48	1441600.0
2023-08-28	ADFI	ETF	8.35	8.36	8.341	8.355	6900.0
2023-08-28	ADIV	ETF	13.371	13.371	13.37	13.37	1000.0
2023-08-28	ADME	ETF	36.245	36.26	36.12	36.233	14800.0
2023-08-28	ADPV	ETF	24.8262	24.85	24.75	24.77	8295.0
2023-08-28	AEMB	ETF	37.058	37.07	37.058	37.07	200.0
2023-08-28	AESR	ETF	12.65	12.67	12.58	12.651	31900.0
2023-08-28	AFIF	ETF	8.87	9.08	8.87	8.93	42900.0
2023-08-28	AFK	ETF	14.53	14.6	14.45	14.52	10200.0
2023-08-28	AFLG	ETF	25.328	25.328	25.328	25.328	100.0
2023-08-28	AFMC	ETF	24.658	24.658	24.658	24.658	100.0
2023-08-28	AFSM	ETF	24.599	24.599	24.599	24.599	100.0
2023-08-28	AFTY	ETF	14.99	15.001	14.97	15.001	1200.0
2023-08-28	AGG	ETF	96.1	96.11	95.93	96.08	6544500.0
2023-08-28	AGGH	ETF	21.88	21.97	21.87	21.936	17698.0
2023-08-28	AGGY	ETF	42.32	42.35	42.267	42.34	145100.0
2023-08-28	AGNG	ETF	27.27	27.428	27.03	27.16	102300.0
2023-08-28	AGOV	ETF	74.45	77.4899	74.45	75.9103	1346.0
2023-08-28	AGOX	ETF	23.5	23.5	23.26	23.33	13500.0
2023-08-28	AGQ	ETF	29.48	30.14	29.43	29.82	377900.0
2023-08-28	AGZ	ETF	106.42	106.47	106.36	106.46	15600.0
2023-08-28	AGZD	ETF	22.16	22.24	22.11	22.2	27200.0
2023-08-28	AHYB	ETF	44.07	44.07	44.07	44.07	100.0
2023-08-28	AIA	ETF	57.8	58.15	57.72	58.06	6600.0
2023-08-28	AIEQ	ETF	30.71	30.88	30.69	30.807	14300.0
2023-08-28	AIQ	ETF	27.72	27.83	27.583	27.78	184000.0

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

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