PREVIEW / etf_daily / 2023-07-20

all etf daily files

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

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-20	SPY	ETF	454.17	455.1	451.44	452.18	70591600.0
2023-07-20	QQQ	ETF	382.61	384.095	375.72	376.76	71941674.0
2023-07-20	IWM	ETF	196.94	196.94	194.27	195.08	27278100.0
2023-07-20	DIA	ETF	351.45	353.89	351.35	352.43	4561300.0
2023-07-20	GLD	ETF	183.73	183.77	182.47	182.74	4972900.0
2023-07-20	TLT	ETF	102.22	102.31	101.28	101.7	56951200.0
2023-07-20	AAA	ETF	24.67	24.67	24.67	24.67	300.0
2023-07-20	AAAU	ETF	19.61	19.62	19.48	19.51	905100.0
2023-07-20	AADR	ETF	51.3	51.51	51.13	51.13	9100.0
2023-07-20	AAPB	ETF	29.26	29.7999	28.9117	28.97	25408.0
2023-07-20	AAPD	ETF	20.01	20.26	19.875	20.19	173591.0
2023-07-20	AAPU	ETF	29.28	29.5653	28.68	28.82	195476.0
2023-07-20	AAXJ	ETF	67.8	67.94	67.52	67.62	388500.0
2023-07-20	ABEQ	ETF	28.41	28.52	28.41	28.486	7000.0
2023-07-20	ACES	ETF	49.31	49.4	48.37	48.82	300100.0
2023-07-20	ACIO	ETF	31.5	31.63	31.45	31.52	58000.0
2023-07-20	ACSI	ETF	47.775	47.775	47.775	47.775	100.0
2023-07-20	ACT	ETF	27.0	27.09	26.64	26.78	160241.0
2023-07-20	ACTV	ETF	32.99	33.02	32.79	32.97	9400.0
2023-07-20	ACTX	ETF	0.21	0.21	0.21	0.21	417.0
2023-07-20	ACVF	ETF	34.78	34.78	34.58	34.591	8300.0
2023-07-20	ACWF	ETF	36.2248	36.2248	36.12	36.14	4676.0
2023-07-20	ACWI	ETF	98.39	98.53	97.79	97.94	6185600.0
2023-07-20	ACWV	ETF	99.06	99.42	99.03	99.39	178300.0
2023-07-20	ACWX	ETF	50.48	50.58	50.25	50.33	1293900.0
2023-07-20	ADFI	ETF	8.45	8.46	8.45	8.45	14900.0
2023-07-20	ADIV	ETF	13.785	13.785	13.785	13.785	100.0
2023-07-20	ADME	ETF	37.06	37.06	36.82	36.87	44500.0
2023-07-20	ADPV	ETF	25.64	25.64	25.54	25.5525	1788.0
2023-07-20	AESR	ETF	13.06	13.12	12.96	13.04	73300.0
2023-07-20	AFIF	ETF	8.92	8.96	8.78	8.8	19900.0
2023-07-20	AFK	ETF	15.69	15.76	15.65	15.65	5800.0
2023-07-20	AFLG	ETF	25.941	25.941	25.941	25.941	100.0
2023-07-20	AFMC	ETF	25.72	25.72	25.63	25.68	6700.0
2023-07-20	AFSM	ETF	25.65	25.65	25.65	25.65	100.0
2023-07-20	AFTY	ETF	15.02	15.034	15.01	15.034	1300.0
2023-07-20	AGG	ETF	98.06	98.08	97.73	97.92	12562400.0
2023-07-20	AGGH	ETF	22.54	22.6	22.54	22.5757	11304.0
2023-07-20	AGGY	ETF	43.27	43.27	43.12	43.191	119800.0
2023-07-20	AGNG	ETF	27.97	28.09	27.97	27.995	2500.0
2023-07-20	AGOV	ETF	77.57	77.57	77.57	77.57	77.0
2023-07-20	AGOX	ETF	24.13	24.19	23.97	24.01	22800.0
2023-07-20	AGQ	ETF	32.77	32.84	31.53	31.59	588200.0
2023-07-20	AGZ	ETF	107.04	107.07	106.88	107.02	223100.0
2023-07-20	AGZD	ETF	22.15	22.195	22.09	22.15	66000.0
2023-07-20	AHYB	ETF	44.11	44.18	44.11	44.18	700.0
2023-07-20	AIA	ETF	60.44	60.58	60.19	60.24	40800.0
2023-07-20	AIEQ	ETF	32.51	32.54	32.38	32.52	8600.0
2023-07-20	AIQ	ETF	29.18	29.24	28.57	28.68	525700.0
2023-07-20	AIRR	ETF	54.82	54.83	54.31	54.77	102700.0

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

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