PREVIEW / etf_daily / 2023-05-18

all etf daily files

  file:    by_date/etf_daily/2023/2023-05-18.parquet
  size:    110 KB
  rows:    2,968

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-18	SPY	ETF	414.9	419.67	414.67	419.23	97177200.0
2023-05-18	QQQ	ETF	331.52	337.49	331.5	337.27	64213466.0
2023-05-18	IWM	ETF	175.56	177.57	175.02	177.19	30446600.0
2023-05-18	DIA	ETF	333.9	336.44	332.75	336.06	3553500.0
2023-05-18	GLD	ETF	182.1	182.28	181.34	181.84	8812600.0
2023-05-18	TLT	ETF	102.2	102.26	101.75	101.82	25536600.0
2023-05-18	AAA	ETF	24.56	24.56	24.56	24.56	9.0
2023-05-18	AAAU	ETF	19.44	19.46	19.36	19.41	1369300.0
2023-05-18	AADR	ETF	47.67	47.79	47.52	47.79	900.0
2023-05-18	AAPB	ETF	24.52	24.839	24.48	24.82	24453.0
2023-05-18	AAPD	ETF	22.57	22.6399	22.295	22.3	164634.0
2023-05-18	AAPU	ETF	24.88	25.3328	24.79	25.3	156803.0
2023-05-18	AAXJ	ETF	66.08	66.08	65.68	65.96	497600.0
2023-05-18	ABEQ	ETF	28.2	28.43	28.2	28.43	13700.0
2023-05-18	ACES	ETF	42.81	42.94	42.27	42.85	49100.0
2023-05-18	ACIO	ETF	30.19	30.31	30.12	30.28	67900.0
2023-05-18	ACSI	ETF	44.5102	44.5102	44.5102	44.5102	58.0
2023-05-18	ACT	ETF	24.05	24.54	23.87	24.54	512504.0
2023-05-18	ACTV	ETF	29.41	29.94	29.41	29.8725	5951.0
2023-05-18	ACTX	ETF	0.2772	0.28	0.2772	0.28	762.0
2023-05-18	ACVF	ETF	31.52	31.729	31.49	31.729	700.0
2023-05-18	ACWF	ETF	34.13	34.3195	34.06	34.3195	10314.0
2023-05-18	ACWI	ETF	92.34	92.99	92.18	92.91	4237500.0
2023-05-18	ACWV	ETF	98.88	99.08	98.49	99.01	2519100.0
2023-05-18	ACWX	ETF	49.43	49.43	49.135	49.42	1716131.0
2023-05-18	ADFI	ETF	8.43	8.44	8.42	8.435	9600.0
2023-05-18	ADIV	ETF	13.5	13.5	13.5	13.5	100.0
2023-05-18	ADME	ETF	34.82	35.05	34.82	35.05	52600.0
2023-05-18	ADPV	ETF	23.09	23.2335	23.09	23.2335	30129.0
2023-05-18	AEMB	ETF	37.09	37.09	37.09	37.09	100.0
2023-05-18	AESR	ETF	12.06	12.14	12.03	12.14	11500.0
2023-05-18	AFIF	ETF	8.79	8.8	8.74	8.765	44463.0
2023-05-18	AFK	ETF	15.11	15.11	14.7	14.7255	28919.0
2023-05-18	AFLG	ETF	23.955	24.135	23.955	24.135	500.0
2023-05-18	AFMC	ETF	23.07	23.156	23.07	23.156	100.0
2023-05-18	AFSM	ETF	22.9	23.061	22.9	23.061	300.0
2023-05-18	AFTY	ETF	15.559	15.559	15.559	15.559	100.0
2023-05-18	AGG	ETF	98.49	98.51	98.27	98.3	4811300.0
2023-05-18	AGGH	ETF	22.9366	22.9366	22.9207	22.9207	929.0
2023-05-18	AGGY	ETF	43.32	43.32	43.232	43.28	87600.0
2023-05-18	AGNG	ETF	27.95	28.028	27.918	27.98	900.0
2023-05-18	AGOV	ETF	76.555	76.555	76.555	76.555	3.0
2023-05-18	AGOX	ETF	21.75	22.18	21.75	22.11	21600.0
2023-05-18	AGQ	ETF	29.25	29.31	28.76	29.14	946200.0
2023-05-18	AGZ	ETF	108.02	108.15	107.93	108.08	39953.0
2023-05-18	AGZD	ETF	21.79	21.82	21.75	21.81	17000.0
2023-05-18	AHYB	ETF	43.512	43.512	43.512	43.512	100.0
2023-05-18	AIA	ETF	59.06	59.06	58.58	58.87	23389.0
2023-05-18	AIEQ	ETF	28.24	29.16	28.24	29.12	26800.0
2023-05-18	AIQ	ETF	24.65	25.08	24.59	25.08	357913.0

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

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