PREVIEW / etf_daily / 2023-07-28

all etf daily files

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

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-07-28	SPY	ETF	455.88	457.78	452.49	456.92	80011800.0
2023-07-28	QQQ	ETF	380.74	384.52	380.22	383.48	56902926.0
2023-07-28	IWM	ETF	196.02	196.95	195.5	196.43	21612200.0
2023-07-28	DIA	ETF	354.51	355.55	353.43	354.48	3219000.0
2023-07-28	GLD	ETF	181.48	182.27	181.25	181.86	3828800.0
2023-07-28	TLT	ETF	99.4	99.86	99.15	99.81	27434000.0
2023-07-28	AAA	ETF	24.75	24.775	24.75	24.775	900.0
2023-07-28	AAAU	ETF	19.38	19.46	19.36	19.42	746900.0
2023-07-28	AADR	ETF	52.73	52.94	52.67	52.84	900.0
2023-07-28	AAPB	ETF	29.29	29.72	29.165	29.53	8320.0
2023-07-28	AAPD	ETF	20.07	20.12	19.88	19.97	64453.0
2023-07-28	AAPU	ETF	29.16	29.56	29.1	29.42	109813.0
2023-07-28	AAXJ	ETF	70.26	70.51	70.03	70.48	452300.0
2023-07-28	ABEQ	ETF	28.64	28.64	28.57	28.621	25500.0
2023-07-28	ACES	ETF	47.27	47.37	46.728	47.36	123700.0
2023-07-28	ACIO	ETF	31.57	31.84	31.57	31.8	461900.0
2023-07-28	ACSI	ETF	47.91	48.168	47.91	48.168	2700.0
2023-07-28	ACT	ETF	27.5	27.83	27.178	27.33	321563.0
2023-07-28	ACTV	ETF	33.35	33.37	33.12	33.246	5700.0
2023-07-28	ACVF	ETF	34.72	34.8	34.69	34.78	10000.0
2023-07-28	ACWF	ETF	36.57	36.6599	36.53	36.58	3632.0
2023-07-28	ACWI	ETF	98.99	99.4	98.86	99.2	4202600.0
2023-07-28	ACWV	ETF	100.22	100.22	99.76	99.99	104300.0
2023-07-28	ACWX	ETF	51.11	51.29	51.0	51.14	2413000.0
2023-07-28	ADFI	ETF	8.44	8.445	8.44	8.445	800.0
2023-07-28	ADIV	ETF	14.335	14.335	14.335	14.335	100.0
2023-07-28	ADME	ETF	36.97	37.34	36.97	37.31	214000.0
2023-07-28	ADPV	ETF	25.82	25.82	25.74	25.7772	5550.0
2023-07-28	AEMB	ETF	37.949	37.949	37.949	37.949	100.0
2023-07-28	AESR	ETF	13.144	13.2	13.12	13.15	13800.0
2023-07-28	AFIF	ETF	8.87	8.89	8.85	8.85	5200.0
2023-07-28	AFK	ETF	15.81	15.82	15.66	15.82	5400.0
2023-07-28	AFMC	ETF	25.64	25.658	25.64	25.658	500.0
2023-07-28	AFTY	ETF	16.171	16.19	16.166	16.166	1100.0
2023-07-28	AGG	ETF	97.39	97.59	97.31	97.56	9233600.0
2023-07-28	AGGH	ETF	22.3499	22.36	22.28	22.2876	41133.0
2023-07-28	AGGY	ETF	42.85	42.92	42.82	42.92	98600.0
2023-07-28	AGNG	ETF	27.94	28.049	27.94	28.049	1100.0
2023-07-28	AGOV	ETF	75.9	76.5	75.77	75.97	2269.0
2023-07-28	AGOX	ETF	24.11	24.11	23.97	24.01	43600.0
2023-07-28	AGQ	ETF	30.26	30.63	30.1	30.4	423000.0
2023-07-28	AGRH	ETF	25.74	25.74	25.67	25.725	3050.0
2023-07-28	AGZ	ETF	106.72	106.92	106.72	106.79	10200.0
2023-07-28	AGZD	ETF	22.21	22.275	22.145	22.175	27400.0
2023-07-28	AHYB	ETF	44.31	44.31	44.25	44.25	500.0
2023-07-28	AIA	ETF	62.74	63.34	62.74	63.25	36800.0
2023-07-28	AIEQ	ETF	32.79	33.33	32.79	33.33	22500.0
2023-07-28	AIQ	ETF	29.22	29.54	29.15	29.51	475700.0
2023-07-28	AIRR	ETF	54.11	54.28	53.78	54.06	92200.0
2023-07-28	AIVI	ETF	40.41	40.56	40.38	40.4	4900.0

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

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