PREVIEW / etf_daily / 2023-04-14

all etf daily files

  file:    by_date/etf_daily/2023/2023-04-14.parquet
  size:    109 KB
  rows:    2,936

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-04-14	SPY	ETF	412.81	415.09	410.06	412.46	78161500.0
2023-04-14	QQQ	ETF	317.59	320.36	315.61	318.57	56278284.0
2023-04-14	IWM	ETF	178.33	179.22	175.34	176.51	29600400.0
2023-04-14	DIA	ETF	339.94	340.85	337.31	338.84	3107900.0
2023-04-14	GLD	ETF	188.08	188.49	185.17	186.36	13272500.0
2023-04-14	TLT	ETF	105.39	105.55	104.77	105.08	19801900.0
2023-04-14	AAA	ETF	24.52	24.52	24.52	24.52	0.0
2023-04-14	AAAU	ETF	20.08	20.11	19.77	19.89	2197600.0
2023-04-14	AADR	ETF	48.76	49.02	48.62	49.02	5800.0
2023-04-14	AAPB	ETF	22.6007	22.9099	22.4197	22.6319	9131.0
2023-04-14	AAPD	ETF	23.7	23.81	23.47	23.64	339256.0
2023-04-14	AAPU	ETF	23.2	23.54	23.02	23.33	91673.0
2023-04-14	AAXJ	ETF	68.02	68.27	67.59	67.85	541800.0
2023-04-14	ABEQ	ETF	28.79	28.79	28.575	28.61	3700.0
2023-04-14	ACES	ETF	45.02	45.05	43.916	44.42	67200.0
2023-04-14	ACIO	ETF	30.37	30.37	30.24	30.3	25000.0
2023-04-14	ACSI	ETF	44.4047	44.4047	44.4047	44.4047	71.0
2023-04-14	ACT	ETF	24.58	24.78	24.51	24.6	137130.0
2023-04-14	ACTV	ETF	29.39	29.67	29.24	29.43	6069.0
2023-04-14	ACVF	ETF	31.302	31.474	31.302	31.474	800.0
2023-04-14	ACWF	ETF	34.018	34.0975	33.945	34.0975	2607.0
2023-04-14	ACWI	ETF	92.42	92.85	91.83	92.3	1095600.0
2023-04-14	ACWV	ETF	98.84	99.08	98.28	98.49	164700.0
2023-04-14	ACWX	ETF	49.88	50.04	49.56	49.77	955596.0
2023-04-14	ADFI	ETF	8.54	8.56	8.54	8.56	13600.0
2023-04-14	ADIV	ETF	13.9	13.9	13.9	13.9	100.0
2023-04-14	ADME	ETF	35.05	35.05	34.78	34.95	530900.0
2023-04-14	ADPV	ETF	23.175	23.2094	23.05	23.2039	1700.0
2023-04-14	AESR	ETF	12.17	12.17	12.076	12.127	14000.0
2023-04-14	AFIF	ETF	8.85	8.89	8.83	8.86	16455.0
2023-04-14	AFK	ETF	16.49	16.49	16.04	16.1748	30558.0
2023-04-14	AFLG	ETF	24.02	24.084	24.02	24.084	100.0
2023-04-14	AFMC	ETF	23.01	23.021	22.96	23.021	700.0
2023-04-14	AFSM	ETF	23.07	23.152	23.07	23.152	100.0
2023-04-14	AFTY	ETF	16.105	16.105	16.105	16.105	100.0
2023-04-14	AGG	ETF	99.56	99.59	99.32	99.4	4794100.0
2023-04-14	AGGH	ETF	23.03	23.04	23.03	23.0356	9147.0
2023-04-14	AGGY	ETF	43.81	43.814	43.701	43.76	74900.0
2023-04-14	AGNG	ETF	28.16	28.16	27.95	27.95	600.0
2023-04-14	AGOV	ETF	80.17	80.17	77.35	78.07	357.0
2023-04-14	AGOX	ETF	21.825	21.92	21.66	21.846	81800.0
2023-04-14	AGQ	ETF	36.14	36.3	33.93	34.58	1418600.0
2023-04-14	AGZ	ETF	108.21	108.24	108.12	108.18	19214.0
2023-04-14	AGZD	ETF	21.81	21.835	21.735	21.815	186200.0
2023-04-14	AHYB	ETF	44.21	44.21	44.115	44.123	1600.0
2023-04-14	AIA	ETF	60.84	60.97	60.35	60.57	29990.0
2023-04-14	AIEQ	ETF	28.99	29.25	28.734	28.85	10600.0
2023-04-14	AIQ	ETF	24.04	24.23	23.86	24.06	21373.0
2023-04-14	AIRR	ETF	46.17	46.29	45.535	45.73	18500.0
2023-04-14	AIVI	ETF	39.82	39.9	39.79	39.9	700.0

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

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