PREVIEW / etf_daily / 2023-08-03

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-03.parquet
  size:    107 KB
  rows:    3,000

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-03	SPY	ETF	448.04	450.79	447.37	448.84	64276100.0
2023-08-03	QQQ	ETF	371.94	375.95	371.77	373.79	47855381.0
2023-08-03	IWM	ETF	194.3	195.64	193.06	194.56	24279300.0
2023-08-03	DIA	ETF	351.6	353.39	351.12	351.99	3307000.0
2023-08-03	GLD	ETF	179.44	179.95	179.28	179.54	4636300.0
2023-08-03	TLT	ETF	95.19	95.32	94.54	94.85	59394800.0
2023-08-03	AAA	ETF	24.64	24.7	24.64	24.67	10100.0
2023-08-03	AAAU	ETF	19.16	19.21	19.15	19.17	1027200.0
2023-08-03	AADR	ETF	51.54	51.68	51.38	51.38	1600.0
2023-08-03	AAPB	ETF	28.53	28.58	28.28	28.32	25311.0
2023-08-03	AAPD	ETF	20.43	20.5	20.3401	20.48	472521.0
2023-08-03	AAPU	ETF	28.4	28.59	28.26	28.34	295519.0
2023-08-03	AAXJ	ETF	68.11	68.67	68.09	68.43	405600.0
2023-08-03	ABEQ	ETF	28.32	28.4	28.28	28.32	25600.0
2023-08-03	ACES	ETF	45.64	46.2	45.64	45.72	51500.0
2023-08-03	ACIO	ETF	31.44	31.49	31.38	31.418	81500.0
2023-08-03	ACSI	ETF	47.383	47.383	47.383	47.383	100.0
2023-08-03	ACT	ETF	28.1	28.77	27.97	28.6	241015.0
2023-08-03	ACTV	ETF	32.82	32.971	32.79	32.84	6300.0
2023-08-03	ACVF	ETF	34.09	34.36	34.09	34.308	5600.0
2023-08-03	ACWF	ETF	35.62	35.865	35.62	35.7827	2863.0
2023-08-03	ACWI	ETF	96.55	97.19	96.48	96.84	5379100.0
2023-08-03	ACWV	ETF	98.33	98.33	97.98	98.03	111500.0
2023-08-03	ACWX	ETF	49.29	49.59	49.23	49.45	569700.0
2023-08-03	ADFI	ETF	8.36	8.37	8.35	8.37	26100.0
2023-08-03	ADIV	ETF	14.03	14.03	14.03	14.03	100.0
2023-08-03	ADME	ETF	36.87	36.87	36.665	36.756	39100.0
2023-08-03	ADPV	ETF	25.49	25.54	25.48	25.51	2325.0
2023-08-03	AEMB	ETF	37.02	37.05	37.02	37.039	900.0
2023-08-03	AESR	ETF	12.87	12.95	12.87	12.93	25800.0
2023-08-03	AFIF	ETF	8.91	8.91	8.89	8.9	21400.0
2023-08-03	AFK	ETF	15.16	15.34	15.04	15.16	8100.0
2023-08-03	AFLG	ETF	25.806	25.806	25.806	25.806	100.0
2023-08-03	AFMC	ETF	25.32	25.41	25.32	25.41	700.0
2023-08-03	AFTY	ETF	16.008	16.008	16.008	16.008	100.0
2023-08-03	AGG	ETF	95.93	96.02	95.8	95.89	7532700.0
2023-08-03	AGGH	ETF	22.16	22.16	22.02	22.02	13644.0
2023-08-03	AGGY	ETF	42.41	42.43	42.35	42.395	189500.0
2023-08-03	AGNG	ETF	27.22	27.32	27.22	27.32	6400.0
2023-08-03	AGOV	ETF	75.06	75.16	74.905	74.905	374.0
2023-08-03	AGOX	ETF	23.7	23.8	23.61	23.65	22500.0
2023-08-03	AGQ	ETF	28.57	28.79	28.35	28.5	515100.0
2023-08-03	AGRH	ETF	25.6	25.6	25.55	25.55	1361.0
2023-08-03	AGZ	ETF	106.18	106.27	106.16	106.19	29300.0
2023-08-03	AGZD	ETF	22.1	22.235	21.985	22.13	128200.0
2023-08-03	AHOY	ETF	20.86	20.86	20.852	20.852	408.0
2023-08-03	AHYB	ETF	43.7	43.7	43.7	43.7	100.0
2023-08-03	AIA	ETF	60.95	61.49	60.95	61.34	14100.0
2023-08-03	AIEQ	ETF	32.42	33.0	32.42	32.804	15400.0
2023-08-03	AIQ	ETF	28.36	28.6	28.28	28.49	253200.0

> showing 50 of 3,000 rows — these rows as CSV

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