PREVIEW / etf_daily / 2023-03-14

all etf daily files

  file:    by_date/etf_daily/2023/2023-03-14.parquet
  size:    110 KB
  rows:    2,947

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-03-14	SPY	ETF	390.5	393.45	387.05	391.73	149752400.0
2023-03-14	QQQ	ETF	294.31	297.93	293.45	297.37	73602545.0
2023-03-14	IWM	ETF	178.6	179.26	174.61	176.52	48946200.0
2023-03-14	DIA	ETF	322.21	323.71	318.71	322.19	4760500.0
2023-03-14	GLD	ETF	177.35	177.59	176.21	176.83	10019000.0
2023-03-14	TLT	ETF	105.14	105.61	103.75	104.09	38417800.0
2023-03-14	AAA	ETF	24.55	24.55	24.55	24.55	197.0
2023-03-14	AAAU	ETF	18.93	18.95	18.8	18.87	1678800.0
2023-03-14	AADR	ETF	46.57	47.5	46.57	47.09	1800.0
2023-03-14	AAPB	ETF	19.82	20.0373	19.44	19.89	7457.0
2023-03-14	AAPD	ETF	25.92	26.1	25.5501	25.71	272875.0
2023-03-14	AAPU	ETF	20.66	21.02	20.41	20.86	74852.0
2023-03-14	AAXJ	ETF	64.68	65.2	64.68	65.11	553100.0
2023-03-14	ABEQ	ETF	27.3	27.41	27.11	27.244	9800.0
2023-03-14	ACES	ETF	46.03	46.66	44.86	45.48	159100.0
2023-03-14	ACIO	ETF	29.43	29.441	29.24	29.39	56900.0
2023-03-14	ACSI	ETF	42.4	42.4	42.3662	42.3662	120.0
2023-03-14	ACT	ETF	22.56	22.78	21.79	22.05	169292.0
2023-03-14	ACTV	ETF	29.39	29.67	29.2497	29.33	9432.0
2023-03-14	ACVF	ETF	29.92	30.23	29.88	30.038	6200.0
2023-03-14	ACWF	ETF	32.3812	32.45	32.1064	32.3134	5241.0
2023-03-14	ACWI	ETF	87.06	87.62	86.49	87.33	2071200.0
2023-03-14	ACWV	ETF	93.04	93.38	92.69	93.32	101300.0
2023-03-14	ACWX	ETF	46.92	47.11	46.74	47.06	1905088.0
2023-03-14	ADFI	ETF	8.44	8.46	8.42	8.45	53800.0
2023-03-14	ADIV	ETF	13.5	13.5	13.5	13.5	100.0
2023-03-14	ADME	ETF	33.76	33.84	33.6	33.84	7600.0
2023-03-14	ADPV	ETF	23.34	23.62	23.34	23.5409	15319.0
2023-03-14	ADRE	ETF	38.16	38.5122	38.16	38.5	3497.0
2023-03-14	AEMB	ETF	37.416	37.416	37.416	37.416	100.0
2023-03-14	AESR	ETF	11.46	11.58	11.4	11.51	39500.0
2023-03-14	AFIF	ETF	8.8101	8.84	8.76	8.83	33192.0
2023-03-14	AFK	ETF	15.6	15.61	15.5001	15.55	4222.0
2023-03-14	AFLG	ETF	23.209	23.209	23.209	23.209	100.0
2023-03-14	AFMC	ETF	22.883	22.92	22.61	22.61	50300.0
2023-03-14	AFSM	ETF	22.98	22.98	22.98	22.98	100.0
2023-03-14	AGG	ETF	98.77	98.82	98.09	98.29	8159800.0
2023-03-14	AGGY	ETF	43.3	43.375	43.19	43.26	132300.0
2023-03-14	AGNG	ETF	25.932	26.09	25.853	26.09	1300.0
2023-03-14	AGOV	ETF	76.1857	76.1857	76.1857	76.1857	1.0
2023-03-14	AGOX	ETF	20.9	21.03	20.772	20.97	19900.0
2023-03-14	AGQ	ETF	25.6	26.05	25.18	25.27	672200.0
2023-03-14	AGZ	ETF	107.91	107.91	107.32	107.59	56752.0
2023-03-14	AGZD	ETF	21.79	21.945	21.685	21.945	20600.0
2023-03-14	AHHX	ETF	8.4242	8.4242	8.4242	8.4242	50.0
2023-03-14	AHYB	ETF	43.12	43.23	43.05	43.085	600.0
2023-03-14	AIA	ETF	57.65	58.24	57.65	58.24	79739.0
2023-03-14	AIEQ	ETF	28.9	28.95	28.4	28.52	17300.0
2023-03-14	AIQ	ETF	22.3	22.57	22.25	22.38	16803.0
2023-03-14	AIRR	ETF	47.75	48.165	46.97	47.56	64800.0

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

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