PREVIEW / etf_daily / 2023-05-30

all etf daily files

  file:    by_date/etf_daily/2023/2023-05-30.parquet
  size:    111 KB
  rows:    2,985

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-05-30	SPY	ETF	422.03	422.58	418.74	420.18	72216000.0
2023-05-30	QQQ	ETF	352.71	353.93	348.53	349.98	72652156.0
2023-05-30	IWM	ETF	176.71	177.55	174.76	175.5	25572600.0
2023-05-30	DIA	ETF	330.65	331.32	328.92	330.52	3474500.0
2023-05-30	GLD	ETF	181.72	182.4	181.17	182.04	4906100.0
2023-05-30	TLT	ETF	101.4	102.24	101.25	102.1	23125200.0
2023-05-30	AAA	ETF	24.56	24.575	24.56	24.575	152.0
2023-05-30	AAAU	ETF	19.4	19.47	19.35	19.43	724500.0
2023-05-30	AADR	ETF	46.44	46.56	46.37	46.47	1000.0
2023-05-30	AAPB	ETF	25.25	25.54	25.25	25.2678	14945.0
2023-05-30	AAPD	ETF	22.13	22.13	21.87	22.06	83167.0
2023-05-30	AAPU	ETF	25.7	26.09	25.59	25.76	122636.0
2023-05-30	AAXJ	ETF	65.81	65.92	65.11	65.28	1758100.0
2023-05-30	ABEQ	ETF	27.65	27.74	27.634	27.74	17100.0
2023-05-30	ACES	ETF	43.59	44.19	43.15	43.85	54900.0
2023-05-30	ACIO	ETF	29.87	30.19	29.87	30.15	34600.0
2023-05-30	ACSI	ETF	44.0072	44.0072	44.0072	44.0072	106.0
2023-05-30	ACT	ETF	24.74	25.22	24.74	25.0	165974.0
2023-05-30	ACTV	ETF	29.65	29.65	29.4755	29.5739	2909.0
2023-05-30	ACTX	ETF	0.285	0.285	0.285	0.285	202.0
2023-05-30	ACVF	ETF	32.18	32.18	31.876	31.936	27800.0
2023-05-30	ACWF	ETF	34.12	34.12	34.0532	34.0532	2794.0
2023-05-30	ACWI	ETF	92.87	92.92	92.0	92.28	4063500.0
2023-05-30	ACWV	ETF	97.02	97.02	96.36	96.52	99000.0
2023-05-30	ACWX	ETF	48.7	48.72	48.21	48.33	659257.0
2023-05-30	ADFI	ETF	8.41	8.44	8.4	8.43	16900.0
2023-05-30	ADIV	ETF	13.32	13.32	13.32	13.32	100.0
2023-05-30	ADME	ETF	34.6	35.12	34.6	34.91	6800.0
2023-05-30	ADPV	ETF	22.91	22.91	22.89	22.9081	3196.0
2023-05-30	AESR	ETF	12.17	12.2	12.12	12.16	21500.0
2023-05-30	AFIF	ETF	8.78	8.88	8.75	8.8004	15881.0
2023-05-30	AFK	ETF	14.85	14.92	14.84	14.84	42929.0
2023-05-30	AFLG	ETF	23.979	23.979	23.979	23.979	100.0
2023-05-30	AFMC	ETF	22.87	22.87	22.841	22.841	100.0
2023-05-30	AFTY	ETF	14.899	14.899	14.899	14.899	100.0
2023-05-30	AGG	ETF	97.9	98.24	97.85	98.22	7349900.0
2023-05-30	AGGH	ETF	22.7	22.73	22.7	22.726	4613.0
2023-05-30	AGGY	ETF	42.96	43.07	42.935	43.06	88800.0
2023-05-30	AGOV	ETF	76.14	77.2626	75.8	77.2626	316.0
2023-05-30	AGOX	ETF	22.25	22.37	22.23	22.32	43100.0
2023-05-30	AGQ	ETF	28.16	28.47	27.83	28.3	689800.0
2023-05-30	AGZ	ETF	107.45	107.7	107.43	107.57	23343.0
2023-05-30	AGZD	ETF	21.82	21.875	21.78	21.81	35600.0
2023-05-30	AHOY	ETF	19.32	19.33	19.2705	19.2705	227.0
2023-05-30	AHYB	ETF	43.59	43.591	43.59	43.591	300.0
2023-05-30	AIA	ETF	59.12	59.12	58.22	58.39	21816.0
2023-05-30	AIEQ	ETF	30.62	30.62	29.995	30.22	20600.0
2023-05-30	AIQ	ETF	26.44	26.5	26.11	26.26	560574.0
2023-05-30	AIRR	ETF	49.01	49.01	48.485	48.77	35700.0
2023-05-30	AIVI	ETF	39.02	39.02	38.74	38.82	4800.0

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

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